Grouping inventory by wholesaler invoice

Shopify Discussion
,

Topic summary

A user seeks guidance on two inventory management challenges in Shopify:

Grouping New Inventory:

  • Wants to organize incoming inventory by individual wholesaler invoices
  • Needs a method to reference products as grouped sets based on their original supplier orders
  • Has already uploaded most existing inventory but wants to improve the process going forward

Sales Reporting Requirements:
Looking to generate reports (daily/weekly/monthly) that include:

  • SKU number and description
  • Quantities sold
  • Sales revenue and cost of goods
  • Gross margin (both dollar amounts and percentages)
  • Subtotals organized by department

The discussion remains open with no responses yet. The user is essentially asking whether Shopify’s native features support these workflows or if third-party solutions are needed.

Summarized with AI on October 23. AI used: claude-sonnet-4-5-20250929.
1

Hello, I have a couple questions regarding product entry and reports.

I’ve already uploaded the vast majority of inventory, but going forward would like to group them by individual wholesaler invoice.

So my questions are:

1 What is the best way to enter new purchases of inventory for resale into shopify from individual supplier invoices? So that i can refer back to that order as a group of products2 How can we generate daily, weekly and monthly sales reports that show sku number, sku description, item quantities sold, item sales (dollars), item cost (dollars), item gross margin (in dollars), item gross margin (percentage) with subtotals by department