Import products into a wholesale pricing rule
Add a batch of products (and their custom prices) straight into a single wholesale pricing rule you're already editing, by uploading a CSV or XLSX file.
This is a lighter-weight import than Import multiple products for Wholesale pricing setup. Use it when you already have a wholesale pricing rule open — new or existing — and just want to add many products (and their custom 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, and prices.
Step 1: Prepare your file
Create a CSV or XLSX file with one row per product or variant, 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.
Discount Type
No
percent, fixed (fixed amount off), or amount. Defaults to percent.
Discount Value
Yes
The price for this product/variant, for the rule's current audience (all/logged/non-logged customers).
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 wholesale_products_example.csv or wholesale_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?