Thread: can you do this wsi updatE?

CAn you update your products by SKU instead of product/variant ID?

<AspDotNetStorefrontImport Verbose="false">

<Transaction>

<Product Action="Update" SKU="1">

<Variants>

<Variant Action="Update" SKU="143">

<Inventory>100</Inventory>

</Variant>

</Variants>

</Product>


</Transaction>

</AspDotNetStorefrontImport>

No. Product/Variant are the unique keys in the database.

SKUs aren't guaranteed to be unique, but if you know yours are you could do something like

Code:

<AspDotNetStorefrontImport>
<Query>
<SQL>
<![CDATA[
update dbo.ProductVariant set Inventory=100 where SKUSuffix='143' and ProductID=(select p.ProductID from dbo.Product p where p.SKU='1')
]]>
</SQL>
</Query>
</AspDotNetStorefrontImport>

Now, that's powerful! Passing in an SQL UPDATE via the web service. I like it!

Originally Posted by swheeler

Now, that's powerful! Passing in an SQL UPDATE via the web service. I like it!

Powerful, yes ... dangerous, probably

Just be careful and make sure you know what your sql WILL do.

George,

Can I pass in mulitple updates in one transaction, such as:

<Query>
<SQL>
<![CDATA[
update dbo.ProductVariant set Inventory=100 where SKUSuffix='123' and ProductID=(select p.ProductID from dbo.Product p where p.SKU='1')
]]>
</SQL>
</Query>
<Query>
<SQL>
<![CDATA[
update dbo.ProductVariant set Inventory=100 where SKUSuffix='456' and ProductID=(select p.ProductID from dbo.Product p where p.SKU='1')
]]>
</SQL>
</Query>

Thanks,

Scott

Yeah absolutely...just as you've done