Khaos Control Cloud Data Import Mapping - Relationships
Information
This page contains the field mapping requirements for Khaos Control Cloud (KCC) stock item relationships. A sample file is attached to this article.
MANDATORY FIELDS
All fields except REL_TYPE are mandatory.
| FIELD NAME (Case Sensitive) | MANDATORY FIELD? | DESCRIPTION | FIELD TYPE | FIELD LENGTH |
| PARENT_CODE | YES | The unique stock code of the parent item. | FREE TEXT | 30 |
| CHILD_CODE | YES | The unique stock code of the child item | FREE TEXT | 30 |
| QTY | YES | The quantity of the child item per parent. | NUMERICAL | 18, 2 |
| REL_TYPE | NO | This column is optional. If omitted, the relationship type for each parent item must be set manually within its stock item record. If used then specify PACK or BUILD. PACK items will be a Move With stock relationship. | NUMERICAL | 5 |
Related Articles
Importing Stock Item Relationships
Before You Begin This guide should be used in conjunction with the Relationship Mapping document here, Khaos Control Cloud Data Import Mapping - Relationships. Please Note: Stock items that have relationships imported incorrectly can not easily be ...Khaos Control Cloud Data Import Mapping - Customers / Suppliers
Information This page contains the field mapping requirements for customer and supplier imports. This page is also available to download as a PDF from the attachments tab. An example Customer / Supplier import file is available on the attachments ...Sales Order Data Import Mapping
Information This page contains the field mapping requirements for importing existing sales orders into Khaos Control Cloud (KCC). MANDATORY FIELDS Mandatory fields vary depending on the complexity of the data you are intending to import. Notes A ...Stock Data Import Map
Information This guide contains the file requirements for importing stock data into Khaos Control Cloud (KCC). This article only covers simple SKUs, a separate guide is available for SCS items (variations) here, Stock Data Import (SCS). Detailed ...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 ...