🔄 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

1. Go to B2B Pricing → Volume Pricing → Configuration.

2. Click Export.

3. Download the CSV file containing all current rules.

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

---

📥 Import New or Updated Rules

Step 1: Download the Sample Template

1. Click Import on the Configuration page.

2. In the import dialog, click Download CSV sample.

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

Key rules for the CSV:

Scenario	What to do
Creating a new rule	Leave the ID column blank
Updating an existing rule	Include the rule's ID
Overwriting existing rules by ID	Check the Overwrite option in the import dialog

Required fields: id, name, priority, status

id, titles, SKUs, barcodes must be unique

Other configurable fields:

Field	Values
Status	Enable / Disable
Priority	0–99
Apply to customers	All, Logged-in customers, Not logged-in customers, Specific customers, Customer tags
Apply to products	All products, Specific products, Product collections, Product tags, Specific variants
Exclude products	None, Specific products, Specific variants, Product tags, Product collections
Exclude customers	None, Specific customers, Customer tags
Rule type	QB (quantity-based) or AB (amount/value-based) For QB, rule_type should be one of: Minimum Order Qty, Minimum Product Qty, Minimum Variant Qty For AB, rule_type options are: Order Amount, Product Amount, Variant Amount
Discount type	Fixed price, Fixed amount decrease, Percentage decrease
Table style	Full range & Discounts, From & Discounted prices, Legacy 1, etc

Depending on your Apply to customers or Apply to products (Exclude also) choice, specific fields like customer_emails, product_titles, sku, barcode, or variant_ids must not be empty and must correspond to actual data in your store.

Step 3: Upload & Import

1. Click Import on the Configuration page.

2. Upload your CSV file.

3. Choose import behavior:

   • Import and Add Rules — adds new rules without removing existing ones

   • Import and Replace Rules — deletes all current rules and replaces with the imported set

4. The system validates your file and processes it in the background.

5. Successful imports activate rules immediately. Rows with errors return specific error messages.

---

Best Practices

• Always back up your current rules before replacing them entirely.

• Use the sample file as a guide — errors often come from missing or improperly formatted fields.

• Double-check customer and product identifiers (emails, SKUs, barcodes, variant IDs) to make sure they exist in your store — otherwise the rule won’t apply.

• Keep priority numbers consistent so your new rules take effect in the intended order.

• Use the merge option if you want to retain existing rules but add new ones.

• Use the replace option when you're making a full refresh or restructuring your pricing logic.

Encounter a problem? Feel free to reach us at [e-mail] or Live Chat.