Hi, @ThreeBarsFeed ! I'm sorry to hear about this issue with the COGS report. I'm going to outline below some troubleshooting steps and if you are still having difficulty running the COGS report, please tag me and I will escalate to our Application Support Team.
Force a Sync / Refresh
-
Go to Square Dashboard > Items > Item Library
-
Make a minor edit to one of the items showing a $0 cost (like re-entering the same cost or changing a description)
-
Save the change. This sometimes prompts the system to reindex the item data
-
Then go to Reports > Cost of Goods Sold and re-run the report for that date
Re-run the COGS report later in the day
-
Square may auto-correct the cost data within a few hours (delayed syncing is common after heavy usage days like weekends or holidays)
-
Wait a few hours, then re-run the report using a custom time frame rather than just "Yesterday"
Export Sales Data and Merge with Item Cost Manually
As a temporary workaround:
-
Export Sales Transactions CSV for the affected date
-
Export your Item Library with costs
-
Use Excel or Google Sheets to match items and calculate margin manually
I know this is a very tedious suggestion...but I wanted to at least propose it in case you need something to try.
I hope this helps!
