--- title: "Retail | What's New: New Columns and Calculation Changes" description: Learn about the Nov 2026 BLAZE Retail (US) data export updates, including new loyalty and Stronghold columns, COGS calculation fixes, and the Insights menu move. --- [Skip to content](https://support.blaze.me/hc/en-us/articles/data-exports-whats-new-new-columns-and-calculation-changes#main-content) [![BLAZE-Logo-Blue (2)](https://support.blaze.me/hs-fs/hubfs/BLAZE-Logo-Blue%20(2).png?width=140&height=37&name=BLAZE-Logo-Blue%20(2).png)](https://support.blaze.me?hsLang=en) - [BLAZE US Knowledge Base](https://support.blaze.me/hc/en-us/articles) Open main navigation Close main navigation - [BLAZE US Knowledge Base](https://support.blaze.me/hc/en-us/articles) Welcome to the Blaze US Knowledge Base! Find helpful reference by searching here... - There are no suggestions because the search field is empty. 1. [BLAZE US Knowledge Center](https://support.blaze.me/hc/en-us/articles?hsLang=en) 2. [BLAZE Retail](https://support.blaze.me/hc/en-us/articles/blaze-retail?hsLang=en) 3. [Reporting](https://support.blaze.me/hc/en-us/articles/blaze-retail?hsLang=en#reporting) # Retail | What's New: New Columns and Calculation Changes ## As of November 11, 2026, five BLAZE Retail (US) data exports run on our new data warehouse: Total Sales Detail (TSDR), Total Sales (TSR), Cash Drawer Sessions, Sales Payments, and New Members. While your overall sales, taxes, and payment totals remain the same, some reports have moved to a new location, several have new columns, and a few fields are calculated or displayed differently. This guide covers each update so you know what to expect when comparing a new export with an older one. ### Where to Find Your Reports Migrated reports are moving from the legacy **Data Export** section to **Insights \> Data Export**. The updated page features two main tabs: - **Data Exports:** Choose a report, set your filters, and run the export. - **Export Logs:** View exports you have run and download completed files. ![](https://support.blaze.me/hs-fs/hubfs/image-png-Nov-13-2026-04-36-22-2061-AM.png?width=1911&height=934&name=image-png-Nov-13-2026-04-36-22-2061-AM.png) To run an export: 1. Log in to **BLAZE Retail** and open **Insights** from the left navigation menu. 2. Select **Data Export**. 3. On the **Data Exports** tab, choose your desired report and set your date range. 4. Run the export, then navigate to the **Export Logs** tab to download the file once it is ready. --- ### New Columns Four new columns have been added to provide greater granularity. Each column either breaks out data previously grouped under another metric or introduces new detail: | **Column** | **Report(s)** | **What It Shows** | | --- | --- | --- | | **Loyalty Reward** | TSDR, TSR | Rewards redeemed through AlpineIQ or BLAZE Growth (previously included in the **Promotions** column). | | **Loyalty Points Redeemed** | TSDR, TSR | The total number of loyalty points redeemed by the customer. | | **Loyalty Dollar Amount Redeemed** | TSDR, TSR | The dollar value paid using Pay with Points. | | **Stronghold Tips** | Cash Drawer Sessions | Tips collected through Stronghold. |   **NOTE:** Because loyalty rewards now have their own dedicated column, your **Promotions** total may appear lower than in older exports. Your overall discount amount has not changed—it is simply split across more columns. --- ### Calculation and Display Changes If you compare a new **TSDR** or **TSR** export with one generated prior to the migration, you may notice the following differences in how specific fields are calculated or formatted: | **Field** | **Report(s)** | **Before Migration** | **Now** | | --- | --- | --- | --- | | **COGS and Gross Margin** | TSDR, TSR | Past sales recalculated whenever a batch cost was edited. | Uses the batch cost at the time of sale, ensuring historical sales no longer change if a cost is edited later. | | **Product, Vendor, Member, and Employee Names** | TSDR, TSR | Could display the name as it was recorded at the time of sale. | Displays the current name. If a product or vendor is renamed, older sales will reflect the new name. | | **Category and Sub Category** | TSDR, TSR | A category without a parent appeared under **Category**, leaving **Sub Category** blank. | **Category** displays the parent category and **Sub Category** displays the category. A category without a parent displays `N/A` under **Category** and its name under **Sub Category**. | | **Prepared Date** | TSR | Displayed date only (with time defaulted to `00:00`). | Displays both the exact date and time. | | **THC % and CBD %** | TSDR | Displayed `0` when the batch had no potency entered. | Defaults to the product's potency if the batch has no potency entered. | | **Batch Receive Date** | TSDR, TSR | Displayed `1969-12-31` when no receive date was recorded. | Uses the batch creation date when no receive date was recorded. | **TIP:** If you filter or build pivot tables using the **Category** column, check for categories without a parent—they will now be grouped under `N/A`. --- ### What Hasn't Changed - **Sales Payments and New Members:** No changes. These exports contain the exact same columns and values as before. - **Cash Drawer Sessions:** All existing values remain unchanged; the only addition is the new **Stronghold Tips** column. - **TSDR and TSR Totals:** Overall sales, taxes, and payment totals remain identical. --- ### Frequently Asked Questions (FAQ) **My COGS for last month changed compared with an export I ran earlier. Is something wrong?** No. Older exports dynamically recalculated past sales whenever a batch cost was edited. The new exports lock in the batch cost at the time of sale, giving you a more accurate historical margin. **Why is my Promotions total lower than before?** Loyalty rewards redeemed through AlpineIQ or BLAZE Growth are now separated into the **Loyalty Reward** column rather than being grouped under **Promotions**. **Why do I see `N/A` in the Category column?** That product's category does not have a parent category assigned. Its category name now appears in the **Sub Category** column instead. **I can't find a report in the old Data Export menu. Where did it go?** Migrated reports have moved to **Insights \> Data Export**. If you still cannot locate the report there, please reach out to our support team. --- ### Still Have Questions? If you need further assistance with your reports, reach out to our support team at **support@blaze.me**. - [BLAZE Retail](https://support.blaze.me/hc/en-us/articles/blaze-retail?hsLang=en#main-content) - [FAQs](https://support.blaze.me/hc/en-us/articles/blaze-retail?hsLang=en#faqs) - [Ecommerce](https://support.blaze.me/hc/en-us/articles/blaze-retail?hsLang=en#ecommerce) - [Transactions](https://support.blaze.me/hc/en-us/articles/blaze-retail?hsLang=en#transactions) - [Loyalty / Marketing](https://support.blaze.me/hc/en-us/articles/blaze-retail?hsLang=en#loyalty-marketing) - [Members](https://support.blaze.me/hc/en-us/articles/blaze-retail?hsLang=en#members) - [Integrations](https://support.blaze.me/hc/en-us/articles/blaze-retail?hsLang=en#integrations) - [Reporting](https://support.blaze.me/hc/en-us/articles/blaze-retail?hsLang=en#reporting) - [Metrc](https://support.blaze.me/hc/en-us/articles/blaze-retail?hsLang=en#metrc) - [Delivery & Dispatch](https://support.blaze.me/hc/en-us/articles/blaze-retail?hsLang=en#delivery-dispatch) - [Getting Started](https://support.blaze.me/hc/en-us/articles/blaze-retail?hsLang=en#getting-started) - [BioTrack](https://support.blaze.me/hc/en-us/articles/blaze-retail?hsLang=en#biotrack) - [Promotions](https://support.blaze.me/hc/en-us/articles/blaze-retail?hsLang=en#promotions) - [Point of Sale (POS)](https://support.blaze.me/hc/en-us/articles/blaze-retail?hsLang=en#point-of-sale-pos) - [Purchase Orders](https://support.blaze.me/hc/en-us/articles/blaze-retail?hsLang=en#purchase-orders) - [Insights](https://support.blaze.me/hc/en-us/articles/blaze-retail?hsLang=en#insights) - [BLAZEPAY](https://support.blaze.me/hc/en-us/articles/blaze-retail?hsLang=en#blazepay) - [Compliance & Taxes](https://support.blaze.me/hc/en-us/articles/blaze-retail?hsLang=en#compliance-taxes) - [Inventory Management](https://support.blaze.me/hc/en-us/articles/blaze-retail?hsLang=en#inventory-management) - [Hardware & Labels](https://support.blaze.me/hc/en-us/articles/blaze-retail?hsLang=en#hardware-labels) - [Web POS App](https://support.blaze.me/hc/en-us/articles/blaze-retail?hsLang=en#web-pos-app) - [State Limits](https://support.blaze.me/hc/en-us/articles/blaze-retail?hsLang=en#state-limits) - [New Mexico S2S](https://support.blaze.me/hc/en-us/articles/blaze-retail?hsLang=en#new-mexico-s2s) - [Member Merge](https://support.blaze.me/hc/en-us/articles/blaze-retail?hsLang=en#member-merge) - [BLAZE ECOM](https://support.blaze.me/hc/en-us/articles/blaze-ecom?hsLang=en#main-content) - [ECOM Mission Control](https://support.blaze.me/hc/en-us/articles/blaze-ecom?hsLang=en#ecom-mission-control) - [Ecommerce](https://support.blaze.me/hc/en-us/articles/blaze-ecom?hsLang=en#ecommerce) - [Onboarding](https://support.blaze.me/hc/en-us/articles/blaze-ecom?hsLang=en#onboarding) - [Website Content](https://support.blaze.me/hc/en-us/articles/blaze-ecom?hsLang=en#website-content) - [Mobile Apps](https://support.blaze.me/hc/en-us/articles/blaze-ecom?hsLang=en#mobile-apps) - [SEO](https://support.blaze.me/hc/en-us/articles/blaze-ecom?hsLang=en#seo) - [General](https://support.blaze.me/hc/en-us/articles/blaze-ecom?hsLang=en#general) - [Promotions, Discounts & Rewards](https://support.blaze.me/hc/en-us/articles/blaze-ecom?hsLang=en#promotions-discounts-rewards) - [Integrations](https://support.blaze.me/hc/en-us/articles/blaze-ecom?hsLang=en#integrations) - [WordPress](https://support.blaze.me/hc/en-us/articles/blaze-ecom?hsLang=en#wordpress) - [Order Notifications](https://support.blaze.me/hc/en-us/articles/blaze-ecom?hsLang=en#order-notifications) - [Online Store Configuration](https://support.blaze.me/hc/en-us/articles/blaze-ecom?hsLang=en#online-store-configuration) - [Customization](https://support.blaze.me/hc/en-us/articles/blaze-ecom?hsLang=en#customization) - [BLAZEPAY](https://support.blaze.me/hc/en-us/articles/blazepay?hsLang=en#main-content) - [Cashless ATM](https://support.blaze.me/hc/en-us/articles/blazepay?hsLang=en#cashless-atm) - [BLAZE Growth](https://support.blaze.me/hc/en-us/articles/blaze-growth?hsLang=en) - [Ecommerce](https://support.blaze.me/hc/en-us/articles/ecommerce?hsLang=en#main-content) - [Online Store Configuration](https://support.blaze.me/hc/en-us/articles/ecommerce?hsLang=en#online-store-configuration) - [Mobile Apps](https://support.blaze.me/hc/en-us/articles/mobile-apps?hsLang=en#main-content) - [Go To Market](https://support.blaze.me/hc/en-us/articles/mobile-apps?hsLang=en#go-to-market) - [Troubleshooting](https://support.blaze.me/hc/en-us/articles/mobile-apps?hsLang=en#troubleshooting) - [Push notifications](https://support.blaze.me/hc/en-us/articles/mobile-apps?hsLang=en#push-notifications) - [Onboarding](https://support.blaze.me/hc/en-us/articles/mobile-apps?hsLang=en#onboarding) - [Payment Integrations](https://support.blaze.me/hc/en-us/articles/payment-integrations?hsLang=en#main-content) - [Birchmount](https://support.blaze.me/hc/en-us/articles/payment-integrations?hsLang=en#birchmount) - [BLAZE Sites](https://support.blaze.me/hc/en-us/articles/blaze-sites?hsLang=en#main-content) - [SEO](https://support.blaze.me/hc/en-us/articles/blaze-sites?hsLang=en#seo) - [General](https://support.blaze.me/hc/en-us/articles/blaze-sites?hsLang=en#general) - [Widgets](https://support.blaze.me/hc/en-us/articles/blaze-sites?hsLang=en#widgets) - [BLAZE Widgets](https://support.blaze.me/hc/en-us/articles/blaze-sites?hsLang=en#blaze-widgets) - [3rd Party Apps](https://support.blaze.me/hc/en-us/articles/blaze-sites?hsLang=en#3rd-party-apps) - [Company Products](https://support.blaze.me/hc/en-us/articles/company-products?hsLang=en) - [SSO(Single Sign-On)](https://support.blaze.me/hc/en-us/articles/ssosingle-sign-on?hsLang=en) - [BLAZE Brands](https://support.blaze.me/hc/en-us/articles/blaze-brands?hsLang=en) - [Product Catalog](https://support.blaze.me/hc/en-us/articles/product-catalog?hsLang=en) - [Compliance](https://support.blaze.me/hc/en-us/articles/compliance?hsLang=en#main-content) - [New Mexico](https://support.blaze.me/hc/en-us/articles/compliance?hsLang=en#new-mexico) - [What's New in BLAZE](https://support.blaze.me/hc/en-us/articles/whats-new-in-blaze?hsLang=en) - [BLAZE Accounts](https://support.blaze.me/hc/en-us/articles/blaze-accounts?hsLang=en) [![BLAZE-Logo-Blue (2)](https://support.blaze.me/hs-fs/hubfs/BLAZE-Logo-Blue%20(2).png?width=140&height=37&name=BLAZE-Logo-Blue%20(2).png "BLAZE-Logo-Blue (2)")](http://blaze.me) BLAZE US Help Center Copyright © 2026, BLAZE Solutions Inc.