Last week I spend doing one of the challenging things in my programming career : OsCommerce One of the free, open source , Shopping cart in PHP and mySql.

At first it seems little complicated, but later on as I spend few hours I got the feel of it and see its working, My first opinion about it changes. Whats my first opinion that it is one of best code software..

It organization is much more complex than it should be, I provide few things for me for customization than the complexity it contain. To add the custom product attributes I have to insert data in as many as 5-6 tables.

Seems exciting …lol
this is where I recall the use of Store procedure in Ms SQL Server which are useful in these situations.

Anyway If I got time I will try to put a guidline for those who need to edit shopping cart in Oscommerce.

Sumit Gupta