Products
Query the available products in Stripe.
Table Specific Information
Select
Server-Side Query Support
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.
- Id supports the following operator: =.
- Active supports the following operator: =.
- Created supports the following operators: <, <=, =, >, >=.
- Shippable supports the following operator: =.
- Type supports the following operator: =.
- Url supports the following operator: =.
- Description supports the following operator: =.
- Name supports the following operator: =.
- Metadata supports the following operator: =.
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 (Created may be used with the >, >=, <, <=, or = conditions and may be used twice to specify a range):
SELECT * FROM Products WHERE Created > '12/1/2015'
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 Products where id = 'prod_PEcZQqWgJzbBCW'
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | False |
ID of product. | |
| Active | Boolean | False |
Whether or not 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. | |
| FeaturesAggregate | String | False |
A list of up to 5 attributes that each SKU can provide value. | |
| Created | Datetime | True |
The time when product is created. | |
| 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.maximum character length limit of 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 |
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 last updated time. | |
| 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 |
Tells if the dispute is in livemode. | |
| MetadataAggregate | String | False |
Set of key-value pairs | |
| 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 will be 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. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| AccountId | String |
The Id of the connected account to get products for. |