​How to import Product in the Metro ERP?

To import products in bulk quantities into the Metro ERP system efficiently, follow these step-by-step instructions:

Step 1: Prepare Your Excel or CSV File

Ensure that your Excel or CSV file is properly formatted and includes all the necessary information for each product. Include columns for essential details such as product name, description, quantity, price, and any other relevant attributes.

For example:


Step 2: Access the Import Functionality

Log in to the Metro ERP system with your credentials.

Navigate to the 'Inventory' section


Navigate to the 'Products'.


This is a preview of the product page.


Locate 'Favorites' and click on the 'Import Records' option.


Step 3: Choose File and Mapping

Click on the 'Load File' option and select the Excel or CSV file you prepared in Step 1.


The system will prompt you to map the columns from your file to the corresponding fields in the ERP system.

Preview the data to be imported and verify that all information is accurate.

Click on 'Test' to check whether the data mapping is correct or if there is any issue.

If necessary, make adjustments or corrections.

Note: Certain fields such as Product type, Product category, Unit of measure, Purchase unit of measure, Taxes, etc., need to be created in the ERP system before importing products. Alternatively, you can check the box below the 'Mapped' column for 'Create if it doesn't exist'.


If everything is correct, and the message 'Everything seems valid' will be displayed as shown in the screenshot below.

Click on 'Import' to start the importing process.


Step 4: Post-Import Verification

After the import process is complete, cross-verify a sample of imported products to ensure accuracy.

Check inventory levels and product details to confirm that all relevant information has been successfully imported.

Congratulations! You have successfully imported products in bulk quantities into the Metro ERP system using an Excel or CSV file.


To get more detail to How to update the units of measure (UOM), please do contact us at  support@metrogroup.solutions