Search our Help.

Import Products Field Definitions

Follow

* denotes mandatory fields. Ensure that you enter correct values in the template before importing into Unleashed.

Field Name Description
*Product Code Unique product code (max character limit = 100).
*Product Description Description of the Product (max character limit = 500).
Notes Any notes related to the Product.
Barcode Barcode number of the Product's Base Unit (max character limit = 200). 
Unit of Measure Unit of measure for Product's Base Unit e.g. EA, Kg, m² etc. 
Min Stock Alert Level The minimum stock quantity to trigger a low stock level alert.
Max Stock Alert Level The maximum stock quantity to trigger a high stock level alert.
Label Template The default Product label 
SO Label Template The default Product label used when label's printed for a Sales Order
PO Label Template The default Product label used when label's printed for a Purchase Order
SO Label Quantity The default Quantity applied when printing labels from a Sales Order
PO Label Quantity The default Quantity applied when printing labels from a Purchase Order
Supplier Code Code of the default Supplier for the Product (max character limit = 500).
NOTE: If you enter the Supplier Code, it is mandatory to enter the Supplier Name.
Supplier Name Name of default Supplier for the Product (max character limit = 500).
Supplier Product Code Supplier Product Code for the product (if different from the Product Code).
Default Purchase Price Default purchase price in the currency of Supplier. This price is GST/VAT exclusive.
Minimum Order Quantity Minimum order quantity for the product when a purchase order is created.
Minimum Sale Quantity Minimum order quantity for the product when a sales order is created.
Default Sell Price Default sell price in currency of the Customer. This price is GST/VAT exclusive.
Minimum Sell Price Minimum sell price in currency of the Customer. This price is GST/VAT exclusive.
Sell Price Tier 1-10 Sell price for price tiers 1-10.
Pack Size Pack size of the Product's Base Unit (used to limit what quantities can be entered e.g. packs of 10, 100 etc.).
Weight  Weight of the Product's Base Unit. The measurement unit can be specified from Settings | Company | Details tab | Measurement Units drop-down list. 
Width Width of the Product's Base Unit.
Height  Height of the Product's Base Unit.
Depth  Depth of the Product's Base Unit.
Reminder Reminder Note to display when adding the product to an order
Last Cost Last landed cost of the Product
Nominal Cost A nominal cost to use when Quoting the product
Never Diminishing YES or NO value. Never Diminishing products do not hold any stock (e.g. Freight, Labor etc.)
Product Group Assign a Product Group. If it does not exist in Unleashed then it is automatically created upon import (max character limit = 450).

NOTE:  Product Group Names cannot contain comma's

Sales Account The Sales account in your accounting provider that this Product’s sales go to. If it is left blank it defaults to the sales account.
COGS Account The Cost of Goods Sold account in your accounting provider that this Product’s costs goes to. If it is left blank, it defaults to the COGS account defined in the accounting integration configuration page. (Quickbooks Online has 50 character limit per account)
Purchase Account The expense account in your accounting provider if the product is never diminishing and purchased.(Quickbooks Online has 50 character limit per account)
Purchase Tax Type When your accounting provider integration is enabled, the Purchase Tax Type can be used for purchasing this product. The tax rate entered is the code, e.g. INPUT1.
Purchase Tax Rate The tax rate to be used for purchasing this product. This overrides all other tax rates. The purchase tax must be entered as a numeric value. 
Sales Tax Type When your accounting provider integration is enabled, the Sales Tax Type can be used for selling this product. The sales tax rate entered is the code, e.g. OUTPUT2.
Sales Tax Rate The tax rate used for selling the product. This overrides all other tax rates. The sales tax must be entered as a numeric value. 
IsAssembledProduct YES or NO value. If the Production module is enabled, then you can mark assembled products as YES.
IsComponent YES or NO value. If the Production module is enabled then you can mark component products as YES.
IsObsoleted YES or NO value. If your product should not be used anymore, then mark as YES.
Is Sellable YES or NO value. If you want this product to be available for sale on Sales Orders and Sales Quotes, then mark as Yes. If it is left blank it defaults to YES.
Is Serialized YES or NO value.
NOTE: If you have selected YES for any of the following columns: Never Diminishing or Batch Tracked, the Is Serialized column value must be NO.
Is Batch Tracked YES or NO value. Any new product can be tagged as 'Batch Tracked' only if the stock on hand is 0; otherwise this value is not updated.  
NOTE: If you have selected YES for any of the following columns:
Never Diminishing or Is Serialized, the Is Batch Tracked column value must be NO.
Commerce Code A 6-14 digit code that Customs authorities use to identify goods that are sent/received internationally. Also known as "Commodity Code", "Harmonized Code", "HS Code" or "Tariff Code".
Customs Description A simplified description of the product to appear on a commercial invoice.
Country Of Origin The country where the product was manufactured (max character limit = 100)
Supplementary Unit Supplementary units are used for customs purposes for goods when a more appropriate measure is required.
Default Purchasing Unit of Measure The unit of measure to use as the default for Purchasing (must be a valid unit of measure)
Was this article helpful?
0 out of 0 found this helpful