osCommerce Repair & Customization

Experienced osCommerce programmer needed to repair and customize an existing website ported from bCentral. The existing site intermittently fails to process transactions due to SQL errors. That needs to be fixed so that 100% of transactions process. The site may need [login to view URL],4255/category,1/search,Linkpoint Linkpoint API installed - right now the client must manually batch transactions. I would also like the following contributions added to the existing installation (if you have better solutions, I'm open to hearing about them, overall functionality is key): [login to view URL],3220 - Points & Reward module [login to view URL],3141/page,3 Add comments to invoice [login to view URL],355/category,all/search,store+name Purchase without creating an account [login to view URL],207/category,all/search,meta+tags Creates title tags, keywords and item descriptions on a page by page basis [login to view URL],1709/category,all/search,meta+tags Article Manager [login to view URL],5080/category,all/search,SEO Search engine friendly URLs, [login to view URL],3439/category,all/search,SEO Creates a Google friendly Site Map [login to view URL],3849/page,19 Export customer data into Constant Contact Once everything is installed, the site must be tested to ensure all features are functional. We'll also want to customize the headers and footers, although I'm open to a price that includes a new template design. This project must be 100% complete on or before 6/3/07. Please do not bid if you are unable to accomplish this within that timeframe.