Products

Returns the available products in Stripe and supports creating, updating, and deleting them.

Table-Specific Information

SELECT

The add-in uses the Stripe API to filter the results by the following columns and operators while the rest of the filter is executed client-side within the add-in.


Column	Supported Operators
Id	=
Active	=
Created	<, <=, =, >, >=
Shippable	=
Type	=
Url	=
Description	=
Name	=
Metadata	=

You can select:

A product by specifying its Id:

SELECT * FROM Products WHERE Id = '12345678'

Multiple products by specifying their Ids:

SELECT * FROM Products WHERE Id IN ('12345678', '123456789', '123456788',)

Products that can be shipped:

SELECT * FROM Products WHERE Shippable = 'true'

Products for a given URL:

SELECT * FROM Products WHERE URL = '/v1/skus?product=1234\u0026active=true'

Active products:

SELECT * FROM Products WHERE Active = True

Products created after a certain date:

SELECT * FROM Products WHERE Created > '2018-01-01'

Created can also be used twice to specify a range:

SELECT * FROM Products WHERE Created >= '2018-01-01 00:00:00.0' AND Created <= '2018-12-31 23:59:59.0'

INSERT

A name is required to create a product:

INSERT INTO Products (Name, Images, FeaturesAggregate, MetadataAggregate) VALUES ('asdwd', '[\"http://da.cs/fs.jpg\",\"http://da.cs/fss.jpg\"]', '[{\"name\":\"asdsa\"}]', '[{\"nsame\":\"asdsa\"}]')

UPDATE

To update a product, specify the Id:

UPDATE Products SET Name = 'fafs' WHERE Id = 'prod_PEcZQqWgJzbBCW'

DELETE

To delete a product, specify the Id:

DELETE FROM Products WHERE Id = 'prod_PEcZQqWgJzbBCW'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	False		The Id of the product.
Active	Boolean	False		Indicates whether the product is currently available for purchase. Afterwards stripe:version = 2016-06-15 setting active to false no longer marks the product's SKUs as inactive.
MarketingFeaturesAggregate	String	False		A list of up to 5 attributes that each SKU can provide value.
Created	Datetime	True		The date and time at which the product was created, measured in seconds since the Unix epoch.
DefaultPrice	String	False		The Id of the Price object that is the default price for this product. Can be used in Update.
Description	String	False		The product's description, meant to be displayable to the customer.
Name	String	False		The product's name, meant to be displayable to the customer. The maximum character length limit is 250.
PackageDimensionsHeight	Double	False		The height dimension of this product for shipping purposes.
PackageDimensionsLength	Double	False		The length dimension of this product for shipping purposes.
PackageDimensionsWeight	Double	False		The weight dimension of this product for shipping purposes.
PackageDimensionsWidth	Double	False		The width dimension of this product for shipping purposes.
Shippable	Boolean	False		Indicates whether this product is a shipped good.
StatementDescriptor	String	False		Extra information about a charge for the credit card statement of the customer.
Updated	Datetime	True		The date and time at which the product was last updated, measured in seconds since the Unix epoch.
Type	String	True		The type of the product.
Url	String	False		The URL of a publicly-accessible webpage for this product.
TaxCode	String	False		A tax code Id.
Livemode	Boolean	True		Indicates whether the object exists in live mode. The value is true in live mode and false in test mode.
MetadataAggregate	String	False		Set of key-value pairs that you can attach to an object.
Object	String	True		String representing the object's type. Objects of the same type share the same value.
UnitLabel	String	False		A label that represents units of this product in Stripe and on customers' receipts and invoices. When set, this is included in associated invoice line item descriptions.
Images	String	False		A list of up to 8 URLs of images for this product, meant to be displayable to the customer.

Pseudocolumns

Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.


Name	Type	Description
AccountId	String	The Id of the connected account to get products for.

Excel Add-In for Stripe