This article will be broken into 2 sections:

1. Shopify Data Validation using Canned/Pre-Buildt reports.
2. Shopify Data Validation using Custom Reports (Database Queries)

Please go the section that applies to your needs:

1. Shopify Data Validation Using Canned/Pre-Buildt Reports

Sales and Markdowns('Discounts'):

• Log into the Shopify 
• Choose customer
• Adjust the date range to the appropriate timeframe
• Proceed to Analytics> Reports> POS total sales by product type

• Scroll down and on the right hand side click the garbage can on the following two filters: "Is POS sale" and "Product Type [is not] [None]". This will show all sales for all locations and product types. 

• Export at the top right. If there are sales for product types with no location, you may need to sum together with the same product type for a specific location. This is client specific.

2. Shopify Data Validation using Custom Reports (Database Queries)

Here are two queries that can be used for validation within Shopify Reports.

Simply go to Analytics>Reports in Shopify.

Click 'New Exploration' button in the top right.

This will open a blank report for you to edit. Click in the top section and paste one of the following queries [ensure to edit the date fields to match what you are validating]

Sales and Markdowns

FROM sales
  SHOW discounts, net_sales
  WHERE line_type = 'product'
  GROUP BY pos_location_name, product_type WITH TOTALS
  SINCE 2026-01-01 UNTIL 2026-01-31

Inventory (including Historical)

FROM inventory_by_location
SHOW ending_inventory_retail_value_at_location
WHERE day = 2026-01-31
GROUP BY inventory_location_id, product_type WITH GROUP_TOTALS, TOTALS

The Inventory Location Id used in Retail Orbit can be found on the POS Mapping Page