Can’t download products CSV

  • Resolved karyls

    (@karyls)


    6 years, 4 months ago

    I am moving a WooCommerce site and need to download the product information from the old site to go on the new site. I only need the products & information associated with products although I do not need the images.

    The old site is hosted on GoDaddy. When I try to export a csv via the WordPress importer, the csv comes up blank.

    I tried a store exporter plugin called ‘Store Exporter’ and get the error:

    Internal Server Error
    A WordPress or server error caused the exporter to fail with a blank screen, this is either a memory or timeout issue, please get in touch so we can reproduce and resolve this

    I changed my php.ini to:

    cgi.fix_pathinfo = 1 (was already there)

    memory_limit = 456M
    upload_max_size = 64M
    post_max_size = 64M
    upload_max_filesize = 64M
    max_execution_time = 300
    max_input_time = 1000

    and still cannot download the products. Same error. GoDaddy server error logs are useless – I cannot access them.

    If the product information can be extracted from the database, I don’t know how to do this. I have no experience with MySQL.

    There are 1200 products in this site and I have no idea how to get them, any advice would be greatly appreciated. Re-doing 1200 products would be a nightmare to say the least.

Viewing 9 replies - 1 through 9 (of 9 total)
  • Dustin Hartzler

    (@dustinhartzler)

    Automattic Happiness Engineer

    6 years, 4 months ago

    It sounds like your server is timing out before the export can be completed.

    Would it be possible to clone your site and install it on a different server? You can use a tool like Duplicator to make an exact copy of your site, then you can start making modifications.

    Here’s a how to guide to make the clone:
    https://optimwise.com/copy-migrate-wordpress-sites-with-the-duplicator-plugin/

    Thread Starter karyls

    (@karyls)

    6 years, 4 months ago

    Thank you, but I only need the products. The new site has been built, I do not need a duplicate. The original site was 2 databases on two platforms and I made it a single platform and database. I went round again with the host and the bottom line is that I am having to re-add all the products manually. It’s a nightmare and my income so I’m very bummed.

    don’t build a store on Godaddy. I didn’t pick it and wish I could move to a new host.

    Dustin Hartzler

    (@dustinhartzler)

    Automattic Happiness Engineer

    6 years, 4 months ago

    Could you still use the same plugin and duplicate to a different server just so you could export the products without running into the timeout error?

    And are you exporting from the Products area of your site? Or the WordPress Exporter? I’d recommend trying from the Products area and see if that export can be completed.

    Thread Starter karyls

    (@karyls)

    6 years, 4 months ago

    I tried both the products and the WP exporter. Neither worked.

    I tried two migration plug ins and only asked for small packets of products. Both stopped.

    I upped the server timeout. Didn’t change anything.

    I will try the duplicator on another server but the site is on GoDaddy so I don’t understand how it wouldn’t still time out or the upload to the new site won’t time out…but I will try anything. 🙂

    I did get a backup of the DB but can’t find anything on how to extract only product info. I have a complete site backup which I can try restoring it on another server. That’s a good idea, thank you.

    Dustin Hartzler

    (@dustinhartzler)

    Automattic Happiness Engineer

    6 years, 4 months ago

    If you have the database, then use that database to create a test site with only WooCommerce installed. You don’t need to do a full backup if you have a database. The site will look wonky, but the data will be there.

    Then try the WooCommerce exporter.

    Thread Starter karyls

    (@karyls)

    6 years, 4 months ago

    Thank you!! I managed to get the product files.

    I migrated old site on to a separate server using All-in-One WP Migration ( http://bit.ly/1wxxpR6 ). Wow, the plug in was a breeze. 5 stars and more.

    I was then able to export products via the WooCommerce exporter.

    I also made a copy of the products using WooCommerce – Store Exporter ( http://bit.ly/2Cz65e7 ) because it allowed me to save my SEO plug in settings. I will attempt to use this to import first but whatever works.

    Now I still will need to import the data to the new GoDaddy hosted site but will work on that tomorrow. I suspect it will be a fight.

    Meanwhile, I did collect the product data which was crucial. Thank you so much for the advice. 🙂

    Thread Starter karyls

    (@karyls)

    6 years, 4 months ago

    update: I was able to upload products to the new site without problems. The WooCommerce generated csv product data worked out better than the Store Exporter.

    Thank you for the advice. You saved me huge amounts of worm and my sanity.

    Thread Starter karyls

    (@karyls)

    6 years, 4 months ago

    resolved

    Dustin Hartzler

    (@dustinhartzler)

    Automattic Happiness Engineer

    6 years, 4 months ago

    Perfect! Marking as resolved.

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Can’t download products CSV’ is closed to new replies.