View per-product reports

How to see who bought a specific product and which products sold most in a date range

SGEN ships with two per-product reports that sit inside the Products section. The Product Customers report lists every customer who bought a specific product within a date range — names, emails, order IDs, status. The Scan Product Orders report flips the view: for a date range, it lists every product with a count of completed orders and the order IDs. Both reports populate as your store takes real orders; until you have orders in your system they render as empty-state screens with the filters and headers ready. A 10-minute monthly review on the Product Customers report is a solid way to spot repeat buyers; the Scan Product Orders report is the one you open when you want to know "what sold this week."

What is this for?

Per-product reports answer two very different questions:

• "Who bought this specific product?" — open Product Customers for that product. You get a list of orders: billing name, email, the customer who placed the order (linked to their account), the order status, and the date.
• "Which products sold the most in the last week?" — open Scan Product Orders. You get a list of products with completed-order counts; click a product name to jump into its edit page, or click an order ID to open the order.

Both reports are admin-only; customers never see them. They are operational tools for fulfillment, marketing, and inventory decisions. You reach for them every time you need evidence of what sold vs what didn't, rather than just a gut sense.

Good use cases

Example 1: Identifying repeat buyers for a thank-you campaign. You want to send a hand-written note to everyone who bought the Tote Bag in the last 90 days. Open the Tote Bag's edit page, click View product customers, set the date range to "last 90 days", click Select Dates. The table fills with orders — billing names and emails together. Copy the email list into your email tool or CRM.

Example 2: Stock-taking after a busy week. You just ran a weekend promotion and want to know which of the four fixtures moved most. Open Scan Product Orders, set the date range to "the last 3 days", click Apply Filter. The table lists every product with its Completed-order count. Reconcile those counts against your physical stock to spot discrepancies.

Example 3: Finding a specific order for a support call. A customer calls saying "I bought the Brand Book last week and never got my copy." Open the Brand Book's edit page, click View product customers, set the date range to "last 14 days", search by the customer's email. Their order row appears with the status (Pending, Processing, Completed, etc.) and a link to the order view.

Example 4: Spotting a quiet product. You suspect the Sticker Pack isn't selling. Open Scan Product Orders, set the range to "last 30 days". If the Sticker Pack doesn't appear in the list (or has zero orders), that's evidence. Decide whether to promote it harder or retire it.

What NOT to use this for

• Do not treat either report as a revenue dashboard. These are per-product reports, not a whole-store income statement. For total revenue, order volumes, and ecommerce analytics, look at your ecommerce reporting (outside the Products section).
• Do not use Product Customers as a privacy-compliant export. If you need to hand customer data to a third party for a privacy or legal request, use your store's dedicated export tool. This screen is for operational lookup, not formal data handling.
• Do not expect per-variant breakdowns. Product Customers aggregates at the parent product level. If the T-Shirt sold 10 in Medium/Black and 5 in Large/White, both show as T-Shirt orders — the specific variant is visible on each individual order, not summarized here.
• Do not rely on Scan Product Orders for non-completed statuses. Scan Orders only counts orders with status Completed. Pending, Processing, and Cancelled orders are excluded. Use Ecommerce Orders for the full picture.

How this connects to other features

• Ecommerce → Orders — every order ID in the Product Customers table links to the Orders screen where you can see the full order, update status, refund, and message the customer.
• Products list — open any product from Products → All Products and its edit page shows a View product customers button that takes you straight to its Product Customers report.
• Ecommerce → Configuration — the currency symbol shown in the summary total ("Amount: $0.00") comes from your store configuration.
• Your user records — customer rows in the Product Customers table link to the user's profile under Users for their full order history across every product, not just this one.

Before you start

• You are signed in to SGEN as an admin.
• You have at least one product (to run Product Customers against).
• For meaningful results: your store has taken at least one order. While orders are empty, both reports render with their filters and layout but no data to show. They fill up automatically as orders come in.

Where to go — Product Customers

1. Open the left navigation.
2. Click Store Management → Products → All Products.
3. Click any product's Edit row action.
4. On the product edit page, scroll to the right sidebar. Click View product customers.
5. You land on /sg-admin/ecommerce/products/customers/<product-id>.

Where to go — Scan Product Orders

Scan Product Orders isn't visible in the left navigation by default. Open it by direct URL:

1. Open your admin with any product open in the editor (or any page that preserves your session).
2. In the browser address bar, navigate to /sg-admin/ecommerce/products/scan_orders.
3. The Scan Product Orders report loads.

Consider bookmarking this URL for monthly use.

Steps — Product Customers

1. Confirm the product at the top

The report's H1 is Product Customers and the subtitle shows which product you're looking at. The breadcrumb ends with the product's title. If you're on the wrong product, go back to Products and pick the right one.

2. Set the date range

The Date range picker at the top defaults to "last 14 days plus 1" (so today's orders are included). Click it to open the calendar. Pick a start and end date. Click Select Dates. The table refreshes.

3. Read the summary line

Just under the header, a summary line shows:

• Quantity — total units of this product sold in the range.
• Amount — total revenue for this product in the range.

These are aggregate numbers across every order shown in the table.

4. Search for a specific order

The Search box matches on order ID, billing name, billing email, and the customer's account email. Type part of any of those and the table narrows.

5. Read each row

Each row is one order containing this product. Columns:

• Order — the order's admin ID, linked to the full order view.
• Billing Name — the name on the order.
• Billing Email — the email on the order.
• Customer — the customer's account (if they were signed in), linked to their user profile.
• Order Status — a colored badge: Pending / Processing / Completed / Cancelled.
• Date — when the order was placed.

6. Open an order

Click the Order ID to open the full order view. From there you can see line items, shipping, payment status, and the customer history.

Steps — Scan Product Orders

1. Set the date range

The Date range picker at the top of Scan Product Orders defaults to "last 2 days". Click it, pick a start and end date, click Apply Filter. The table refreshes.

2. Read the table

Each row is one product that had at least one Completed order in the range. Columns:

• Product Name — the product's title, linked to its edit page.
• Orders — comma-separated list of order IDs, each linked to that order's view.
• Total — the count of Completed orders in the range.

Rows are sorted by Total descending — highest-selling product at the top.

3. Search for a specific product

The Search box matches on product name, product ID, or order ID. Use this when the date range is wide and the list is long.

4. Jump to a product or an order

Click a product name to open its edit page (useful when you notice an inventory problem and want to adjust stock). Click an order ID to open that order.

What success looks like

• Product Customers loads for a product with at least one order showing the Quantity / Amount summary, one row per order, status badges, and clickable order IDs.
• Product Customers loads for a product with no orders showing an empty-state "No orders were found!" and a Quantity / Amount of 0 / $0.00 — the filters and search are still visible and ready.
• Scan Product Orders loads for a date range with Completed orders showing one row per product, sorted by order count descending, with clickable product names and order IDs.
• Scan Product Orders loads for a date range with no orders showing an empty-state "No orders were found!" and the date picker and search still visible.

What to do if it does not work

• Product Customers is empty even though I know there are orders for this product. The date range filter may be excluding them. Widen the range (try "last 12 months" to start). Also check that the orders have a status — if orders are still in Pending or Cart, they may not appear depending on your store's configuration.
• I can't find Scan Product Orders in the menu. It's intentionally direct-URL only. Navigate to /sg-admin/ecommerce/products/scan_orders and bookmark it for future use.
• Scan Product Orders shows fewer products than I expected. Scan Orders only counts Completed orders. A product that has only Pending orders shows zero here. For a wider view, look at Ecommerce Orders directly.
• The H1 and breadcrumb on the Scan Product Orders page look cramped or overlapping. That's a known cosmetic quirk of the page layout — it doesn't affect the data. Reload if the layout misbehaves.
• Opening a non-existent product's customer report shows a blank page. If you land on /sg-admin/ecommerce/products/customers/<id> for an id that doesn't exist, the page renders without content. Go back to the Products list and pick a valid product.
• The product has orders but Amount shows $0.00. Confirm your store currency is set under Ecommerce → Configuration. The report uses that configuration to render the monetary totals.

Next step