I have a heavily modified OSCommerce site which needs fixing. After register globals was turned off, occasionally a customers' city will not get added to the database. This happens with state information as well, although this was happening periodically before that.
An autofill feature for city/state based on zip code was custom coded for me, and it appears this may not have been thoroughly debugged prior to releasing it to me, or it was perhaps not made to be register globals off compatible. I suspect this is a very simple fix for someone with adequate debugging tools and intimate knowledge of OSCommerce.
There is also some logic and coding corrections to better handle errors during the checkout process. For example, if a customer makes a mistake by leaving out required information, they are returned to the same page and asked to make the required corrections. The problem is that all the fields are blank - it should contain the information that the customer had already input just before it errored out so they do not have to re-enter anything if possible. The other thing is that subsequent attempts after making the required correction(s), fails due to the email address already being in the database. First, I am not sure why the email address should be in the database in the first place after the form erroring out, since they are a brand new customer.
The checkout process was redesigned to make account creation a seamless part of the checkout process - it is automatic. Once the form is successfully processed, a password is automatically created by the program and then sent to them.
A project I plan to do later is redo the checkout process entirely so as to mimic something along the lines of zipzoomfly, but with the autofill feature. Successful bidder will have first shot at this and other projects I will post from time to time.
Must have good-excellent communication skills, honesty, patience, excellent debugging skills, and the ability to see the whole picture.
I prefer to get this fixed ASAP.