Skip to content

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.

  1. Go to B2B pricing > Custom Pricing.
  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 with scope and file format

Export complete banner with 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.

More actions menu with Export history

Export history page listing the exported file

    1. Click Import above the rule list.
    2. In the Import rules by CSV dialog, click Download sample CSV.
    3. Open the file in Excel or Google Sheets: it includes formatting guidelines.

    Import rules by CSV dialog with the sample download link

  1. 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 (enable or disable), Market, Customer condition, Exclude customer condition, Product condition, Exclude product condition, Discount type, Discount value. Leave ID blank 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
    1. Click Import above the rule list.
    2. Click Add files and choose your completed CSV (up to 5 MB).

    Import dialog with a file chosen and the overwrite options

    1. Choose your import behavior:
      1. Check Overwrite rules with matching IDs: updates existing rules whose IDs match rows in the file; all other rules are kept as-is.
      2. 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).
    2. 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.
    3. The system validates data and processes in the background.
    4. Successful imports activate rules immediately. Errors return row-specific messages.

    Import complete banner

    Storefront after import: Ceramic Espresso Cups show $49.50

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

  • 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