Khaos Control Cloud Data Import Mapping - Price Lists

Khaos Control Cloud Data Import Mapping - Price Lists

Information

This page contains the field mapping requirements for Khaos Control Cloud (KCC) customer price list imports and a sample file is attached to this article. In the sample file, our stock item 1976 has two price bandings and is being sold on two separate price lists, Amazon and Retail, using those bandings. The use of bandings is optional.

MANDATORY FIELDS

Only the stock code and the price list name column are mandatory.

Note: For multiple price lists, add a new column with the title of the price list and list the prices for each stock item.
FIELD NAME
(Case Sensitive)		MANDATORY FIELD?
DESCRIPTION 
FIELD TYPE
FIELD LENGTH
STOCK_CODE
YES
The unique stock code of the item to be added to the price list(s).
FREE TEXT
30
BAND_LOW
NO
The lower quantity limit on a single sales order for the price to apply.
NUMERICAL
5
BAND_HIGH
NO
The upper limit on a single sales order for the price to apply.
NUMERICAL
5
Price List Name
YES
This column HEADER needs to have the same name as your price list in [System Data | Price Lists]. For each row of data, enter the price the item is sold for on this price list.
NUMERICAL
18, 2