Export Bulk Prices Tool for BigCommerce
🔧 Quick Info: Export Product Bulk Pricing pulls quantity-break pricing tiers stored directly on your BigCommerce products into a CSV or Excel spreadsheet. Each pricing tier is exported as a separate row, and the finished file can be edited and re-imported with the Bulk Pricing Updater.
What It Does
Export Product Bulk Pricing pulls the bulk pricing tiers attached directly to your products out of BigCommerce and places them into a spreadsheet.
Each quantity-break pricing tier is exported as its own row. For example, if a product has three bulk pricing tiers, the exported file contains three rows for that product.
Only products that currently have bulk pricing tiers are included. Products without bulk pricing are skipped automatically.
Product Bulk Pricing vs. Price List Bulk Pricing: This tool exports quantity-break pricing stored directly on products. To export bulk pricing stored inside a BigCommerce Price List, use Export Price List Bulk Pricing.
The exported spreadsheet uses the same column structure accepted by the Bulk Pricing Updater. You can export the current tiers, edit them in the spreadsheet, and import the updated file back into BigCommerce.
When Should You Use This?
- You want a backup of the bulk pricing tiers currently assigned to your products.
- You need to audit or review which products have quantity-break pricing.
- You want to review bulk pricing across selected categories, brands, or groups of SKUs.
- You want a correctly formatted spreadsheet to edit and re-import using the Bulk Pricing Updater.
- You want to make bulk pricing changes without editing products individually in BigCommerce.
Before You Get Started
- Your store must be connected to BigCommerce with permission to read product and bulk pricing information.
- Decide whether you want to export every product with bulk pricing or use filters to narrow the results.
- 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 Bulk Pricing tool from your BigCommerce tools dashboard.
2 Select the Products
On the Select Products step, leave all filters blank to export every product that has bulk pricing. To narrow the export, apply one or more of the available product filters.
3 Enter the Filename
On the Export Options step, enter the filename you want to use for the exported spreadsheet.
4 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.
5 Confirm Email Delivery
Confirm or change the email address that should receive the download link when the export is complete.
6 Start the Export
Submit the export. The tool creates the file as a background job, so you can close the page while it runs.
7 Download the File
When the export is finished, you’ll receive an email containing a download link. Open the link to download the completed CSV or Excel file.
Filter Reference
All filters on the Select Products step are optional. Leave them blank to export every product that has bulk pricing tiers.
| Filter | Notes |
|---|---|
| SKU | Enter a single SKU or a comma-separated list of SKUs. Leave blank to include all products. |
| Keyword | Searches by product name or SKU. |
| Select Categories | Limits the export to products assigned to one or more selected categories. |
| Brand | Limits the export to products assigned to one selected brand. |
| Product Availability | Filters products by Available, Disabled, or Preorder status. |
| Product Condition | Filters products by New, Refurbished, or Used condition. |
| Featured Products | Filters products by Featured or Not Featured status. |
| Product Shipping Type | Filters products by Free Shipping or Paid Shipping. |
| Product Stock Status | Filters products by In Stock or Out of Stock status. |
| Product Visibility | Filters products by Visible or Not Visible status. |
File and Field Reference
The exported file always contains the following columns:
| Column | Notes |
|---|---|
| SKU | The SKU of the product associated with the bulk pricing tier. |
| Min Qty | The minimum quantity at which the bulk pricing tier begins. |
| Type | Determines how the Amount is applied. Possible values are price, percent, or fixed. |
| Amount | The set price, percentage discount, or fixed discount amount assigned to the tier. |
Ready for Re-Import: The exported spreadsheet uses the same column structure accepted by the Bulk Pricing Updater. You can edit the file and import it back into BigCommerce without restructuring the columns.
Troubleshooting and FAQ
A product is missing from the file
Only products that currently have bulk pricing tiers are exported. Products without quantity-break pricing are skipped automatically.
The export file is empty
Your filters may be too narrow, or none of the matching products may have bulk pricing tiers. Run the export again with fewer filters or leave all filters blank.
I didn’t receive an email or download link
Check your spam or junk folder and confirm that the correct email address was entered on the final step. You can also review the export in the tool’s History.