Import/Export Custom Pricing rules

You can create CP 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.

Import rules

It could take time to build the file at first, however, it's time-saving for you to create rules in bulk via importing. Moreover, it's easier for you to manage and edit the price according to your business strategy.

Step 1: Download the sample file

Heading to the Configuration tab of the feature, you can see the Import button

An importing box will display when you click the Import button. You can download the CSV sample to view the format of the file that should be built

To better understand what data type should be included in each field, you can read the following guidelines

Column
Required?
Data type

ID

Required for updating rule

Number format

Name

Required

String format

Priority

Required

Number format. Value must be a positive integer from 0 to 99 (0 is highest priority)

Status

Required

Value must be "enable" or "disable"

Market

Required

String format. Fill in "All" if apply for all markets, otherwise fill in a list of markets (use country code) separated by commas

Customer condition

Required

Value must be one of the following: - All - Logged-in - Not logged-in - Specific customers - Customer tags

Customers

Required when customer condition is one of values: - "Specific customers" - "Customer tags"

Value is list of customer email or customer tag separated by commas

Exclude customer condition

Required

Value must be one of the following: - None - Specific customers - Customer tags

Exclude customers

Required when exclude customer condition is one of values: - Specific customers - Customer tags

Value is list of customer email or customer tag separated by commas

Product condition

Required

Value must be one of the following: - All - Specific products - Specific variants - Specific collections - Specific tags

Products

Required when product condition is not All

Value is list of product ID/ title/SKU/barcode/collection/tag or variant ID/ SKU/barcode (if you chose "specific variants" separated by commas

Exclude product condition

Required

Value must be one of the following: - None - Specific products - Specific variants - Specific collections - Specific tags

Exclude products

Required when exclude product condition is not None

Value is a list of product ID or product title or SKU, or barcode separated by commas

Discount type

Required

Value must be one of the following: - Fixed price - Decrease fixed amount - Decrease fixed percentage

Discount value

Required

Number format. Value must be positive number

Start date

Optional

Date format. Value must be a date in the format YYYY-MM-DD

Start time

Optional

Time format. Value must be a time in the format HH:MM

End date

Optional

Date format. Value must be a date in the format YYYY-MM-DD

End time

Optional

Time format. Value must be a time in the format HH:MM

Step 2: Upload CSV file

You can select a file to import, which should be in CSV format and less than 10 MB.

If you intend to overwrite existing rule data, simply check the option "Overwrite rules with matching IDs". By that, existing rules having the same ID as the rule ID in the file will have their data overridden.

Notes:

  • If you want to override/replace existing rules, tick the option "Overwrite rules with matching IDs", and at least one rule in the file has to include the rule ID

  • If you only want to create new rules, don't tick that option, and do not fill in the rule ID data. Any rule having a rule ID will be counted as an error

If you want to replace all existing rules with new ones in the file, select the second checkbox. So, all existing rules will be removed and replaced by new ones.

Step 3: Import file

The file will be automatically imported into our system if everything is validated successfully. The import process will now run in the background, allowing you to continue working without interruption.

Limit:

  • You can import 1 rule/time

  • File format must be .csv

  • File size must be under 10 Mb

Export rules

You can export your rule data for editing or connecting with other systems. Simply click the "Export" button and download the exported file to view details.

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

Last updated

Was this helpful?