In sage we use a product code, we then use the suppliers part number for what we order said product as. We work like this as if a product becomes unavailable from a supplier we can change to a new supplier of the same product just by changing the supplier and their respective part number in the prodcts window.
With Brexit and all the faff and hassle it's created we've basically had to add commodity codes to 5k+ products manually.
This is a little frustrating and time consuming when I don't think that this process should be so difficult, just Sage decides it should be!
The thing is, we get .xls or .csv "price files" from suppliers which contain not only commodity codes and descriptions but other vital info like weight, EAN, cost price, comparison numbers and the like.
It would be so much simpler to import or update product information in Sage if Sage would allow you to either map data fields or use the suppliers part number to marry products up.
Obviosuly we wouldn't want to import all the suppliers data from their price file so it would need to only import data for suppliers parts numbers that already exist.
This way, Brexit prep would have been so much quicker and would make life going forward much simpler too as when new price files become available then they could simply be mapped and imported, hey presto, literally weeks of faff done in a few clicks.
Guest
