This feature allows you to import a file containing new products and their attributes (PDE, Unit Cost etc) to create new products in Minfos.
Note
- The file must be saved in Tab Delimited format
- Each product attribute (Name, Barcode etc) must be in a separate column
- Barcode and Name must be included as the first two columns in the file
- Please refer to the Import File Format table below for an explanation of the accepted values for each attribute
1. From the Stock Manager module, click File and select P. Import New Product Attributes.
The Import New Product Attributes window is displayed.
2. Click Browse and navigate to the file to be imported.
3. Click Open.
The File and File Path you have selected is displayed in the File field.
4. From the Import panel, select one of the attributes included in the file, then click Add.
The attribute is added to the File panel.
5. Repeat this step for all attributes included in the file.
6. The order of the attributes listed in the File panel must be the same as the order of the columns in the file. Select an attribute and click Up or Down to adjust the order of listed attributes.
7. Click OK.
The file is processed and the Import New Product Attributes Result Report is displayed.
This report displays:
- Products successfully created
- These products have been created without any exceptions/errors
- Products created with exceptions
- These products have been created with exceptions (such as No preferred supplier specified for the PDE) that need attention.
- Products failed and not created
- These products were not created because of the reason specified in the report (eg, barcode is assigned to another product).
Import File Format
This table provides the accepted values for each attribute that may be included in the file to be imported.
Import Field | Accepted Values |
Ignore | Allows the user to enter a field to ignore |
Barcode | Valid Barcodes |
Name | Text - 40 character limit |
IEU | IEU Code |
Class | Class Code |
Department | Department Code |
Brand | Brand Code |
Company | Company Code |
Price Policy | Pricing Policy Code |
Location | Location Code |
Preferred Supplier | Supplier Code |
PDE | 20 character limit |
AR Product Code | AR Product Code |
Re-Order (Stocked) | True / False |
Discountable | True / False |
Discontinued | True / False |
Recommended | True / False |
GST On Purchases | True / False |
GST On Sales | True / False |
KVI | True / False |
Small Label | True / False |
Dispensable | True / False |
Exclude from Loyalty | True / False |
Retail Price | Numeric, up to 2 decimal places |
Unit Cost | Numeric, up to 2 decimal places |
SOH | Numeric whole number |
Schedule | Text (0, 2, 3, 4, 5, 6, 7, 8) |
Monitored | True / False |
Generic | Generic Product Code |