Identify products by Supplier

Identify products by Supplier

Feb 29, 2016
Alessio wrote
Hello,
put you have more than one supplier and you want to:
1) Add the products by Supplier ONE
2) Just Add the products by Supplier TWO
3) By next imports, even if some products have the same reference (eg. Mpn/Product Code/Icecat Code)
you can choose to not add them from Supplier TWO, so you can just correctly modify the products of both suppliers...and add new products only, if found...

but currently you can't do that... when you IMPORT you can't identify products by "Reference AND Supplier", maybe you could just add a prefix to the reference for the 2nd Supplier, eg. Supplier2_ProductCode
but it causes issues when you go to search on Icecat... unless you create a kind of "editor" even in the Icecat plugin...and also, often merchants don't like duplicate products...

Hope this helps
Kind Regards
New
0 votes
Vote
Reply
7 Answers
Avatar image
Feb 29, 2016
Alex Pryshlivskiy agent wrote
Do you want to add the following option on mapping stage of Import ?
See screenshot -
Feb 29, 2016
Alessio wrote
;-) yes, exactly...
Avatar image
Feb 29, 2016
Alex Pryshlivskiy agent wrote
Could you provide example of your file with refs and suppliers ? I'd like to have a look on it. There is one idea for it.. :-) I'll reach you via email.
Feb 29, 2016
Alessio wrote
indeed there's no need of a sample .csv file

just put the case that in the Supplier field, when you import for a specific supplier,

on editor of the left column you write "Supplier ONE name".... so on database you know that those products are related to Supplier ONE...

then, you import the products from Supplier TWO, with the Supplier field set to 'Supplier TWO name'...and so on...

so, ... you should be able to do the comparison/identification (on database with php bridge for sure)
Feb 29, 2016
Alessio wrote
when you just ADD new products, important is that you always write the correct Supplier name...and even if you identify by "Reference" only there are no problems...

the problem, instead, now is that when you want to MODIFY the products... the 2nd (or other suppliers) could have the same products on their list... and you DON'T want to modify them...because they belong to the 1st supplier (or other)...

hope all is clear
Feb 29, 2016
Alessio wrote
not only... even if you change idea and want to assign some products to another supplier... will be enough if you write the correct supplier name ;-)
Avatar image
Mar 01, 2016
Alex Pryshlivskiy agent wrote
So, you want to do mapping of suppliers with product duplicate validation for CSV file.
In this case we need to do import twice for 2 suppliers or 1 time for 1 supplier.