Hello, Could you guys please advice me on which shopping cart is better?
ShopSite Pro vs CRE Loaded B2B

Here's the full feature list for both of the carts:
http://www.creloaded.com/pages.php?pID=11&CDpath=1_64_6
http://shopsite.com/scpro.html

Thanks alot, and I appreciate your help.

Please let me know if you know of a shopping cart better than these 2.
Also, I'm looking for a cart that allows me to have an affiliate program, and from what i understand - a cart that creates static html product page is good for the search engine?

I don't think that any shopping cart software produces static pages LOL Maybe they appear to be static for search engine spiders and people (have .htm extension), but they're actually generated on-the-fly by scripts anyway.

That static look ain't so hard to do. It's all about URL rewriting. Apache web server has a module called mod_rewrite, that can change URLs according to sophisticated rules. For example, if somebody asks for a page /products/356.htm, mod_rewrite changes it to /show_product.php?product_id=356 and the script does its job, and the requester doesn't even notice that.

Many shopping carts can do this, for example, Avactis (my cart of choice).

You can create a "shopping cart" with static HTML pages that would have the advantage of each page being 100% customisable on a page by page basis but the site would have very limited features as it would need to use JavaScript to give it any functionality. There would be no stock control or any of the other features that are common on most ecommerce sites. Any site that used this method would be like some of the home brew ecommerce sites of the 90s. I certainly wouldn't recommend this approach.
I think Hitch is probably right, by "static pages" you're probably referring to rewriting pages to remove the variables from the URLs e.g. remove productid=4536&cat=956 and replace it with something more meaningful to a bot. Whether the extensions is html, php, asp or whatever makes no difference as Googlebot and the other spiders are smart enough to not get tripped up by this.

__________________
Lawrence