When exporting Orders or Draft Orders from Shopify – the Line Items had somewhat limited data about the Products and their Variants.
Now you can add the additional product and variant data for the exported line items.
When you click the checkbox “Line Items Product Data” for the Orders or Draft Orders export, then the export file will contain additional columns.
New Product Data columns
Those columns are:
- Line: Product Type
- Line: Product Tags
- Line: Variant SKU
- Line: Variant Barcode
- Line: Variant Weight
- Line: Variant Weight Unit
- Line: Variant Inventory Qty
Of course, those columns are only exported and will be ignored when imported.
Note that if you change the data of your Shopify Product, the Order Line items will remain as they were when the order was placed, but the Product Data columns will contain the current product data.
Rows which have Product Data columns filled
In the exported Excel file, those columns will get filled for the following Line Types:
- Line Item
- Fulfillment Line
- Refund Line
Exported columns will look like this:
- See all the available exported Orders columns.
- See all the available exported Draft Orders columns.
- Read our tutorial on how to import Shopify Draft Orders.