Can i export products from phpmyadmin?

  • Resolved gerlucio97

    (@gerlucio97)


    5 years, 8 months ago

    Hi, i’m doing a local version of an site for an friend, and that site have a lot of products cataloged, but i don’t have access to the panel, or wp-admin (technical problem), but i have access to FTP and phpmyadmin. The question is if i can export (or generate a n csv file) the products via phpMyAdmin, I was able to download the images via FTP.

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

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

    (@rynald0s)

    Automattic Happiness Engineer

    Hi @gerlucio97!

    You can see if the following SQL command works in exporting the products from there:

    SELECT product.ID as product_id, product.post_title as product_name, replace(product.post_content, '"', "'") as product_content, product_sku.meta_value as product_sku, product_price.meta_value as product_price, product_weight.meta_value as product_weight
FROM wp_posts as product
LEFT JOIN wp_postmeta as product_sku ON product.ID = product_sku.post_ID
LEFT JOIN wp_postmeta as product_price ON product.ID = product_price.post_ID
LEFT JOIN wp_postmeta as product_weight ON product.ID = product_weight.post_ID
WHERE (product.post_type = 'product' OR product.post_type = 'product_variation') AND product_sku.meta_key = '_sku' AND product_price.meta_key = '_price' AND product_weight.meta_key = '_weight'

    Cheers!

    Rynald0s

    (@rynald0s)

    Automattic Happiness Engineer

    Howdy!

    We haven’t heard back from you in a while, so I’m going to go ahead and mark this thread as resolved. If you have any other questions please start a new thread.

    Cheers!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Can i export products from phpmyadmin?’ is closed to new replies.