Export your trade-in data

Tern allows merchants to easily export their trade-in data.

What is the trade-in product data export?

The trade-in product data export enables merchant to download a CSV file containing information about products that have been traded-in.

This data can be used to analyse your trade-ins in more detail or create new product listings if you are planning to run a resale programme.

How to use the trade-in data export

Downloading your trade-in product data is simple and should take less than 30secs. Start by heading over to the Trade-ins page in the merchant admin pages.

  1. Select the Export trade-in product data button in the top right-hand side of the page.

  2. In the pop-up that appears, select the time period that you’d like to export the product data from. You can select any of the default options, like the Last 7 days, or you can choose your own.

  3. Optionally, update the Export Delivery Email. This is the email address we will send the export file to if it is too large to be downloaded in the browser

  4. Clicking Export will then being the export, and the CSV file will be downloaded to your computer.

Description of the trade-in product export CSV file

The trade-in product export CSV file has been based on the CSV template that Shopify provides, which is normally used to create new product listings. In addition to all of the columns found in the Shopify CSV template, Tern includes a number of additional columns that contain data specific to the trade-in.

Each new row in the trade-in product export CSV represents an individual product that has been traded-in.

For full details about the data included in each column, including how it differs for products from order history vs registered products, please see the table below:

Column titleData for products from order historyData for registered products

Handle

Copied from original product listing

Blank

Title

Copied from original product listing

Always 'Registered product'

Body (HTML)

Copied from original product listing

Blank

Vendor

Copied from original product listing

Blank

Standard Product Type

Copied from original product listing

Blank

Custom Product Type

Blank (Tern is unable to retrieve this through the Shopify APIs)

Blank

Tags

Copied from original product listing

Always 'Registered product'

Published

Always ‘FALSE’

Always ‘FALSE’

Option1 Name

Copied from original product listing

Blank

Option1 Value

Copied from original product listing

Blank

Option2 Name

Copied from original product listing

Blank

Option2 Value

Copied from original product listing

Blank

Option3 Name

Copied from original product listing

Blank

Option3 Value

Copied from original product listing

Blank

Variant SKU

Copied from original product listing

Blank

Variant Grams

Copied from original product listing

Blank

Variant Inventory Tracker

Copied from original product listing

Blank

Variant Inventory Qty

Always '1'

Always '1'

Variant Inventory Policy

Always ‘deny

Always ‘deny

Variant Fulfillment Service

Copied from original product listing

Always ‘deny

Variant Price

Always '0'

Always '0'

Variant Compare At Price

Blank

Blank

Variant Requires Shipping

Always ‘TRUE’

Always ‘TRUE

Variant Taxable

Blank

Blank

Variant Barcode

Blank

Blank

Image Src

Pulls in the variants image from the original listing. If not a variant or no variant image is available, it pulls in the first product image.

Blank

Image Position

Always '1'

Always '1'

Image Alt Text

Blank

Blank

Gift Card

Blank

Blank

SEO Title

Blank

Blank

SEO Description

Blank

Blank

Variant Image

Blank

Blank

Variant Weight Unit

Copied from original product listing

Blank

Cost per item

Blank

Blank

Status

Blank

Blank

Age (days)

The number of days since the product was purchased

The age bracket selected by the customer when registering the product (e.g. <6 months)

Original purchase price

The original price the item was purchased for

The amount of credit offered to the customer for the product

Trade-in Credit Value

The amount of credit offered to the customer for the product

The amount of credit offered to the customer for the product

Exchange product variant

Blank - N/A

The product variant that is being offered to the customer in exchange for the trade-in product. Only relevant to customers using the item exchange flow.

Product received

'Y' or 'N' Indicates whether the product has been received by the merchant

'Y' or 'N' Indicates whether the product has been received by the merchant

Trade-in ID

The ID of the trade-in order the product belongs to

The ID of the trade-in order the product belongs to

Trade-in Item ID

The unique ID of the product

The unique ID of the product

Trade-in status

'Open' or 'Closed' Shows the status of the trade-in order the product belongs to

'Open' or 'Closed' Shows the status of the trade-in order the product belongs to

Trade-in opened

The date the trade-in order that the product belongs to was opened

The date the trade-in order that the product belongs to was opened

Trade-in closed

The date the trade-in order that the product belongs to was closed

The date the trade-in order that the product belongs to was closed

Credit discount code

The discount code generated for the trade-in order that the product belongs to

The discount code generated for the trade-in order that the product belongs to

Total credit value issued

The value of the discount code generated for the trade-in order that the product belongs to

The value of the discount code generated for the trade-in order that the product belongs to

Date of credit redemption

The value of the discount code generated for the trade-in order that the product belongs to

The value of the discount code generated for the trade-in order that the product belongs to

Shipping cost (merchant share)

The share of the shipping cost to the merchant.

Learn more about shipping.

The share of the shipping cost to the merchant.

Learn more about shipping.

Tracking number

The tracking number of the shipping label associated with the trade-in order

The tracking number of the shipping label associated with the trade-in order

Product option

Blank - N/A

The product option that this product represents

Category path

Blank - N/A

The full path of categories that the product option belongs to

Purchased from

Blank - N/A

'From us' or 'Someone else*' The answer the customer selected for the 'Who did you buy this product from?' question. *If the question answer format is set to 'Free text' this will be 'Someone else'

Retailer name

Blank - N/A

Relates to the Purchased from column. The answer the customer enters into the free text field if they choose 'Someone else' or the question answer format is 'Free text'.

Purchase location

Blank - N/A

'Online' or 'In-store' The answer the customer selected for the 'Where did you buy this product?' question.

Purchase condition

Blank - N/A

'New' or 'Pre-owned' The answer the customer selected for the 'Was it new or pre-owned?' question.

Condition question 1

Blank - N/A

The question the merchant has created if the Condition question has been enabled (e.g. What condition is the product in?)

Condition question 1 answer

Blank - N/A

The answer the customer selects to the Condition question when registering a product

Custom question 1

Blank - N/A

The question the merchant has created if the first custom question has been enabled (e.g. What colour is this product?)

Custom question 1 answer

Blank - N/A

The answer the customer selects to the first custom question when registering a product

Custom question 2

Blank - N/A

The question the merchant has created if the second custom question has been enabled (e.g. What colour is this product?)

Custom question 2 answer

Blank - N/A

The answer the customer selects to the second custom question when registering a product

How to use the CSV file to create new product listing for traded-in products

For merchants looking to list trade-in products for resale, the CSV file can be used to import trade-in product data directly to Shopify to create new product listings. We’ve purposely formatted the export CSV to mirror the product template file that Shopify provides, so merchants only need to edit the data before re-uploading the same file to Shopify.

How to edit your CSV file and upload it to Shopify

  1. Edit the CSV file to contain the products that you want to create new listings. Make sure to edit the Handle, Title, Body, and Variant SKU columns as failure to do so could result in overwriting existing product listings.

  2. Save the file, making sure that it is still in CSV format.

  3. Head over to your stores admin pages, and navigate to the Products tab.

  4. Click the Import button, upload your CSV file, and select Upload and continue

  5. Preview the details about the import, and then click Import products.

After your CSV file is uploaded, you receive a confirmation email from Shopify at the email account used to set up your Shopify store.

For further information or support with importing products using a CSV file, see the Shopify help docs:

Last updated