🔧 Quick Info: This tool exports the quantity-discount tiers on your products to a spreadsheet. Each tier becomes its own row, and only products with bulk pricing are included. The exported file is formatted to re-import with the Bulk Pricing Updater.
Note: This tool exports bulk pricing set directly on your products (the “buy 10+ and pay less” quantity discounts). If you manage quantity discounts inside a BigCommerce Price List for customer groups, use Export Price List Bulk Pricing instead.
What It Does
Export Product Bulk Pricing pulls the quantity-discount tiers attached directly to your products out of BigCommerce and into a spreadsheet. Each tier becomes its own row, so a product with three different quantity breaks produces three rows in your export. Only products that actually have bulk pricing are included – products with no quantity tiers are skipped. The exported file comes with columns for SKU, Min Qty, Type, and Amount, which is the exact same format the Bulk Pricing Updater uses for imports.
When Should You Use This?
Use this tool whenever you need your product bulk pricing in a spreadsheet format. Common scenarios include creating a backup or audit of your current quantity-break pricing, getting a correctly formatted file to edit and re-import with the Bulk Pricing Updater, or reviewing which products have quantity-break pricing set up and what those tiers look like.
Before You Get Started
- Your store must be connected to BigCommerce with the proper permissions.
- Decide how to narrow the export, or leave the filters blank to export every product’s bulk pricing.
- Pick where you want the download link sent (your email by default).
How to Use It
1 Open the Tool
Navigate to the Export Product Bulk Pricing tool in your Your Store Wizards dashboard for your BigCommerce store.
2 Filter Your Products (Optional)
On the Select Products step, optionally filter which products to include. Leave all filters blank to export every product’s bulk pricing. Available filters include:
- SKU – A single SKU or a comma-separated list.
- Keyword – Search by product name or SKU.
- Select Categories – One or more categories.
- Brand – A single brand.
- Product Availability – Available, Disabled, or Preorder.
- Product Condition – New, Refurbished, or Used.
- Featured Products – Featured or Not Featured.
- Product Shipping Type – Free Shipping or Paid Shipping.
- Product Stock Status – Out of Stock or In Stock.
- Product Visibility – Visible or Not Visible.
3 Configure Your Export
On the Export Options step, set up your file:
- Filename – Enter a name for your export file.
- File Format – Choose between CSV or Excel format.
4 Confirm Email Delivery
On the Email Delivery step, confirm (or change) the address we should send the download link to.
5 Start the Export
Submit and the export runs as a background job. You can close the page and work on other things. We’ll email you a download link when the file is ready.
File and Field Reference
Exported Columns
The file always contains these four fields. This is the exact same format the Bulk Pricing Updater uses for imports, so you can edit the file and push it straight back to update your bulk pricing:
| Column Name | Notes |
|---|---|
| Amount | The tier’s discount value. |
| Min Qty | The minimum quantity for the tier. |
| Sku | The product SKU. |
| Type | How the amount applies: price, percent, or fixed. |
Troubleshooting
A product is missing from the file
Only products that have bulk pricing tiers are exported. Products with no quantity tiers are skipped, so if a product isn’t in your file, it probably doesn’t have any bulk pricing set up.
Export looks empty
Your filters may be too narrow, or none of the matching products have bulk pricing set up. Try clearing the filters and running the export again to see all products with bulk pricing.
No email or no download link
Check your spam folder, confirm the recipient address on the final step, and review the run in the tool’s History to see what happened.
Permission errors
Check out our guide on resolving API permission errors.