Stock Level 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 unique stock code of the item. | Yes |
| Stock Level | STOCK_LEVEL | The quantity to update the stock level to. | Yes |
| Site ID | SITE_ID | No |