How to import supplier by CSV file

Step 1: Access the Import Supplier page.

You can access the Import Supplier function by:

+ Clicking on the Import Supplier button on the Manage Suppliers page.

Step 2: Import file

This is the Import Supplier popup

First, you can click on Download button to download a sample csv file then fill in that file.

Field Name	Required	Description
Supplier Code	TRUE	The code of the supplier.
Supplier Name	TRUE	The name of the supplier.
Contact Person	TRUE	The contact person of this supplier.
Supplier Email	TRUE	The email to contact with this supplier
Cc Emails	FALSE	The cc emails when sending email to the supplier. Fill in multiple cc emails separated by ",".
Description	FALSE	The description for this supplier.
Status	TRUE	The status of the Supplier. Only accept value = "Enable/Disable".
Telephone	FALSE	The phone number of the supplier.
Fax	FALSE	The fax of the supplier.
Street	FALSE	The street in the address of the supplier.
City	FALSE	The city in the address of the supplier.
Country	FALSE	The country in the address of the supplier. Acceptable value will follow the country list of magento.
Region	FALSE	The region in the address of the supplier. For some country such as US, the region must be a value on the list region of the selected country of Magento.
Zip/Postal Code	FALSE	The Zip/Postal Code in the address of the supplier.
Website	FALSE	The website of the supplier.

After you have filled in the data for the supplier (must fill in all required fields).

After clicking on Select File button, the Select File popup will show, then you select the file you want to import.

After that, you can click on Import button. The data will be validated then imported.

Note that if you import a supplier with the same Supplier Code with an existing one, the imported data will replace the existing data.

If you import successfully, it will show message as below:

Some failed cases

When user clicks on Import button, but no file has been uploaded.
-> Import failed, show failed message as the above picture, if the CSV file does not have require columns.

When user clicks on Import button, and a csv file has been uploaded, the import will be failed and show the failed message if the data in the file is not valid as in the following cases:

1. If in a row, among these fields Supplier Code, Supplier Name, Contact Person, Supplier Email, if there are any fields being empty, add the failed reason :" You cannot leave {field name} empty" Ex: You cannot leave Supplier Code empty ( Among Supplier Code, Supplier Name, Contact Person, Supplier Email, if there is more than one field being empty, the field name in the failed reason will be separated by ", " Ex: The Supplier Code and Supplier Name are empty -> The failed reason: You cannot leave Supplier Code, Supplier Name empty

2. If in a row, if the Status field is empty -> Add failed reason: The status of the supplier can only be "Enable/Disable"

3. If there is any row in the file with the Status field value invalid (only accept "Enable/Disable"). -> Add failed reason: The status of the supplier can only be "Enable/Disable"

4. If there are any Supplier Codes in the CSV file that are the same as the Supplier Code in the Supplier list page, add the failed reason " This supplier code has already been added to the Supplier list" (In these cases, the system will still validate failed with this failed reason:

5. The failed Supplier Code in the CSV file has spaces at the beginning and the end of the Supplier Code value

6. The failed Supplier Code in the CSV file has lowercase or capitalized letters, but the letters are still the same as the Supplier Code that is already added to the supplier list).

7. If there are multiple rows with the same Supplier Code, add failed reason "Same Supplier Code in multiple rows" (In case, there are multiple rows with the same Supplier Code and spaces at the beginning and ending of these Supplier Code values, the system still validate failed and show failed reason: "Same Supplier Code in multiple rows" )

8. If there is any row in the file with the Supplier Email invalid value (valid form: brian@domain.com), add failed reason: Invalid supplier email address (valid email example: brian@domain.com)

9. If there is any row in the file with the Cc Emails invalid emails, add failed reason: Invalid cc emails address (valid cc emails example: brian@domain.com, patrick@domain.com)

10. If there is any row in the file with the Status field value invalid (only accept "Enable/Disable"). -> Add failed reason: The status of the supplier can only be "Enable/Disable"

11. If in a row, Supplier Name, Supplier Code, Supplier Email , Contact Person are filled, and the Status is empty -> Also add failed reason: The status of the supplier can only be "Enable/Disable"

12. If there is any row in the file with the Country field value invalid (only accept value on the Magento Country list). -> Add failed reason: You can only select the supplier's country from the Magento countries list

13. If there is any row in the file with the Country selected that has a predefined list for Region (ex: Argentina, US), and the filled-in Region is invalid (only accept value on the Magento Region list). -> Add failed reason: For some countries, you must select the supplier's region from the Magento region list