EndPoint Update a Product

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`

If the column you are looking for is missing, consider customizing Shopify Connector.

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.

Use Shopify Connector in API Source component to read data or in API Destination component to read/write data:

This EndPoint belongs to Products table, therefore you cannot work with it directly. Use this table and table-operation pair instead:

Shopify

Products

Update