Explore: Current Inventory Level

Description

Product specifications and attributes from Shopify, along with current inventory levels from Shopify.

Common Use Cases

Look up current inventory level of specific SKUs.
Create report for SKUs running low on inventory.

Fields

**Current Inventory Level: inventory_levels**
Filters, Dimensions and Measures	Category	Description
Current Inventory Level: Inventory Location	dimension	Name from the Location table where the inventory is location
Current Inventory Level: Inventory Quantity	dimension	Total item inventory in the store(s)
Current Inventory Level: Listing SKU	dimension	The SKU in the store
Current Inventory Level: SKU	dimension	The normalized SKU across all stores
Current Inventory Level: Current Inventory Cost Value	measure	Inventory quantity * sku cost
Current Inventory Level: Current Inventory Retail Value	measure	Inventory quantity * product price
Current Inventory Level: Inventory Location	measure	Count of the unique locations inventory is recorded
Current Inventory Level: Item Inventory	measure	Count of the unique items + store combinations

**Order Line Detail: order_line_revenue**
Filters, Dimensions and Measures	Category	Description
Order Line Detail: Converted Currency	dimension	The Currency Code the amount was convererted to
Order Line Detail: Currency Conversion Rate	dimension	The daily rate of the currency conversion
Order Line Detail: Gift Card Flag (Yes / No)	dimension	If the Item is a Gift Card
Order Line Detail: Listing SKU	dimension	The SKU of the product from the Source System
Order Line Detail: Original Currency	dimension	The Currency Code the amount was convererted from
Order Line Detail: Product Name	dimension	The name of the product when purchased
Order Line Detail: Product Type	dimension	The type of product from the Source System
Order Line Detail: SKU	dimension	The mapped SKU (if applicable) based on the BSD SKU Mapping table
Order Line Detail: SKU Cost	dimension	The cost of the item (1 unit)
Order Line Detail: Store Customer ID	dimension	The Customer ID from the Source System
Order Line Detail: Store Order ID	dimension	The Order ID from the Source System
Order Line Detail: Store Order Line ID	dimension	The Order Line ID from the Source System
Order Line Detail: Variant Name	dimension	The name of the Item (Product Variant) when purchased
Order Line Detail: Variant Price	dimension	The price of the item when purchased
Order Line Detail: Attribution Contribution Margin	measure	Total contribution margin of orders: Net Margin less attribution marketing cost and fulfillment/shipping cost
Order Line Detail: Attribution Marketing Cost	measure	Total Attribution Marketing cost of orders
Order Line Detail: Average Order Attribution Marketing Cost	measure	Average Attribution Marketing Cost per valid order
Order Line Detail: Average Order Discount Amount	measure	Average discount per order -- Total Discount Amount divided by Valid orders
Order Line Detail: Average Order First Click Marketing Cost	measure	Average First Click Marketing Cost per valid order
Order Line Detail: Average Order Gross Sales	measure	Average order value using gross sales -- Total Gross Sales divided by Valid orders
Order Line Detail: Average Order Last Click Marketing Cost	measure	Average Last Click Marketing Cost per valid order
Order Line Detail: Average Order Net Sales	measure	Average order value using net sales -- Total Net Sales divided by Valid orders
Order Line Detail: Average Order Product Cost	measure	Average Product Cost per order
Order Line Detail: Average Order Product Sales	measure	Average product sales per order -- Total Product Sales divided by Valid orders
Order Line Detail: Average Unit Attribution Marketing Cost	measure	Average Attribution Marketing Cost per valid unit
Order Line Detail: Average Unit Discount Amount	measure	Average discount per order line item -- Total Discount Amount divided by Valid order items
Order Line Detail: Average Unit First Click Marketing Cost	measure	Average First Click Marketing Cost per valid unit
Order Line Detail: Average Unit Gross Sales	measure	Average gross Sales unit -- Total gross Sales divided by Valid order items
Order Line Detail: Average Unit Last Click Marketing Cost	measure	Average Last Click Marketing Cost per valid unit
Order Line Detail: Average Unit Net Sales	measure	Average net Sales per unit -- Total Net Sales divided by Valid order items
Order Line Detail: Average Unit Product Cost	measure	Average Product Cost per valid unit
Order Line Detail: Average Unit Product Sales	measure	Average product sales per unit -- Total Product Sales divided by Valid order items
Order Line Detail: Cart Discount Amount	measure	Total discount applied at the cart level (order)
Order Line Detail: Count - Customers	measure	Count the number of householded customers
Order Line Detail: Count - Feature Items	measure	Count the number of line order items
Order Line Detail: Count - Free Items	measure	Count the number of free items (price is zero)
Order Line Detail: Count - Invalid Feature Items	measure	Count the number of invalid feature items
Order Line Detail: Count - Invalid Free Items	measure	Count the number of invalid free items (price is zero)
Order Line Detail: Count - Invalid Items	measure	Count the number of invalid feature + invalid free items
Order Line Detail: Count - Invalid Orders	measure	Count the number of invalid orders
Order Line Detail: Count - Items	measure	Count the number of feature + free items
Order Line Detail: Count - Orders	measure	Count the number of orders
Order Line Detail: Count - Valid Feature Items	measure	Count the number of valid feature items
Order Line Detail: Count - Valid Free Items	measure	Count the number of valid free items (price is zero)
Order Line Detail: Count - Valid Items	measure	Count the number of valid feature + valid free items
Order Line Detail: Count - Valid Orders	measure	Count the number of valid orders
Order Line Detail: Discount Amount	measure	Total discount amount a customer be charged
Order Line Detail: Feature Product Amount	measure	Total product sales including product discounts
Order Line Detail: First Click Contribution Margin	measure	Total contribution margin of orders: Net Margin less first click marketing cost and fulfillment/shipping cost
Order Line Detail: First Click Marketing Cost	measure	Total First Click Marketing cost of orders
Order Line Detail: Gift Card Sales Amount	measure	Total Gift Card amount purchased
Order Line Detail: Gross Margin	measure	Total Gross Margin of orders: Gross Sales less sku cost
Order Line Detail: Gross Sales	measure	Total Gross sales of orders: Amount Charged - Tax Amount
Order Line Detail: Last Click Contribution Margin	measure	Total contribution margin of orders: Net Margin less last click marketing cost and fulfillment/shipping cost
Order Line Detail: Last Click Marketing Cost	measure	Total Last Click Marketing cost of orders
Order Line Detail: Net Sales	measure	Total Net sales of orders: Amount Charged - Tax - Refund
Order Line Detail: Percent - Discount of Potential Sales	measure	Percentage of discount amount on the full amount
Order Line Detail: Percent - Refund of Gross	measure	Percentage of refund amount on total gross sales
Order Line Detail: Potential Sales	measure	Potential Sales is the full amount a customer could be charged - i.e. Non-Discounted Product Amount + Shipping Amount
Order Line Detail: Product Cost	measure	Total Product cost of orders
Order Line Detail: Product Discount Amount	measure	Total discount applied to the product (line level)
Order Line Detail: Refund Amount	measure	Total refund amount allocated based on Product Sales
Order Line Detail: Shipping Amount Charged	measure	Total shipping amount of orders
Order Line Detail: Tax Amount	measure	Tax amount allocated based on Product Sales
Order Line Detail: Unit Per Order	measure	Units per order -- Total feature items divided by valid orders

**Orders: order_status**
Filters, Dimensions and Measures	Category	Description
Orders: AVS Result Code	dimension	Result Code of Address Verification
Orders: Business Order Flag (Yes / No)	dimension	If the order was flagged as a business order in Amazon
Orders: CVV Result Code	dimension	Result Code of CVV Check
Orders: Cancel Reason	dimension	The reason an order was cancelled from the Source System
Orders: Cancelled Flag (Yes / No)	dimension	If the Order Status is: Cancelled
Orders: Credit Card BIN	dimension	Credit Card BIN - the first 6 digits of the credit card: used to identify type of card and issuer
Orders: Credit Card Type	dimension	The type of credit card from the transaction
Orders: Discount Flag (Yes / No)	dimension	If a valid order and the discount_amount is greater than 0
Orders: Email Address	dimension	Customer email address
Orders: Expedited Shipping Order Flag (Yes / No)	dimension	If the order was flagged with expedited shipping in Amazon
Orders: Finacial Status	dimension	The financial status from the Source System
Orders: First Order Flag (Yes / No)	dimension	If a valid order and is the first order
Orders: Fraud Flag (Yes / No)	dimension	If the Order Status is: Fraud
Orders: Free Order Flag (Yes / No)	dimension	If the Order Status is: Free Order
Orders: Fulfillment Status	dimension	The fulfillment status from the Source System
Orders: Last Order Flag (Yes / No)	dimension	If a valid order and is the last order
Orders: Order Cancelled Date	dimension	Date the order was cancelled
Orders: Order Cancelled Day of Week	dimension	Date the order was cancelled
Orders: Order Cancelled Day of Week Index	dimension	Date the order was cancelled
Orders: Order Cancelled Month	dimension	Date the order was cancelled
Orders: Order Cancelled Month Name	dimension	Date the order was cancelled
Orders: Order Cancelled Month Num	dimension	Date the order was cancelled
Orders: Order Cancelled Quarter	dimension	Date the order was cancelled
Orders: Order Cancelled Week	dimension	Date the order was cancelled
Orders: Order Cancelled Year	dimension	Date the order was cancelled
Orders: Order Date	dimension	Date the order was processed
Orders: Order Day of Week	dimension	Date the order was processed
Orders: Order Day of Week Index	dimension	Date the order was processed
Orders: Order Month	dimension	Date the order was processed
Orders: Order Month Name	dimension	Date the order was processed
Orders: Order Month Num	dimension	Date the order was processed
Orders: Order Quarter	dimension	Date the order was processed
Orders: Order Refunded Date	dimension	The date of the first refund
Orders: Order Refunded Day of Week	dimension	The date of the first refund
Orders: Order Refunded Day of Week Index	dimension	The date of the first refund
Orders: Order Refunded Month	dimension	The date of the first refund
Orders: Order Refunded Month Name	dimension	The date of the first refund
Orders: Order Refunded Month Num	dimension	The date of the first refund
Orders: Order Refunded Quarter	dimension	The date of the first refund
Orders: Order Refunded Week	dimension	The date of the first refund
Orders: Order Refunded Year	dimension	The date of the first refund
Orders: Order Sequence Number	dimension	The sequential order number for all orders
Orders: Order Status	dimension	Possible Values: Fraud, Voided, Cancelled, Refunded, Partially Refunded, Free Order (no sales price), Full Gift Card (Entire order paid with a gift card), Partial Gift Card (Part of the order paid with a gift card), Gift Card Purchase, and Full Payment
Orders: Order Week	dimension	Date the order was processed
Orders: Order Year	dimension	Date the order was processed
Orders: Paid Shipping Flag (Yes / No)	dimension	If a valid order and the shipping_amount is greater than 0
Orders: Payment Gateway	dimension	The Payment Gateway used for the largest amount of the order if multiple Payment Gateways
Orders: Prime Order Flag (Yes / No)	dimension	If the order was flagged as a Prime Order in Amazon
Orders: Refund Flag (Yes / No)	dimension	If the Order Status is: Partially Refunded, Refunded
Orders: Subscription Order Flag (Yes / No)	dimension	If the order_tag contains 'subscription'
Orders: Time From First Purchase Day Buckets	dimension	The time in seconds of this order from the first valid order
Orders: Time From Previous Purchase Day Buckets	dimension	The time in seconds of this order from the last valid order
Orders: Transaction Source	dimension	The application in the Source System where the order originated
Orders: Transaction Type	dimension	The type of transcation
Orders: Valid Order Flag (Yes / No)	dimension	If the Order Status is one of: Full Payment, Partially Refunded, Refunded, Partial Gift Card Usage, Gift Card Usage, Partial Gift Card Purchase)
Orders: Valid Order Sequence Number	dimension	The sequential order number of a valid order
Orders: Valid Order Subscription Sequence Number	dimension	The sequential order number of a subscription order

**Product and Vendor Information: product_variants**
Filters, Dimensions and Measures	Category	Description
Product and Vendor Information: Country of Origin	dimension	Product country of origin
Product and Vendor Information: Image	dimension	URL of image in the store
Product and Vendor Information: Image Position	dimension	Position of the image on the page
Product and Vendor Information: Image URL	dimension	URL of image in the store
Product and Vendor Information: Inventory Tracked Flag (Yes / No)	dimension	Is inventory marked as tracked in source integration?
Product and Vendor Information: Listing SKU	dimension	The SKU in the store
Product and Vendor Information: Product Created Date	dimension	Calendar date that a product was created

Product and Vendor Information: Product Created Day of Week	dimension	The day of the week that a product was created

Product and Vendor Information: Product Created Day of Week Index	dimension	A number representing the day of the week that a product was created, with Monday = 0 And Sunday = 6

Product and Vendor Information: Product Created Month	dimension	The calendar month that a product was created in YYYY-MM format

Product and Vendor Information: Product Created Month Name	dimension	The calendar month name that a product was created

Product and Vendor Information: Product Created Month Num	dimension	The month number that a product was created from 1 to 12

Product and Vendor Information: Product Created Quarter	dimension	The quarter number in YYYY-Q# form

Product and Vendor Information: Product Created Week	dimension	The calendar week in YYYY-MM-DD form

Product and Vendor Information: Product Created Year	dimension	The calendar year that a product was created in YYYY form

Product and Vendor Information: Product ID	dimension	Product ID stored in the source system
Product and Vendor Information: Requires Shipping Flag (Yes / No)	dimension	Is product marked to require shipping in source integration?
Product and Vendor Information: Retail Price	dimension	Retail Price of the product in the store source integration
Product and Vendor Information: SKU	dimension	The normalized SKU across all stores
Product and Vendor Information: SKU Cost	dimension	Sku cost of the inventory item in the source integration
Product and Vendor Information: Variant ID	dimension	Variant ID stored in the source integration
Product and Vendor Information: Variant Name	dimension	Name of the product variant
Product and Vendor Information: Weight (Unit)	dimension	Weight unit of the product in the source integration
Product and Vendor Information: Weight (Value)	dimension	Weight of the product in the source integration
Product and Vendor Information: Product	measure	Count of unique products
Product and Vendor Information: Variant	measure	Count of unique product variants

Using Explores

Exploring data can be insightful and fun! Before you start your exploration, make sure to go through our Using Explores Bootcamp.

Views

View	Cardinality	Relationship	Join
inventory_levels	-	self	-
product_variants	left_outer	one_to_one	${inventory_levels.inventory_item_id} = ${product_variants.inventory_item_id}
order_line_revenue	left_outer	many_to_many	${product_variants.variant_id} = ${order_line_revenue.variant_id}
order_status	left_outer	many_to_one	${order_line_revenue.order_id} = ${order_status.order_id}