Import & Export Custom Pricing Rules
Bulk-manage your Custom Pricing rules with a CSV file: useful for large catalogs, many customer segments, or moving rules between stores.
Export Existing Rules
Section titled “Export Existing Rules”- Go to B2B pricing > Custom Pricing.
- Click Export above the rule list.
- Choose an export scope: Current page, Selected records (when you ticked rules), records matching your search (when a search is active) or All records.
- Choose a file format: CSV or Excel (.xlsx).
- The export runs as a background job. A progress indicator shows how far along it is; you can keep working while it finishes.
- When it completes, click the 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.
The exported file contains your rules and serves as both a backup and an edit template.


Import New or Modified Rules
Section titled “Import New or Modified Rules”-
Download the Sample Template
Section titled “Download the Sample Template”- Click Import above the rule list.
- In the Import rules by CSV dialog, click Download sample CSV.
- Open the file in Excel or Google Sheets: it includes formatting guidelines.

-
Fill In Your Rules
Section titled “Fill In Your Rules”Scenario What to do Creating a new rule Leave the ID column blank Updating an existing rule Include the matching rule ID Overwriting by ID Enable the Overwrite checkbox in the import dialog Required columns:
Name,Priority,Status(enableordisable),Market,Customer condition,Exclude customer condition,Product condition,Exclude product condition,Discount type,Discount value. LeaveIDblank to create a rule.Key constraints:
- File must be CSV format, up to 5 MB
- New rules require a blank ID field
- Customer emails and product SKUs must match exactly what’s in Shopify
-
Upload & Import
Section titled “Upload & Import”- Click Import above the rule list.
- Click Add files and choose your completed CSV (up to 5 MB).

- Choose your import behavior:
- Check Overwrite rules with matching IDs: updates existing rules whose IDs match rows in the file; all other rules are kept as-is.
- Check Replace all existing rules: deletes all current rules and replaces them entirely with the imported set. The app asks you to confirm before it deletes anything (see the next step).
- Click Validate and import. If you checked Replace all existing rules, the Replace all rules? window opens. 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.
- The system validates data and processes in the background.
- Successful imports activate rules immediately. Errors return row-specific messages.


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.
CSV column reference
Section titled “CSV column reference”The file uses these columns: ID, Name, Priority, Status, Market, Customer condition, Customers, Exclude customer condition, Exclude customers, Product condition, Products, Exclude product condition, Exclude products, Discount type, Discount value, Start date, Start time, End date, End time.
Condition and type columns accept only these values:
| Column | Allowed values |
|---|---|
| Customer condition | All, Logged-in, Not logged-in, Specific customers, Customer tags, Company locations, All company locations |
| Exclude customer condition | None, Specific customers, Customer tags, Company locations |
| Product condition | All, Specific products, Specific variants, Specific collections, Specific tags |
| Exclude product condition | None, Specific products, Specific variants, Specific collections, Specific tags |
| Discount type | Set a fixed price, Fixed price, Decrease fixed amount, Decrease fixed percentage, Increasing price, Increase fixed amount, Increase fixed percentage |
All company locations needs no value in Customers. Its Market cell must still not be empty (enter All), but its value is ignored: the rule applies in every market. Company locations is the label for specific company locations; it stays as it was.
Any column left out of an imported row is reset to empty for that rule.
Best Practices & Tips
Section titled “Best Practices & Tips”- Back up your current rules by exporting before making sweeping changes
- Use the sample file as your base - don’t change header names
- Include IDs only when you intend to update existing rules
- When mixing imports and overrides, carefully manage your overwrite and replacement settings to avoid accidental deletions
- Keep your file size at or below 5 MB
- Make sure your customer email addresses, product SKUs, and other referenced values match the store data exactly
- Display Custom Pricing: How Prices Appear to CustomersControl how custom wholesale prices are displayed on product pages, in the cart, and at checkout. These settings let you choose what original and discounted prices customers see.
- Set Unique Prices for Wholesale CustomersAssign exclusive wholesale pricing to specific customers or groups - without duplicating products or using coupon codes. Eligible customers see their personalized prices automatically when logged in.
- Custom PricingCustom Pricing lets you define unique prices for different customers or customer groups. Instead of running store-wide discounts, you set precise wholesale rates per segment
- More: Add Depth & Flexibility to Your B2B PricingExtra Fee and Shipping Rate let you charge handling fees and custom B2B shipping rates on top of your wholesale pricing rules.