What We'll Cover
Exporting your products will let you view your product data in spreadsheet form. By using a CSV spreadsheet, you can back up your products, adjust the prices or descriptions of your products all at once, or transfer them to another store or software.
Did you know? You can choose to export your product data to a CSV file or XML file. We recommend using the CSV file format, unless you're using a specific software that requires an XML file.
Choosing an Export Template
An export template determines specifically what product information you're exporting. All export templates will include details like the product name, but you can get more granular about other details like price, dimensions, Google Shopping details, and so forth.
BigCommerce comes with a few product export templates built in:
- Bulk Edit (recommended) — the bulk edit template was made for updating your product information. It includes the majority of exportable fields, and has specifically named columns that let you skip steps in the importing process.
- Default — the default template includes only basic product details such as name, weight, description and price.
- MYOB — this template is specifically for exporting to MYOB accounting software.
- Peachtree — this template is specifically for exporting to Peachtree Accounting software.
Exporting Your Products
This walkthrough covers how to export all of your products. (You can re-import without changing data on unaffected products). For methods of exporting select products, see Exporting Specific Products.
1. Go to Products › Export.
2. Select your export settings.
- Template — Select your export tempalte. We recommend Bulk Edit if you're not using a custom template.
- File Format — You can export your file as a CSV or XML. We recommend CSV as any other file type will not import.
- Save export to the server for later download? — Select this option to save the file to your exports folder in WebDAV (recommended for exporting 1000+ products).
3. Click Continue, then click Export my products to a CSV file in the pop-up window. The export will begin to process.
4. When the export is complete, select Download my Products file. The file will be saved to your computer, usually in your Downloads folder.
Exporting Specific Products
There are three ways to export specific products:
- Select individual products
- Export products based on a search or view
- Export products belonging to a particular category
Select individual products
1. Go to Products › View.
2. Click the checkbox to the left of the product or products you want to export.
3. Under Choose an Action, select Export These Products, then Confirm. You will be taken to the Export page.
Export products based on a search or view
1. Go to Products › View.
3. Once your view or search results are up, go to Choose an Action and select Export These Products, then Confirm. Selecting individual products from this list will only export those products; otherwise, all products that came up in the view or search will be exported.
Export products from a particular category
1. Go to Products › Product Categories.
2. Locate the category you want to export, and click Action › Products.
3. Under Choose an Action, select Export These Products, then Confirm. Selecting individual products from this list will only export those products; otherwise, all products in that category will be exported.
Table of Exportable Fields
Below is a table of all product attributes that are exportable via the CSV. The majority of these fields are included when using the Bulk Edit export template. See Custom Export Template Fields for a list of fields that are not included in the Bulk Edit template but can be added to a custom export template.
|Item Type||Defines the item as a Product, SKU, or Rule||Product = product; SKU = SKU, Rule = rule|
|Product ID||The system-generated product identifier; cannot be created manually||Required for updates; must be blank for creating new products|
|Product Name||The name of your product; no two can be the same|
|Product Type||Defines whether the item is physical or digital (downloadable)||P = physical; D = downloadable|
|Product Code/SKU||Stock-keeping unit number you use for inventory||Alphanumeric|
|Bin Picking Number||Identifies where in a warehouse the item is located|
|Brand Name||The brand or manufacturer of a product|
|Option Set||The option set if you are using product options|
|Option Set Align||Determine whether the options are to the right or below the product image||Right = to the right; >Below = below|
|Product Description||A description of your product||Can contain text or HTML|
|Price||Your product's base price||Numbers only; no units (e.g. 24.99)|
|Cost Price||The cost of the product for you (accounting purposes only)||Numbers only; no units|
|Retail Price||The retail price; if entered, it will appear next to your base or sale price||Numbers only; no units|
|Sale Price||The sale price; if entered, it will replace the base price||Numbers only; no units|
|Fixed Shipping Cost||The price to ship one unit of your product; if entered, this applies internationally overrides any other shipping settings||Numbers only; no units|
|Free Shipping||If applied, your product will ship internationally for free; if selected, overrides any other shipping settings||Y = free shipping enabled; N = not enabled|
|Product Warranty||Product warranty information||Text or HTML|
|Product Weight||Product weight (physical only)||Numbers only; no units|
|Product Width||Your product's width for calculating shipping||Numbers only; no units|
|Product Height||Your product's height for calculating shipping||Numbers only; no units|
|Product Depth||Your product's depth for calculating shipping||Numbers only; no units|
|Allow Purchases?||Can the product be purchased from your store?||Y = the product can be purchased or pre-ordered; N = the product cannot be purchased or pre-ordered|
|Product Visible?||Should the product be visible in your store?||Y = yes; N = no|
|Product Availability||A brief description of how long it takes your product to ship||Text or HTML|
|Track Inventory||Should inventory be tracked? If so, by option or by product?||None = do not track; by product = track by product; by option = track by SKU|
|Current Stock Level||Number of units in stock (only applies if tracking inventory)||Numbers only|
|Low Stock Level||Inventory level at which you are sent a notification to restock (only applies if tracking inventory)||Numbers only|
|Category||Categories and subcategories applied to product||Category1; Category2/Subcategory1;Category2/Subcategory2|
If your category name has a /, denote it with \/ (e.g. Mittens\/Gloves)
|Product File - 1||The file name of your downloadable product (downloadable products only)||filename.pdf|
|Product File Description - 1||A description of your file|
|Product File Max Downloads - 1||The maximum number of times a single customer can download their purchase||Numbers only|
|Product File Expires After - 1||The time period after which the download link will not work for your customer||# Days, # Weeks, # Months, # Years or Never|
|Product Image ID - 1||The system-generated product image ID|
|Product Image File - 1||Image file name (if stored in WebDAV) or full URL||imagename.jpg or http://fullurl.com/imagename.jpg|
|Product Image Description - 1||A description of the image|
|Product Image Is Thumbnail - 1||If there is more than one image for the product, specify one to be the thumbnail||Y = is thumbnail (one only); N = not thumbnail|
|Product Image Sort - 1||If there is more than one image for the product, specify which order they should appear in (lower numbers appear earlier)||Whole numbers only; can use negatives|
|Search Keywords||Keywords for your store's search||Keywords separated by commas|
|Page Title||Your product's page title; will default to the product name if left blank|
|Meta Keywords||Meta keywords; if left blank will default to those entered in the Website Settings||Keywords separated by commas|
|Meta Description||Meta description; if left blank will default to what's entered in the Website Settings|
|MYOB Asset Acct||Settings if using MYOB|
|MYOB Income Acct||Settings if using MYOB|
|MYOB Expense Acct||Settings if using MYOB|
|Product Condition||Product condition for Google Shopping||New; Used; Refurbished|
|Show Product Condition?||Show the product condition on your product page?||Y = show on product page; N = don't show on product page|
|Event Date Required?||Is a date required for purchase?||N = no event date; Start Date = limit start date; End Date = limit end date; Date Range = limit start and end dates|
|Event Date Name||Name of event date|
|Event Date Is Limited?||Limit the event date? (Limits are inclusive)||Y = yes; N = no|
|Event Date Start Date||Earliest date available (inclusive)||MON DD, YYYY|
|Event Date End Date||Latest date available (inclusive)||MON DD, YYYY|
|Sort Order||The order in which a product appears on a category page relative to other products; default is 0||Whole numbers only; can use negatives|
|Product Tax Class||The tax class applied to a product|
|Product UPC/EAN||Product's UPC or GTIN (Global Trade Item Number)|
|Stop Processing Rules||For Rules, stop processing all rules placed below that rule||Y = stop processing rules; N = don't stop processing rules|
|Product URL||The relative path of your product's URL on your store; if left blank it will default to the product name||/new-relative-url/|
|Redirect Old URL?||If you change the product URL, you can select whether or not to create a 301 Redirect||Y = create a 301; N = don't create a 301|
|GPS Global Trade Item Number||The UPC/EAN for the product; required for Google Shopping if not a custom product|
|GPS Manufacturer Part Number||The Manufacturer Part Number; required for Google Shopping if not a custom product|
|GPS Gender||The intended gender for the product; required for some Google Shopping categories|
|GPS Age Group||The intended age group for the product; required for some Google Shopping categories|
|GPS Color||The color of the product; required for some Google Shopping categories|
|GPS Size||The size of the product; required for some Google Shopping categories|
|GPS Material||The material of the product; required for some Google Shopping categories|
|GPS Pattern||The pattern of the product; required for some Google Shopping categories|
|GPS Item Group ID||A system-generated value for Google Shopping; leave blank if creating products|
|GPS Category||The BigCommerce category (which is mapped to the Google Shopping category you want to list to)||Category1/Subcategory|
|GPS Enabled||Should the product be exported to Google Shopping?||Y = enabled; N = not enabled|
|Avalara Product Tax Code||Product's unique Avalara tax ID; use only if you've linked your paid Avalara account||Numeric only|
|Product's Custom Fields||Name of custom field=Name of value;Name of custom field #2=Name of value #2||
Custom Export Template Fields
These fields are not exported in the Bulk Edit export template by default, but can be added to a custom export template.
|Calculated Price||The product's net price (product price - cost price)|
|Date Added||The date the product was added to the catalog in BigCommerce|
|Date Modified||The date the product was most recently modified|
|Product File Path - 1||For downloadable products, the full path of the downloadable file|
|Product File Total Downloads - 1||The total number of times a downloadable product has been downloaded|
|Category ID - 1||The BigCommerce-specific category ID|
|Category Name - 1||The category name associated with a product|
|Category Path - 1||The category path associated with the product|
|Minimum Purchase Quantity||Setting this value will enforce a minimum quantity limit, on a per-order basis, when customers are ordering this product from your store.||Numeric only|
|Maximum Purchase Quantity||Setting this value will enforce a maximum quantity limit, on a per-order basis, when customers are ordering this product from your store.||Numeric only|
|Shipping Groups||Product's unique ShipperHQ shipping group; only available if ShipperHQ is enabled.|
|Origin Locations||Product's unique ShipperHQ origin group; only available if ShipperHQ is enabled.|
|Dimensional Rules||Product's unique ShipperHQ dimensional rule group; only available if ShipperHQ is enabled.|
- Backing Up Your Store
- Importing Products
- Customizing Export Templates
- Applying ShipperHQ Attributes to Products via CSV Import/Export
- Searching Products
- Creating a Custom View for Products
- Connecting to WebDAV