How does exporting products work?
Exporting products creates a Microsoft Excel spreadsheet and populates it with product data before downloading it to your computer.
You can control which products will be exported by setting filters such as:
Category
Tag
Badge
Size Guide
Supplier
Type
Recurring order frequency
Website status
Filter
POS channel
Website channel
Google product category
You can then control what data will be included for each exported product by selecting fields such as:
Product ID
Sub product ID
Title
Name
Website status
POS channel
Website channel
SKU
Barcode
Variations
Summary
Description
Intangible
Weight
Width
Height
Depth
HS Code
Country of origin title
Customs description
Weighting
Stock control
Stock
Low stock threshold
Notify if low stock
Notify if no stock
Allow order if no stock
Hide if no stock
Supplier
Supplier code
Google product category ID
Tax type
Xero inventory item code*
Xero sales account code*
Xero tracking category name*
Xero tracking category option name*
Prices**
Missing price text
Publish date
Expiry date
Keywords
Category names
Tag names
Badge label
Vimeo URL
Vimeo video ID
YouTube URL
YouTube video ID
Page title
Page description
Image URLs
Custom fields***
* Only available if Xero is connected, see Connecting Xero
** Prices vary depending on what Pricing tiers and Currencies you have added
*** Custom fields vary depending on what Custom fields you have added.
How do I export products?
Go to Commerce > Products > Products.
Click on the Export button in the top right.
Optionally, select a Category.
Optionally, select a Tag.
Optionally, select a Badge.
Optionally select a Size guide.
Optionally, select a Supplier.
Optionally, select a Type.
Optionally, select a Recurring order frequency.
Optionally, select a Website status.
Optionally, select a Filter.
Optionally, select a POS channel.
Optionally, select a Website channel.
Optionally, select a Google product category.
Optionally, tick/untick the Fields you would like to include.
Click the Export button.