What did the store really sell each day?
The problemThe daily sales number includes orders that were later cancelled, so it never matches what was actually billed.
What Claude doesClaude reads Orders, Order Value and Units by Order Date and keeps only orders whose Order Status is invoiced. Order Date is your store's local day, taken from the time zone of each sales channel.
What you getA daily net sales series that matches the VTEX admin day by day, with average order value worked out as Order Value divided by Orders.
For the last 30 days, show invoiced Orders, Order Value and Units by Order Date from VTEX. Add the average order value for each day as Order Value divided by Orders, and tell me which day sold the most.For: ecommerce managers · DTC marketers · agencies


