Export Variants Tool for BigCommerce
🔧 Quick Info: Export Product Variants pulls BigCommerce variant information into a CSV or Excel spreadsheet. Export every variant in your store or use filters to select specific products, variant SKUs, UPCs, or IDs, then choose the fields you want included.
What It Does
Export Product Variants pulls your BigCommerce product variant data into a spreadsheet. You choose which variants to include, select the fields you want included as columns, and choose either CSV or Excel as the file format.
You can export all variants in your store or narrow the results using Product ID, Product SKU, Variant SKU, UPC, or Variant ID.
If you leave all filters blank, the tool exports every product variant in your BigCommerce store.
The export runs as a background job. When the file is ready, you’ll receive an email containing a link to download it.
When Should You Use This?
- You want a spreadsheet of your product variants for review, reporting, or backup.
- You need variant SKUs, prices, stock levels, dimensions, identifiers, or other data for a bulk update.
- You want to export only the variants belonging to certain products.
- You need a list of specific variant SKUs, UPCs, or variant IDs.
- You want a correctly structured file to edit and re-import using Import Product Variants.
Before You Get Started
- Decide whether you want to export every variant or only a filtered group.
- If filtering, prepare the Product IDs, Product SKUs, Variant SKUs, UPCs, or Variant IDs you want to use.
- Separate multiple filter values with commas.
- Decide which fields you want included as columns in the export.
- Choose whether you want the finished file in CSV or Excel format.
- Confirm the email address where the download link should be sent.
How to Use It
1 Open the Tool
Open the Export Product Variants tool from your BigCommerce tools dashboard.
2 Select the Variants
On the Select Product step, enter a filter to narrow the export. Leave all filters blank to export every variant in your store.
You can filter using Product ID, Product SKU, Variant SKU, UPC, or Variant ID. Each filter accepts multiple comma-separated values.
3 Continue to Export Variants
After choosing your filters, continue to the Export Variants step.
4 Enter the Filename
Enter the filename you want to use for the exported spreadsheet.
5 Choose the File Format
Choose the format for the exported file:
- CSV – A simple, universal format supported by most spreadsheet, database, and import applications.
- Excel – An Excel workbook that opens directly in Microsoft Excel and compatible spreadsheet applications.
6 Select the Export Fields
Choose the fields you want included as columns in the exported file. Only the fields you select are included.
7 Confirm Email Delivery
Continue to the Email step and confirm the address that should receive the download link.
8 Start the Export
Start the export. The tool creates the file as a background job, so you can close the page while it processes.
9 Download the File
When the export is ready, you’ll receive an email containing a download link. Open the link to download the completed CSV or Excel file.
Filter Reference
Use one of the following filters on the Select Product step to limit the variants included in the export. Each field accepts multiple values separated by commas.
| Filter | What It Does |
|---|---|
| Product ID | Exports every variant belonging to the listed BigCommerce product IDs. |
| Product SKU | Exports every variant belonging to the listed parent product SKUs. |
| Variant SKU | Exports only the variants matching the listed variant SKUs. |
| UPC | Exports only variants matching the listed UPC values. |
| Variant ID | Exports only variants matching the listed BigCommerce variant IDs. |
Filtering Tip: Only one filter is applied at a time. Enter your values in the field that matches the information you have, such as Product SKU or Variant SKU.
Available Export Fields
Choose any combination of the fields below. Only selected fields appear as columns in the finished spreadsheet.
| Field | What It Contains |
|---|---|
| Variant SKU | The SKU assigned to the individual product variant. |
| SKU | The SKU assigned to the parent product. |
| UPC | The Universal Product Code assigned to the variant. |
| MPN | The manufacturer’s part number assigned to the variant. |
| GTIN | The Global Trade Item Number assigned to the variant. |
| Price | The variant’s price. |
| Sale Price | The sale price assigned to the variant. |
| Retail Price | The retail or manufacturer’s suggested price. |
| Cost Price | The internal cost assigned to the variant. |
| Fixed Cost Shipping Price | The fixed shipping charge assigned to the variant. |
| Width | The variant’s width. |
| Height | The variant’s height. |
| Depth | The variant’s depth. |
| Weight | The weight assigned directly to the variant. |
| Calculated Weight | The effective weight used by BigCommerce for the variant. |
| Purchasable | Indicates whether the variant can currently be purchased. |
| Image URL | The web address of the image assigned to the variant. |
| Stock | The current inventory quantity for the variant. |
| Low Stock | The low-stock warning level assigned to the variant. |
| Bin Picking Number | The warehouse bin or picking location assigned to the variant. |
File Format Options
| Format | Best For |
|---|---|
| CSV | A simple, widely compatible file that works with most spreadsheet, database, and import tools. |
| Excel | A native Excel workbook for opening and editing directly in Microsoft Excel or a compatible spreadsheet application. |
Troubleshooting and FAQ
My export has more rows than expected
If you leave all filters blank, every variant in your BigCommerce store is exported. Run the export again and enter a filter on the Select Product step to narrow the results.
My filter returned no results
Confirm that the values match the information stored in BigCommerce and that multiple values are separated by commas. Also make sure you entered the values in the correct field, such as Variant SKU rather than Product SKU.
Where is my file?
When the background export finishes, the tool sends an email containing a download link. Confirm the address shown on the Email step and check your spam or junk folder.
Which columns will be included?
Only the fields selected on the Export Variants step appear as columns in the completed spreadsheet.