WordPress.org

Support

Support » Plugins and Hacks » WooCommerce » MYSQL Script

MYSQL Script

  • I am trying to export and old product list that was done a few months ago by someone else. I cannot make updates to my them, my database nothing. Also when I export the item list it throws an error. So i decided to go into the MySQL and export the items from there. this is the sql script that I ran

    SELECT
    posts.ID,
    posts.post_title AS title,
    posts.post_content AS content,
    files.meta_value AS filepath
    FROM
    wp_posts posts
    INNER JOIN wp_posts attachments ON posts.ID = attachments.post_parent
    INNER JOIN wp_postmeta files ON attachments.ID = files.post_id
    WHERE files.meta_key = ‘_wp_attached_file’

    now everything works PERFECTLY except that I am not getting the price of the items or the product code. can anyone please help me as I have no idea where to look for those columns?

    I didnt change anything. The entire database was installed using defaults. (according to the guy who did the previous install)

    as of now I get the Title the Description and the product images. please help 🙁 thank you so much in advance

    https://wordpress.org/plugins/woocommerce/

Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
  • The topic ‘MYSQL Script’ is closed to new replies.
Skip to toolbar