Hello.
I am using WSI for a number of things and one of them is to add/update products hourly via console app/WSI.
I have it working pretty well. All I need now is to know exactly how the <Product> node is used to 'lookup' products to see if they exist.
I have the following as a product in the DB but it doesn't show up in WSI using lookup. What am I missing. I was told I need name/sku as a minimum but it doesn't work. I've checked back and forth between SQL mgr and the sample WSI app.
using:
<AspDotNetStorefrontImport Verbose="false">
<Product Action="Lookup" SKU="03-047" Name="Single Fender Back - Small">
</Product>
</AspDotNetStorefrontImport>
it returns that it was 'Not Found'...

but looking in the DB it IS there sure as can be....

What's wrong/missing? What is the minimum attributes needed for a 'lookup' inside the 'product' node of WSI?

Can I just use SKU? (which is all I really want/need to use since this app updates product info including product name... so if name is required, it won't work reliably since names might change. SKU is the linker here only.

Any ideas?

Thanks