Comment on page

Import/Export Price List rules

You can automatically create Price List rules by using the import/export function on the application. This is helpful when you have many rules that you want to simultaneously upload to your store without making them manually.

Export Price List rule

Step 1: Check your saved Price List rules

Step 2: Export your existing rules

From Custom Pricing, head to Import/Export PL Rules, and you can start exporting your rules.
You can locate the Export buttons on the bottom of the page:
Once downloaded, you can open the file and make changes to the rules.

Import Custom Pricing rule

Step 1: Head to Import/Export PL Rules

From Custom Pricing, head to Import/Export PL Rules:

Step 2: Download sample file:

On the top of the page, you can download a sample file to input all the fields, instead of making a file from scratch.
You can also use the guidelines (next to the Download Sample button) to be informed of what types of input is needed for each row.
Import Guideline
  1. 1.
    id, titles, sku and barcode must be unique
  2. 2.
    status must be one of these values:
    • Enable
    • Disable
  3. 3.
    priority must be in the range of 0-99
  4. 4.
    apply_to_customers must be one of these values:
    • All
    • Logged-in customers
    • Not logged-in customers
    • Specific customers
    • Customer tags
  5. 5.
    apply_to_products muse be one of these values:
    • All products
    • Specific products
    • Product collections
    • Product tags
  6. 6.
    exclude_customers must be one of these values:
    • None
    • Specific customers
    • Customer tags
  7. 7.
    rule_setting field must be one of these value:
    • QB (Quantity Break)
    • AB (Amount Break)
  8. 8.
    If rule_setting is QB, rule_type must be one of these values:
    • Minimum Order Qty
    • Minimum Product Qty
    • Minimum Variant Qty
  9. 9.
    If rule_setting is AB, rule_type must be one of these values:
    • Order Amount
    • Product Amount
    • Variant Amount
  10. 10.
    discount_type must be one of these values:
    • Apply a price to selected products
    • Decrease a fixed amount of the original prices of selected products
    • Decrease the original prices of selected products by a percentage
  11. 11.
    table_style must be one of these values:
    1. 1.
      Full range & Discounts
    2. 2.
      Full range & Discounted prices
    3. 3.
      From & Discounts
    4. 4.
      From & Discounted prices 1
    5. 5.
      From & Discounted prices 2
    6. 6.
      From & Discounts with Discounted prices 1
    7. 7.
      From & Discounts with Discounted prices 2
    8. 8.
      Legacy 1
    9. 9.
      Legacy 2
  12. 12.
    If apply_to_customers field is Specific Customers, then customer_emails must not be empty and already exits in the Shopify store
  13. 13.
    If apply_to_customers or exclude_customers field is Customer tags, then customer_tags must not be empty
  14. 14.
    If apply_to_products field is Specific Products, then product_titles must not be empty
  15. 15.
    If apply_to_products field is Product tags, then product_tags must not be empty
  16. 16.
    If exclude_customers field is Specific customers, then exclude_customer_emails must not be empty
  17. 17.
    If exclude_customers field is Customer tags, then exclude_customers_tags must not be empty
  18. 18.
    exclude_customer_emails must already exist in your Shopify store
  19. 19.
    If exclude_customer_emails contains more than one email, then separate each email must be separated by a comma and a space ", "
  20. 20.
    sku and barcode must be formatted as “Text“
If everything is correct to the guideline, a Success Message should pop up:

Step 3: Choose to override existing rules or not

In case you have existing rules on your store, you can choose if the imported rules should override the existing ones or not.
Import and Add Rules: If you choose this option, the newly imported Price List rules will be added to the existing Price List rules and displayed in the Price List rules grid.
Import and Replace Rules: If you choose this option, existing Price List rules will be replaced by the newly imported ones. It means that the old Price List rules in your store will be deleted, and only newly imported rules will display in your Price List rules section.
If you need further assistance, please feel free to reach us at [email protected] or Live Chat.
Last modified 1mo ago