What Is the Sales by Vendor Report?
The Sales by Vendor report groups your Shopify order data by the Product Vendor field, so each supplier or brand becomes one row. For the date range you choose, it totals net quantity, gross sales, discount, returns, net sales, shipping, tax, total duties, and total sales for that vendor.
The vendor value comes from the Vendor field on each product. If a product has no vendor assigned, Shopify uses your store name instead, so unassigned items get counted under the store rather than a supplier.
Sales by Product tells you which items sold. Sales by Vendor rolls those products up to the supplier behind them, which is what you want when the question is which vendor relationship carries the store and how much your revenue depends on any one of them.
Which Fields Are Included in the Sales by Vendor Report?
You can add, remove, or reorder columns, and you can add a calculated column such as each vendor's share of total net sales.
Important Insights You Can Find in This Report
Which vendors hold up on net sales, not just gross?
A supplier can rank high on gross sales and drop once discounts and returns come off. Compare each vendor's gross sales against net sales. A wide gap means that vendor's revenue leans on promotions or comes back as returns, so it nets less than the headline suggests.
How much of your revenue depends on one vendor?
Each row is a whole supplier's catalog, so this is the quickest way to see concentration. Add a share-of-net-sales column and look at your top one or two vendors. If a single supplier drives a large slice of sales, a stockout or price change on their side becomes your problem, which is a reason to line up a backup.
Which vendors are actually worth reordering from?
Read net quantity, net sales, and returns together. A vendor moving steady volume at clean net sales with few returns is a reorder candidate. One selling on heavy discount or with high returns is not, even if its gross sales look healthy.
THE ANALYST'S READ
Watch the gross-to-net gap per vendor across a few periods. A gap that stays wide for one supplier while others at similar volume stay narrow points to structural discounting or a returns-prone line, worth checking before a larger purchase order or a renewal.
The read only holds if the Vendor field is clean. Split spellings or products defaulting to the store name break the vendor rows, so normalize the field first.
How Can You Automate the Sales by Vendor Report?
Open the pre-made Sales by Vendor template and run it as is, or set your date range first. To build it yourself, add the fields above, group by Product Vendor, and save.
Then schedule it daily, weekly, or monthly to your inbox, your buying or finance team, Google Sheets, or Google Drive, and export any run as Excel, CSV, or PDF.
Frequently Asked Questions
What does the Sales by Vendor report group by?
he Product Vendor field on each Shopify product. One row represents one supplier and totals that vendor's sales for the period.
What happens if a product has no vendor assigned?
Shopify uses your store name as the vendor when the field is blank, so those products get grouped under the store instead of a supplier. Fill in the Vendor field before relying on the totals.
How is Sales by Vendor different from the Sales by Product report?
Both use the same sales metrics, but Sales by Product has one row per product and Sales by Vendor rolls those products up to the supplier that provides them.
How is this different from Shopify's native Total sales by vendor report?
Shopify's built-in report shows vendors and their products with core sales metrics. The Report Pundit version adds saved custom columns, filters, calculated fields, scheduling, and exports to Google Sheets.
What is the difference between gross sales and net sales here?
Gross sales is the vendor's product price times quantity before deductions. Net sales subtracts that vendor's discount and returns.