If you have a large number of pricing rules, they can be easier to manage in a spreadsheet.
There are 2 ways to upload a pricing rules csv file:
Upload a file to the repository
Use webdav to connect your computer to a remote server for file viewing and transfer
Either way, your file must be in a specific format. The file name must be sitename-ecomstore-rules.csv, e.g. ecommerce-store-ecomstore-rules.csv
The csv is parsed in the following order.
This means the spreadsheet should be set out like below.
Please note, when you upload the spreadsheet it may only import from the first column with content. If you have blank columns, open your spreadsheet in a text editor (Notepad, TextEdit, etc), and edit as below to allow for the blank columns.
To upload your pricing rules csv file, go to the WEB-INF repository for your site, and click Upload.
Alternatively, connect to your Kademi account using webdav, and you can edit pricing-rules.csv in your preferred spreadsheet program.
Once uploaded, your csv in Kademi should look like this.
And your pricing rules on the eCommerce store management page will look like this.
