View: Product and Vendor Information

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]