Before importing inventory data to WooPOS, some terms and WooPOS operation must be well understood in order to correctly plan the possible required transformation of the original data to be imported to WooPOS. Knowing that ensure the optimal data organization in WooPOS.
SKU: A Stock Keeping Unit (SKU) is a unique numeric or alpha numeric id assigned to a product to surely and rapidly identify all its features as its product name, price, attributes, brand, quantity on hand, etc. A SKU is used to track inventory and can be assigned manually or by the inventory system itself.
For a product with variants like a T-shirt which has color and size as variation attributes, you can create Variation SKU. In that case, the SKU identifies the style (set of variants) of the product and the Variation SKU identifies not only the style but also its different variants composed of different attributes. Ex: T-shirt style is TS_Messi and it comes in two attributes, which are colors (blue and red) and sizes (S, M).
So the WooPOS SKU will be TS_Messi and there will be 4 Variation SKUs generated by WooPOS as written below:
LOOKUP CODE: You can add manufacturer UPCs or EANs as lookup codes in WooPOS. The lookup codes are additional links to the SKU. When lookup code scanned, WooPOS will automatically convert lookup code into SKU.
BARCODE: A barcode is a square or rectangular image consisting of a series of parallel black lines and white spaces of varying widths that can be read by a scanner. Barcodes are applied to products as a means of quick identification. They are used in retail stores as part of the purchase process, in warehouses to track inventory, and on invoices to assist in accounting, among many other uses.
WooPOS will print the SKU on the barcode by default. In some cases, if the SKU won’t fit on the barcode, WooPOS will use or create lookup code instead. Ex: If ever the number of characters of the SKU is greater than the one set in the barcode used for printing labels (many barcode parameters can be configured with the label designer) then WooPOS will create a lookup code that will be associated with the SKU. The barcode will then represent the lookup code and not the SKU.
CAUTION: The more characters has your SKU the more space is required by the barcode on the label. You can make the barcode smaller on the label but smaller is your barcode and more accurate must be your label printer and harder it will be to read it by your scanner. More barcode designing tips here.
- WooPOS always tries matching what you scan with anything possible in its database to then list you the result.
- If possible avoid using the lookup code.
- If possible, manage to create a SKU or a Variation SKU that indicate something meaningful to you.
- Despite the fact that there are many places giving access to label printing, print labels when you receive your PO.