Thanks for providing those screenshots, I can confirm that the DB table does seem to be correct whereas the order list is showing everything double. Could you also confirm if this is for all the orders in the report or just the ones shown in that screenshots?
Would it also be possible to show the full report to see if the graphs / summary are also doubling the order numbers as well as the net sales being calculated twice? For example I tried to see how this looks on a local test site, but all the order information matches up in the report and I don’t see any doubles.
The reason I ask this is because the reports send several API requests to populate this screen so it would be helpful to know if the API requests are actually providing the duplicate data or if it’s just being rendered in the report as duplicates.
Would you also be able to check in your browser with the Chrome Developer Tools to see what the API data looks like? You can do so by opening the Chrome Developer Tools and then browsing to the Network tab and look for a requests to orders? the filter can be used to find a request by name. You can then click on the request and view the Preview. Can you confirm if in that response it’s also returning double orders?
Finally would you be able to confirm whether orders are being saved in HPOS and whether syncing is enabled? You can find these settings in WooCommerce > Settings > Advanced > Features
This reply was modified 1 year, 1 month ago by Michael K.
Hi @netcomagency , thanks for the screenshots, they are very helpful.
In the orders table screenshot, I noticed there is a “N de facture” (“Invoice number”) column. That does not come from WooCommerce plugin.
In your Chrome Developer Tools screenshot, I also noticed there are some additional fields such as invoice_number, order_cost and order_profit which also do not come from WooCommerce.
Do you have some custom code or plugins that add the above column and data fields? I suspect they may be causing the issue that you are seeing.
As a quick step to help you out, could you try deactivating and activating the plugins one by one, and see which plugin is causing the orders to be displayed twice in the table? This will help narrow down the issue. Once you have identified which plugin is causing the issue, you can try reaching out to the plugin developer or support team.
Thanks for running the test to deactivate the plugins. Can I ask to confirm if cache was also cleared when the plugins were deactivated? The reason I ask is because Analytic reports rely heavily on cache, so even if plugins are deactivated it could still be loading from the cache.
I’d recommend to use a plugin like Transients Manager to clear the cache, as well as ensure the browser cache is fully refreshed when loading the analytics page to ensure it’s not using any cached JavaScript. In this case reloading JavaScript is particularly important, as you mentioned that the API responses aren’t showing duplicates in the data.
Another alternative to try is to switch to a custom date range covering a smaller period of time, which you haven’t used generated a report for yet. That will ensure it reloads the data from scratch.
