How to import supplier

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.

+ Clicking on the Import Suppliers item on the left menu

Step 2: Import file

This is the Import Supplier page.

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 note under the Import file section "This is a required field."

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:

If the file cannot find any column (Supplier Code, Supplier Name, Contact Person, Supplier Email, CC Emails, Description, Status, Telephone, Fax, Street, City, Country, Region, Zip/Postal Code, Website).
-> Show message "Cannot find {missing column} data in the file". In case there are multiple missing columns, separate them by ", ". ex: "Cannot find Supplier Code, Supplier Name data in the file!"
If there is any row in the file with the required fields empty (Supplier Code, Supplier Name, Contact Person, Supplier Email, Status) while other fields have been filled in at least one.
-> Show message "You cannot leave {empty required column} blank!". In case there are multiple empty required columns, separate them by ", ". ex: "You cannot leave Supplier Code, Supplier Name blank!"
If there is any row in the file with the Status field value invalid (only accept "Enable/Disable").
-> Show message "The status of the supplier can only be "Enable/Disable"".
If there is any row in the file with the Country field value invalid (only accept value on the Magento Country list).
-> Show message "You can only select supplier's country from Magento countries list".
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).
-> Show message "For some countries, you must select supplier's region from Magento region list".
If there is multiple rows in the file with the same Supplier Code.
-> Show message "Supplier Code must not be duplicated in the file".