Import Products Field Definitions
Follow
George Sutton
Updated : Created :
* 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 length = 100). |
| *Product Description | Description of the Product (max length = 500). |
| Notes | Any notes related to the Product. |
| Barcode | Barcode number of the Product (Base Unit only). |
| Units | Unit of measure for Product 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. |
| Bin Location | Bin location where the product is located in the warehouse. |
| Supplier Code | Code of the default Supplier for the Product (max length = 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 length = 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. |
| Mimimum 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 (used to limit what quantities can be entered e.g. packs of 10, 100 etc.). |
| Weight | Weight of the Product. The measurement unit can be specified from Settings | Company | Details tab | Measurement Units drop-down list. |
| Width | Width of the Product. |
| Height | Height of the Product. |
| Depth | Depth of the Product. |
| 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. Note: Product Group Names cannot contain commas |
| 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. |
| Purchase Account | The expense account in your accounting provider if the product is never diminishing and purchased. |
| 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. If you have selected YES for any of the following columns: IsComponent, 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. 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. |
| 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) |
A product cannot be tagged as 'Batch Tracked' and 'Serialized' at the same time.