Updating Stock Items Using Data Imports

Updating Stock Items Using Data Imports

Overview  

Updating Stock items using the Import Tool

Specification 

This can be done using the inbuilt data import tool in [System Setup | Data Imports].
There is only one mandatory column as detailed below plus as many columns as you wish to update.
A sample file that updates the stock value and country of manufacture for stock item 773W can be found attached to this article.
  1. STOCK_CODE - This field is mandatory and is what your system will use to identify existing products.
  2. Any columns you wish to update.
    1. A list of the available fields that can be updated is here, Stock Data Import Map

Notes/Caveats 

If you require a list of all the stock codes on your system, this can be generated using the process below. 
  1. Go to [Reports | Adhoc Reports].
  2. In the popup window select System - Products.
    1. This will produce a CSV file of all the stock items on your system.

    • Related Articles

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

    • Update a Stock Item After the Initial Data Import

      Overview An example where you may want to do this, is when there has been a recent change in your buy/sell price of a stock item. Step By Step In order to update the details of a stock item after the primary data import, you can follow the ...

    • Bulk Update Supplier Availability for my Stock Items

      Overview The below will show you how to import your supplier stock levels into your KCC system. Usage There are two parts this process and both will be covered here. Part 1 Getting your data from KCC. This process will export your stock file from KCC ...

    • Bulk Update Stock Items

      Overview Steps Open up the Stock List screen. Green select the items you wish to update. Click on the Actions button. Select Update Stock Items. In the dialog you can see all the attributes you can update. In the attribute(s) you wish update, add the ...

    • Bulk Import ICN Codes to products

      This feature is still in development and all instructions in this article MUST be adhered to. Please contact training@khaoscloud.com if you are unsure about any steps. When importing ICN codes, the system will only allow ICN codes that do not ...