import scenario issue on Vendors - Attributes

I have tried, but imported wrong column?

according the excel file it should be Column B “Vendor products”  line 4 in system, but after I imported, it goes to line 1  “Chinese Address”  

I’m not sure which part is wrong? could you help?

On the 4th line, Source Field / Value change =’SOURCE’, This needs to be your actual attribute ID: =’Vendor Products’ (to hard code it) or use Attribute column from the excel sheet.

On the 5th line, Source Field /Value change Attribute, this needs to be the column in your sheet that has the value you want to insert.  This would be Value (column D) if you are attempting to insert “On Semiconductor”.  

On the 7th line uncheck the Active box, save and test and see if this works.

I tried to adjust my excel file move “ON Semiconductor” from column D to column B

Line 4 changed to =’Vendor Products’

Line 7 unchecked

Vendor Products = ON Semiconductor imported

but Chinese Address come out “False” and come out the new line Opportunity Source???

can it be removed the line Opportunity Source, I didn’t add it

If you want to update several attributes you will still need the attribute ID on the excel sheet.  If this is also the case, you should not hard code the Source Field / Value to be =’Vendor Products’.  Delete that out of the field and double click/look up your excel column for the attribute ID (your original excel sheet had this as column b “Attribute”).  The following line of the import scenario will be value (the excel value you want to insert into the attribute value). 

I didn’t add Opportunity source in Attribute why it appear suddenly？　can it remove?

I’m not sure what going on with the Opportunity Source.  These are controlled by which attributes are assigned to the Vendor Class.  Do you have multiple vendor classes set up and is it the correct class for the vendor you are working with?