EndPoint Delete a Product

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.

Examples

SSIS

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

Delete rows from Products table using API Destination

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

Stripe

Products

Delete