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.

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