Hi all,
I am trying to solve a fun problem, where I would like to copy a subset of the product catalog from Store A to Store B. These are not pre-existing in Store B, so I don't need to worry about "check if it exists first".
In theory, the Excel export / import gets me part of the way there. For example, I can filter by Manufacturer A in Store A, and generate an Excel file. However, that file is missing tons of lookup tables. I need all that stuff too, categories, manufacturer(s), pictures, related products, specs, you know, all of the product data :)
Has anyone written a SQL Server script that could be modified or used to do the above?
What about commercial tools? I see there is nopAdmin that kind of does things in this category, but doesn't seem to quite do what I'm asking.
Thank you!