WordPress.org

Ready to get started?Download WordPress

Forums

Woocommerce CSV importer
[resolved] CSV import error (18 posts)

  1. Abdul Awal Uzzal
    Member
    Posted 1 year ago #

    Hi,
    I have installed the plugin in wp version 3.4.2 . I have this csv for testing initially http://demos.softwareinbangladesh.com/dvd/csv-1.zip
    But when I try to upload this it shows this error
    Warning: Invalid argument supplied for foreach() in /home/softwar/public_html/demos/dvd/wp-content/plugins/woocommerce-csvimport/include/woocommerce-csvimport-functions.php on line 109

    Can you please help me fixing what's the problem ?

    Thanks in advance for help

    http://wordpress.org/extend/plugins/woocommerce-csvimport/

  2. Abdul Awal Uzzal
    Member
    Posted 1 year ago #

    When I upload import.csv that comes with the plugin , it works great.

    But after customization it doesn't work anymore.

  3. allaerd
    Member
    Plugin Author

    Posted 1 year ago #

    Hi there Abdul,

    I checked you're file. It's fine but it has the wrong line endings. Open you're file in you're text editor and convert te line endings to unix style.

    I tried it and i have now 3 nice product in my webshop with Dalmatians :D

  4. Abdul Awal Uzzal
    Member
    Posted 1 year ago #

    Hi Allaerd Mensonides,
    Can you please give me the customized version of csv file which worked ??

    So that I can understand how to make it work.

    Thanks a lot for helping.

  5. allaerd
    Member
    Plugin Author

    Posted 1 year ago #

    You can download it here

  6. allaerd
    Member
    Plugin Author

    Posted 1 year ago #

    or download the zip here

  7. Abdul Awal Uzzal
    Member
    Posted 1 year ago #

    Actually I am not sure what you did.

    Can you please describe me the process ??

    Thanks a lot for spending your valuable time in hwlping me.

  8. Abdul Awal Uzzal
    Member
    Posted 1 year ago #

    Fixed it.

    Thanks a lot.

  9. allaerd
    Member
    Plugin Author

    Posted 1 year ago #

    hehe,

    even did something better. Try version 0.5.4 i added an option in the settings page where you can select to auto detect line endings!

    It should work now with most files!!

    but glad you solved it you're self a well!

  10. Abdul Awal Uzzal
    Member
    Posted 1 year ago #

    Hi Allaerd,
    ANother question for you. Do I need to fill up all the fields in a csv file ??

  11. allaerd
    Member
    Plugin Author

    Posted 1 year ago #

    Hello,

    You do not need to have all the fields. The name, description and SKU i would recommend!

  12. Abdul Awal Uzzal
    Member
    Posted 1 year ago #

    I want to have name, category, price & image. Can you kindly send me a format for this ?
    I have this (http://demos.softwareinbangladesh.com/files/p.zip) but not working, so I need your help.

    Thanks

  13. allaerd
    Member
    Plugin Author

    Posted 1 year ago #

    hi Abdul,

    I tried you import and it worked fine. Remember to set the field separator too a comma. If you do not supply the SKU every time when you import new product will be made. The SKU prevents this. instead of insert it will update!

    title,Description,short_description,Category,stock,Price,regular_price,Sales_Price,weight,length,width,height,sku,Picture,tags,tax_status,tax_class
    101 Dalmatians [Platinum Edition] [2 Discs] [DVD],,,Kids & Disney,,9.99,,,,,,,,http://i1276.photobucket.com/albums/y469/abamedvds/DPekSKhgGClW1kkuwOrYqSndEbHQ9MqOfdX_zps67f4916b.jpg,,,
    101 Dalmatians 2 Patch's London Adventure DVD,,,Kids & Disney,,9.99,,,,,,,,http://i1276.photobucket.com/albums/y469/abamedvds/lCxtD2Gm23_Qse0Fe9-_XQmiJVKR5TW0HjB_zps61aab1ab.jpg,,,
    101 Dalmatians 2: Patch's London Adventure [Special Edition] [DVD],,,Kids & Disney,,9.99,,,,,,,,http://i1276.photobucket.com/albums/y469/abamedvds/lCxtD2Gm23_Qse0Fe9-_XQmiJVKR5TW0HjB_zps61aab1ab.jpg,,,
    101 Dalmatians Platinum Edition 2 Discs DVD,,,Kids & Disney,,9.99,,,,,,,,http://i1276.photobucket.com/albums/y469/abamedvds/DPekSKhgGClW1kkuwOrYqSndEbHQ9MqOfdX_zps67f4916b.jpg,,,
    15 Years After by Enigma Audio CD,,,Concert & Music,,64.99,,,,,,,,http://i1276.photobucket.com/albums/y469/abamedvds/41FVbUFSHaL_zps65e54ea3.jpg,,,

    These lines i tried. You can see the result here

    The link will be updated shortly! Soo check it today :D

  14. Abdul Awal Uzzal
    Member
    Posted 1 year ago #

    You mean I need to add SKU for all products ??

  15. Abdul Awal Uzzal
    Member
    Posted 1 year ago #

    In my site, when I upload the codes you mentioned in last comment it's taking only 1 product. The last one.

  16. allaerd
    Member
    Plugin Author

    Posted 1 year ago #

    it uses the sku for updating the lines when you run it more than 1 time. So if you only upload it once. delete all you're products and upload it. When you upload it multiple times....i need the sku to be there!

  17. josephjrobison
    Member
    Posted 1 year ago #

    I tried the auto detect option, but still after I upload, my products are not showing up! I sent you an email too. Thanks!

  18. allaerd
    Member
    Plugin Author

    Posted 1 year ago #

    Hi josephjrobison,

    I'll check youre mail this weekend. Did you include you're csv file?

    Allaerd

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic