Bulk Update Supplier Availability for my Stock Items

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 and prepare the spreadsheet to add your supplier availability to it, if you already have this, proceed to preparing the data in step 3.
  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.

Preparing the data

This section will setup the file generated above so that harmonisation codes can be imported to your system and added to stock items.
  1. Open the CSV file generated above.
  2. Delete all columns keeping only the following (order not important):
    1. CONTROLLED
    2. STOCK_CODE
    3. SHORT_DESC
    4. STOCK_TYPE1
    5. STOCK_TYPE2
    6. TAX_CODE
    7. BUY_PRICE
    8. SELL_PRICE
  3. Add the following column headers to columns I and J.
    1. Supplier:COMPANY_CODE (Column I)
    2. Supplier:QTY_AVAIL (Column J)
  4. In column I, for every stock item, enter the URN of the supplier (the supplier MUST exist on your system).
  5. In column J enter the quantity of stock your supplier has available.
  6. If you have more than 3000 rows of data the import may fail - please split your file in to smaller chunks.
  7. Save your file(s) as Text (tab delimited) files.
    1. If using software that does not support this you will likely be able to 'Copy and Paste' from the spreadsheet into notepad - you should just save the file as txt if this is the case.

Part 2

Reimporting the data into KCC.

In order to import the updated data, please follow our data import guide here, Importing Your Data and then carry out the Confirmation Check below.
Please Note:
The Data Import feature will only display the mandatory fields when confirming the headers on your data import file - this is normal behaviour.

Confirmation Check

​Open any stock item that was present on your import file, go to the supplier tab and confirm the Qty Avail value is present.


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

    • Bulk update stock lead time

      Overview Sometimes stock items from a single supplier may need their lead time adjusting. Usage This solution will bulk update the lead time of the products. Go to the [Stock Items] list and filter to only show products supplied by the supplier in ...

    • 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 Supplier Buy Price Amendments

      Question/Problem Requirement to update all stock buy prices from a specific supplier. Solution This is something likely to affect all businesses from time to time and can be completed by following the steps: Go to [Reports | Ad-Hoc Reports] and ...

    • Adding Stock Items to a Supplier Return

      Overview This video explains how you add stock items to a Supplier Return. A step by step guide can be found below the video. Steps Ensure the Supplier Return is in Edit mode. Use the New Item button to add the item(s) being returned from the Stock ...