Importing Stock Item Relationships

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 corrected. It is your responsibility to ensure data is correct prior to import.

Prepare Your Data

As always, the quality of the data used for imports is of paramount importance. You should not run any import without ensuring a good quality of data.

Importing stock item relationships is the same process as a standard stock import however the import file contains only 4 columns:
  1. PARENT_CODE - This is the 'Pack' or 'Build' item stock code.
  2. CHILD_CODE - This is a component of the parent.
  3. QTY - How many of this child the relationship contains.
  4. REL_TYPE
    1. PACK - This will create 'Move With' (bundle) relationship. Move With relationships allow all of the child items to be sold independently of the pack at any time.
    2. BUILD - This will create a 'Build' relationship. Builds are used predominatly if you pre-assemble something and need to keep track of the finished product. Stock levels for child items will be reduced as builds are assembled.
It is essential when performing a relationship import that you do not have any item in the child column that is also present in the parent column as this will likely create a 'nested' relationship  which isn't supported.

If you wish us to have a quick once over your file pre import please send it over to training@khaoscloud.com and we will have a look.

    • Related Articles

    • Create a Pack Relationship

      Overview You can create packs, also known as move with or bundle relationships. This video explains the process: Steps Create a non stock controlled pack parent item. Go to the Relationships tab. Enter Edit mode. Use the Relationship Type drop down ...

    • 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) ...

    • View Stock Item Relationships

      Overview The below will show you the options of how to see what relationships a stock item belongs to. Usage In your [Stock Items] list screen, it is possible to filter for a specific relationship type, i.e. Move With or Build. It will not display ...

    • Remove a Stock Item from a Build Relationship

      Overview The following guide explains how to remove a single stock item from a build relationship. This may be due to a newly discontinued item that was previously part of a build or simply a change in what items are included in the build. Usage Go ...

    • Error Message - Relationships cannot be set when there are existing assigned levels

      Overview If you receive the above message when trying to create a Relationship stock item, it is because the system will not allow relationships to be created if any of the items involved are currently assigned to existing sales orders. ...