Net sales, orders, and average order value for every company and company location in your Shopify B2B setup, in a live spreadsheet fed by your store. Rank accounts, watch reorder patterns, and split wholesale from retail.
Mixtable's analytical worksheets treat companies and company locations as first-class targets, so wholesale gets the same reporting depth as your retail side.
Net, gross, and total sales, order count, quantity, refunds, discounts, and average order value, computed per company.
The same metrics per company location, so a chain's branches stop hiding behind one account total.
The order type filter separates wholesale from retail on any store metric, so each side gets honest numbers.
Shipping, taxes, duties, and additional fees per company, which matter more in B2B than anywhere else.
Lay account sales out by month or quarter and see which companies order on schedule and which ones went quiet.
Rank accounts, flag ones below target, or compute share of wholesale revenue, like any spreadsheet.
In B2B, ten accounts can decide your year. Per-company metrics put net sales, orders, and average order value against every company you sell to, so account management starts from a ranked list instead of a hunch.
A company total blends every branch together. Company location metrics split the account into the locations that order, so you know which branch grew, which one stalled, and where the next conversation should happen.
When B2B and B2C run through one store, the totals blur. The order type filter computes any store metric for B2B orders only or B2C orders only, so both sides of the business report cleanly from the same data.
Mixtable already manages Shopify B2B companies, locations, and catalogs in worksheets. Analytics lives in the same spreadsheet, so the account list you maintain and the numbers that judge it are one tab apart.
Analytical worksheets cover supported metric and filter combinations. These are the core metrics per company and company location.
Shopify B2B stores the data. Here is how the options compare when you want account-level answers.
| Analysis task | Mixtable | Shopify admin | Exporting to Excel | ERP and CRM tools |
|---|---|---|---|---|
| Sales metrics per company | Yes, in a live sheet | Per-company screens | Manual joins | Yes, after integration |
| Metrics per company location | Yes | Limited | Manual joins | Depends on setup |
| B2B vs B2C revenue split | Yes, one filter | Partial | Manual tagging | Yes, after integration |
| Rank accounts and flag ones off pace | Yes, sort plus formulas | No | Yes, manually | Sometimes |
| Numbers beside editable B2B records | Yes, same spreadsheet | Separate screens | No | Own record system |
| Stays current without re-exporting | Yes, dynamic ranges | Yes | No | Yes, via sync jobs |
| Setup time | Minutes | None | Every single time | Weeks to months |
Comparison reflects typical B2B analysis workflows. Company metrics require Shopify B2B; Mixtable analytics covers supported metric and filter combinations.
No exports, no pipelines. Your Shopify B2B data is already enough.
Install the Mixtable Analytics Spreadsheet from the Shopify App Store and open a spreadsheet.
Create a worksheet of B2B companies, or company locations for branch-level analysis.
Net sales, orders, and AOV per company or location, over the range you care about.
Use the order type filter on store metrics to see the wholesale share cleanly.
Sort, flag accounts off pace with formulas, and export to Excel or CSV for the meeting.
Install the Mixtable Analytics Spreadsheet from the Shopify App Store and add company-level analytics metrics. Every company from your Shopify B2B setup gets net sales, orders, average order value, refunds, and discounts as columns, live from your store.
Yes. Company and company location metrics build on Shopify's B2B objects, so your store needs Shopify B2B with companies set up. The B2B versus B2C order split works as soon as you have B2B orders.
Yes. Every company metric also works per company location, so multi-branch accounts split into the locations that actually place the orders.
Yes. Filter store metrics by order type to get B2B-only and B2C-only numbers, then compute the share with a formula in the same worksheet.
Yes. Lay account sales out by month or quarter and quiet accounts show up as fading rows. A threshold formula can flag them automatically.
Yes. Shipping amounts, taxes, duties, and additional fees are available per company and location, which keeps bigger B2B invoices honest.
Yes. Companies, company locations, and B2B catalog price lists are editable in regular worksheets in the same spreadsheet, with changes previewed before they sync to Shopify.
Yes. Share the spreadsheet with per-worksheet permissions, or export to Excel or CSV when someone just needs the file.
Open Mixtable for your store and see what every account is really worth.
