Table 30129 "Shpfy Variant"

Shopify · Microsoft.Integration.Shopify · captioned “Shopify Variant” · BC29-30 · source at ea08af5e · facts from BC29

Learn documents this table through its pages: Page 30127 “Shpfy Variants” (3 Learn pages).

Properties

Property	Value
Caption	Shopify Variant
DataClassification	CustomerContent

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

No.	Name	Type	Explanation	Notes
1	Id	BigInteger	Specifies the unique numeric identifier for the product variant. Each product has always one variant. via Page 30127 “Shpfy Variants”
2	Product Id	BigInteger	ProductId caption
3	Created At	DateTime	Specifies the date and time when the product variant was created in Shopify. via Page 30127 “Shpfy Variants”
4	Updated At	DateTime	Specifies the date and time when the product variant was last modified in Shopify. via Page 30127 “Shpfy Variants”
5	Available For Sales	Boolean	Specifies if the variants is available for sales. via Page 30127 “Shpfy Variants”
6	Barcode	Text[50]	Specifies the barcode, UPC, or ISBN number for the product. via Page 30127 “Shpfy Variants”
7	Compare at Price	Decimal	Specifies the original price of the product variant in Shopify before a discount. Shopify displays it alongside the current price to show the price reduction. via Page 30127 “Shpfy Variants”
8	Display Name	Text[250]	—
9	Inventory Policy	Enum “Shpfy Inventory Policy”	Specifies whether customers are allowed to place an order for the product variant when it is out of stock. Valid values are: deny, continue. via Page 30127 “Shpfy Variants”	enum Enum 30125 “Shpfy Inventory Policy”
10	Position	Integer	—
11	Price	Decimal	Specifies the price of a product variant. via Page 30127 “Shpfy Variants”
12	SKU	Text[50]	Specifies the unique identifier for the product variant in the shop. via Page 30127 “Shpfy Variants”
13	Tax Code	Code[20]	Specifies the Avalara tax code for the product variant. This parameter applies only to the stores that have the Avalara AvaTax app installed. via Page 30127 “Shpfy Variants”	obsolete Pending 28.0; #if not CLEANSCHEMA31
14	Taxable	Boolean	Specifies whether a tax is charged when the product variant is sold. via Page 30127 “Shpfy Variants”
15	Title	Text[100]	Specifies the title of the product variant. The title field is a concatenation of the option1, option2, and option3 fields. via Page 30127 “Shpfy Variants”
16	Weight	Decimal	Specifies the weight of the product variant. via Page 30127 “Shpfy Variants”
17	Option 1 Name	Text[50]	Specifies the custom properties that a shop owner uses to define product variants. You can define three options for a product variant. via Page 30127 “Shpfy Variants”
18	Option 1 Value	Text[50]	Specifies the value of the first option. via Page 30127 “Shpfy Variants”
19	Option 2 Name	Text[50]	Specifies the custom properties that a shop owner uses to define product variants. You can define three options for a product variant. via Page 30127 “Shpfy Variants”
20	Option 2 Value	Text[50]	Specifies the value of the second option. via Page 30127 “Shpfy Variants”
21	Option 3 Name	Text[50]	Specifies the custom properties that a shop owner uses to define product variants. You can define three options for a product variant. via Page 30127 “Shpfy Variants”
22	Option 3 Value	Text[50]	Specifies the value of the third option. via Page 30127 “Shpfy Variants”
23	Unit Cost	Decimal	Specifies the cost of one unit for the variant. via Page 30127 “Shpfy Variants”
24	Image Id	BigInteger	—
100	Shop Code	Code[20]	—	TableRelation Table 30102 “Shpfy Shop” (Shpfy Shop)
101	Item SystemId	Guid	—	DataClassification SystemMetadata
102	Item Variant SystemId	Guid	—	DataClassification SystemMetadata
103	Last Updated by BC	DateTime	—	DataClassification SystemMetadata
104	Item No.	Code[20]	Specifies the item number. via Page 30127 “Shpfy Variants”	FlowField: lookup(Item.“No.” where(SystemId = field(“Item SystemId”)))
105	Variant Code	Code[10]	Specifies the code of the item variant. via Page 30127 “Shpfy Variants”	FlowField: lookup(“Item Variant”.Code where(SystemId = field(“Item Variant SystemId”)))
106	UoM Option Id	Integer	—	DataClassification SystemMetadata
107	Mapped By Item	Boolean	—	DataClassification SystemMetadata
108	Image Hash	Integer	—	DataClassification SystemMetadata
109	Tariff No.	Code[20]	—
110	Country/Region of Origin Code	Code[10]	—

Keys

PK: Id (clustered)

Triggers

OnDelete

Relations

Shop Code: TableRelation Table 30102 “Shpfy Shop”
Variant Code: CalcFormula Table 5401 “Item Variant”

Pages and codeunits on this table

Page 30127 “Shpfy Variants” (source table)
Codeunit 30171 “Shpfy Create Item” (codeunit runs on it)
Codeunit 30188 “Shpfy Update Item” (codeunit runs on it)
Codeunit 30456 “Shpfy Variant Image Export” (codeunit runs on it)

Recent changes

2026-07-09 #9253 [Shopify] Disambiguate Shopify timestamp field captions and tooltips (main, BC30, fix)

Deprecations

field Tax Code: Pending 28.0 (#if not CLEANSCHEMA31), “Shopify API 2025-10 deprecated taxCode on ProductVariant. This field is no longer available in the API.”

Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).

Ask your agent

Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Shpfy Variant"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.