Total spend and orders not calculated

  • Resolved agrolsy

    (@agrolsy)


    5 years, 10 months ago

    Hi,
    I see my list of customers, but total spend and total orders is just set to zero

    I’m running the latest version of wordpress

    I get a database error Table ‘wordpress.wp_posts’ doesn’t exist
    SELECT DISTINCT wp_posts.post_date_gmt, wp_posts.ID, wp_postmeta.meta_value
    FROM wp_posts
    INNER JOIN wp_postmeta
    ON ( wp_posts.ID = wp_postmeta.post_id )
    WHERE 1=1
    AND wp_postmeta.meta_key = ‘_customer_user’
    AND wp_posts.post_type IN (‘shop_order’, ‘shop_order_refund’)
    ORDER BY wp_posts.post_date_gmt DESC

    It seems like the plugin doesn’t work with custom database prefixes? (I don’t use the standard prefix)

    The page I need help with: [log in to see the link]

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Blaze Concepts

    (@blazeconcepts)

    Hi,

    Thanks for taking the time to let us know of this issue, we have released an update which should fix the issue you’ve described.

    Please let us know if the update fixes your issue.

    Thanks,

    The Blaze Team

    Thread Starter agrolsy

    (@agrolsy)

    Great, thank you! That was faster than lightning! Now it works very well!

    Plugin Author Blaze Concepts

    (@blazeconcepts)

    Happy to help ??

    Let us know if you have any other issues and if you find the plugin helpful and have the time, we’d appreciate a rating but no pressure ??

    Thanks,

    The Blaze Team

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Total spend and orders not calculated’ is closed to new replies.