Price list Import Mapping
Table Of Contents
Creating a CSV File
To create a CSV file for importing data into Khaos Control Cloud you will need software capable of making a spreadsheet, such as Microsoft Excel or Google Sheets.
- Open up the software you are using and create a new document.
- In the first row you will need to enter a title for each column, so you know what data is included in the column when it comes to importing it into Khaos Control Cloud.
Microsoft Excel
Google Sheets
- Now fill in each column with the matching data for each product, with each product on a new row.
Microsoft Excel
Google Sheets
- Once you have entered all of the product information you will need to save the spreadsheet as a "Comma-separated Value (CSV)" file.
- In Microsoft Excel you do this by clicking "File", then "Save As", then "Browse", then under "Save as type" select "CSV (Comma delimited) (*.csv)":
You can then browse and select the location to save the file, as well as give the file a name via the "File name" field, then click the "Save" button. - In Google Sheets you do this by clicking "File", then "Download", then "Comma-separated values (.csv)":
Your browser will then download the file to your default download location.
Testing your Import
Once you have CSV file setup and are ready to import your product data into Khaos Control Cloud, it is recommended that you first test this using your "Demo" Khaos Control Cloud system.
This way you can make sure that all of the required data is in the correct place, and that the import works correctly.
Import Mappings
Required Fields
Fields that are marked as "Required" must be included in the import or it will fail.
If you need to run an import more than once then all "Required" fields MUST be completed for each import.
| Title | Field Name | Description | Required |
|---|---|---|---|
| Stock Code | STOCK_CODE | The Stock Code that the price is for. | Yes |
| Price for "2014 Retail" pricelist | 2014 Retail | No | |
| Price for "2018 Retail" pricelist | 2018 Retail | No | |
| Price for "AT01" pricelist | AT01 | No | |
| Price for "DC01" pricelist | DC01 | No | |
| Price for "Dollar Prices" pricelist | Dollar Prices | No | |
| Price for "Dorwest 2017 Local" pricelist | Dorwest 2017 Local | No | |
| Price for "JC-TPL1" pricelist | JC-TPL1 | No | |
| Price for "JCP1 Price list" pricelist | JCP1 Price list | No | |
| Price for "MVEP" pricelist | MVEP | No | |
| Price for "NHS" pricelist | NHS | No | |
| Price for "Phase 1 Mar 24" pricelist | Phase 1 Mar 24 | No | |
| Price for "Price List 239" pricelist | Price List 239 | No | |
| Price for "Price List 249" pricelist | Price List 249 | No | |
| Price for "Price List 251" pricelist | Price List 251 | No | |
| Price for "Price List 388" pricelist | Price List 388 | No | |
| Price for "Price List 391" pricelist | Price List 391 | No | |
| Price for "Retail" pricelist | Retail | No | |
| Price for "Steves magical price list" pricelist | Steves magical price list | No | |
| Price for "Stockist" pricelist | Stockist | No | |
| Price for "TESTIMPORTLIST" pricelist | TESTIMPORTLIST | No | |
| Price for "TESTIMPORTLIST2" pricelist | TESTIMPORTLIST2 | No | |
| Price for "Test Price List 39" pricelist | Test Price List 39 | No | |
| Price for "Test Price List redundant" pricelist | Test Price List redundant | No | |
| Price for "Test Price List" pricelist | Test Price List | No | |
| Price for "Testy McTest" pricelist | Testy McTest | No | |
| Price for "Trade" pricelist | Trade | No | |
| Price for "import_pl_retail" pricelist | import_pl_retail | No | |
| Price for "import_pl_trade" pricelist | import_pl_trade | No | |
| Price for "import_pl_wholesale" pricelist | import_pl_wholesale | No | |
| Price for "my new price list" pricelist | my new price list | No | |
| Price for "pierce list" pricelist | pierce list | No | |
| Quantity Break (end) | BAND_HIGH | Price Lists can optionally be banded, with a price only being relevant when the Quantity being sold on a Sales Order is between a low and high boundary. | No |
| Quantity Break (start) | BAND_LOW | Price Lists can optionally be banded, with a price only being relevant when the Quantity being sold on a Sales Order is between a low and high boundary. | No |