> For the complete documentation index, see [llms.txt](https://docs.intentwise.com/iac-source-data/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.intentwise.com/iac-source-data/shopify-source-data/shopify-reports.md).

# Shopify Reports

## **Data Source**

To enable the Shopify Reports, the datasource: **Shopify** has to be enabled on the Intentwise Platform

### Acquisition Report

The Shopify Acquisition Report attributes sessions, orders, and revenue to marketing channels, evaluating how customers discover the store and which acquisition sources drive conversions.

​Table Name: **shopify\_source\_data.acquisition\_report**

<table><thead><tr><th>Column Name</th><th>Data type</th><th width="418">Description</th></tr></thead><tbody><tr><td>account_id</td><td>Date</td><td>Intentwise Account ID</td></tr><tr><td>shop_id</td><td>String</td><td>Unique identifier of the Shopify store</td></tr><tr><td>shop_name</td><td>String</td><td>Name of the Shopify store</td></tr><tr><td>shop_currency_code</td><td>String</td><td>Currency Code of the shop</td></tr><tr><td>shop_country_code</td><td>String</td><td>Country Code of the shop</td></tr><tr><td>date</td><td>Date</td><td>Date of the session or order attribution (usually order created date)</td></tr><tr><td>traffic_type</td><td>String</td><td>Type of the traffic</td></tr><tr><td>landing_page_path</td><td>String</td><td>Page Path of the landing</td></tr><tr><td>landing_page_type</td><td>String</td><td>Page Type of the landing</td></tr><tr><td>landing_page_url</td><td>String</td><td>First page the customer landed on during the session</td></tr><tr><td>session_city</td><td>String</td><td>City of the session</td></tr><tr><td>session_country</td><td>String</td><td>Country of the session</td></tr><tr><td>session_country_code</td><td>String</td><td>Country Code of the session</td></tr><tr><td>session_device_os</td><td>String</td><td>Device Os of the session</td></tr><tr><td>session_device_type</td><td>String</td><td>Device Type of the session</td></tr><tr><td>referrer_domain</td><td>String</td><td>Domain of the referrer</td></tr><tr><td>referrer_name</td><td>String</td><td>Name of the referrer</td></tr><tr><td>referrer_site</td><td>String</td><td>Site of the referrer</td></tr><tr><td>referrer_source</td><td>String</td><td>High-level traffic source (search, social, email, direct, referral)</td></tr><tr><td>referring_channel</td><td>String</td><td>Shopify-defined marketing channel (Online Store, Social, Email, Search)</td></tr><tr><td>referring_medium</td><td>String</td><td>Combined source and medium (example: google / cpc)</td></tr><tr><td>referring_platform</td><td>String</td><td>Referring Platform</td></tr><tr><td>session_device_browser</td><td>String</td><td>Device Browser of the session</td></tr><tr><td>sessions</td><td>Integer</td><td>Number of sessions attributed to this source</td></tr><tr><td>online_store_visitors</td><td>Integer</td><td>Number of unique visitors who accessed the online store during the selected time period. A visitor may have multiple sessions but is counted once.</td></tr><tr><td>sessions_with_cart_additions</td><td>Integer</td><td>Number of sessions where at least one product was added to the cart. Indicates early purchase intent and merchandising effectiveness.</td></tr><tr><td>sessions_that_reached_checkout</td><td>Integer</td><td>Number of sessions where the checkout process was initiated. Measures how many shoppers progressed beyond the cart.</td></tr><tr><td>sessions_that_completed_checkout</td><td>Integer</td><td>Number of sessions that resulted in a completed order. This is effectively the count of converting sessions.</td></tr><tr><td>sessions_that_reached_and_completed_checkout</td><td>Integer</td><td>Number of sessions where checkout was both started and completed within the same session. Highlights clean, uninterrupted purchase journeys.</td></tr><tr><td>bounces</td><td>Integer</td><td>Number of single-page sessions with no further interaction. Used to assess landing page relevance and traffic quality.</td></tr><tr><td>pageviews</td><td>Integer</td><td>Total number of pages viewed across all sessions, including repeat views of the same page. Reflects overall site engagement and browsing depth.</td></tr><tr><td>downloaded_at</td><td>Timestamp</td><td>Download DateTime</td></tr></tbody></table>

### Customers Report

The Shopify Customers Report provides customer-level insights to analyze acquisition, retention, and lifetime value by aggregating order activity across each customer.

​Table Name: **shopify\_source\_data.customers\_report**

| Column Name                      | Data type | Description                                                                                                                 |
| -------------------------------- | --------- | --------------------------------------------------------------------------------------------------------------------------- |
| account\_id                      | Integer   | Intentwise Account ID                                                                                                       |
| shop\_id                         | String    | Unique identifier of the Shopify store                                                                                      |
| shop\_name                       | String    | Name of the Shopify store                                                                                                   |
| shop\_currency\_code             | String    | Currency Code of the shop                                                                                                   |
| shop\_country\_code              | String    | Country Code of the shop                                                                                                    |
| days\_since\_last\_order         | Numeric   | Number of days since the customer’s most recent completed order. Used to measure recency and churn risk.                    |
| rfm\_group                       | String    | Customer segment based on Recency, Frequency, and Monetary value scoring. Commonly used for lifecycle and loyalty analysis. |
| customer\_id                     | String    | Unique identifier assigned by Shopify to the customer.                                                                      |
| percent\_of\_customers           | Numeric   | Percentage of total customers represented by this customer segment or group. Used in aggregated views.                      |
| total\_number\_of\_orders        | Integer   | Total number of orders placed by all customers within the selected segment or report scope.                                 |
| customer\_number\_of\_orders     | Integer   | Total number of orders placed by the individual customer.                                                                   |
| new\_customer\_records           | Integer   | Count of customers whose first-ever order occurred within the reporting period.                                             |
| predicted\_spend\_tier           | String    | Model-driven classification of expected future spend (for example low, medium, high). Used for predictive segmentation.     |
| total\_amount\_spent             | Numeric   | Total monetary value spent by the customer across all completed orders, net of refunds.                                     |
| total\_amount\_spent\_per\_order | Numeric   | Average spend per order for the customer, calculated as total\_amount\_spent divided by customer\_number\_of\_orders.       |
| customer\_first\_order\_date     | Date      | Date when the customer placed their first completed order.                                                                  |
| customer\_last\_order\_date      | Date      | Date when the customer placed their most recent completed order.                                                            |
| abandoned\_checkout\_date        | Date      | Date when the customer last abandoned a checkout without completing the purchase.                                           |
| customer\_account\_status        | String    | Current status of the customer account (enabled, disabled, or invited).                                                     |
| customer\_added\_date            | Date      | Date when the customer record was created in Shopify.                                                                       |
| customer\_tag                    | String    | Custom tag assigned to the customer for segmentation, marketing, or internal classification.                                |
| downloaded\_at                   | DateTime  | Downloaded Date                                                                                                             |

### Locations

The Shopify Locations Report provides **location-level operational visibility** across warehouses, retail stores, fulfillment centers, and custom locations. It is used to track where inventory is stored, fulfilled, and managed.

​Table Name: **shopify\_source\_data.locations**

| Column Name          | Data type | Description                                                                      |
| -------------------- | --------- | -------------------------------------------------------------------------------- |
| account\_id          | Integer   | Intentwise Account ID                                                            |
| shop\_id             | String    | Unique identifier of the Shopify store                                           |
| shop\_name           | String    | Name of the Shopify store                                                        |
| shop\_currency\_code | String    | Currency Code of the shop                                                        |
| shop\_country\_code  | String    | Country Code of the shop                                                         |
| location\_id         | String    | Unique identifier assigned by Shopify to the location.                           |
| name                 | String    | Name of the location as defined in Shopify, such as a warehouse or retail store. |
| is\_active           | Boolean   | Indicates whether the location is currently active and available for use.        |
| is\_primary          | Boolean   | Indicates whether this location is set as the primary location for the store.    |
| address1             | String    | Primary street address of the location.                                          |
| address2             | String    | Secondary address information such as apartment, suite, or unit number.          |
| city                 | String    | City where the location is physically located.                                   |
| province             | String    | State or province of the location.                                               |
| country              | String    | Country where the location is located.                                           |
| zip                  | String    | Postal or ZIP code of the location.                                              |
| created\_at          | DateTime  | Timestamp when the location was created in Shopify.                              |
| updated\_at          | DateTime  | Timestamp when the location details were last updated.                           |
| deactivated\_at      | DateTime  | Timestamp when the location was deactivated. Null if the location is active.     |
| address\_verified    | Boolean   | Indicates whether the location address has been verified by Shopify.             |
| downloaded\_at       | DateTime  | Downloaded Date                                                                  |

### Outstanding Gift Card Balance

The Outstanding Gift Card Balance Report tracks the **remaining unused value of issued gift cards**. It represents a **financial liability** for the store, since the value may be redeemed for future purchases.

​Table Name: **shopify\_source\_data.outstanding\_gift\_card\_balance**

| Column Name                      | Data type | Description                                                                                                                             |
| -------------------------------- | --------- | --------------------------------------------------------------------------------------------------------------------------------------- |
| account\_id                      | Integer   | Intentwise Account ID                                                                                                                   |
| shop\_id                         | String    | Unique identifier of the Shopify store                                                                                                  |
| shop\_name                       | String    | Name of the Shopify store                                                                                                               |
| shop\_currency\_code             | String    | Currency Code of the shop                                                                                                               |
| shop\_country\_code              | String    | Country Code of the shop                                                                                                                |
| date                             | Date      | Reporting date for the gift card balance snapshot.                                                                                      |
| starting\_gift\_card\_balance    | Numeric   | Outstanding gift card balance at the beginning of the reporting date.                                                                   |
| issued\_gift\_card\_balance      | Numeric   | Total value of new gift cards issued during the reporting date.                                                                         |
| disabled\_gift\_card\_value      | Numeric   | Total value of gift cards disabled during the reporting date.                                                                           |
| redeemed\_gift\_card\_value      | Numeric   | Total value of gift cards redeemed toward purchases during the reporting date.                                                          |
| refunded\_gift\_card\_value      | Numeric   | Total value of gift card balance refunded back to customers during the reporting date.                                                  |
| ending\_gift\_card\_balance      | Numeric   | Outstanding gift card balance at the end of the reporting date.                                                                         |
| gift\_card\_balance\_net\_change | Numeric   | Net change in outstanding gift card balance for the reporting date, calculated as issued minus redeemed, refunded, and disabled values. |
| downloaded\_at                   | DateTime  | Downloaded Date                                                                                                                         |

### Payments

This Payments Report summarizes payment transaction volumes and values by date, gateway, method, and transaction type to support payment analysis and reconciliation.

​Table Name: **shopify\_source\_data.payments**

| Column Name          | Data type | Description                                                                                         |
| -------------------- | --------- | --------------------------------------------------------------------------------------------------- |
| account\_id          | Integer   | Intentwise Account ID                                                                               |
| shop\_id             | String    | Unique identifier of the Shopify store                                                              |
| shop\_name           | String    | Name of the Shopify store                                                                           |
| shop\_currency\_code | String    | Currency Code of the shop                                                                           |
| shop\_country\_code  | String    | Country Code of the shop                                                                            |
| date                 | Date      | Reporting date for the payment transactions.                                                        |
| payment\_gateway     | String    | Payment gateway that processed the transaction.                                                     |
| payment\_method      | String    | Payment method used, such as credit card, PayPal, Shopify Payments, or gift card.                   |
| transaction\_kind    | String    | Type of payment transaction, such as authorization, capture, sale, refund, or void.                 |
| transactions         | Integer   | Number of payment transactions processed for the given date, gateway, method, and transaction type. |
| gross\_payments      | Numeric   | Total value of successful payment transactions before refunds for the given grouping.               |
| refunded\_payments   | Numeric   | Total value of payments refunded during the reporting period.                                       |
| net\_payments        | Numeric   | Net payment amount after refunds, calculated as gross payments minus refunded payments.             |
| downloaded\_at       | DateTime  | Downloaded Date                                                                                     |

### Product Variants

The Product Variants Report provides variant-level catalog and inventory details to support merchandising, pricing, and operational decision-making.

​Table Name: **shopify\_source\_data.product\_variants**

| Column Name          | Data type | Description                                                                                                                         |
| -------------------- | --------- | ----------------------------------------------------------------------------------------------------------------------------------- |
| account\_id          | Integer   | Intentwise Account ID                                                                                                               |
| shop\_id             | String    | Unique identifier of the Shopify store                                                                                              |
| shop\_name           | String    | Name of the Shopify store                                                                                                           |
| shop\_currency\_code | String    | Currency Code of the shop                                                                                                           |
| shop\_country\_code  | String    | Country Code of the shop                                                                                                            |
| variant\_id          | String    | Unique identifier assigned by Shopify to the product variant.                                                                       |
| product\_id          | String    | Identifier of the parent product to which the variant belongs                                                                       |
| title                | String    | Variant title, typically representing option values such as size or color                                                           |
| sku                  | String    | Stock keeping unit defined by the merchant for the variant.                                                                         |
| price                | Numeric   | Selling price of the variant before discounts and taxes.                                                                            |
| inventory\_quantity  | Integer   | Current available inventory quantity for the variant across all locations or the default location, depending on inventory settings. |
| available\_for\_sale | Boolean   | Indicates whether the variant is currently available for purchase.                                                                  |
| barcode              | String    | Barcode associated with the variant, such as UPC, EAN, or ISBN.                                                                     |
| created\_at          | DateTime  | Timestamp when the variant was created in Shopify.                                                                                  |
| display\_name        | String    | Customer-facing name of the variant, usually a combination of product title and variant options.                                    |
| updated\_at          | DateTime  | Timestamp when the variant details were last updated.                                                                               |
| image\_url           | String    | URL of the image associated with the variant, if available.                                                                         |
| downloaded\_at       | DateTime  | Downloaded Date                                                                                                                     |

### Products

The Products Report provides product-level catalog details to support merchandising, organization, and high-level product analysis.

​Table Name: **shopify\_source\_data.products**

| Column Name          | Data type | Description                                                                                                                                 |
| -------------------- | --------- | ------------------------------------------------------------------------------------------------------------------------------------------- |
| account\_id          | Integer   | Intentwise Account ID                                                                                                                       |
| shop\_id             | String    | Unique identifier of the Shopify store                                                                                                      |
| shop\_name           | String    | Name of the Shopify store                                                                                                                   |
| shop\_currency\_code | String    | Currency Code of the shop                                                                                                                   |
| shop\_country\_code  | String    | Country Code of the shop                                                                                                                    |
| product\_id          | String    | Unique identifier for the product in your Shopify store. Useful for referencing products in API calls or integrations.                      |
| title                | String    | Name of the product as displayed in your store.                                                                                             |
| vendor               | String    | The supplier or manufacturer of the product. Often used for filtering or categorizing products.                                             |
| product\_type        | String    | A classification you assign to the product, such as “Shirt,” “Accessory,” or “Electronics.” Helps with organization and reporting.          |
| status               | String    | Current publishing status of the product. Common values: active (visible in store), draft (not published), archived (removed from catalog). |
| category             | String    | Optional hierarchical or custom grouping of products. Can help with filtering in reports or storefront collections                          |
| total\_inventory     | Integer   | Total number of units available across all locations. Important for stock management and reporting.                                         |
| description          | String    | Full product description as shown on the product page                                                                                       |
| online\_store\_url   | String    | Direct link to the product page on your online store                                                                                        |
| created\_at          | DateTime  | Timestamp when the product was first created in Shopify                                                                                     |
| updated\_at          | DateTime  | Timestamp of the last update made to the product                                                                                            |
| published\_at        | DateTime  | Timestamp when the product was made visible on the online store. null if never published.                                                   |
| tags                 | String    | Comma-separated list of labels applied to the product for categorization, filtering, or marketing purposes.                                 |
| downloaded\_at       | DateTime  | Downloaded Date                                                                                                                             |

### Profit Report

Shows revenue, costs, and profit for each product or order, helping you track profitability and margins across your store.

​Table Name: **shopify\_source\_data.profit\_report**

| Column Name                 | Data type | Description                                                      |
| --------------------------- | --------- | ---------------------------------------------------------------- |
| account\_id                 | Integer   | Intentwise Account ID                                            |
| shop\_id                    | String    | Unique identifier of the Shopify store                           |
| shop\_name                  | String    | Name of the Shopify store                                        |
| shop\_currency\_code        | String    | Currency Code of the shop                                        |
| shop\_country\_code         | String    | Country Code of the shop                                         |
| date                        | Date      | Date the sale occurred.                                          |
| sale\_id                    | String    | Unique identifier for the sale transaction.                      |
| order\_id                   | String    | Unique ID of the order containing the sale.                      |
| order\_name                 | String    | Human-readable order identifier                                  |
| customer\_id                | String    | Unique identifier for the customer who made the purchase.        |
| product\_id                 | String    | Unique ID of the product sold.                                   |
| product\_variant\_id        | String    | Unique ID of the specific product variant sold.                  |
| pos\_location\_id           | String    | Identifier for the physical location or POS used for the sale.   |
| cost\_of\_goods\_sold       | Numeric   | The cost of the product sold (COGS).                             |
| gross\_profit               | Numeric   | Revenue minus the cost of goods sold, before discounts and fees. |
| net\_items\_sold            | Integer   | Total number of items sold after returns are accounted for.      |
| quantity\_ordered           | Integer   | Number of units ordered in the sale.                             |
| quantity\_returned          | Integer   | Number of units returned by the customer.                        |
| discounts                   | Numeric   | Total discounts applied to this sale.                            |
| discounts\_returned         | Numeric   | Discounts refunded when items are returned.                      |
| order\_level\_discounts     | Numeric   | Discounts applied to the entire order                            |
| line\_item\_discounts       | Numeric   | Discounts applied specifically to individual products.           |
| shipping\_charges           | Numeric   | Total shipping fees collected.                                   |
| shipping\_charge\_discounts | Numeric   | Discounts applied to shipping fees.                              |
| shipping\_charge\_taxes     | Numeric   | Taxes applied to shipping fees.                                  |
| shipping\_returned          | Numeric   | Shipping fees refunded when items are returned.                  |
| total\_shipping\_charges    | Numeric   | Net shipping revenue after discounts, taxes, and returns.        |
| return\_fees                | Numeric   | Fees charged for processing returns.                             |
| gift\_card\_gross\_sales    | Numeric   | Total value of gift cards sold before any adjustments.           |
| gift\_card\_net\_sales      | Numeric   | Net revenue from gift card sales after discounts/returns.        |
| gift\_card\_discounts       | Numeric   | Discounts applied to gift card sales.                            |
| gift\_card\_taxes           | Numeric   | Taxes collected on gift card sales.                              |
| downloaded\_at              | DateTime  | Downloaded Date                                                  |

### Sales

Summarizes all sales transactions, including orders, products, discounts, shipping, returns, and gift card activity, helping you track revenue and sales performance over time

​Table Name: **shopify\_source\_data.sales**

<table><thead><tr><th width="202">Column Name</th><th>Data type</th><th>Description</th></tr></thead><tbody><tr><td>account_id</td><td>Integer</td><td>Intentwise Account ID</td></tr><tr><td>shop_id</td><td>String</td><td>Unique identifier of the Shopify store</td></tr><tr><td>shop_name</td><td>String</td><td>Name of the Shopify store</td></tr><tr><td>shop_currency_code</td><td>String</td><td>Currency Code of the shop</td></tr><tr><td>shop_country_code</td><td>String</td><td>Country Code of the shop</td></tr><tr><td>date</td><td>Date </td><td>date and time when the sale transaction occurred.</td></tr><tr><td>sale_id</td><td>String</td><td>A unique identifier for the specific transaction</td></tr><tr><td>order_id</td><td>String</td><td>The internal Shopify numerical ID for the entire order.</td></tr><tr><td>order_name</td><td>String</td><td>The customer-facing order number</td></tr><tr><td>customer_id</td><td>String</td><td>A unique identifier for the customer who placed the order, useful for tracking repeat buyers.</td></tr><tr><td>product_id</td><td>String</td><td>The unique ID for the specific product sold.</td></tr><tr><td>product_variant_id</td><td>String</td><td>The ID for the specific version of a product</td></tr><tr><td>pos_location_id</td><td>String</td><td>The ID of the physical retail location if the sale was made through Shopify POS; blank for online orders.</td></tr><tr><td>gross_sales</td><td>Numeric</td><td>The total price of the items at the time of sale (Price × Quantity) before any deductions.</td></tr><tr><td>discounts</td><td>Numeric</td><td>The total value of coupons or automatic discounts applied to the items.</td></tr><tr><td>returns</td><td>Numeric</td><td>The value of items that were returned by the customer.</td></tr><tr><td>net_sales</td><td>Numeric</td><td>Calculated as Gross Sales - Discounts - Returns. This represents the actual sales revenue generated.</td></tr><tr><td>shipping_charges</td><td>Numeric</td><td>The amount paid by the customer for shipping.</td></tr><tr><td>return_fees</td><td>Numeric</td><td>Fees charged to the customer for processing a return (e.g., restocking fees).</td></tr><tr><td>taxes</td><td>Numeric</td><td>The total amount of sales tax collected on the order.</td></tr><tr><td>total_sales</td><td>Numeric</td><td>Calculated as Net Sales + Shipping + Taxes. This is the total amount of money moving into your account for that transaction.</td></tr><tr><td>net_sales_without_cost_recorded</td><td>Numeric</td><td>The portion of Net Sales where no "Cost per item" was entered in Shopify at the time of sale.</td></tr><tr><td>net_sales_with_cost_recorded</td><td>Numeric</td><td>The portion of Net Sales for which you did have a "Cost per item" recorded.</td></tr><tr><td>cost_of_goods_sold</td><td>Numeric</td><td>The total cost to you for the products sold (Price you paid to the supplier).</td></tr><tr><td>gross_profit</td><td>Numeric</td><td>Calculated as Net Sales - COGS. This shows the actual money made after product costs but before overhead.</td></tr><tr><td>gift_card_gross_sales</td><td>Numeric</td><td>The value of gift cards sold (Note: Shopify usually treats gift card sales as a liability until they are redeemed).</td></tr><tr><td>net_items_sold</td><td>Integer</td><td>The total quantity of items sold minus the quantity of items returned.</td></tr><tr><td>gift_card_discounts</td><td>Numeric</td><td>Any discounts applied specifically to the purchase of a gift card.</td></tr><tr><td>gift_card_net_sales</td><td>Numeric</td><td>The final revenue from gift card sales (Gross - Discounts).</td></tr><tr><td>downloaded_at</td><td>DateTime</td><td>Downloaded Date</td></tr></tbody></table>

### Sales Report

Summarizes comprehensive financial record that tracks how much money your store is making, where that money is coming from (marketing channels), and how much of it remains after discounts, returns, and costs.

​Table Name: **shopify\_source\_data.**&#x73;ales\_report

<table><thead><tr><th width="202">Column Name</th><th>Data type</th><th>Description</th></tr></thead><tbody><tr><td>account_id</td><td>Integer</td><td>Intentwise Account ID</td></tr><tr><td>shop_id</td><td>String</td><td>Unique identifier of the Shopify store</td></tr><tr><td>shop_name</td><td>String</td><td>Name of the Shopify store</td></tr><tr><td>shop_currency_code</td><td>String</td><td>Currency Code of the shop</td></tr><tr><td>shop_country_code</td><td>String</td><td>Country Code of the shop</td></tr><tr><td>date</td><td>Date </td><td>date and time when the sale transaction occurred.</td></tr><tr><td>sale_id</td><td>String</td><td>A unique identifier for the specific transaction</td></tr><tr><td>order_id</td><td>String</td><td>The internal Shopify numerical ID for the entire order.</td></tr><tr><td>order_name</td><td>String</td><td>The customer-facing order number</td></tr><tr><td>customer_id</td><td>String</td><td>A unique identifier for the customer who placed the order, useful for tracking repeat buyers.</td></tr><tr><td>product_id</td><td>String</td><td>The unique ID for the specific product sold.</td></tr><tr><td>product_variant_id</td><td>String</td><td>The ID for the specific version of a product</td></tr><tr><td>pos_location_id</td><td>String</td><td>The ID of the physical retail location if the sale was made through Shopify POS; blank for online orders.</td></tr><tr><td>referring_channel</td><td>String</td><td>The broad source that sent the customer to your store</td></tr><tr><td>referring_medium</td><td>String</td><td>The specific marketing method used</td></tr><tr><td>new_or_returning_customer</td><td>String</td><td>Identifies if this was the customer's first purchase or a repeat visit.</td></tr><tr><td>orders</td><td>Integer</td><td>The count of unique orders placed within the specified timeframe.</td></tr><tr><td>total_sales</td><td>Numeric</td><td>Net Sales + Shipping + Taxes + Tips</td></tr><tr><td>gross_sales</td><td>Numeric</td><td>Product Price × Quantity</td></tr><tr><td>net_sales</td><td>Numeric</td><td>Gross Sales - Discounts - Returns</td></tr><tr><td>net_sales_with_cost_recorded</td><td>Numeric</td><td>The portion of Net Sales for which you did have a "Cost per item" recorded.</td></tr><tr><td>net_sales_without_cost_recorded</td><td>Numeric</td><td>The portion of Net Sales where no "Cost per item" was entered in Shopify at the time of sale.</td></tr><tr><td>gross_returns</td><td>Numeric</td><td>represent the total value of products returned before adjusting for taxes or shipping.</td></tr><tr><td>total_returns</td><td>Numeric</td><td>represent the total value of products returned before adjusting for taxes or shipping.</td></tr><tr><td>net_returns</td><td>Numeric</td><td>The actual value refunded to customers after subtracting any return fees.</td></tr><tr><td>returns</td><td>Numeric</td><td>Value of items sent back</td></tr><tr><td>net_items_sold</td><td>Integer</td><td>The total quantity of items sold minus the quantity of items returned.</td></tr><tr><td>quantity_ordered</td><td>Integer</td><td>The total number of units sold.</td></tr><tr><td>quantity_ordered_per_order</td><td>Numeric</td><td>The average number of items found in a single order</td></tr><tr><td>quantity_returned</td><td>Integer</td><td>The number of units sent back by customers.</td></tr><tr><td>discounts</td><td>Numeric</td><td>Discounts applied</td></tr><tr><td>discounts_returned</td><td>Numeric</td><td>The portion of a discount that was "reversed" because the item it was applied to was returned.</td></tr><tr><td>order_level_discounts</td><td>Numeric</td><td>Discounts applied to the entire cart</td></tr><tr><td>line_item_discounts</td><td>Numeric</td><td>Discounts applied to a specific product</td></tr><tr><td>shipping_charges</td><td>Numeric</td><td>The amount paid by the customer for shipping.</td></tr><tr><td>total_shipping_charges</td><td>Numeric</td><td>The final amount the customer paid for shipping.</td></tr><tr><td>shipping_charge_discounts</td><td>Numeric</td><td>Any "Free Shipping" coupons or discounts applied to the delivery cost.</td></tr><tr><td>shipping_charge_taxes</td><td>Numeric</td><td>Sales tax specifically calculated on the shipping fee.</td></tr><tr><td>shipping_returned</td><td>Numeric</td><td>The amount of the shipping fee refunded to the customer during a return.</td></tr><tr><td>return_fees</td><td>Numeric</td><td>Fees charged to the customer for processing a return</td></tr><tr><td>duties</td><td>Numeric</td><td>International customs duties collected for cross-border sales.</td></tr><tr><td>taxes</td><td>Numeric</td><td>The total amount of sales tax collected on the order.</td></tr><tr><td>taxes_excluding_gift_cards</td><td>Numeric</td><td>Tax collected only on physical or digital products, excluding the purchase of gift cards.</td></tr><tr><td>taxes_returned</td><td>Numeric</td><td>The amount of sales tax refunded to the customer.</td></tr><tr><td>tips</td><td>Numeric</td><td>Any voluntary gratuities added by the customer at checkout (common for POS or certain services).</td></tr><tr><td>bundles_ordered</td><td>Integer</td><td>The number of "product bundles" sold (groups of items sold as a single unit).</td></tr><tr><td>cost_of_goods_sold</td><td>Numeric</td><td>The total cost to you for the products sold (Price you paid to the supplier).</td></tr><tr><td>gross_profit</td><td>Numeric</td><td>This is your Net Sales minus your Cost of Goods Sold (COGS)</td></tr><tr><td>gift_card_gross_sales</td><td>Numeric</td><td>The value of gift cards sold (Note: Shopify usually treats gift card sales as a liability until they are redeemed).</td></tr><tr><td>gift_card_net_sales</td><td>Numeric</td><td>The final revenue from gift card sales (Gross - Discounts)</td></tr><tr><td>gift_card_discounts</td><td>Numeric</td><td>Any discounts applied specifically to the purchase of a gift card.</td></tr><tr><td>gift_card_taxes</td><td>Numeric</td><td>specific amount of sales tax applied to the purchase of a gift card.</td></tr><tr><td>downloaded_at</td><td>DateTime</td><td>Downloaded Date</td></tr></tbody></table>

### Taxes Summary

Taxes Summary is a consolidated report that breaks down the total tax collected into its specific components based on the customer's location and local laws.

​Table Name: **shopify\_source\_data.**&#x74;axes\_summary

| Column Name          | Data type | Description                                                                                                                                                                                                                                                                                                                                                                          |
| -------------------- | --------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| account\_id          | Integer   | Intentwise Account ID                                                                                                                                                                                                                                                                                                                                                                |
| shop\_id             | String    | Unique identifier of the Shopify store                                                                                                                                                                                                                                                                                                                                               |
| shop\_name           | String    | Name of the Shopify store                                                                                                                                                                                                                                                                                                                                                            |
| shop\_currency\_code | String    | Currency Code of the shop                                                                                                                                                                                                                                                                                                                                                            |
| shop\_country\_code  | String    | Country Code of the shop                                                                                                                                                                                                                                                                                                                                                             |
| date                 | Date      | date and time when the sale transaction occurred.                                                                                                                                                                                                                                                                                                                                    |
| sales\_channel       | String    | The platform where the order was placed (e.g., Online Store, Shop, Facebook, or POS).                                                                                                                                                                                                                                                                                                |
| tax\_country         | String    | The country where the tax was applied, determined by the customer's shipping address.                                                                                                                                                                                                                                                                                                |
| tax\_region          | String    | The specific state, province, or territory within that country (e.g., California or Ontario).                                                                                                                                                                                                                                                                                        |
| tax\_name            | String    | The specific label of the tax collected, such as State Tax, County Tax, VAT, or GST.                                                                                                                                                                                                                                                                                                 |
| filed\_by\_channel   | String    | This is a critical tracking column that identifies if a marketplace is handling your taxes: Marked as "Filed": A marketplace channel (like Facebook or Meta) has collected and will remit the tax on your behalf. You do not need to file this amount yourself. Blank/Empty: You are the "seller of record" and are responsible for filing and remitting this tax to the government. |
| sales\_taxes         | Numeric   | The total amount of sales tax collected for that specific line item or order.                                                                                                                                                                                                                                                                                                        |
| downloaded\_at       | DateTime  | Downloaded Date                                                                                                                                                                                                                                                                                                                                                                      |


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.intentwise.com/iac-source-data/shopify-source-data/shopify-reports.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.