This feature allows you to import a text file to update product attributes 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 or MNPN must be included 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 Q. Update Product Attributes.

The Update Product Attributes window is displayed.

 A screenshot of a computer Description automatically generated

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. Select the attribute the file should match by in the Match Field section, either Barcode or MNPN.

5. From the Import panel, select one of the attributes included in the file, then click Add.

The attribute is added to the File panel.

6. Repeat this step for all attributes included in the file.

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

 A screenshot of a computer Description automatically generated

8. Click OK.

The file is processed and the Update Product Attributes Report is displayed.

This report displays:

  • Products successfully updated
    • These products have been updated without any exceptions/errors
  • Products updated with exceptions
    • These products have been updated with exceptions (such as No preferred supplier specified for the PDE) that need attention.
  • Products not found
    • These products were not updated as they could not be found in Minfos.


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

MNPN

MNPN existing in database

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