SCS (Size, Colour, Style) Stock Data Import Map

Information

This article contains the file requirements for importing SCS (variations) stock data into Khaos Control Cloud (KCC). This article only covers simple variation items, a separate guide is available for simple stock items here, Stock Data Import. Detailed notes and caveats can be found at the bottom of the grid below.
All import files must be saved as a Text (Tab Delimited) file in order to import them to KCC. If this is not an option in your spreadsheet application you can usually copy and paste the entire spreadsheet into a text document which can then be imported.

Importing SCS Stock Items

When importing SCS stock items the following field names are required. When the items are imported, the system will create the stock items and their parent item based on the structure defined in the import.

A sample SCS example import file is available in the 'Attachments' area and we strongly recommend you viewand import this on to your DEMO systemto see how the various values appear on the system.

All YES/NO fields should be entered as Boolean values. YES = -1, NO = 0

 

FIELD NAME

MANDATORY FIELD?

DESCRIPTION

TYPE OF FIELD

FIELD LENGTH


CONTROLLED

YES

Is the item stock controlled?

YES/NO

4

STOCK_CODE

YES

The stock code of the parent item. The child SCS_SK# will be appended to this code to make the individual child stock codes.

FREE TEXT

 

30

SHORT_DESC

YES

The short description of the parent stock item. The child SCS_DESC# will be appended to this description to make the individual child stock short descriptions. This appears on picking sheets, invoices etc.

FREE TEXT

250

STOCK_TYPE1

YES

Is the top level of stock types structure. No physical stock is held under this level.

FREE TEXT

25 

 

STOCK_TYPE2

YES

Main stock type/level - this level is where physical stock items are held and is the one used to set nominal mapping and filter on sales reports. It is the most important level of categorisation.
THIS IS THE MOST IMPORTANT STOCK TYPE.

FREE TEXT

100

BUY_PRICE

YES

The default cost (in the system's base currency) of buying the product from a supplier (can be net or gross, but this decision will affect how your system functions) as held against the Stock Item. The Stock Buy Price is also used as the Stock Value (required for Cost of Sale analysis)

NUMBER

20

SELL_PRICE

YES

The default selling price to the customer (can be net or gross, but this decision will affect how your system functions)

NUMBER

20

TAX_CODE

YES

The integer code representing the tax rate of the product: 1 = Standard 20% (default) / 2 = Zero 0% / 3 = Exempt / 4 = Reduced 5% / 5 = Old Rate (pre 1st Dec 2008) 17.5% / 6 = 2009 Rate (01-Dec-2008 to 31-Dec-2009) 15%

NUMBER

4

SCS_SK1

Yes

The value that will be used as part of the stock code and it is linked to the SCS_DESC1 below.

FREE TEXT

 

SCS_SK2

No*

The value that will be used as part of the stock code and it is linked to the SCS_DESC2 below.

FREE TEXT

 

SCS_SK3

No*

The value that will be used as part of the stock code and it is linked to the SCS_DESC3 below.

FREE TEXT

 

SCS_SK4

No*

The value that will be used as part of the stock code and it is linked to the SCS_DESC4 below.

FREE TEXT

 

SCS_DESC1

Yes

The value that will be used as part of the stock short description and it is linked to the SCS_SK1 above.

FREE TEXT

 

SCS_DESC2

No*

The value that will be used as part of the stock short description and it is linked to the SCS_SK2 above.

FREE TEXT

 

SCS_DESC3

No*

The value that will be used as part of the stock short description and it is linked to the SCS_SK3 above.

FREE TEXT

 

SCS_DESC4

No*

The value that will be used as part of the stock short description and it is linked to the SCS_SK4 above.

FREE TEXT

 

SCS_CAPTION1

Yes

The description of the values in the first element, for example Size, Colour, Style, Material.

FREE TEXT

 

SCS_CAPTION2

No*

The description of the values in the second element, for example Size, Colour, Style, Material.

FREE TEXT

 

SCS_CAPTION3

No*

The description of the values in the third element, for example Size, Colour, Style, Material.

FREE TEXT

 

SCS_CAPTION4

No*

The description of the values in the fourth element, for example Size, Colour, Style, Material.

FREE TEXT

 

SCS_TEMPLATE
No*
This option allows you to configure the stockcode format for SCS items.
By default the system will create SCS items with a stockcode format of:
$SKCODE$-$E1$-$E2$-$E3$-$E4$
(Where SKCODE is the SCS parent stockcode, and E represents the element).

You can rearrange this to any combination, with or without hyphens.


SCS_DESC_TEMPLATE
No*
This option allows you to configure the stock description format for SCS items.
By default the system will create SCS items with a stockcode format of:
$DESC$ $E1$ / $E2$ / $E3$ / $E4$
(Where DESC is the SCS parent stock description, and E represents the element).

You can rearrange this to any combination, with or without gaps and slashes.



Notes and Caveats:
  1. Levels 2-4 for SCS_SK, SCS_DESC and SCS_CAPTION are not required unless there is more than one level of child items. If there are 2 levels then you will need SCS_SK2, SCS_DESC2 and SCS_CAPTION2, for 3 levels you will need all level 2 plus SCS_SK3, SCS_DESC3 and SCS_CAPTION3 and for level 4 you will need all levels 2 and 3 plus SCS_SK4, SCS_DESC4 and SCS_CAPTION4.
  2. By default, the system will import and then create the SCS items using the following format unless the SCS_TEMPLATE and SCS_DESC_TEMPLATE fields are used:
    1. Parent Stock Code-SCS_SK1- SCS_SK2- SCS_SK3- SCS_SK4
    2. Parent Description SCS_DESC1 / SCS_DESC2 / SCS_DESC3 / SCS_DESC4
  3. If the STOCK_CODE specified matches an existing item, the system will attempt to convert that item to an SCS item.
  4. Setting a new combination of Level 1 Stock Type / Level 2 Stock Type or Level 3 Stock Type / Level 4 Stock Type, if the combination does not already exist within System Data it will be created. The corresponding values will also be set against the imported/updated stock items.
  5. No addional item information is to be entered for importing an SCS item, e.g. barcodes and product weights.
    1. To add this information, a second import should be done using the fullstock for the variant plus the additional information to be added.
  6. If there is a blank line at the end of the file, this will be reported as a skipped line that does not contain a full set of fields.

Downloads

Did you find this article helpful?