To import pricing via CSV, please use the following format:
List Name, Start Date, End Date, Currency, Conversion Rate, List Markup, Rounding, Sku, SKU Cost, SKU Markup, Markup Type
ie. 1Price List,2018-01-23,2018-03-15,USD,1.2,120,99,54321,9.99,5,fixed
Here is a link to an example file. Remember not to include headers.
Convictional allows you to setup exceptions to your price lists. This makes it easier to manage any non-standard pricing for a particular trading partner or group of trading partners. Instead of changing your base prices for the duration of an event, you can setup an additional price list called an exception list that will only sync with your partner when active.
An exceptions price list is the same as a regular price list. You can import it and set various parameters (conversion rate, markdowns, etc.) that will apply to the SKUs on it. There are a few key things to consider when setting it up though, including:
Say you have a price list for all your trading partners or shops in Canada. The base prices for all those partners or shop in Canada would be set in a price list with the name “CANADA”. The exceptions to this list would have a dash and an “E” as a suffix (ie. “-E”). So the list name would be: “CANADA-E”.
Importing a price list of exceptions is the same as importing any other price list outside of the factors discussed above. Here is an article on how to import exceptions prices.
There are many use cases for a flexible approach to pricing like this one: * Sale pricing * Clearance pricing * Time or date-specific prices * Flash sales
The benefit to this approach is you do not have to change your base price list in order to set up exceptions. In some systems you would need to change the base price in order to update pricing for one-off events. This approach allows you to setup one-off pricing without changing your base prices, so you can revert back to base prices automatically when the exceptions end.