🔄 Import & Export Price List Rules

When managing large catalogs or tailoring numerous pricing schemes for many clients, manually creating each price list is often impractical. Our Import / Export Price List feature helps you bulk upload, edit, or migrate Price List rules effortlessly — saving hours and minimizing mistakes.

📤 Export Your Price List Rules

1. In your app dashboard, navigate to Import / Export PL Rules under the Price List module.

2. Click the Export button (typically found at the bottom of the page).

3. Download a CSV file containing all your current price list rules.

4. Open the file to review or modify existing rules — it becomes your working template for bulk edits.

---

📥 Import New or Updated Rules

Step 1: Download the Sample Template

• From the Import / Export PL Rules section, click Download Sample File.

• The template includes all required columns and guidelines to help you fill in correct values.

Step 2: Fill Out the Template

• To create new rules: Leave the ID column blank.

• To update existing rules: Include the matching ID in your worksheet.

• Be sure to follow formatting guidelines for each column (priority, status, product identifiers, discount types, etc.).

• Input fields such as apply_to_customers, apply_to_products, start/end dates, and discount type/value must adhere to the allowed values.

Step 3: Import & Choose Overwrite Behavior

• Upload your completed CSV in the same Import / Export PL Rules section.

• Choose whether to Add (merge with existing rules) or Replace (overwrite all existing rules).

  • Add / Merge: Adds your new entries alongside existing ones.

  • Replace: Deletes all current rules and replaces them with the imported set.

• After upload, the app validates your file and applies new or updated rules. If there are errors, it will display messages pointing to invalid rows or fields.

• Once successful, your newly imported rules are live and active.

ID	Required for updating rule	Number	Used only when updating an existing rule. Leave blank for new entries.
Name	Required	String	Rule name for internal identification.
Priority	Required	Number	Value must be a positive integer from 0–99 (0 = highest priority).
Status	Required	String	Must be either enable or disable.
Market	Required	String	Fill in All for all markets or list country codes separated by commas.
Apply_to_customers	Required	String	One of: All, Logged-in, Not logged-in, Specific customers, Customer tags.
Customers_email / Customers_tags	Required when Apply_to_customers is Specific customers or Customer tags	String	List of customer emails or tags, separated by commas.
Exclude customers	Required	String	One of: None, Specific customers, Customer tags.
Exclude_customers_email / Exclude_customers_tags	Required when exclusion applies	String	List of emails or tags to exclude, separated by commas.
Exclude product condition	Required	String	One of: None, Specific variants.
Exclude products	Required when exclusion applies	String	List of variant IDs, SKUs, or barcodes separated by commas.
Start date	Optional	Date	Format: YYYY-MM-DD. Defines when the rule becomes active.
Start time	Optional	Time	Format: HH:MM. Works with the start date for precise timing.
End date	Optional	Date	Format: YYYY-MM-DD. Defines when the rule ends.
End time	Optional	Time	Format: HH:MM. Works with the end date for precise timing.
Apply_at	Required	String	One of: Specific products or Specific variants.
Product_title / SKU / Barcode	Required (one field) when applying to specific products	String	List of product identifiers separated by commas.
Variant_ids / SKU / Barcode	Required (one field) when applying to specific variants	String	List of variant identifiers separated by commas.
Discount type	Required	String	One of the following: – Apply a price to selected products – Decrease a fixed amount of original prices – Decrease original prices by a percentage
Discount value	Required	Number	Positive number defining the discount or fixed price value.

---

✅ Tips & Best Practices

• Always export and back up your current rules before importing.

• Use the sample file template — altering column headers can cause import failures.

• Only use the Replace option when you want to refresh your entire pricing structure.

• Double-check your product SKUs, variant IDs, and customer identifiers to ensure accuracy.

• Keep file size manageable (e.g., below 10 MB) to avoid upload issues.

If you need further assistance, please feel free to reach us at [email protected] or Live Chat.