Skip to content

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.


  1. Go to B2B pricing > Price Lists.
  2. Click Export above the rule list.
  3. Choose an export scope: Current page, Selected records (when you ticked rules), records matching your search (when a search is active) or All records.
  4. Choose a file format: CSV or Excel (.xlsx).
  5. The export runs as a background job. A progress indicator shows how far along it is; you can keep working while it finishes.
  6. When it completes, click the download link.

Export rules dialog on the Price Lists page

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.


    1. Go to B2B pricing > Price Lists.
    2. Click Import above the rule list. The Import rules by CSV dialog opens.
    3. Click Download sample CSV to get pl_rules_template.csv.

  1. 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.

    1. In the Import modal, click Add files and select your CSV.
    2. 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.
    3. 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.
    4. 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.

    Import rules by CSV dialog on the Price Lists page

    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.

Merchants often ask which Discount type value to enter in the CSV. Below is a quick decision guide and complete reference:

  • “I want to sell this product for an exact wholesale price (e.g., exactly $45.00)”
    ➔ Choose Set a fixed price and enter 45 in Discount 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”
    ➔ Choose Set 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)”
    ➔ Choose Decrease fixed amount and enter 10 in Discount value.
  • “I want to offer a percentage discount off the retail price (e.g., 20% off)”
    ➔ Choose Decrease fixed percentage and enter 20 in Discount value.

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

Product page with the price list price and struck original


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.

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,,,,

  • 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 Product cell.
  • Check file size limits: Ensure the file is under 10 MB and saved in standard .csv format (UTF-8). A .csv file 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 .txt file, 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.

Cart for a B2B buyer on a price list: Lightweight Hand Lotion at $20.00 instead of $37.40 and Hydrating Milk and Honey Body Lotion at $73.60 instead of $83.60