Update a product
Updates an existing product record in the Products table. This example demonstrates updating multiple fields, including images and dimensions. Note that supplying image fields will reset any previously existing images for the product.
UPDATE Products
SET [Name]='SSIS PowerPack 3 - Updated'
, [Caption]='Caption-updated'
, [Description]='Desc-updated'
--, [UnitLabel] --only when product type=service
, [Active]='true'
, [PackageDimensionsHeight]=12
, [PackageDimensionsWidth]=13
, [PackageDimensionsLength]=14
, [PackageDimensionsWeight]=1122
, [URL]='https://zappysys.com/products/ssis-powerpack/?updated=1'
, [Image1]='https://zappysys.com/images/tech/web-api-logo.png?updated=1'
, [Image2]='https://zappysys.com/images/tech/xml-logo.png?updated=1'
WHERE Id='prod_MiSJzGZ8PDM9uh'