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 title	Data for products from order history	Data 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:

Importing products with a CSV fileShopify Help Center