Help Bulk Uploading To WooCommerce

by 8 replies
8
I have images for 4800 products I want to put on my WooCommerce store....is the a resource to visit for getting assistance with this? I manually uploaded 67 images on my own, but it is so grueling. Any comments on where to go for help would be appreciated.....
#website design #bulk #uploading #woocommerce
  • [DELETED]
  • There is no quick way to do this, however there is a better way than uploading them one by one. You can create a CSV file and upload using something like the Product Suite CSV Import plugin for WooCommerce. You will still have to take the time to create the CSV file for all 4800 products, but that should take a lot less time than uploading them one by one.
  • There are some good plugins for importing huge list of wooCommerce products. I suggest visiting woothemes.com to check out there plugins.
  • went to woothemes and appreciate that info....unfortunately, they have no plugin for uploading over 4,800 products. Also looking at the product suite CSV import, I am wondering that if you use it, you need to first make an Excel file, correct? Is that a necessity? I mean, you need to make a file in Excel? If so, what is the best tuutorial in creating an actual Excel file? And, are an Excel and CSV one in the same?
  • Banned
    Just create folders on your offline desktop for image categories then FTP (FileZilla - Free) the folders to your host. As easy as drag & drop. Done.
    • [1] reply
    • thanks Yukon. I don't think that is going to work because each single image needs it's own title, short description, tags and then the actual image file name goes into the WooCommerce "File Name [?]" (in "attributes" settings) box and is supposed to be added to a single URL which works in conjunction with a PHP script in the database (performing an action, whereby the "buyer" of my product, which is actually the cartoon itself, gets a clear hi-res image file that is emailed to them after payment)....this is why actually uploading all the images into over 68 separate categories is essential.
      • [1] reply
  • Is there a difference between CSV spreadsheet and an Excel file? I've been looking into that aspect of it, but no good tutorials....for instance, the image itself (doesn't get attached, right) but you input the title, short description, tags etc. in a single line in one of these? Let's start with the CSV/Excel file. Are these one in the same or both different? I found some videos on how to make one, of course, the accent is so broken English or very low and you simply cannot follow it....are there good quality, reputable sites that can be recommended? I find some of these videos, but are so muddled, I get depressed and figure let some data entry professionals handle it.....but would attempt it if there was a clear, concise starting point.....which is rare.
    • [1] reply
    • Banned

      A CSV (Comma Separated Value) file is simply a plain text file where each column is separated by a comma (). CSVs are very common, personally I use Notepad++ for a text editor & Open Office for spreadsheets. A CSV file is a spreadsheet so it will open in Excel.

      Here's a screenshot of a CSV file in Open Office spreadsheet, same as Excel. The plain text code below the screenshot is the same CSV data viewed in a text editor (Notepad++), as you can see it's very basic & consistent (data comma data comma data). Commas create new columns on CSV files.






      Code:
      -85.773251,33.614002,"Camping World-Anniston,AL"
      -86.766749,33.149808,"Camping World-Calera,AL"
      -85.432878,31.219628,"Camping World-Dothan,AL"
      -87.7085,30.5358,"Camping World-Robertsdale,AL"
      -94.149336,36.259039,"Camping World-Lowell,AR "
      -92.139939,34.784054,"Camping World-North Little Rock,AR "
      -112.282775,33.459127,"Camping World-Avondale,AZ"
      -111.81041,35.229,"Camping World-Flagstaff,AZ"
      -111.784088,33.415459,"Camping World-Mesa,AZ"
      -110.917792,32.17563,"Camping World-Tucson,AZ"



      Again, CSV files are plain text, that's what goes in the WP/WooCommerce MySQL database. The images go in folders on your host. The database (CSV spreadsheet file) will have a column for product image URLs. The image URL is plain text which again is what goes inside the CSV file which in turn is uploaded to the online MySQL database on your host via phpMyAdmin or whatever you use, phpMyAdmin is very common on web host Cpanels.

Next Topics on Trending Feed

  • 8

    I have images for 4800 products I want to put on my WooCommerce store....is the a resource to visit for getting assistance with this? I manually uploaded 67 images on my own, but it is so grueling. Any comments on where to go for help would be appreciated.....