Related products and mySQL DB

  • Resolved jbv2000

    (@jbv2000)


    3 years, 1 month ago

    Hello,
    I have a website built around woocommerce with the “Related products” plug-in installed.
    I need to update automatically on a regular basis the related products for each product.
    I will write a php script that will do the job, but I need some documentation about where and how related products are stored in the WP/woo mySQL database, so that my script can update products by writing directly in the database.
    Any help will be much appreciated.

    Thank you in advance.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter jbv2000

    (@jbv2000)

    Please forget my question, I think I have found what I was looking for.
    Best

    Plugin Author WebToffee

    (@webtoffee)

    Hi @jbv2000,

    Thanks for sharing the information and we are glad to know that you have found the solution. Please feel free to write to us if anything.

    Thread Starter jbv2000

    (@jbv2000)

    Actually, I jumped to conclusion to fast : I found the entry in wpoq_postmeta table, but when I change the meta_value for the “_crp_related_ids” meta_key, things don’t work as expected…
    So, back to my initial question, which mySQL tables are modified and how ?
    Thank you in advance.

    Thread Starter jbv2000

    (@jbv2000)

    Finally I got it to work as expected : I had made a stupid coding mistake.
    My bad.
    Sorry for the trouble and for the wasted bandwidth…

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Related products and mySQL DB’ is closed to new replies.