Using WP All Import csv import plugin for wordpress to daily update products on large ecommerce site. Category naming and other issues.

[weebro]

We have just got an automated solution working to upload about 4000 products daily to our site. We get a CSV file from the wholesalers server each day and the way they have named products and categories is not ideal.

Although most of the products remain the same (don't need to be over written)

Some will go out of stock or prices may change etc.

Problem is we have no control over the csv file so we need to keep the catagories they have given us. Might be able to create new catgories and have products listed under multiple categories?

If anyone has used wp all import or has knoledge in this area please let me know. I have plenty more questions but this should start the ball rolling!

Thanks in advance mozzers

[BlueprintMarketing]

are you using Woo commerce? I think you are trying to import the csv  file like a website however I have no idea what you're actually doing.

Where are you importing it into what software plug-in?

There are better methods including ones that will check with an API determine if the price or stock has changed and update accordingly. woo Commerce is the best word press e-commerce software on the market in my opinion. It has a lot of plug-ins  go to woothemes.com search for woo commerce and look at all of the plug-ins that offers.

I have done what you're talking about with another e-commerce website and it was fairly simple however it seems like you have more politics in play and they expect you to use what they have created.

I would need to play by play of software to software exactly what's occurring exactly what you're doing to import exactly what e-commerce plug-in you're using?

There's a lot of questions.

Sincerely,

Thomas

[BlueprintMarketing]

http://www.webgility.com/woocommerce.php

http://www.woothemes.com/product-category/woocommerce-extensions/

http://www.storeapps.org/product/smart-manager/

http://docs.woothemes.com/document/woocommerce/

http://winkpress.com/ecommerce/shopping-cart/woocommerce/

http://winkpress.zippykidcdn.com/wp-content/uploads/2012/05/woocommerce-product-variations.png

This is a photo of wink press please notice the content delivery network and name of the host

This may be the best a choice for e-commerce on WordPress as far as hosting goes so much you get tons of high quality perks plus outstanding private cloud hosting  along with it being backed by rack space, but meant for WordPress only. For e-commerce you can't go wrong with Zippy kid

https://www.zippykid.com comes with a free Cdn along with the new SPDY protocol to make using SSL Certs lightning fast

You might just need an import tool like this

http://www.woothemes.com/products/sequential-order-numbers-pro/

This controls inventory, customers, orders and ties into the Financials

http://demo.storeapps.org/wp-admin/admin.php?page=smart-manager-woo-demo

http://docs.woothemes.com/document/woocommerce/

This does it all and ties into github a fantastic way to update your website constantly with this type of information managed WordPress posts that integrate with. github  Zippy kid and WP engine.  Each is fantastic

https://github.com/woothemes/woocommerce

I think you can stop looking however and put away your spreadsheets if you can

http://www.webgility.com/woocommerce.php

I hope I have been of help,

Thomas

[weebro]

Hey Guys thanks for the help Yes I am using woocomerce.

The import is all set up and runs all by it''s self using cron

The problem is the category field in csv  cant be changed (at least not by the wholesaler ) so we would need to write some code to make that happen.

I might try adding some new categories and and still keep the old ones (otherwise) wordpress/woocommerce wouldnt know where to put the products.