Have a table that has the providers you use
ProviderID, Provider
1, Amazon
2, Whatever
Have a table of the products you track
ProductID, ProductName
1, Dyson 300 Vacuum Cleaner
2, VAX 250 Vacuum Cleaner
Have a table that stores provider-specific info
SkuID, ProviderID, ProductID, Price, ProductCode
1, 1, 1, 300, A1234
2, 2, 1, 295, W3547
3, 1, 2, 250, A6548
4, 2, 2, 249, W3325
You would then let people search your product table then join the SKU table to get the prices, codes etc per vendor.