Help Bulk Uploading To WooCommerce

8 years ago

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.

Thanks

Signature

Premium WooCommerce & WordPress Plugins $10/ea. or FREE With Membership. PluginForage.com

{{ DiscussionBoard.errors[10450142].message }}

nbatioco

8 years ago

There are some good plugins for importing huge list of wooCommerce products. I suggest visiting woothemes.com to check out there plugins.

Thanks

Signature

Need a Website? Get that website starting for $75!!!

{{ DiscussionBoard.errors[10450226].message }}

toivo

8 years ago

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?

Thanks

Signature

Cartoons For Web | Print Projects

{{ DiscussionBoard.errors[10450510].message }}

yukon

Banned 8 years ago

Originally Posted by toivo

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.....

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.

Thanks
1 reply

{{ DiscussionBoard.errors[10450515].message }}

toivo

8 years ago

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.

Thanks
1 reply

Signature

Cartoons For Web | Print Projects

{{ DiscussionBoard.errors[10450540].message }}

yukon

Banned 8 years ago

Originally Posted by toivo

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.

It's been a while since I've worked with WooCommerce but it's just folders & MySql database on the host.

The way I would do this is first create the 68 categories on Wordpress/WooCommerce as usual, save everything & then go to the host & use phpMyAdmin on Cpanel. Look for the WooCommerce database & export as a CSV file. That database/CSV file will show you the structure of the database that WooCommerce created when you setup the 68 categories via WP.

You can create all the data offline in a CSV spreadsheet & upload to the host phpAdmin database.

For the images, upload one image per each of the 68 categories you created via WP. Next, use FileZilla to find the WooCommerce image folders that WP created. Drag the WooCommerce image folders to your desktop via FTP. After you have all the images in their correct image folders offline drag each image folder via FileZilla/FTP back to your online host. If I remember correctly WooCommerce creates 2 or 3 image sizes so make sure you have the correct image size folder/s.

Regardless which route you take it's a lot of work for 4,800 images/products but If you use FTP it's going to be way faster once the basic stuff is setup (ex: image folders, CSV file).

Thanks

{{ DiscussionBoard.errors[10450558].message }}

toivo

8 years ago

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.

Thanks
1 reply

Signature

Cartoons For Web | Print Projects

{{ DiscussionBoard.errors[10450598].message }}

yukon

Banned 8 years ago

Originally Posted by toivo

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.

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.

Thanks

{{ DiscussionBoard.errors[10450631].message }}

Help Bulk Uploading To WooCommerce

Trending Topics

Newbie

How did you turn it all around?

A healthy fascination for Hollywood...

Any thoughts on golf's latest phenom...Scottie Scheffler??

best high quality crypto traffic.