...
+ 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. popup
...
First, you can click on Download button to download a sample csv file then fill in that file.
...
Field Name | Required | Description | |||
SUPPLIER CODESupplier Code | TRUE | The code of the supplier. | |||
SUPPLIER NAMESupplier Name | TRUE | The name of the supplier. | |||
CONTACT PERSONContact Person | TRUE | The contact person of this supplier. | |||
SUPPLIER EMAILSupplier Email | TRUE | The email to contact with this supplier | |||
CC EMAILSCc Emails | FALSE | The cc emails when sending email to the supplier. Fill in multiple cc emails separated by ",". | |||
DESCRIPTIONDescription | FALSE | The description for this supplier. | |||
STATUSStatus | TRUE | The status of the Supplier. Only accept value = "Enable/Disable". | |||
TELEPHONETelephone | FALSE | The phone number of the supplier. | |||
FAXFax | FALSE | The fax of the supplier. | |||
STREETStreet | FALSE | The street in the address of the supplier. | |||
CITYCity | FALSE | The city in the address of the supplier. | |||
COUNTRYCountry | FALSE | The country in the address of the supplier. Acceptable value will follow the country list of magento. | |||
REGIONRegion | 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. | |||
ZIPZip/POSTAL CODEPostal Code | FALSE | The Zip/Postal Code in the address of the supplier. | |||
WEBSITEWebsite | FALSE | The website of the supplier. | |||
...
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."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
...