i can't import long data by the CSV

  • Resolved Richa Jain

    (@richa-jain)


    10 years, 5 months ago

    Hi,
    1. I am using this plugin. This is grate plugin but import more than 3000 records, it shows an error msg ‘something went wrong’ and my file is not imported.

    I set maximum upload limit and time by php.ini but still its not working.

    2. In my csv different products has same SKU, when i import file, ‘0(zero)’ post is assign in ‘product->categories’.

    Is there has any solution for this.

    https://www.ads-software.com/plugins/woocommerce-csvimport/

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author allaerd

    (@allaerd)

    1. there is no limit for the amount of rows. Please set the number to process to 5 and try again.

    2. This is a problem. The SKU is seen as UNIQUE. Doo it will update the other product!

    Thread Starter Richa Jain

    (@richa-jain)

    I want import more than 20,000 records by CSV.

    I set process to 50 and try on server.
    It shows i can import data till 64MB, and i imported 13MB data, after some times its shows error message ‘something went wrong’ and my file is not imported fully….

    I think its problem with php.ini, ‘max_time_execution’ or memory limit.

    My site is hosted on share server so i can’t change php.ini file, can i change it by code in my WordPress or theme.

    Plugin Author allaerd

    (@allaerd)

    so best to put the number of rows to 1.

    the 64 mb has nothing to do with it. This is just the max file size you can upload.

    So, please set the amount to 1, than you will not have timeouts

    Thread Starter Richa Jain

    (@richa-jain)

    Hi, allaerd

    Thank for reply

    I set number of rows 10 and its take 2 hours for importing 1 MB CSV file and it is still uploading.

    How can I reduce time limit so it can me imported 30 min or maximum 45 min.
    It taking so much time for importing, it is not good for my website.

    Please reply soon i am stuck very badly….
    ??

    Thread Starter Richa Jain

    (@richa-jain)

    My problem is not solved…….

    I have the same problem. Have imported 3.500 products all works fine.

    But the next day im making an import and it says its done but no product is online.

    After updating the plugin im getting error in my logs

    [Tue Jun 17 15:07:08.999176 2014] [:error] [pid 3532] [client 86.93.193.37:54640] PHP Warning: fgetcsv() expects parameter 1 to be resource, boolean given in /home/admin/domains/horeca-winkels.nl/public_html/wp-content/plugins/woocommerce-csvimport/include/class-woocsv-admin-import.php on line 122, referer: https://horeca-winkels.nl/wp-admin/admin.php?page=woocsv_import

    Had to shutdown the plug-in because the log file was 16GB big.

    Hope you have a solution

    KR Rory

    If you require assistance then, as per the Forum Welcome, please post your own topic instead of tagging onto someone else’s topic.

    This topic has been resolved.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘i can't import long data by the CSV’ is closed to new replies.