Import get stuck soon after start

  • Resolved fabiopwl37

    (@fabiopwl37)


    7 years, 3 months ago

    Hello,

    I am trying to import a large amount of products, but the importer keep getting stuck soon after starting. the loading bar animation is still going, but after an overnight 15 hour import only the first 100 or so products were imported. I noticed that during testing, if i stopped the import and re-ran, it would get farther along, but only for 30 or so more products and then get stuck again. The CSV is in UTF-8 comma delimited format and has all of the appropriate fields.

Viewing 7 replies - 1 through 7 (of 7 total)

  • Hello fabiopwl37,

    – Try increasing the PHP memory and max_execution_time of the site.
    – Check the CSV file where it is stopping importing. It might have any special characters or any invalid formats.
    – Kindly check the log file for the reason of stopping the import process.
    log file: WooCommerce–> status–> logs–> csv import. You will get to know the cause of the issue.

    Regards,
    Veeresh
    Team XA

    Thread Starter fabiopwl37

    (@fabiopwl37)

    The log has a few entries that look like this:

    2017-08-28T21:04:02+00:00 DEBUG Finished processing products.

    that occur after each interval of 10 products has been completely imported. Everytime the import has froze, it happened right after one of those logs.

    There are no ‘out of memory’ indicators in the log either. The PHP memory is at 256 MB. Is this typically enough?

    The entries on the CSV where the import freezes do not differ from any of the rest either.

    • This reply was modified 7 years, 3 months ago by fabiopwl37.
    • This reply was modified 7 years, 3 months ago by fabiopwl37.

    Hello fabiopwl37,

    kindly check the issue with the latest version of the plugin v.1.3.8
    If you face the same issue, please share your CSV file to check it.
    (you can share a link of google drive by saving your csv there. and we will download it from our end. once we download and confirm, you can delete the link)

    Regards,
    Veeresh
    Team XA

    Thread Starter fabiopwl37

    (@fabiopwl37)

    I am using v.1.3.8

    here is the link:

    https://docs.google.com/spreadsheets/d/19i65PJaI0hRTe3caT5X3hRm9tUtSWnKv7h-MVtMppmQ/edit?usp=sharing

    Hello fabiopwl37,

    We performed importing your CSV in our demo site.
    It went well and imported 200+ products in 3-4 minutes time. We did not find any difficulty in that.
    kindly check it here: https://snag.gy/hiGlMX.jpg

    Please check your server error log for the cause of the issue.

    Regards,
    Veeresh
    Team XA

    Thread Starter fabiopwl37

    (@fabiopwl37)

    Hmmm very interesting. Well, the server log isn’t showing anything significant. I just tried deactivating all of my plugins except for yours and WooCommerce, but the same thing happened.

    Here is a link to part of the plugin error log I put on google docs:

    https://docs.google.com/document/d/1RlYm5I4tDdgM97ZCCIhx8czBNv1RQSMkrwCINsFk-QM/edit?usp=sharing

    Maybe you guys can find something that’s escaping me. The only errors I am noticing are the ones for the images. I made a folder in my uploads folder and stored the images there. The file paths are directed to that folder in the csv correctly and it is pulling them. We had 15000 products and only 5000 images so the ones that are getting errors in the log are because the images simply don’t exist.

    • This reply was modified 7 years, 3 months ago by fabiopwl37.
    • This reply was modified 7 years, 3 months ago by fabiopwl37.

    Hello fabiopwl37,

    kindly try importing your products without images.
    (Ignore images column and check it) If the file gets imported, then try updating SKU column and Images column only.

    Regards,
    Veeresh
    Team XA

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Import get stuck soon after start’ is closed to new replies.