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.

A screenshot of a computer

Description automatically generated

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).

A screenshot of a computer

Description automatically generated

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)
Only imported if Dispensable is also True

Monitored

True / False
Only imported if Dispensable is also True

Generic

Generic Product Code
Only imported if Dispensable is also True