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

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

Last updated
Was this helpful?