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