Shopify Peak Order Quantity: Master Stock Planning with Max Sales Data

Cracking the Code: Finding Your Shopify Store's Highest Order Quantities

Hey there, fellow store owners! Let's talk about something critical for any growing e-commerce business: stock planning. If you're like most merchants, you're constantly trying to balance having enough inventory to meet demand without tying up too much capital in unsold goods. It's a delicate dance, and frankly, Shopify's standard reports don't always give us all the moves we need.

Recently, a lively discussion popped up in the Shopify community that really resonated with me. A merchant, AsMd, who manages an incredibly varied store with over 20,000 SKUs and 208 brands, hit on a pain point many of us share: the need for a "highest quantity per order" metric. They pointed out that while Shopify gives us "average quantity per order," averages can be incredibly misleading. One huge, outlier order could completely skew your perception of typical demand, leading to either stockouts or, worse, overstocking.

AsMd put it perfectly: "Averages can hide occasional large orders." And they're right! What if you get a big wholesale order once a quarter, or a sudden rush for a specific product for a social event? Your average might look normal, but if you're not planning for those peak orders, you're asking for trouble.

Why Standard Shopify Reports Fall Short

The core of the problem, as several community members like Ecom_swift_LLC and accessify.web.app confirmed, is that Shopify's built-in report builder only offers average and total aggregations. There's no direct, one-click way to see the maximum quantity of a single SKU ever sold in one order right there in your standard sales reports. This means a bit of manual work or a clever workaround is needed.

Solution 1: Harnessing the Power of ShopifyQL (for the data explorers)

For those comfortable with a little code, ShopifyQL offers a powerful way to dig deeper into your data. v.marychenka shared a fantastic query in the thread that can help you find those peak orders. It's not a single "max" column, but it lists every order for each product, sorted by quantity, so the highest is right at the top.

How to Use ShopifyQL to Find Peak Quantities:

Go to your Shopify Admin, then navigate to Analytics > Reports.
Click New exploration.
In the ShopifyQL editor, paste the following query:

FROM sales
  SHOW quantity_ordered
  GROUP BY product_title, order_name
  SINCE -10y
  ORDER BY product_title ASC, quantity_ordered DESC

v.marychenka also provided a slightly more refined version that includes the sale date and allows for a brand filter:

FROM sales
  SHOW quantity_ordered
  WHERE product_vendor = 'Brand name'
  GROUP BY product_title, order_name, day
  SINCE -10y
  ORDER BY product_title ASC, quantity_ordered DESC

Remember to replace 'Brand name' with your actual brand if you use the filter. This query will group your rows by product, and for each product, it will list all its orders from largest to smallest. The first row under each product title will be its peak quantity! You can then see the order number and the day it sold. VikashJ notes that for large catalogs (like AsMd's 20,000+ SKUs), manually scanning this won't scale, so you'd want to Export the result as a CSV and then use a pivot table (more on that next).

Solution 2: The Spreadsheet Powerhouse (Accessible to All)

If ShopifyQL feels a bit daunting, or if you're dealing with a massive catalog, the community highlighted a robust spreadsheet-based approach using your raw sales data. This is often the most practical solution for many merchants.

Step-by-Step Spreadsheet Method:

Export Your Line-Item Data: Go to Orders > Export in your Shopify Admin. Choose to export orders with line items as a CSV. ahsandoesntcare reminds us to set the date range to your full store history to capture all-time peaks, not just recent ones. Also, filter by order status to match what you actually shipped (e.g., exclude refunded or cancelled orders).
Create a Master File: As optima-tiktok-shop1 and accessify.web.app suggested, instead of re-exporting everything every time, create one master line-item CSV. For future stock orders, export only new orders since your last export date and append those rows to your master file. This saves a ton of time!
Calculate Max Quantity per SKU:
- Using a Pivot Table: In Excel or Google Sheets, create a pivot table. Put your "SKU" or "product_title" column in the Rows area. Drag "Lineitem quantity" (or similar) into the Values area, and change the aggregation from "Sum" or "Average" to "Max". This instantly gives you the highest quantity for each product in a single order.
- Using MAXIFS (Google Sheets/Excel): If you prefer a helper column, you can use a formula like =MAXIFS(quantity_column, sku_column, A2) where quantity_column is your column with line item quantities, sku_column is your column with SKUs, and A2 is the cell containing the SKU you're currently looking up.
Add Context: ahsandoesntcare also recommends pulling the MAX of the order date per SKU so you know when that peak order actually happened.

Expert Insights: Beyond Just the "Max"

While finding the highest quantity per order is super useful, the community experts offered some critical perspective. Jack_BuildsShopify and Nobolevsk wisely cautioned against relying solely on the all-time max. Why?

Outliers Skew Planning: That absolute max order is, by definition, an outlier. It might be a one-off wholesale order or a special gift set that won't repeat regularly. Sizing your safety stock to cover that single peak means carrying extra inventory on every SKU, all the time, which can be costly.
Consider Percentiles: Nobolevsk suggests a more practical approach for safety stock: sorting all order quantities per SKU and taking the 90th or 95th percentile instead of the flat max. This covers nearly all orders without inflating every reorder to guard against a rare one-off. Keep the absolute max for context, but don't let it dictate your everyday stock levels.
Frequency Matters: Jack_BuildsShopify also recommends looking at how often 2+, 3+, or 5+ units are bought in one order, alongside your supplier lead times. This gives you a more holistic view of demand patterns.

The takeaway here is that the "max per order" is a powerful exception signal, not necessarily the sole rule for reordering. Combine it with other data points for truly smart inventory decisions.

Making Your Voice Heard: Feature Requests for Shopify

AsMd also asked a great question: "Does Shopify have a feature request inbox anywhere?" VikashJ from Apploy provided a clear answer. While there isn't a dedicated, centralized portal like some SaaS products, the most reliable way to submit a feature request directly to Shopify's product team is through the feedback option inside your Shopify admin (usually under the "?" Help icon). Shopify staff also monitors community discussions like this one for patterns and feedback, but direct in-admin feedback is generally more impactful for tracked requests.

So, there you have it! While Shopify doesn't offer a direct "max quantity per order" column in its standard reports, our amazing community has come up with some robust workarounds. Whether you're comfortable with ShopifyQL or prefer the power of a good old spreadsheet, you now have the tools to dig into your data and make more informed stock planning decisions. Remember, understanding your peak demand, not just your average, is key to keeping your shelves stocked and your customers happy. If you're building or optimizing a Shopify store, remember that deep dives into your data are key to success. If you're ready to take your e-commerce journey to the next level or just starting out, Shopify offers powerful tools to help you manage everything from inventory to sales.

Beyond Averages: How to Find Your Shopify Store's Peak Order Quantities for Smarter Stock Planning