Wordpress

[F1 Fan]

Hi All

Need some advice. Had a website designed to sell products online. What I would like to know is, is it possible to populate an excel list and upload it to WP adds products by pulling the info from the sheet? I currently have around 1000 products I need to add and it's very time consuming doing it individually.

In addition, can I?

Can I maintain pricing and stock quantity via Excel?
Can it show how many products there are in category, e.g. Vitaderm(35)

Any suggestions?

 

[rudig]

Hi All

Need some advice. Had a website designed to sell products online. What I would like to know is, is it possible to populate an excel list and upload it to WP adds products by pulling the info from the sheet? I currently have around 1000 products I need to add and it's very time consuming doing it individually.

In addition, can I?

Can I maintain pricing and stock quantity via Excel?
Can it show how many products there are in category, e.g. Vitaderm(35)

Any suggestions?

I looked into something CSV-like, WooCommerce had a plugin for $99.99.
Didn't find a free one.

Good luck!

 

[Other Pineapple Smurf]

Depends if the plugin used supports this feature.

A developer could customize the plugin using PHPExcel to upload your excel file and import it (I use PHPExcel for my development).

 

[F1 Fan]

And would the PHP file then load all the products onto the site?

 

[gkm]

You can maybe write a Ruby script to post the data for each line in your spreadsheet. Save the spreadsheet as a .csv then use something along these lines to fill your forms rapidly:
https://www.google.co.za/search?q=ruby+net+http+form+post
https://www.google.co.za/search?q=ruby+csv+file

 

[House]

Depending on what your MySQL table & field structure looks like, it could be fairly use to write a simple script that will update the fields by uploading the file.

 

[InvisibleJim]

You can also import a csv file into a MySQL table using phpMyadmin. No programming involved.

 

[SilverNodashi]

You can also import a csv file into a MySQL table using phpMyadmin. No programming involved.

This will be the easiest and cheapest way todo it. Look at the product table(s) to get an idea of the layout you need then re-arrange your XLS file to match the columns and import the data. It shouldn't take more than 30 minutes todo this

 

[AWD]

wp - there are a few different carts one can use - which one you using ?