I really need to create a list of all products sorted by manufacturer that includes to the product, sku/model, price.
I've been exporting the db table _product(and a few others) and a few others to merge them but it takes me over an hour each time. I need this list to compare with my distributors list ever month. Perhaps if this isn't feasible someone could assist me in a sql query that would alleviate the merging afterwards?
The tables I need are:
products_name,manufacturer_name,products_SKU,products_price
Bookmarks