ProductVariants
Returns a list of the product variants.
Table-Specific Information
Select
The connector uses the Shopify API to process WHERE clause conditions built with the following columns and operators. The connector processes other filters client-side within the connector.
- Id supports the '=,IN' comparison operators.
- ProductId supports the '=,!=' comparison operators.
- Title supports the '=,!=' comparison operators.
- Barcode supports the '=,!=' comparison operators.
- Sku supports the '=,!=' comparison operators.
- Taxable supports the '=,!=' comparison operators.
- UpdatedAt supports the '=,!=,<,>,>=,<=' comparison operators.
- CreatedAt supports the '=,!=,<,>,>=,<=' comparison operators.
- InventoryQuantity supports the '=,!=,<,>,>=,<=' comparison operators.
- DeliveryProfileId supports the '=,!=' comparison operators.
The connector processes other filters client-side within the connector.
For example, the following queries are processed server-side:
SELECT * FROM ProductVariants WHERE Id = 'gid://shopify/ProductVariant/6788079091735'
SELECT * FROM ProductVariants WHERE Id IN ('gid://shopify/ProductVariant/6830135181335', 'gid://ProductVariant/Product/6830135181336')
SELECT * FROM ProductVariants WHERE ProductId='VALUE'
SELECT * FROM ProductVariants WHERE Title='VALUE'
SELECT * FROM ProductVariants WHERE Barcode='VALUE'
SELECT * FROM ProductVariants WHERE Sku='VALUE'
SELECT * FROM ProductVariants WHERE Taxable='true'
SELECT * FROM ProductVariants WHERE UpdatedAt<'2000-01-01 01:00:00.0'
SELECT * FROM ProductVariants WHERE CreatedAt<'2000-01-01 01:00:00.0'
SELECT * FROM ProductVariants WHERE InventoryQuantity<'100'
SELECT * FROM ProductVariants WHERE DeliveryProfileId='VALUE'
Insert
The following columns can be used to create a new record:
ProductId, Position, Price, CompareAtPrice, Barcode, Weight, WeightUnit, Sku, Taxable, TaxCode, InventoryPolicy, InventoryItemTracked, Options
UPDATE
The following columns can be updated:
Position, Price, CompareAtPrice, Barcode, Weight, WeightUnit, Sku, Taxable, TaxCode, InventoryPolicy, InventoryItemTracked, Options
DELETE
You can delete entries by specifying the Id.
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
A globally-unique identifier. | |
| LegacyResourceId | Long | True |
The ID of the corresponding resource in the REST Admin API. | |
| ProductId | String | True |
Products.Id |
A globally-unique identifier. |
| Position | Int | False |
The order of the product variant in the list of product variants. The first position in the list is 1. | |
| AvailableForSale | Bool | True |
Whether the product variant is available for sale. | |
| SellableOnlineQuantity | Int | True |
The total sellable quantity of the variant for online channels. This doesn't represent the total available inventory or capture (limitations based on customer location). | |
| SellingPlanGroupCount | Int | True |
Count of selling plan groups associated with the product variant. | |
| Price | Decimal | False |
The price of the product variant in the default shop currency. | |
| CompareAtPrice | Decimal | False |
The compare-at price of the variant in the default shop currency. | |
| DisplayName | String | True |
Display name of the variant, based on product's title + variant's title. | |
| Barcode | String | False |
The value of the barcode associated with the product. | |
| Weight | Double | False |
The weight of the product variant in the unit system specified with weight_unit. | |
| WeightUnit | String | False |
The unit of measurement that applies to the product variant's weight. If you don't specify a value for weight_unit, then the shop's default unit of measurement is applied. Valid values: 'g', 'kg', 'oz', 'lb'. | |
| Sku | String | False |
An identifier for the product variant in the shop. Required in order to connect to a fulfillment service. | |
| Title | String | False |
The title of the product variant. | |
| Taxable | Bool | False |
Whether a tax is charged when the product variant is sold. | |
| TaxCode | String | False |
The tax code for the product variant. | |
| UpdatedAt | Datetime | True |
The date and time when the product variant was last modified. | |
| CreatedAt | Datetime | True |
The date and time when the variant was created. | |
| InventoryPolicy | String | False |
Whether customers are allowed to place an order for the product variant when it's out of stock. | |
| InventoryQuantity | Int | True |
The total sellable quantity of the variant. | |
| InventoryItemId | String | True |
A globally-unique identifier. | |
| InventoryItemTracked | Bool | False |
Whether inventory levels are tracked for the item. | |
| ImageId | String | True |
A unique identifier for the image. | |
| ImageAltText | String | True |
A word or phrase to share the nature or contents of an image. | |
| ImageHeight | Int | True |
The original height of the image in pixels. Returns 'null' if the image is not hosted by Shopify. | |
| ImageWidth | Int | True |
The original width of the image in pixels. Returns 'null' if the image is not hosted by Shopify. | |
| ImageUrl | String | True |
The location of the image as a URL. | |
| DeliveryProfileId | String | True |
A globally-unique identifier. | |
| FulfillmentServiceEditableLocked | Bool | True |
Whether the attribute is locked for editing. | |
| FulfillmentServiceEditableReason | String | True |
The reason the attribute is locked for editing. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements, to offer a more granular control over the tuples that are returned from the data source, or as parameters in INSERT statements.
| Name | Type | Description |
| Options | String |
The custom properties that a shop owner uses to define product variants. |