Adding Net Weight to products in bulk

Adding Net Weight to products in bulk

Problem
How can I upload the Net Weight for all my stock items and have this shown on sales invoices?

Solution
This is a three part process starting with an export of all your stock items on KCC.

Step One

If you already have a stock file from your KCC system, this step may be skipped.
  1. Go to [Reports | Adhoc Reports].
  2. In the popup window select System - Products.
  3. This will produce a CSV file of all the stock items on your system.

Step Two

  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 header to column I.
    1. NET_WEIGHT
  4. Save the file as a text (tab delimited) file.
    1. If your spreadsheet does not offer this, it is possible to copy and paste the spreadsheet in to a text document for saving.

Step Three

Import data
  1. Go to [System Setup | Data Import].
  2. Click Import Your Data.
  3. You can drag and drop your import file into the 'Drop files to import' box or click on the 'Select files to import' button and browse your computer to find and select the file to upload.
  4. In the dropdown menu to the right, specify the type of data import you are performing.
    1. Keeping preview enabled is recommended for this procedure.
  5. Click Check File.
    1. KCC will verify the import file to let you know if the file is suitable for importing, along with listing the column headers seen within the file and highlighting in green the valid column headers.
  6. If preview was enabled the system will run a dummy import to quality check the data and will feedback to tell you how many rows the import preview can successfully able to import. 
    1. At this stage the data is not yet imported into your KCC system, you will need to continue to Step 7 in order to fully import your data.
    2. The system will only run a preview on the first 500 rows of data.
  7. The final step is to fully import the data by clicking the Import button.
    1. There will be no more click through options and the system will simply confirm how many items have been successfully imported. The data import screen can then be closed using the red cross button on the top right of the screen.
Once your data has imported, you will be able to view the Net Weight for each product by opening the Stock Item record and confirming the value is displayed in the Accounting box of the Properties tab.
Notes & Caveats: All weights on the import file should be entered as a numerical figure without the unit.

    • Related Articles

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

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

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