EndPoint Update a Product

Contents

Name

put_product

Updates an existing product. [API reference]

Parameter	Label	Required	Options	Description
Id	Product Id	YES		The ID of the product to be updated.

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
Id	`DT_I8`	`bigint`		False
Title	`DT_WSTR`	`nvarchar(200)`	200	False
BodyHtml	`DT_NTEXT`	`nvarchar(MAX)`		False
Vendor	`DT_WSTR`	`nvarchar(200)`	200	False
ProductType	`DT_WSTR`	`nvarchar(200)`	200	False
CreatedAt	`DT_DBTIMESTAMP`	`datetime`		False
UrlHandle	`DT_WSTR`	`nvarchar(200)`	200	False
UpdatedAt	`DT_DBTIMESTAMP`	`datetime`		False
PublishedAt	`DT_DBTIMESTAMP`	`datetime`		False
TemplateSuffix	`DT_WSTR`	`nvarchar(200)`	200	False
Status	`DT_WSTR`	`nvarchar(200)`	200	False
PublishedScope	`DT_WSTR`	`nvarchar(200)`	200	False
Tags	`DT_WSTR`	`nvarchar(4000)`	4000	False
AdminGraphqlApiId	`DT_WSTR`	`nvarchar(200)`	200	False
Variants	`DT_NTEXT`	`nvarchar(MAX)`		False
Options	`DT_WSTR`	`nvarchar(4000)`	4000	False
Images	`DT_NTEXT`	`nvarchar(MAX)`	4000	False
Image	`DT_WSTR`	`nvarchar(4000)`	4000	False
ImageId	`DT_I8`	`bigint`		False
ImageProductId	`DT_I8`	`bigint`		False
ImagePosition	`DT_I4`	`int`		False
ImageCreatedAt	`DT_DBTIMESTAMP`	`datetime`		False
ImageUpdatedAt	`DT_DBTIMESTAMP`	`datetime`		False
ImageAlt	`DT_WSTR`	`nvarchar(4000)`	4000	False
ImageWidth	`DT_I4`	`int`		False
ImageHeight	`DT_I4`	`int`		False
ImageSrc	`DT_WSTR`	`nvarchar(4000)`	4000	False
ImageVariantIds	`DT_WSTR`	`nvarchar(500)`	500	False
ImageAdminGraphqlApiId	`DT_WSTR`	`nvarchar(200)`	200	False
Metafields	`DT_NTEXT`	`nvarchar(MAX)`		False

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw	Description
Title	`DT_WSTR`	`nvarchar(200)`	200	False
BodyHtml	`DT_NTEXT`	`nvarchar(MAX)`		False	(maximum is 512 KB)
UrlHandle	`DT_WSTR`	`nvarchar(500)`	500	False
ProductType	`DT_WSTR`	`nvarchar(200)`	200	False
Status	`DT_WSTR`	`nvarchar(200)`	200	False
Vendor	`DT_WSTR`	`nvarchar(200)`	200	False
TemplateSuffix	`DT_WSTR`	`nvarchar(200)`	200	False
PublishedScope	`DT_WSTR`	`nvarchar(200)`	200	False
Tags	`DT_WSTR`	`nvarchar(4000)`	4000	True
Variants	`DT_NTEXT`	`nvarchar(MAX)`		True
Options	`DT_WSTR`	`nvarchar(4000)`	4000	True
Images	`DT_NTEXT`	`nvarchar(MAX)`		True
Metafields	`DT_NTEXT`	`nvarchar(MAX)`		True
SEOTitle	`DT_WSTR`	`nvarchar(1000)`	1000	False
SEODescription	`DT_WSTR`	`nvarchar(4000)`	4000	False
Id	`DT_I8`	`bigint`		False

Required columns that you need to supply are bolded.