Import & Export Volume Pricing Rules
Use bulk import/export to manage many volume pricing rules at once, ideal when you have large product catalogs or need to replicate rules across multiple stores.
Need to manage many pricing rules at once? Our Import / Export feature for Volume Pricing makes it simple. You can bulk create, edit, or migrate discount rules without having to configure each one manually, saving time and reducing errors.
Export Existing Rules
Section titled “Export Existing Rules”- Go to B2B pricing > Volume Pricing.
- Click Export above the rule list.
- Choose an export scope: Current page, Selected records (when you ticked rules), records matching your search (when a search is active) or All records.
- Choose a file format: CSV or Excel (.xlsx).
- The export runs as a background job. A progress indicator shows how far along it is; you can keep working while it finishes.
- When it completes, click the download link.


To export only some rules, tick them in the list, then click Export selected in the bar that appears. Export rules opens with Selected records already chosen.


Use the exported file as a backup or starting point for bulk edits.

Import New or Updated Rules
Section titled “Import New or Updated Rules”Step 1: Download the Sample Template
Section titled “Step 1: Download the Sample Template”- Go to B2B pricing > Volume Pricing and click Import above the rule list.
- In the Import rules by CSV dialog, click Download sample CSV.
- Open the file in Excel or Google Sheets.

The sample file includes all required columns and a guidelines sheet explaining valid values.
Step 2: Fill In Your Rules
Section titled “Step 2: Fill In Your Rules”Each row of the CSV is one pricing tier. A rule with three tiers takes three rows that share the same ID and Name; only the tier columns (From, To, Discount type, Discount value) change from row to row.
| Scenario | What to do |
|---|---|
| Creating a new rule | Leave the ID column blank |
| Updating an existing rule | Keep the rule’s ID and tick Overwrite rules with matching IDs when you import |
| Rebuilding everything from the file | Tick Replace all existing rules when you import |
CSV columns (the header row must match the sample file). Separate several values in one cell with commas.
| Column | Accepted values |
|---|---|
| ID | Blank for a new rule, or the ID of an existing rule |
| Name | Any text |
| Priority | 0 to 99. A lower number wins when several rules match |
| Status | enable or disable (lowercase) |
| Market | All, or the names of the markets the rule targets. Ignored for All company locations, which applies in every market, so it may be left empty |
| Customer condition | All, Logged-in, Not logged-in, Specific customers, Customer tags, Company locations, All company locations |
| Customers | Customer emails, customer tags or company location names, matching Customer condition. Leave empty for All company locations |
| Exclude customer condition | None, Customer tags, Specific customers, Company locations |
| Exclude customers | Values matching Exclude customer condition |
| Product condition | All, Specific products, Specific collections, Specific tags, Specific variants |
| Products | Product titles (or a variant SKU/barcode), collection titles, product tags, or variant SKUs/barcodes/IDs, matching Product condition |
| Exclude product condition | None, Specific products, Specific collections, Specific tags, Specific variants |
| Exclude products | Values matching Exclude product condition |
| Volume pricing type | Quantity (quantity-based pricing) or Value (value-based pricing) |
| Apply level | Product (Each product in the app), Order (All products that use this rule (one total)) or Variant (Each variant). Product is not available when Product condition is Specific variants. Each collection cannot be set in the file: choose it in the app |
| Table style | One of the 10 table style names in the sample file, for example From & Discounts, Full range & Discounted prices or Legacy 1 |
| From | Start of the tier (quantity or order value) |
| To | End of the tier. Leave blank for “and above” |
| Discount type | Fixed price, Decrease fixed amount, Decrease fixed percentage |
| Discount value | Number. For a percentage, enter 10 for 10% |
When Customer condition, Product condition or an exclude condition is anything other than All / None, its value column must not be empty, and every customer, product, collection, variant, market or company location listed must exist in your store. Values that cannot be found are reported in the error file.
Step 3: Upload & Import
Section titled “Step 3: Upload & Import”
- Click Import above the rule list.
- Click Add files and choose your file. Only
.csvis accepted, maximum 10 MB. - Choose how the file is applied (both are optional):
- Overwrite rules with matching IDs: existing values are replaced for all columns included in the file.
- Replace all existing rules: removes all current rules and replaces them with the rules in the file.
- Click Validate and import. If you checked Replace all existing rules, the Replace all rules? window opens first. It shows how many current rules will be deleted and says You can’t undo this. Click Delete N rules and import to go ahead, or Back to change your choice. Nothing is deleted until you confirm. To keep a copy first, click Back, close the import window and export your rules.
- The app validates the file first, then imports it in the background. A progress banner shows the percentage validated and imported.
- If some rows fail, the app shows how many rules failed and gives you a file with the error for each row. Fix those rows and import the file again.

If the import doesn’t start
- The import didn’t start: the upload was interrupted, usually by your connection. Check your connection and click Try again. The app sends the same file with the same options.
- This file is too large to upload: split the rules into smaller CSV files and import them one at a time. This message has no Try again button, because sending the same file would fail again.
Best Practices
Section titled “Best Practices”- Export your current rules first before using Replace all existing rules, so you have a backup to restore.
- Start from the sample file of the current version: the banner “File format updates” in the import dialog means the column layout has changed since older exports.
- Double-check customer emails, product titles and variant SKUs: a value that does not exist in your store fails the row.
- Keep priority numbers deliberate: when several rules match the same product, the rule with the lowest number applies.
- Leave Overwrite rules with matching IDs off when you only want to add new rules.
- Set Tiered Pricing by Purchase VolumeThis guide walks you through creating a Volume Pricing rule, from enabling the module to defining tiers and activating the rule on your storefront.
- Settings for Volume PricingControl how the volume pricing table behaves and looks on your storefront. These settings apply globally across all volume pricing rules.
- Translate the Volume Pricing Table LabelsFind the Translations page for Volume Pricing and change the table headings, column titles and discount wording for each language of your store.
- Custom PricingCustom Pricing lets you define unique prices for different customers or customer groups. Instead of running store-wide discounts, you set precise wholesale rates per segment