Search our Help.

Import/Export Products

Follow

You must import product and related details using the Unleashed templates. You can import/export products, stock on hand, batch numbers, serial numbers, supplier details, and inventory details. 

Before You Begin

Read the following topics to understand the correct process details and avoid common errors:

Importing Products

  1. Go to Inventory | Products | Import / Export.
  2. Download the required template and enter data in the format specified:
  3. Save the file and upload it.

Importing Products

  • All products must have a Product Code and Product Description. You can leave the other columns blank if there are no related values.
NOTE:  Removing existing values in a row will cause the update to replace the values with null and remove the existing data.  Only remove values if you want to clear the field(s).
  • If you want to enter new values for Supplier Code, Supplier Name, and Product Groups you can enter them in the respective columns. The corresponding details will be created after the import.
  • A Last Cost value for a specific product can be set in the template but will be overwritten by the most recent purchase price or assembled cost for that product.
  • If the sales tax rate is 15%, you must enter it as 15. Do not include the % symbol.
  • For template field definitions, see Import Products Field definitions.

Importing Stock On Hand

  • This import is only for new products. DO NOT use this import for existing products with available stock on hand.
  • The Stock On Hand import allows you to upload the starting quantities and values of all your product codes, and also correctly split them by location.
  • You must verify and enter the correct values for the Stock on Hand (SOH) import. The stock value and quantity are recorded based on the values you import. 
  • You must enter the Product Code and Warehouse Code for the product. 
  • Average Land Cost is the value PER UNIT, not the total of all SOH. The AverageLandPrice column is used to enter the cost/value per unit of your product. The SOH multiplied by this amount is the total value of stock.
  • Serial Number: Enter each serial number on a different line.

        

  • Batch Number and Expiry Date: Enter the batch number and associated expiry date in the DD/MM/YYYY format.

       

A product can have either a serial number OR batch number.

 

Importing Serial Numbers

If you want to enable serial tracking for your existing products and assign serial numbers, use the template to import the required values.

  • This import is only for existing products with SOH. If you are setting up your products for the first time then you must use the Products and SOH Import templates. 
  • Before you import Serial Numbers, ensure that your current stock on hand quantity matches the total serial numbers you will upload.
  • For template field definitions, see Import Serial Numbers field definitions.

Importing Batch Numbers

If you want to enable batch tracking for your existing products and assign batch numbers, use the template to import the required values.

  • This import is only for existing products with SOH. If you are setting up your products for the first time then you must use the Products and SOH Import templates.
  • Before you import Batch Numbers, check that your current stock on hand quantity matches the exact total of batch numbers you will upload.
  • Unleashed currently only supports the DD/MM/YYYY date format.
  • For template field definitions, see Import Batch Numbers field definitions.

Importing Product Suppliers

You can assign multiple suppliers for a product. Use this template to import product suppliers in bulk for existing products.

  • This import is only for existing products. If you are setting up your products for the first time then you must use the Products and SOH Import templates.
  • For template field definitions, see Import Product Suppliers field definitions.

Importing Inventory Details

You can store your products in different warehouses. Use this template to import inventory details in bulk for existing products.

  • This import is only for existing products. If you are setting up your products for the first time then you must use the Products and SOH Import templates.
  • This import is available only if you have enabled the Per Warehouse Controls option under Settings | Organization | Company.
  • For template field definitions, see Import Inventory Details field definitions.

Importing and Exporting Product Attributes

Product attributes is a way to record product data in the form of attributes belonging to attribute sets. You can create attribute sets containing a list of attributes and assign it to a product for reference purposes.  

Demo: Import/Export Product Attributes

Importing product attributes

  • Ensure that you have created the attribute set before you import the attributes. For more information, see Product Attributes.
  • You can download the template and import product attributes for one attribute set at a time.
  1. Click Download Product Attributes Template File.
  2. Select the attribute set from the drop-down list.
  3. Click Download. For template field definitions, see Import Product Attributes Field Definitions.

Exporting product attributes

You can export only one attribute set at a time.

  1. Go to  Inventory | Products | Import/Export | Export | Product Attributes.
  2. Select the attribute set from the drop-down list.
  3. Click Download. A CSV file is generated with the details.

Importing Product Pricing

If you want to provide a special price or discount for products, you can import multiple product records using this template. For more information, see Quantity Prices.

This import must be used ONLY for existing products. You cannot create a new product using this import.
  1. Click Download Product Pricing Template File.
  2. Enter data in the template format. For field definitions, see Import Product Pricing-field-definitions
  3. Save the file and upload it.
Delete All Product Prices: If you want to update the quantity pricing for all products, you must delete all product prices and then re-import. Ensure that you have exported the existing details for reference before you delete all product prices.

Importing Supplier Quantity Prices

If you want to provide Supplier quantity pricing or discounts for products, you can import multiple supplier/product records using this template. For more information, see Supplier Quantity Prices.

This import must be used ONLY for existing suppliers of your products. You cannot create a new product, a new supplier or a product/supplier relationship using this import.
  1. Click Download Supplier Quantity Prices Template File.
  2. Enter data in the template format. For field definitions, see Import Supplier Quantity Prices
  3. Save the file and upload it.

Exporting Products

You can export Products, Stock On Hand, Serial Numbers, Batch Numbers, Product Suppliers, Inventory Details, and Product Pricing you have created in Unleashed to a CSV file.

  1. Click Export to export products by default.
  2. Alternatively, use the Export button drop-down list to select either Products, Stock On Hand, Serial Numbers, Batch Numbers, Product Suppliers, Inventory Details, or Product Pricing.
  3. A CSV file is generated with the details.
Was this article helpful?
0 out of 0 found this helpful