Skip to content

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.

  1. Go to B2B pricing > Volume Pricing.
  2. Click Export above the rule list.
  3. Choose an export scope: Current page, Selected records (when you ticked rules), records matching your search (when a search is active) or All records.
  4. Choose a file format: CSV or Excel (.xlsx).
  5. The export runs as a background job. A progress indicator shows how far along it is; you can keep working while it finishes.
  6. When it completes, click the download link.

Export rules window with scope and file format

Banner confirming the export with a 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.

Selecting a rule shows the Export selected button

Export rules window with Selected records chosen

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

Export history list with download links


  1. Go to B2B pricing > Volume Pricing and click Import above the rule list.
  2. In the Import rules by CSV dialog, click Download sample CSV.
  3. Open the file in Excel or Google Sheets.

Import window with Download sample CSV highlighted

The sample file includes all required columns and a guidelines sheet explaining valid values.

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.

Import window with a file added and two import options

  1. Click Import above the rule list.
  2. Click Add files and choose your file. Only .csv is accepted, maximum 10 MB.
  3. 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.
  4. 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.
  5. The app validates the file first, then imports it in the background. A progress banner shows the percentage validated and imported.
  6. 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.

Replace all rules confirmation window

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.

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