Can ChatGPT show what I kept this month after refunds and discounts?
The problemGross sales look healthy on the dashboard, but nobody can say what the store kept once refunds and coupon discounts come off.
What ChatGPT doesChatGPT pulls your sales report for this month and the same days last month: gross sales, net sales, refunds, discounts, orders and items. It works out AOV and the change, then shows how much order value sits in pending, on-hold or failed orders.
What you getMonth-end starts from one comparison table instead of an orders export and a pivot table, and the stuck orders are already listed.
PromptFor my WooCommerce store, compare this month to date with the same days last month: Report total sales, Report net sales, Report total refunds, Report total discount, Report total orders and Report total items. Calculate AOV as Report total sales divided by Report total orders and show the % change.Then ask
PromptNow list Order grand total and the number of orders by Order status for this month, and tell me how much is pending, on-hold or failed.For: store owners · e-commerce managers · WooCommerce agencies (one report per client store)
Fields used: Report total salesReport net salesReport total refundsReport total discountReport total ordersReport total itemsOrder grand totalOrder statusOrder creation date
→
→
→
→
→