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 [e-mail] or Live Chat.