--- title: Daily BOPIS Orders Report description: Track the last 30 days' BOPIS orders with this detailed Shopify report. Monitor pickup status, cancellations, and unclaimed orders effortlessly. image: https://www.hotwax.co/hubfs/bi-reports/dashboard-banners/fulfillment-reports/daily-bopis-orders-report-dashboard.png --- [![HotWax Commerce](https://www.hotwax.co/hs-fs/hubfs/hotwax-logo.png?width=200&height=63&name=hotwax-logo.png)](https://www.hotwax.co/) [![HotWax Commerce](https://www.hotwax.co/hs-fs/hubfs/Common%20assets/Logos/HotWax/HWCLogoDarkMode.png?width=200&height=63&name=HWCLogoDarkMode.png)](https://www.hotwax.co/) ☰ - Product - Bundles - [Order Management System](https://www.hotwax.co/product/omnichannel-order-management-system/) - [Store Inventory Management](https://www.hotwax.co/solution/store-inventory-management) - [Omnichannel Suite](https://www.hotwax.co/product/omnichannel-order-management-system-for-shopify/) - Intelligence - [MCP Server](https://www.hotwax.co/product/technology/mcp-server) - [AI Powered Order Routing](https://www.hotwax.co/product/technology/ai-powered-order-routing) - Technology - [OMS Architecture](https://www.hotwax.co/product/technology/oms-architecture) - [Security](https://www.hotwax.co/privacy-and-security) - Use Cases - By Business Benefits - [Prevent Overselling](https://www.hotwax.co/use-cases/prevent-overselling) - [Unified Inventory](https://www.hotwax.co/solution/unified-inventory/) - [Order Routing](https://www.hotwax.co/solution/configurable-order-routing) - [Ship From Store](https://www.hotwax.co/solution/ship-from-store-software) - [Buy Online Pick-Up In Store](https://www.hotwax.co/solution/buy-online-pick-up-in-store-bopis-software/) - [Pre-Orders](https://www.hotwax.co/solution/pre-orders/) - [Inventory Transfers](https://www.hotwax.co/inventory-transfers) - [Cycle Counts](https://www.hotwax.co/cycle-count) - [Return In Store](https://www.hotwax.co/solution/buy-online-return-in-store-boris-software) - [Retail Sales Audit](https://www.hotwax.co/product/omnichannel-retail-sales-audit-oresa/) - By Business Model - [Footwear](https://www.hotwax.co/industries/footwear) - [Jewelry](https://www.hotwax.co/industries/jewelry) - [Fashion & Apparel](https://www.hotwax.co/industries/apparel-and-fashion) - [Beauty](https://www.hotwax.co/industries/beauty-and-personal-care) - [Travel](https://www.hotwax.co/industries/travel-and-bags) - Resources - Learn - [Blogs](https://www.hotwax.co/blog) - [Guides](https://www.hotwax.co/guides) - [Whitepapers](https://www.hotwax.co/whitepaper) - [Solution Briefs](https://www.hotwax.co/solution-briefs) - [Engineering Blog](https://www.hotwax.co/engineering) - Product Help - [Product Updates](https://www.hotwax.co/product-updates) - [Knowledge Base](https://www.hotwax.co/hotwax-commerce-documentation) - [Shopify Integration](https://www.hotwax.co/shopify-order-management-integration) - [NetSuite Integration](https://www.hotwax.co/hotwax-netsuite-integration) - [Sample BI Reports](https://www.hotwax.co/business-intelligence-bi-reports) - [FAQs](https://www.hotwax.co/frequently-asked-questions) - Media - [Podcast](https://www.hotwax.co/podcast) - [Demo Videos](https://www.hotwax.co/demo-videos/) - Company - [Our Story](https://www.hotwax.co/about-us/our-story/) - [Team](https://www.hotwax.co/about-us/) - [Partners](https://www.hotwax.co/become-a-partner) - [All Integrations](https://www.hotwax.co/all-integrations/) - [Customers](https://www.hotwax.co/customers) - [Pressroom](https://www.hotwax.co/hotwax-commerce-pressroom) - [Social Impact](https://www.hotwax.co/social-impact-hotwax-commerce) - [Events](https://www.hotwax.co/events-and-conferences) [Book a demo](https://cta-na2.hubspot.com/web-interactives/public/v1/track/click?encryptedPayload=AVxigLISXXGkcOtRysPKfjcriLyodY4rudkc50veKlKDe8q2B1%2FRWGeLxDhbY%2BkohRU8XspED5h92umpu7OkRZM1bllkBJKAFAlbNGEnCRAQX7O752HQT17G9v%2FBCweH%2FXvHlZ5%2FUC0MRPtKYCn5XoGb8TpxbLxvKbLalLOZcHeqoaHicFtr15mZOUkn2Y06IxHVsa5b0g%3D%3D&portalId=6357099) Fulfillment Reports ![Sample Daily BOPIS Orders Report dashboard with charts and order data, a HotWax Commerce BI report](https://www.hotwax.co/hs-fs/hubfs/bi-reports/dashboard-banners/fulfillment-reports/daily-bopis-orders-report-dashboard.png?width=1600&height=838&name=daily-bopis-orders-report-dashboard.png) # Daily BOPIS Orders Report ## Sample Daily BOPIS Orders report Insider reports that 39% of consumers prefer using BOPIS when placing online orders because they get their orders faster. During their BOPIS journey, customers also expect prompt notifications from the brand on the status of their orders.    When customers can’t come to the store to pick up their orders, store managers need a detailed report on the unpicked BOPIS orders.    The **Daily** **BOPIS Orders Report** provides cumulative details of all the BOPIS orders of the last 30 days. This Shopify report also shows the status of these BOPIS orders if orders are picked up, canceled, or not picked up.    With this detailed report, store managers also look for long pending BOPIS orders. These orders keep the inventory blocked which can be used to fulfill other orders. With the knowledge of pending BOPIS orders, merchants can cancel all long-pending orders and use the inventory for new orders.    The report is essential to improve the BOPIS order fulfillment rate. Again, the fewer the unpicked orders, the better the order fill rate. Additionally, the problem diagnosis with the report helps retailers to clear the challenges in the omnichannel order fulfillment cycle.   ## What the report shows Each row is one pickup order, so a store manager can follow it from the moment it arrives to the moment it leaves the store. - **Order references:** the HotWax Commerce order ID and the Shopify order ID. - **Order timeline:** the dates the order was imported, confirmed against available inventory, brokered to a store, picked up, or canceled. - **Item and customer:** the item description (style, color, and size), UPC or SKU, customer name, the store the customer chose, and the shipping method. - **Pickup status:** whether the order was picked up, canceled, or is still waiting.   ## How teams use it Store managers sort the report by status and start with orders that were confirmed but never collected. A quick call or reminder often brings the customer in. When an order has waited too long, the team can cancel it and free the inventory for other shoppers. The Head of Stores can compare not-picked-up counts across locations to see which stores need help with pickup follow-up. The Daily BOPIS Orders Report is one of the pre-configured reports in the [HotWax Commerce BI report library](https://www.hotwax.co/business-intelligence-bi-reports), which covers demand and sales, fulfillment, pre-orders, returns, and more.   User Head of eCommerce, Head of Stores, Vice President of Retail   ## Glossary ![Glossary table of Daily BOPIS Orders Report fields and what each field means](https://www.hotwax.co/hs-fs/hubfs/bi-reports/tables-for-reports/fulfillment-reports/daily-bopis-orders-report-glossary.png?width=860&height=696&name=daily-bopis-orders-report-glossary.png)   [![HotWax Commerce](https://www.hotwax.co/hubfs/Hotwax-2021/HotWax_February2020/Images%20Icons,%20Apparel%20background,%20Hexagon/logo-hotwax-dark.svg)](https://www.hotwax.co/) ### Connect ### Headquarters 175 S Main St Suite 1310, Salt Lake City, UT 84111 - Product - [Omnichannel Order Management](https://www.hotwax.co/product/omnichannel-order-management-system/) - [Store Inventory Management](https://www.hotwax.co/solution/store-inventory-management) - [FAQ](https://www.hotwax.co/frequently-asked-questions) - [Product Updates](https://www.hotwax.co/product-updates) - [Documentation](https://www.hotwax.co/hotwax-commerce-documentation) - Use cases - [Unified Inventory](https://www.hotwax.co/solution/unified-inventory/) - [Configurable Order Routing](https://www.hotwax.co/solution/configurable-order-routing) - [Ship From Store](https://www.hotwax.co/solution/ship-from-store-software) - [Buy Online Pick-Up In Store](https://www.hotwax.co/solution/buy-online-pick-up-in-store-bopis-software/) - [Pre-Orders](https://www.hotwax.co/solution/pre-orders/) - [Buy Online Return In Store](https://www.hotwax.co/solution/buy-online-return-in-store-boris-software) - Solutions - [Omnichannel OMS for Shopify](https://www.hotwax.co/product/omnichannel-order-management-system-for-shopify/) - [Omnichannel Retail Sales Audit](https://www.hotwax.co/product/omnichannel-retail-sales-audit-oresa/) © 2026 HotWax Commerce ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "Aditya Patel", "url" : "https://www.hotwax.co/bi-reports/author/aditya-patel" }, "dateModified" : "2024-06-18T09:36:09.338Z", "datePublished" : "2023-06-14T12:14:54.000Z", "headline" : "Daily BOPIS Orders Report", "image" : [ "https://www.hotwax.co/hubfs/bi-reports/dashboard-banners/fulfillment-reports/daily-bopis-orders-report-dashboard.png" ], "mainEntityOfPage" : { "@id" : "https://www.hotwax.co/bi-reports/daily-bopis-orders-report", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "url" : "https://www.hotwax.co/hubfs/hotwax-logo.png" }, "name" : "HotWax Commerce" } } ```