CSV import doesn’t work at all on hosted WP site

  • Hi all,

    I am having an issue with WooCommerce CSV importing!

    I have made a very basic WordPress site on Free Hosts EU (it’s just a client demo site, they have their own domain which has a live site on it but I don’t want to test anything there for protection etc) and installed WooCommerce. When I export products as a CSV from their existing site I cannot import them into the test site I’ve made. The CSV importer either hangs, or does not import all of the products.

    I have tried using two different CSV files, both much smaller than the original export. The original export was modified using Google Sheets, as advised by WooCommerce.

    CSV 1 (small): https://drive.google.com/open?id=1UajUk58lln48YjPZgtYmGkxLX1gxbWAr
    CSV 2 (larger): https://drive.google.com/file/d/1sIu_DpF3Y8fXwfiwIRE1tyHTmwoEiexC/view?usp=sharing

    If the CSV importer hangs on import it often corrupts my WordPress database on the Free Hosts EU site and I have to repair the MySQL database and reset its permissions to stop WordPress trying to reinstall itself.

    Then, if I look in my WooCommerce Products I can see that a number of products were imported before the importer crashed, but I cannot access these products (they don’t appear in drafts or anything). See a screenshot here: https://drive.google.com/open?id=1VjvILIPsAf6Y6W2ukQJ8OEkRvKz54rhX

    The small CSV imports OK but no products are viewable. The larger CSV just hangs on import.

    I have been able to export a CSV of products from their current site and import it into a site I’ve made locally on my machine using MAMP, however this is no good anymore because the client wants to be able to see the site and access the admin panel etc which they can’t do if the site is only able to run locally on my PC.

    I’m able to make products individually on my hosted site.

    Any ideas? I have tried everything that I can think of.

    Site URL and admin panel details available on request but will only be sent via private message for security reasons.

    Cheers!
    Jason

  • The topic ‘CSV import doesn’t work at all on hosted WP site’ is closed to new replies.