EndPoint Delete a Product

Contents

1 Label
2 Description
3 Parameters
4 Output Columns
5 Input Columns

Name

delete_product

Description

Delete a product. Deleting a product is only possible if it has no prices associated with it. Additionally, deleting a product with type=good is only possible if it has no SKUs associated with it. [API reference]

Parameters

Parameter	Label	Required	Options	Description
Id	Product Id	YES		Unique identifier for the Product

Output Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
Id	`DT_WSTR`	`nvarchar(100)`	100	False
Name	`DT_WSTR`	`nvarchar(100)`	100	False
Caption	`DT_WSTR`	`nvarchar(4000)`	4000	False
Description	`DT_WSTR`	`nvarchar(4000)`	4000	False
Active	`DT_BOOL`	`bit`		False
Created	`DT_DBTIMESTAMP`	`datetime`		False
Updated	`DT_DBTIMESTAMP`	`datetime`		False
Type	`DT_WSTR`	`nvarchar(100)`	100	False
Object	`DT_WSTR`	`nvarchar(100)`	100	False
Attributes	`DT_WSTR`	`nvarchar(2000)`	2000	False
LiveMode	`DT_BOOL`	`bit`		False
StatementDescription	`DT_WSTR`	`nvarchar(4000)`	4000	False
UnitLabel	`DT_WSTR`	`nvarchar(4000)`	4000	False
PackageDimensionsHeight	`DT_WSTR`	`nvarchar(4000)`	4000	False
PackageDimensionsLength	`DT_WSTR`	`nvarchar(4000)`	4000	False
PackageDimensionsWidth	`DT_WSTR`	`nvarchar(4000)`	4000	False
PackageDimensionsWeight	`DT_WSTR`	`nvarchar(4000)`	4000	False
URL	`DT_WSTR`	`nvarchar(4000)`	4000	False
Images	`DT_WSTR`	`nvarchar(2000)`	2000	False
TaxCodeId	`DT_WSTR`	`nvarchar(4000)`	4000	False
TaxCodeName	`DT_WSTR`	`nvarchar(4000)`	4000	False
PriceUnitAmount	`DT_I8`	`bigint`		False
PriceRecurringInterval	`DT_WSTR`	`nvarchar(4000)`	4000	False
PriceRecurringIntervalCount	`DT_I4`	`int`		False
PriceRecurringUsageType	`DT_WSTR`	`nvarchar(4000)`	4000	False
Shippable	`DT_WSTR`	`nvarchar(4000)`	4000	False
DeactivatedOn	`DT_DBTIMESTAMP`	`datetime`		False

Input Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw	Description
Id	`DT_WSTR`	`nvarchar(100)`	100	False

Required columns that you need to supply are bolded.