I've been able to do this.
The wordpressdatafeedimport.com software costs $137. Need I say more?! And who knows if it will even work? Personally, I wouldn't spend more than $50 on a data feed import unless I knew for certain that it would do the trick with my unique feed files.
Also, my suppliers regularly change their feed file format (for improvements), so what happens when I finally find something that works well, and then it suddenly stops working when the format changes (ie. different layout or delimiter change)?
I have a product feed that is in tab delimited format, and it contains about 700 products. I needed to be able to import everything at once, creating categories on-the-fly, sorting the products into their associated categories, defining price or shipping markups by percentage, and the ability to use variable tags in the post content that refer to their corresponding feed cell content. There was no way I was going to do this all manually. I refused!
At first, I assumed that there must be a WordPress plugin out there that would simplify this task, but the more I looked, the more it became apparent that I would have to settle for something less than what I wanted, or pay a high price for something that couldn't guarantee compatibility. In my search efforts, I gave up and just wrote the software myself, which I'm happy I decided to do since now I can import all different types of feeds without changing delimiters, column names, or moving columns around to suit the parser.
With most of the CSV parsing software available, you are still left with the arduous task of manually setting markups, manually creating categories, and manually sorting posts into their categories, not to mention changing the feed around to suit the parser, instead of telling the parser what to look for in the feed.
If you're in the same position that I was in, email me (user: seordin, account: gmail), and we can work something out.
Thanks for reading.
|