Updated Build a sales-ranking workbook by shipping region
Turn regional sales data into an Excel workbook with total checks and clear notes on unresolved differences.
The context
The operations team needs to see which regions contribute orders and sales during a specified period, then share the findings in a workbook. Store-wide totals cannot answer that question, and missing address fields in an order response do not mean regional reporting is unavailable. The report needs a usable geographic breakdown without hiding differences between reporting methods.
The Bustly workflow
Bustly reads the order overview, checks the missing address fields and confirms which geographic dimensions Shopify reporting supports. It builds a ranking by shipping country and state or region, including orders, sales, net sales and the platform's average order value. It checks order totals against the overview and records monetary differences and unverified items in a separate notes sheet. It generates and saves the Excel file, then checks a saved copy and reopens its sheets. Revenue differences, refunds and cancellation treatment remain unresolved; this is not a fully reconciled financial report.
A prompt to adapt
Create an Excel sales-ranking report for the selected Shopify store and period, grouped by shipping country and state or region. Include orders, sales, net sales, average order value and shares, with the time zone, currency, cutoff and metric definitions. Compare regional totals with the order overview; keep unexplained differences visible. Add a data-notes sheet, save the workbook and reopen it to check the file.
Adapted from real operating tasks. Customer identifiers and sensitive business details are omitted. The workflows are examples, not promises of business results.
