--- title: "Dashboard: Shopify Sales Report" description: The Shopify Sales Report will match the Sales Over Time report in the Shopify UI --- [Back to home](https://support.daasity.com/migrated/knowledge) - [ Welcome to Daasity ](https://support.daasity.com/migrated/knowledge/welcome-to-daasity) - [ Integration Setup | Connect Your Data Sources ](https://support.daasity.com/migrated/knowledge/welcome-to-daasity#integration-setup-connect-your-data-sources) - [ Integration Setup | Amazon Seller Central ](https://support.daasity.com/migrated/knowledge/welcome-to-daasity#integration-setup-amazon-seller-central) - [ Navigating the Daasity App ](https://support.daasity.com/migrated/knowledge/welcome-to-daasity#navigating-the-daasity-app) - [ Daasity Platform | Business User Analytics ](https://support.daasity.com/migrated/knowledge/daasity-platform-business-user-analytics) - [ Brand Supplied Data (BSD) ](https://support.daasity.com/migrated/knowledge/daasity-platform-business-user-analytics#brand-supplied-data-bsd) - [ Dashboards ](https://support.daasity.com/migrated/knowledge/daasity-platform-business-user-analytics#dashboards) - [ Reports ](https://support.daasity.com/migrated/knowledge/daasity-platform-business-user-analytics#reports) - [ Explores ](https://support.daasity.com/migrated/knowledge/daasity-platform-business-user-analytics#explores) - [ Views ](https://support.daasity.com/migrated/knowledge/daasity-platform-business-user-analytics#views) - [ Audiences ](https://support.daasity.com/migrated/knowledge/daasity-platform-business-user-analytics#audiences) - [ Customizations ](https://support.daasity.com/migrated/knowledge/daasity-platform-business-user-analytics#customizations) - [ ELT+ | Technical User Documentation ](https://support.daasity.com/migrated/knowledge/elt-technical-user-documentation) - [ Platform ](https://support.daasity.com/migrated/knowledge/elt-technical-user-documentation#platform) - [ Transformation ](https://support.daasity.com/migrated/knowledge/elt-technical-user-documentation#transformation) - [ Integrations ](https://support.daasity.com/migrated/knowledge/elt-technical-user-documentation#integrations) - [ User Manual and Support ](https://support.daasity.com/migrated/knowledge/user-manual-and-support) - [ Daasity Logic and Best Practices ](https://support.daasity.com/migrated/knowledge/user-manual-and-support#daasity-logic-and-best-practices) - [ Marketing Analytics ](https://support.daasity.com/migrated/knowledge/user-manual-and-support#marketing-analytics) - [ Customer Analytics ](https://support.daasity.com/migrated/knowledge/user-manual-and-support#customer-analytics) - [ Date Analytics ](https://support.daasity.com/migrated/knowledge/user-manual-and-support#date-analytics) - [ Inventory and Returns Analytics ](https://support.daasity.com/migrated/knowledge/user-manual-and-support#inventory-and-returns-analytics) - [ Submit a Support Request ](https://support.daasity.com/migrated/knowledge/user-manual-and-support#submit-a-support-request) - [ Release Updates ](https://support.daasity.com/migrated/knowledge/release-updates) - [ Release Updates ](https://support.daasity.com/migrated/knowledge/release-updates#release-updates) # Dashboard: Shopify Sales Report ## The Shopify Sales Report will match the Sales Over Time report in the Shopify UI ### **Key Topics** - [Dashboard Description](https://support.daasity.com/migrated/knowledge/shopify-sales-report-dashboard#description) - [Requirements](https://support.daasity.com/migrated/knowledge/shopify-sales-report-dashboard#requirements)  - [Reports](https://support.daasity.com/migrated/knowledge/shopify-sales-report-dashboard#reports) - [Related Resources](https://support.daasity.com/migrated/knowledge/shopify-sales-report-dashboard#resources) ### **Dashboard Description** The Shopify Sales Report Dashboard contains one visualization, a table that matches the numbers found in the Shopify Sales Over Time report *exactly**. * ![Shopify Sales Report Dashboards](https://support.daasity.com/hs-fs/hubfs/Knowledge%20Base/Dashboards%20Overview/Business%20Performance/Shopify%20Sales%20Report%20Dashboards.png?width=688&name=Shopify%20Sales%20Report%20Dashboards.png) **Time Dimension of Report** You’ll find the Total for the period at the bottom of the table. This dashboard is at the daily level. To change the time frame, simply edit the Filter at the top of the report.   To view a different time dimension, such as by month:  - Click the three dots in the upper right corner of the tile.  - Select **Explore from Her****e **under ‘Tile Actions’. - Replace the **T****ransaction ****D****ate** with the timeframe you would like, such as Transaction Month.  - Add a Transaction Date Filter if needed, for example, the past 12 Months.  ***DEFINITIONS OF MEASURES IN THIS VISUALIZATION:*** | **Orders**  | The number of transactions that occurred on a given date. This does not include orders that only contain giftcards.   | | --- | --- | | **Gross sales**  | Equates to **product price x quantity (before taxes, shipping, discounts, and returns)** for a collection of sales. Canceled, pending, and unpaid orders are included. Test and deleted orders are **not** included.  | | **Discounts**  | - Equates to **line item discount + order level discount share** for a collection of sales.  - The total dollar value reduction applied to a sale in the form of discounts on products, collections, or entire orders.  - Discounts that are applied to an entire order are proportionally applied to the sales for the order.  - All discounts are applied before taxes.  - Discounts are created using discount codes, not the compare at price.  | | **Returns**  | The value of goods returned by a customer.  | | **Net sales**  | Equates to **gross sales - discounts - returns**.  | | **Shipping**  | Equates to **shipping charges - shipping discounts - refunded shipping amounts**.  | | **Tax**  | The total amount of taxes based on the orders.  | | **Total sales**  | Equates to **gross sales - discounts - returns + taxes + shipping charges**.    Total sales will be a positive number for a sale on the date that an order was placed, and a negative number for a return on the date that an order was returned.  | ***DUTIES REPORTED FROM SHOPIFY*** Shopify recently changed the Sales Over Time report to include Duties.  As of 01.20.22, Daasity is actively working on ingesting this new data and adding it to our data models and reports. ***FAQs:*** **Q: What currency is the report in?**  **A:** The report is in the currency specified in the merchants Daasity account.  Note that if you have multiple Shopify stores integrated with Daasity and they display different currency values, this report will still only show data in the currency specified in your Daasity account.   **Q: What ****time-zone**** is the report in?**  **A: **The time-zone will match the time zone specified in your Daasity account ** Q: How can I look at individual orders?**  **A:** Go to Tile Actions -> Explore from here. This will open up the Shopify Sales Report explore. Here you can add in either order id (the Daasity order id), store order id (order id from Shopify) or order code (order name in Shopify).  ** Q: What if the numbers don’t match the Shopify report?**  **A:** If all measures are slightly off, the likely cause is that the Looker Shopify Sales Report is incorrectly converting time zone for your account. Other issues might include the inclusion of Duties (see above).  Please reach out to Daasity support and someone on our team will investigate and quickly roll out a fix.   ### **Requirements** The Shopify Sales Report requires that you have a Shopify integration with Daasity. ### **Reports** Shopify Sales Report ### **Related Resources**