Home‎ > ‎e. Inventory Module‎ > ‎

e. 1 import inventory

This guidance is to provide a simple and easy product/service import solution within the inventory module. You can access the import file below our download from the import module page.   

Please fill all the columns in the import file. 

Column Descriptions:

Stock Code - Unique product / service code 

Description - Product / Service short description

Long Description - Product / Service long description

Stock Category - Product / Service category name consistent with the category created in settings

Units of measure (use the same text) -

  • each
  • meters
  • kgs
  • litres
  • length
  • Kilometers
  • centimeters
  • yards
  • gallon
  • inch
  • mile
  • minute
  • hour
  • day
  • gram
  • Kilogram
  • pound

Item Type (use the same text) 

  • Assemble
  • Purchased
  • Wage/Service charge

Current or Obsolete (use the same text)
  •  current
  • obsolete
Controlled (use the same text) 
  • yes
  • no
Serialised (use the same text) 
  • yes
  •  no
Tax Category (use the same text)
  • Taxable supply
  • Luxury Items
  • Exempt
  • Freight
Material Cost - Purchase cost 

Sales Price - Sales price of product or service per the unit of measurement.

Barcode -   Barcode number 

Reorder Level (Economic Quantity Order) - Reorder notification limit to the system in numbers

Quantity - Quantity on hand during 
 

Please note the following import file restrictions:

1. File size should be less than 1 MB / 1000 records*
2. The filename should have less than 150 characters
3. File format should be CSV

ċ
Adrian Mccalla,
Apr 8, 2018, 12:57 AM