Browse by Topic

Exporting Products

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 are using a specific software that requires an XML file.

Choosing an Export Template

An export template determines what product information you are 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.

You can also create custom export templates, and select which of the exportable fields you want it to include.

Exporting Your Products

This walkthrough covers how to export all of your products. (You can reimport without changing data on unaffected products). For methods of exporting select products, see Exporting Specific Products.

1. Go to ProductsExport.

2. Select your export settings.

Export Products showing Export Templates and File Format Options

  • Template — Select your export template. We recommend Bulk Edit if you are 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.

Export Products popup

4. When the export is complete, select Download my Products file. The file will be saved to your computer, usually in your Downloads folder.

Download Products pop up

Exporting Specific Products

There are three ways to export specific products:

Select individual products

1. Go to ProductsView.

2. Click the checkbox to the left of the product or products you want to export.

Product selected in the View Products screen and the Choose an Action dropdown

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 ProductsView.

2. If you already have a custom view, open it under Custom Views. If not, create one or click Search to perform an advanced search.

Custom View and Search buttons

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.

Choose an Action dropdown

Export products from a particular category

1. Go to ProductsProduct Categories.

2. Locate the category you want to export, and click ActionProducts.

Action menu with Products highlighted

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.

Choose an Action dropdown

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 do not appear in the Bulk Edit template but can be added to a custom export template.

FieldDescriptionFormat
Item TypeDefines the item as a Product, SKU, or RuleProduct = product; SKU = SKU, Rule = rule
Product IDThe system-generated product identifier; cannot be created manuallyRequired for updates; must be blank for creating new products
Product NameThe name of your product; no two can be the same 
Product TypeDefines whether the item is physical or digital (downloadable)P = physical; D = downloadable
Product Code/SKUStock-keeping unit number you use for inventoryAlphanumeric
Bin Picking NumberIdentifies where in a warehouse the item is located 
Brand NameThe brand or manufacturer of a product 
Option SetThe option set if you are using product options 
Option Set AlignDetermine whether the options are to the right or below the product imageRight = to the right; >Below = below
Product DescriptionA description of your productCan contain text or HTML
PriceYour product's base priceNumbers only; no units (e.g. 24.99)
Cost PriceThe cost of the product for you (accounting purposes only)Numbers only; no units
Retail PriceThe retail price; if entered, it will appear next to your base or sale priceNumbers only; no units
Sale PriceThe sale price; if entered, it will replace the base priceNumbers only; no units
Fixed Shipping CostThe price to ship one unit of your product; if entered, this applies internationally overrides any other shipping settingsNumbers only; no units
Free ShippingIf applied, your product will ship internationally for free; if selected, overrides any other shipping settingsY = free shipping enabled; N = not enabled
Product WarrantyProduct warranty informationText or HTML
Product WeightProduct weight (physical only)Numbers only; no units
Product WidthYour product's width for calculating shippingNumbers only; no units
Product HeightYour product's height for calculating shippingNumbers only; no units
Product DepthYour product's depth for calculating shippingNumbers 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 AvailabilityA brief description of how long it takes your product to shipText or HTML
Track InventoryShould 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 LevelNumber of units in stock (only applies if tracking inventory)Numbers only
Low Stock LevelInventory level at which you are sent a notification to restock (only applies if tracking inventory)Numbers only
CategoryCategories and subcategories applied to productCategory1; Category2/Subcategory1;Category2/Subcategory2
If your category name has a /, denote it with \/ (e.g. Mittens\/Gloves)
Product File - 1The file name of your downloadable product (downloadable products only)filename.pdf
Product File Description - 1A description of your file 
Product File Max Downloads - 1The maximum number of times a single customer can download their purchaseNumbers only
Product File Expires After - 1The period after which the download link will not work for your customer# Days, # Weeks, # Months, # Years or Never
Product Image ID - 1The system-generated product image ID 
Product Image File - 1Image file name (if stored in WebDAV) or full URLimagename.jpg or http://fullurl.com/imagename.jpg
Product Image Description - 1A description of the image 
Product Image Is Thumbnail - 1If there is more than one image for the product, specify one to be the thumbnailY = is thumbnail (one only); N = not thumbnail
Product Image Sort - 1If 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 KeywordsKeywords for your store's searchKeywords separated by commas
Page TitleYour product's page title; will default to the product name if left blank 
Meta KeywordsMeta keywords; if left blank will default to those entered in the Website SettingsKeywords separated by commas
Meta DescriptionMeta description; if left blank will default to what's entered in the Website Settings 
MYOB Asset AcctSettings if using MYOB 
MYOB Income AcctSettings if using MYOB 
MYOB Expense AcctSettings if using MYOB 
Product ConditionProduct condition for Google ShoppingNew; 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 NameName of event date 
Event Date Is Limited?Limit the event date? (Limits are inclusive)Y = yes; N = no
Event Date Start DateEarliest date available (inclusive)MON DD, YYYY
Event Date End DateLatest date available (inclusive)MON DD, YYYY
Sort OrderThe order in which a product appears on a category page relative to other products; default is 0Whole numbers only; can use negatives
Product Tax ClassThe tax class applied to a product
Product UPC/EANProduct's UPC or GTIN (Global Trade Item Number) 
Stop Processing RulesFor Rules, stop processing all rules placed below that ruleY = stop processing rules; N = don't stop processing rules
Product URLThe 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 RedirectY = create a 301; N = don't create a 301
GPS Global Trade Item NumberThe UPC/EAN for the product; required for Google Shopping if not a custom product 
GPS Manufacturer Part NumberThe Manufacturer Part Number; required for Google Shopping if not a custom product 
GPS GenderThe intended gender for the product; required for some Google Shopping categories 
GPS Age GroupThe intended age group for the product; required for some Google Shopping categories 
GPS ColorThe color of the product; required for some Google Shopping categories 
GPS SizeThe size of the product; required for some Google Shopping categories 
GPS MaterialThe material of the product; required for some Google Shopping categories 
GPS PatternThe pattern of the product; required for some Google Shopping categories 
GPS Item Group IDA system-generated value for Google Shopping; leave blank if creating products 
GPS CategoryThe BigCommerce category (which is mapped to the Google Shopping category you want to list to)Category1/Subcategory
GPS EnabledShould the product be exported to Google Shopping?Y = enabled; N = not enabled
Avalara Product Tax CodeProduct's unique Avalara tax ID; use only if you have linked your paid Avalara accountNumeric only
Product's Custom FieldsName 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.

FieldDescriptionFormat
Calculated PriceThe product's net price (product price - cost price) 
Date AddedThe date the product was added to the catalog in BigCommerce 
Date ModifiedThe date the product was most recently modified 
Product File Path - 1For downloadable products, the full path of the downloadable file 
Product File Total Downloads - 1The total number of times a downloadable product has been downloaded 
Category ID - 1The BigCommerce-specific category ID 
Category Name - 1The category name associated with a product 
Category Path - 1The category path associated with the product 
Minimum Purchase QuantitySetting 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 QuantitySetting 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 GroupsProduct's unique ShipperHQ shipping group; only available if ShipperHQ is enabled. 
Origin LocationsProduct's unique ShipperHQ origin group; only available if ShipperHQ is enabled. 
Dimensional RulesProduct's unique ShipperHQ dimensional rule group; only available if ShipperHQ is enabled. 

Was this article helpful?