Products | Importing and Exporting
Importing and Exporting of Product lists provides efficient management of product records. Exporting allows records to be reviewed externally. Importing allows records to be created or edited in bulk.
Records are exported and imported as a .csv file. It is important when importing that content exactly matches Infusion requirements, particularly when fields use drop-down lists. Spelling and punctuation must be an exact match.
If an import fails due to incorrect content, a notification displays advising the row number and column with the error. A brief message outlines the issue.
When preparing an import, either export the existing list to obtain the column headers or use the templates provided with each Import/Export option below. Each import has a table outlining column formatting requirements.
Refer to the Import and Export article for further general information.
The Products export provides a file with all products and includes Details, Grouping and Pricing information.
The Products import can be used to update existing product information or add new products.
Template link - Products
|Code||REQUIRED: Create a new code or add an existing code. The Code must be identical if using an existing ID. If not, a new product will be created.|
|Description||REQUIRED: Free-text alpha-numeric field to name the product.|
|Primary Barcode; Sales Unit||Free-text alpha-numeric fields.|
|Superceded by||Must match drop-down values.|
|Type; Group; Sub group||Must match drop-down values.|
|Length; Width; Height; Volume; Weight||Free-text numeric fields.|
|Latest Shipping; Latest Purchase; Average Shipping; Average Purchase||Free-text numeric fields.|
|Pricing Method||Must match drop-down values, including capitilisation of letters.|
Product Price Levels
The Product Price Levels export provides a listing of prices per Price Level for all products.
Product Price Level imports are used to update existing or add new price levels. Note: the price level must exist in the Product Price Level settings before selecting for import.
Only products that use the Fixed Price Markup pricing method are updated using an import. Pricing that is controlled by the Product Group Markup pricing method cannot be edited as it is calculated by the software.
Template link - Product Price Levels
|Code||REQUIRED: Existing codes must match exactly.|
|Level||REQUIRED: Price Level must exist against the product.
Must match drop-down values, including capitalisation of letters.
|GST Exclusive; GST Inclusive; Markup (%); Margin (%)||A minimum of one column must be updated.
If all columns are updated, calculations must be correct.
If one column is updated, remaining fields calculate in Infusion when the import is run.
Import Product Receipts
A list of Product for a Product Receipt can be imported instead of manually entering product details.
If the product has a serial number, it continues to import and the product is indicated with a red symbol beside the product code. This identifies that serial numbers are required. They need to be added from within the product receipt.
Template link - Product Receipt
|Product Code||REQUIRED: Existing codes must match exactly.|
|Description||Free-text alpha-numeric field. This doesn't need to exactly match the product description in Infusion and is recorded on the Product Receipt only.
If left blank, the product description defaults in during the import.
|Quantity||REQUIRED: Free-text numeric field.
For products with serial numbers, the Quantity field receives this value. When serial numbers are added on the receipt, the Quantity field updates to reflect the number of serial numbers entered in the pop-up window, over-writing the number from the import.
|Unit Cost ($)||REQUIRED: Free-text numeric field.