Upload Barcodes

August 6, 2017 in Inventory Control

Purpose

This routine can be used to upload barcodes for inventory Products from a file created outside of the system. This is an alternative way of updating barcodes into the system and is most useful when you are updating large volumes. Using this method a “spread-sheet” style tool can be used to create a list of products you want with barcode details as needed.

Note: This function only uploads product barcodes for existing products. For additional details on creating upload files see the note HERE.

Data Input

­

Step 1 – Upload File

Clear or Append

Select ‘Clear’ if you want to replace existing barcodes with the new barcodes found in the file you upload. If you want to add more barcodes to what is already recorded in the system, then choose the ‘Append’ option.  This option ONLY applies to the products listed in your file and does not clear all barcodes recorded in the system.

Upload File

Find and select the spreadsheet file you wish to upload, by clicking ‘Browse’. This assumes you have access to the file with the product barcode details from the browser that you are currently using.

Return to the Top

Step 2 – Verify File Details

The new barcode details of the spread sheet are displayed so that you can review the data and confirm that the correct file has been uploaded before you continue.

Click Submit to submit all the details.
Return to the Top

Spread sheet format

The spread sheet must be in a csv format.

The first row of the spread sheet must be a heading row – it does not matter what the headings are, as long as they are meaningful to you e.g. you could have ‘Product’, ‘Product Code’ or ‘SKU’.

The columns required are:

Column Name Additional Details
A Product Code Must be a valid product on the Product Master file.
B Barcode Mandatory. This is the barcode to upload. The barcode represents the Product, size and colour of the inventory item. The barcode may not be used as a barcode on a different product. The barcode may not be the same as an existing product code.
C Size Code Must be a valid size on the Size Master file and must be a valid size against the product being update.
D Colour Code Must be a valid colour on the Colours Master file and must be a valid colour against the product being updated.
E Unit This is a three character abbreviated Unit Of Measure (UOM) that the bar code represents for this product. It can be in either Stock (STK) units, Purchase (PUR) units, Sales (SLS) units or Warehouse (WHS) units.

Return to the Top

Updating

Once you click submit, the rows on the spread sheet are validated.
If no invalid data is detected, the list of barcodes is updated and cross-referenced with products ready for use.

Return to the Top

{ 0 comments… add one now }

Ask a Question or Leave a Comment

Previous post:

Next post: