How to update wp_wc_product_meta_lookup

  • Resolved ingarb

    (@ingarb)


    2 months, 2 weeks ago

    Hi! I manually updated some product prices in wp_postmeta, but they are not reflected in the store and control-panel. Looks like they both use wp_wc_product_meta_lookup to display prices?

    Is there any way to trigger an update of the prices in wp_wc_product_meta_lookup based on the prices in the wp_postmeta table? I tried running the tool: “Product Lookup Tables” -> Regenerate – but did not help. Prices are still wrong when browsing the store.

    Help!

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

Viewing 1 replies (of 1 total)
  • Plugin Support Zubair Zahid (woo-hc)

    (@doublezed2)

    Hello ingarb,

    Thank you for contacting Woo support.

    To confirm are you directly making changes to the wp_postmeta table?

    We do not recommend editing the database tables directly, as WooCommerce stores product data across multiple tables. Editing products via the WP Admin is the safest and most reliable method to ensure consistency.

    I hope this helps.

    Best regards.

Viewing 1 replies (of 1 total)
  • You must be logged in to reply to this topic.