Products can be bulk imported into WorkGuru using the product import function and the CSV Import Template.    Download the import template for the page or this article and choose the csv file then save to upload the products into WorkGuru.



WorkGuru Product Import Template Field Definitions


Sku    Name    Description    Barcode    Brand    CostPrice    SellPrice    PurchaseTaxCode    SellTaxCode    Category    TrackingType

  1. SKU - Your Product Code which needs to be unique.  Best practices include no spaces, complex characters or leading zeros.
  2. Name - Product Name.
  3. Description - Product Description
  4. Barcode - UPC or EAN Barcode on product packaging.
  5. Brand - Product brand for reporting
  6. SupplierName - Name of Supplier - MUST MATCH EXISTING SUPPLIER
  7. SupplierCode - Supplier's product code.
  8. CostPrice - Default cost price of product
  9. SellPrice - Default sell price of product
  10. PurchaseTaxCode - Purchase Tax - Entered as Text matching Xero Tax Name (eg GST on Expenses)
  11. SellTaxCode - Sales Tax - Entered as Text matching Xero Tax Name (eg GST on Income) 
  12. Category - Product category for reporting
  13. Tracking Type  - Y for FIFO stock control, N for no stock control.