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.