PHP/MySQL shopping cart - any recommendations?

[Crazy_Fool]

i'm looking for a good shopping cart, ideally php/mysql. it'll need
to handle up to 10,000 products. can php/mysql handle that? the main
thing is that the scripts and database can handle the number of
products. there will be about ten categories with about 1000 products
in each.

it doesn't matter what the credit card payment parts do as we have
that under control.

i'm no stranger to e-commerce and shopping carts but have only used
ASP/Access/SQL server on windows servers for bigger sites or Perl for
smaller sites. it's time to look at the PHP/MySQL combination to see
what that can do.

so far i've found phpmyshop and eztrade. any others? it would be helpful if it was also spider friendly! if all else
fails i can switch to actinic.

[sugarkane]

> up to 10,000 products. can php/mysql handle that

Shouldn't be a problem on a decent server / host. I've a database of over 300k emails on a local machine, and 'sensible' queries return results almost immediately.

[Trisha]

I'm using OSCommerce (I'd recommend version 2.2)

Trisha

[mole]

>handle up to 10,000 products

no problem. Have a look at [mysql.com...] for just one example of a fair sized MySQL database.

Simon

[Otaku]

PHP/MySQL is quite a popular combination these days and yep, it works great and lots of e-store scripts made using them.

As for the choice... go to ShoppingCartReviews.com and have a good time.... Personally I stopped at Avactis 'cos I needed easy customization, but it costs money, and if you want Open Source solution then go for ZenCart (its setup is a mess though)