Import & Export Price List Rules
When managing large catalogs or tailoring numerous pricing schemes for different B2B customer tiers, manually creating each price list in the admin can be time-consuming. The Import & Export Price List feature allows you to bulk upload, update, or migrate Price List rules using a CSV file.
Export Existing Rules
Section titled “Export Existing Rules”- Go to B2B pricing > Price Lists.
- 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.
Import New or Updated Rules
Section titled “Import New or Updated Rules”-
Download the Sample Template
Section titled “Download the Sample Template”- Go to B2B pricing > Price Lists.
- Click Import above the rule list. The Import rules by CSV dialog opens.
- Click Download sample CSV to get
pl_rules_template.csv.
-
Fill in the CSV Template
Section titled “Fill in the CSV Template”Fill in your pricing rules according to your update goal:
Scenario What to fill in CSV Create a new rule Leave the ID column blank. Update an existing rule Include the rule’s numerical ID (obtained from an export). Multiple products in one rule Put rule settings on the first row. For subsequent products in the same rule, fill only the Product, Discount type, and Discount value columns, leaving rule-level columns blank.
-
Upload & Import
Section titled “Upload & Import”- In the Import modal, click Add files and select your CSV.
- Select your import mode:
- Overwrite rules with matching IDs: Updates existing rules matching provided IDs and creates new rules for rows without IDs. Unmentioned rules remain unchanged. If the file has IDs and you do not select Overwrite rules with matching IDs, the import stops with an error and nothing is imported. To update, select Overwrite. To add the rows as new rules, delete the values in the ID column.
- Replace all existing rules: Deletes all current Price List rules and replaces them entirely with the imported dataset.
- Click Validate and import. If you chose Replace all existing rules, the Replace all rules? window opens first. 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 headers and row values. If validation passes, the import processes in the background. If errors occur, download the error report CSV to review row-level error 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.
The sections below explain the Discount type values and every CSV column.
Choosing the Right Discount Type
Section titled “Choosing the Right Discount Type”Merchants often ask which Discount type value to enter in the CSV. Below is a quick decision guide and complete reference:
Quick Decision Guide
Section titled “Quick Decision Guide”- “I want to sell this product for an exact wholesale price (e.g., exactly $45.00)”
➔ ChooseSet a fixed priceand enter45inDiscount value. It applies whether $45 is below or above the original price (Apply when: Always), except on stores where B2B prices are applied by a Shopify discount at checkout: there the price must be lower than the original price, or the row is rejected. - “I want my price only when it is cheaper than the retail price”
➔ ChooseSet a fixed price - Lower than product price(Apply when: Only if lower). - “I want to deduct a fixed dollar amount off the retail price (e.g., $10.00 off)”
➔ ChooseDecrease fixed amountand enter10inDiscount value. - “I want to offer a percentage discount off the retail price (e.g., 20% off)”
➔ ChooseDecrease fixed percentageand enter20inDiscount value.
Discount Type Reference & Comparison
Section titled “Discount Type Reference & Comparison”Value to enter in CSV (Discount type) |
Matching In-App UI Option | Calculation Formula | Value Format | Storefront Example (Original = $100.00) |
|---|---|---|---|---|
Set a fixed price |
Set a fixed price | Final Price = Discount value |
Number above 0 (e.g., 80) |
Value = 80 ➔ Final Price: $80.00 |
Set a fixed price - Lower than product price |
Set a fixed price, Apply when Only if lower | Final Price = Discount value, only while it is below the original price |
Positive number (e.g., 80) |
Value = 80 ➔ Final Price: $80.00 |
Set a fixed price - Higher than product price |
Set a fixed price, Apply when Only if higher | Final Price = Discount value, only while it is above the original price |
Positive number (e.g., 120) |
Value = 120 ➔ Final Price: $120.00 |
Decrease fixed amount |
Decrease a fixed amount | Final Price = Original Price - Discount value |
Positive number (e.g., 15) |
Value = 15 ➔ Final Price: $85.00 |
Decrease fixed percentage |
Decrease in percentage | Final Price = Original Price × (1 - Discount value %) |
Number from 0 to 100 (e.g., 20) |
Value = 20 ➔ Final Price: $80.00 |
Increase fixed amount |
Increase a fixed amount | Final Price = Original Price + Discount value |
Positive number (e.g., 10) |
Value = 10 ➔ Final Price: $110.00 |
Increase fixed percentage |
Increase in percentage | Final Price = Original Price × (1 + Discount value %) |
Number from 0 to 100 (e.g., 10) |
Value = 10 ➔ Final Price: $110.00 |

CSV Column Reference
Section titled “CSV Column Reference”The table below lists all supported columns in the Price List CSV template:
| Column Header | Requirement | Data Type | Accepted Values & Formatting |
|---|---|---|---|
| ID | Optional | Number | Rule ID. Leave blank when creating a new rule; fill in matching ID when updating an existing rule. |
| Name | Required | String | Internal name of the price list rule (e.g., VIP Wholesale Pricing). |
| Priority | Required | Number | Integer from 0 to 99 (0 is highest priority when rules overlap). |
| Status | Required | String | enable or disable. |
| Market | Required | String | All or specific Shopify Market name (e.g., United States). Must not be empty. Ignored for All company locations, which applies in every market. |
| Customer condition | Required | String | One of: All, Logged-in, Not logged-in, Specific customers, Customer tags, Company locations, All company locations. |
| Customers | Conditional | String | Comma-separated list of customer emails, tags, or company location IDs (required when condition is Specific customers, Customer tags, or Company locations; leave empty for All company locations). |
| Exclude customer condition | Required | String | One of: None, Specific customers, Customer tags, Company locations. |
| Exclude customers | Conditional | String | Comma-separated list of customer emails, tags, or company location IDs to exclude. |
| Exclude product condition | Required | String | One of: None, Specific products, Specific variants, Specific collections, Specific tags. |
| Exclude products | Conditional | String | Comma-separated list of items to exclude, matching the condition above: product/variant IDs, titles, SKUs, or barcodes for Specific products / Specific variants, collection IDs or titles for Specific collections, or product tags for Specific tags. Required when Exclude product condition is not None. |
| Apply level | Required | String | Product (applies to all variants) or Variant (applies to specific variant). |
| Product | Required | String | Identifier for the item: Product Title (for Product level) or Variant ID / SKU / Barcode (for Variant level). |
| Discount type | Required | String | One of: Set a fixed price, Set a fixed price - Lower than product price, Set a fixed price - Higher than product price, Decrease fixed amount, Decrease fixed percentage, Increase fixed amount, Increase fixed percentage. Older Fixed price and Increasing price still import. |
| Discount value | Required | Number | Positive number (e.g., 50 for $50 fixed/off, or 20 for 20%). |
| Start date | Optional | Date | YYYY-MM-DD (e.g., 2026-09-01). |
| Start time | Optional | Time | HH:MM or HH:MM:SS (e.g., 00:00). |
| End date | Optional | Date | YYYY-MM-DD (e.g., 2026-12-31). |
| End time | Optional | Time | HH:MM or HH:MM:SS (e.g., 23:59). |
| SKU | Optional | String | Added by every export, after the last column, so you can see each item’s SKU. It is for reference only: an import accepts the column but does not read it, so keep identifying items in the Product column. You can leave it out of a file you import. |
Sample CSV Structure
Section titled “Sample CSV Structure”Here is an example showing how multi-product rules are structured in the CSV:
ID,Name,Priority,Status,Market,Customer condition,Customers,Exclude customer condition,Exclude customers,Exclude product condition,Exclude products,Apply level,Product,Discount type,Discount value,Start date,Start time,End date,End time,VIP Wholesalers,0,enable,All,Customer tags,vip-wholesale,None,,Specific tags,clearance,Product,Classic T-Shirt,Decrease fixed percentage,25,2026-09-01,00:00,2026-12-31,23:59,,,,,,,,,,,,Leather Jacket,Fixed price,120,,,,,,,,,,,,,,,,Denim Jeans,Decrease fixed amount,15,,,,Best Practices & Troubleshooting
Section titled “Best Practices & Troubleshooting”- Always backup first: Export your existing rules to a CSV before performing bulk updates or replacements.
- Keep column headers unchanged: Do not rename, remove, or rearrange header columns from the template.
- One product/variant per row: Do not list multiple products or SKUs in a single
Productcell. - Check file size limits: Ensure the file is under 10 MB and saved in standard
.csvformat (UTF-8). A.csvfile whose separator is;or a tab, or that starts with a BOM, is accepted, so a CSV saved from Excel works as it is. Excel’s Text (Tab delimited) export saves a.txtfile, which is not accepted. - Propagation time: Once imported, rule updates write to store metafields and typically take 1 to 3 minutes to reflect across the live storefront.

- Display Custom Pricing for Price ListsControl how Price List prices appear to customers on product pages, in the cart and at checkout, and which original prices stay visible.
- Set Customized Pricing per Product per CustomerCreate a price list that adjusts product or variant prices for a specific customer or customer group.
- 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.