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.