Product prices in database

  • Resolved laurav89

    (@laurav89)


    1 year, 6 months ago

    Hello, I need to update product prices from the database. In which table should I write them? I tried to write them in the table _wc_product_meta_lookup but they are not updated on the frontend. Thanks

Viewing 2 replies - 1 through 2 (of 2 total)

  • I think it’s stored in wp_postmeta

    Easiest way to find the tables is to edit a product and give it a unique proce – like 123456789 for example.

    Then use PHPMyAdmin to search the database for that value.

    Hi @laurav89

    Thanks for reaching out!

    I understand that you would like to update the product’s price on the database using the table _wc_product_meta_lookup, however, it is not working as expected, correct?

    This is because, product prices are stored in the _postmeta table, rather than the _wc_product_meta_lookup table. The _wc_product_meta_lookup table is used for caching and improving the performance of your store, but it’s not the primary source for product prices.

    I did some research and found these articles could be a good starting point:

    Hope this helps!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Product prices in database’ is closed to new replies.