Correcting Product Analytics in the Database

  • Resolved thomasmay

    (@thomasmay)


    3 years, 8 months ago

    Hi,

    I changed the way our variable products are organised in our site, basically reverted from having a single product with 2 variation attributes to splitting them into 2 products with just one variation attribute. Everything is working just fine on the storefront. But as new product and variation ID’s were created all reporting for what is essentially an identical SKU is broken. In an attempt to fix this, I edited the DB to change all orders prior to this change. What I did is the following: Orders with the old ID’s have had the _product_id and _variation_id in the wp_woocommerce_order_itemmeta table updated to the new corresponding product/variation ID’s. These changes are reflected in the actual orders pages, and solved a Quickbooks sync issue, but the Woocommerce analytics product reports seem to be pulling data from somewhere else. WHERE?

    Any help would be appreciated.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support lionel.a11n

    (@lioneldaniel)

    Hi @thomasmay,

    Analytics stores its own data compiled from order information to make reports much faster. Your situation is unique because you’ve made some custom database edits, but if you set everything up right I think that you can get analytics to properly update by rebuilding the Reports table from scratch.

    I recommend backing up as a routine precaution before trying this; if your updated order data isn’t quite as the system expects, you may get unpredictable results. To rebuild your Reports table:

    1. In WP Admin → Analytics → Settings, click ‘Delete Previously Imported Data’ at the bottom of the page:<brScreenshot
      Link to image: https://d.pr/i/spZmv9
    2. Once that is done, return to that area (refresh the page if you need to), and click ‘Start’ to import all your orders to the Reports table. This may take awhile, and you don’t need to stay on this page for the process to complete (I find it sometimes ‘hangs’ here, so you can refresh the page).
    3. Once the orders are imported, check your reports.

    Afterwards, hopefully the problem is resolved. Let us know, we’re looking forward to hearing back it if works!

    Plugin Support lionel.a11n

    (@lioneldaniel)

    We haven’t heard back from you in a while, so I’m going to mark this as resolved – if you have any further questions, you can start a new thread. Thanks!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Correcting Product Analytics in the Database’ is closed to new replies.

Tags