This table should include all products, product variants and unique identifier information. We use this as a source of truth for all skus in your store. Each product can contain an attributes field which is an object of additional product attributes.

Time Period: Current

Why do we need this? We use this information to aid in training our pricing models, implementing margin constraints and correctly calculating P&L metrics.

Schema

Unique Constraint: sku_primary.
NameRequired?TypeDescriptionExample
Identifiers
sku_primaryrequiredstringMust be unique. This is the sku identifier at the most granular at which you would want to manage pricing."sku_variant_12"
barcodeoptionalstring12345678905
barcode_typeoptionalstringE.g asin/ upc/ gtin"gtin"
Price
list_pricerequiredfloat14.99
member_priceoptionalfloat12.99
subscriber_priceoptionalfloat12.99
discounted_priceoptionalfloat14.49
Costs
costrequiredfloat7.10
cogsoptionalfloat11.20
total_costoptionalfloat
Details
namerequiredstring"Blue T-Shirt"
descriptionoptionalstring"The best blue t-shirt."
imageoptionalstringURL link to image for product."exampleimagelink.com"
sku_brandoptionalstringBrand of product being sold."Gap"
price_zoneoptionalstringPrice zone location."Santa Clara"
categoriesrequiredstring[]Sku category["Men", "Shirts"]
sub_categoriesoptionalstring[]Sku subcategories["T-shirt", "Casual"]
attributesoptionalProductAttributesProduct attributes - see below for schema definitionProductAttributesSchema
tagsoptionalstring[]Tags for this sku, which will be applied as imported product tags in the dashboard.["Basics", "Snacks"]
store_idoptionalstringId for the store where the purchase was made - brick and mortar store id, ecomm region, etc."loc_1"
is_activerequiredbooleanNote that we do not suggest price changes or track price changes for inactive SKUs.true
miscoptionaljsonAny fields that we should know about, but aren’t in our schema?
Product Attributes
barcodeoptionalstring"123456"
collectionoptionalstring
coloroptionalstring"red"
country_of_originoptionalstring"USA"
custom_attributesoptionalZodJsonObject{}
departmentoptionalstring
discontinuedoptionalbooleanfalse
expiration_dateoptionalZodDateInput"2023-12-31"
finishoptionalstring
fitoptionalstring"regular"
genderoptionalstring"unisex"
heightoptionalstring"6ft"
ingredientsoptionalstring"sugar, salt"
is_free_shippingoptionalbooleantrue
kvioptionalstringhigh_kvi
lead_timeoptionalstring"2 days"
materialoptionalstring"cotton"
model_numberoptionalstring"XYZ123"
nutritional_infooptionalstring"Calories: 200"
packagingoptionalstring"box"
producer_nameoptionalstring"Company A"
producer_typeoptionalstring"OEM"
product_brand_nameoptionalstring
product_skuoptionalstring"SKU123"
product_typeoptionalstring"Electronics"
quantityoptionalstring"10"
ratingoptionalstring"4.5"
release_dateoptionalZodDateInput"2023-01-01"
search_keywordsoptionalstring"keyword1, keyword2"
secondary_list_priceoptionalstring
secondary_quantityoptionalstring
secondary_unit_of_measurementoptionalstring
shipping_dimensionsoptionalstring"30x20x15"
shipping_weightoptionalstring"5kg"
shipping_weight_unitoptionalstring"kg"
sizeoptionalstring"L"
size_descriptionoptionalstring"Large"
size_unitoptionalstring"cm"
unit_of_measurementoptionalstring"liters"
variant_idoptionalstring"var123"
versionoptionalstring"1.0"
volumeoptionalstring"100ml"
volume_unitoptionalstring"ml"
warrantyoptionalstring"1 year"
weightoptionalstring"500g"
weight_unitoptionalstring"g"
widthoptionalstring"10cm"