Import products into a volume pricing rule
Add a batch of products, quantity tiers, and their custom prices straight into a single volume pricing rule you're already editing, by uploading a CSV or XLSX file.
This is a lighter-weight import than Import multiple products for Volume pricing setup. Use it when you already have a volume pricing rule open — new or existing — and just want to add many products, quantity tiers, and prices to it, without creating extra rules. The rule's audience (which customers it applies to) is whatever you've already configured in the Customer tab; the file only needs to carry products, variants, tiers, and prices.
Step 1: Prepare your file
Create a CSV or XLSX file with one row per product/variant tier, using the columns below. Column order doesn't matter — the file is read by header name — so you only need to include the columns you're actually using.
Full column reference
Product ID
Conditional
The Shopify product ID to price. Required unless you're using SKU instead. See below for how to find it.
Variant ID
No
Fill in to price one specific variant instead of the whole product. See below for how to find it.
SKU
Conditional
A variant's SKU. If a row has a SKU, it's looked up in your store and takes priority over Product ID/Variant ID — you don't need to fill those in for that row.
From Quantity
No
The lower threshold of this tier, e.g. 10 for "buy 10 to 20 units, get 10% off". Use From Amount instead if the rule's Type is Amount.
To Quantity
No
The upper threshold of this tier, e.g. 20 for the same example. Leave blank for an open-ended top tier. Use To Amount instead if the rule's Type is Amount.
From Amount
No
Same as From Quantity, for rules where Type is Amount.
To Amount
No
Same as To Quantity, for rules where Type is Amount.
Discount Type
No
percent, fixed (fixed amount off), or amount. Defaults to percent.
Discount Value
Yes
The price for this product/variant at this tier, for the rule's current audience (all/logged/non-logged customers).
Multiple tiers for the same product: add one row per tier, repeating the same Product ID (and Variant ID, if pricing a specific variant) with a different From/To range each time.
Pricing different customer segments differently: if the rule's audience is customer tags or specific customers, replace the Discount Value column with one column per tag name or customer ID instead, and fill in each segment's price in its own column. If the file's extra columns are tag names or customer IDs that aren't part of the rule yet, they're added to the rule's audience automatically when you confirm the import.
Finding a product ID: go to the Products folder in Shopify, open the product, and check the page URL — the product ID is the number at the end of the link.
Finding a variant ID: open the product, go to the variant you need, and click into it. The variant ID is the number at the end of that page's URL.
Sample file: download volume_products_example.csv or volume_products_example.xlsx to see the format in action.
Once your file is ready, save it.
Step 2: Upload the file to the rule
Last updated
Was this helpful?