About

Hey! We are on BigCommerce and our wholesale customers are mixed into total sales, which throws off our retail metrics. The Orders screen does not give us a “customer group” filter, and the Analytics view we have does not break out sales by group. We just need a simple, reliable way to see retail-only revenue (daily, weekly, monthly) without wholesale in the mix. I am open to any approach that works: Smart export → Sheets or Excel join (Orders plus Wholesale Customers) with a clear flag and pivots. A small API or script that pulls orders and filters by customer_group_id, then outputs a clean table or CSV. If there is a neat dashboard option (Looker Studio or GA4 segment), happy to consider it. What “done” looks like Retail-only totals we can trust, refreshed in under 5 minutes, or automated. A tidy template plus a short SOP so the team can run it without you. Spot checks reconcile against store totals minus wholesale. Great fit if you have BigCommerce experience (exports or API) and strong Sheets or Excel skills. Reporting and data-cleanup experience. When you apply, please share Your preferred approach (Sheet, API, or dashboard) A quick example of similar reporting you have built Your price and rough timeline How you would flag wholesale orders if the export does not include the group Thanks. Keen to keep this lightweight and get a solution that works.