WordPress.org

Forums

WooCommerce - excelling eCommerce
MYSQL Script (2 posts)

  1. ruckus09
    Member
    Posted 8 months ago #

    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/

  2. ruckus09
    Member
    Posted 8 months ago #

    If I could get tags too that would be great but not needed

Reply

You must log in to post.

About this Plugin

  • WooCommerce - excelling eCommerce
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic

Tags

No tags yet.