Editing pricing tiers in a spreadsheet

Blank 5/6/2020 07:32 - 5/6/2020 07:32
Incentives eCommerce

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.

See more on connecting to Kademi using webdav here.

 

Once uploaded, your csv in Kademi should look like this.

 

And your pricing rules on the eCommerce store management page will look like this.