I've spent pretty much my whole day so far looking for a good ecommerce solution, hopefully one that works with WordPress. I have about 300 products in a spreadsheet that I'd like to be able to import, and the products need to be searchable. This is what I've found out so far...
WP Ecommerce - no ability to import or search products
WP.osC - I could not successfully set up the database. Instructions are vague.
OS Commerce (without WordPress) - No product import ability. Navigation required to add products is painful.
osCommerce plugin by Tal Orlik - Says it pulls product listings into WordPress from an installation of OS Commerce. I could not activate it. It caused a fatal error when I tried.
WP-osCommerce plugin by Roya Khosravi - Supposed to work with WP.osC but since I couldn't get the latter to work, the former didn't work either.
FatFreeCart plugin by http://www.e-junkie.com - Allows you to add shopping cart buttons to posts. This makes the products searchable, but there is no product template. The only information that shows in the post is what you manually enter.
Does anyone have suggestions for a better solution? I have used Miva Merchant in the past and love the fact that you can export & import product, category, and order data and products are searchable, but the downside is that it requires Miva's proprietary database engine and the hosting company that the client's sites are on does not provide that. Miva hosting is sort of pricey.
Thanks for any insights.