This article will help you learn about the fields available in the Product and Vendor Information view, the field types, descriptions and how the fields are calculated
Key Topics
Click on the links below to take you to the section where you can learn more about this View and where it is used and how it is created
View Definition
This view is linked to the [uos.product_variants] table which generated as part of the Daasity transformation process and has the following fields available/visible for use.
Field Name | Field Type | Description | Source / Calculation |
Product Created | Dimension Group | Date the product was created in the source | created_at |
Country of Origin | Dimension | Product country of origin | country_of_origin |
Inventory Tracked Flag | Dimension | Is inventory marked as tracked in source integration? | inventory_tracked_flag |
Requires Shipping Flag | Dimension | Is product marked to require shipping in source integration? | requires_shipping_flag |
Product ID | Dimension | Product ID stored in the source system | product_id |
Variant ID | Dimension | Variant ID stored in the source integration | variant_id |
Image | Dimension (Image) | Actual product image | image_url |
Image Position | Dimension | Position of the image on the page | image_position |
Image URL | Dimension | URL of image in the store | image_url |
Listing SKU | Dimension | The SKU in the store | listing_sku |
Retail Price | Dimension | Retail Price of the product in the store source integration | price |
SKU | Dimension | The normalized SKU across all stores | sku |
SKU Cost | Dimension | SKU cost of the inventory item in the source integration | sku_cost |
Variant Name | Dimension | Name of the product variant | variant_name |
Weight (Unit) | Dimension | Weight unit of the product in the source integration | weight_unit |
Weight (Value) | Dimension | Weight of the product in the source integration | weight |
Count Products | Measure | COUNT(DISTINCT product_id) | |
Count Variants | Measure | Count of unique product variants | COUNT(DISTINCT variant_id) |
Explores
This view is part of the following explores:
- Current Inventory Level
Transformation Code
This view is a part of the Daasity Unified Order Schema (UOS) that enables Daasity to combine different order sources into a single data model.
Growth & Pro support the following code:
- [0514_UOS_BAS_SHOPIFY_product_variants.sql]
- [0543_UOS_BAS_AMAZON_product_variants.sql]
- [0575_UOS_BAS_SKUBANA_product_variants.sql]
Pro supports the following code if the optional code is enabled:
- [0588_UOS_BAS_SFCC_product_variants.sql] (Salesforce Commerce Cloud)
- [0604_UOS_PRO_LIGHTSPEED_product_variants.sql]