You can mass create QB rules with the import/export feature. This is helpful to create rules faster, and you don't have to create each rule manually.
Export Quantity Break rule
Step 1: Check your saved Quantity Break rules
Step 2: Export your existing rules
From Quantity/Amount Break (QB/AB), head to Import/Export, and you can start exporting your rules.
You can locate the Export buttons on the bottom of the page:
Once downloaded, you can open the file and make changes to the rules.
Import Quantity Break rule
Step 1: Head to Import/Export
From Quantity/Amount Break (QB/AB), head to Import/Export:
Step 2: Download sample file:
On the top of the page, you can download a sample file to input all the fields, instead of making a file from scratch.
You can also use the guidelines (next to the Download Sample button) to be informed of what types of input is needed for each row.
Import guidelines
id, titles, SKUs, and barcodes must be unique
status must be one of these values:
Enable
Disable
priority must be in the range of 0-99
apply_to_customers must be one of these values:
All
Logged-in customers
Not logged-in customers
Specific customers
Customer tags
apply_to_products must be one of these values:
All products
Specific products
Product collections
Product tags
Specific variants
exclude_product_type must be one of these values:
None
Specific products
Specific variants
Product tags
Product collections
exclude_customers must be one of these values:
None
Specific customers
Customer tags
rule_setting field must be one of these values:
QB (Quantity Break)
AB (Amount Break)
If rule_setting is QB, rule_type must be one of these values:
Minimum Order Qty
Minimum Product Qty
Minimum Variant Qty
If rule_setting is AB, rule_type must be one of these values:
Order Amount
Product Amount
Variant Amount
discount_type must be one of these values:
Apply a price to selected products
Decrease a fixed amount of the original prices of selected products
Decrease the original prices of selected products by a percentage
table_style must be one of these values:
Full range & Discounts
Full range & Discounted prices
From & Discounts
From & Discounted prices 1
From & Discounted prices 2
From & Discounts with Discounted prices 1
From & Discounts with Discounted prices 2
Legacy 1
Legacy 2
If apply_to_customers field is Specific Customers, then customer_emails must not be empty and already exits in the Shopify store
If apply_to_customers or exclude_customers field is Customer tags, then customer_tags must not be empty
If apply_to_products is Specific Products, please enter at least one of these fields:
product_titles
sku
barcode
If apply_to_products field is Product tags, then product_tags must not be empty
If apply_to_products is Specific variants, please enter at least one of these fields:
variant_ids
sku
barcode
If apply_to_products is Specific variants, then rule_type "Minimum Product Qty" for QB, and "Product Amount" for AB is not able to apply
If exc_product_type is Specific products, please enter at least one of these fields:
exc_product_titles
exc_sku
exc_barcode
If product_condition_type is Specific variants, please enter at least one of these fields
exc_variants_id
exc_sku
exc_barcode
If exc_product_type is Product tags, then exc_product_tags must not be empty
If exc_product_type is Product collections, then exc_product_collections must not be empty
If exclude_customers is Specific customers, then exclude_customer_emails must not be empty
If exclude_customers is Customer tags, then exclude_customers_tags must not be empty
exclude_customer_emails must already exist in your Shopify store
If exclude_customer_emails contains more than one email, then separate each email must be separated by a comma and a space ", "
SKU and barcode must be formatted as “Text“
If everything is correct to the guideline, a Success Message should pop up:
Step 3: Choose to override existing rules or not
In case you have existing rules on your store, you can choose if the imported rules should override the existing ones or not.
Import and Add Rules: If you choose this option, the newly imported Quantity Break rules will be added to the existing rules and displayed in the rules grid.
Import and Replace Rules: If you choose this option, existing Quantity Break rules will be replaced by the newly imported ones. It means that the old rules in your store will be deleted, and only newly imported rules will display in your rules section.
If you need further assistance, please feel free to reach us at support-sbc@bsscommerce.com or Live Chat.
