The developer I hired to do this job completely flaked out on me and my client is now getting annoyed (I don't blame him - he's losing money by the order). I need a RELIABLE expert in PHP, MySQL and osCommerce for this job who will get the job done ON TIME.
The site is a wine shop. It runs off of a hacked up version of osCommerce. For example, to update inventory, a CSV file is uploaded and certain sections of the admin area are disabled or missing. So really it's been put together with custom PHP / MySQL development. This is unfortunately the way we inherited the site and the client doesn't want to switch to a better alternative just yet.
There are two things that need finishing up:
1. Coupon code fixes for wine cases:
The sit has coupon codes set up to give $x off per bottle. That part seems to work fine - gives a discount for each bottle. If someone purchases a case, there's a different price applied to that (with or without the coupon). At present the coupon is giving the discount to the case pricing as well, which isn't exactly what he wants. The coupon should discount based on the regular per bottle price x 12. Example from the client using a $2 coupon as reference:
Let's say you order a case of wine at $[url removed, login to view] For ordering a case you get a per bottle price reduction so the case price is $139.92, not 12 X $11.99 = $143.88. What we want to do is drop $24 off $143.88, not $139.92.
We need it to work so that when a buyer orders one case and then enters the coupon code on the credit card page, the next page will show the case price as $143.88 less $24. And not show the case price as $139.92 less $24, which it does now. Of course, if the buyer does not enter a coupon code, the case price should come up as $139.92. Seems doable.
2. Shipping Issues
Presently the website is quoting zero charges or incorrect charges to people placing orders. It needs to be corrected so that shipping charges are correctly coordinated between the Shipping Cost Chart and the state that goods are shipped to.
Also regarding shipping, there are some minor updates that need to be completed:
(a) Go to the website's UPS Shipping Cost Chart (About Us>Shipping>UPS Ground and UPS 2nd Day Air) and add the following states to the bottom (7th) row on the chart: AZ (Arizona), KS (Kansas), TN (Tennessee) and ME (Maine). Make sure charges apply for both UPS Ground and 2nd Day Air. While there, please place a comma on the Chart between MI and SC;
(b) Program the website so that orders from the 35 listed states (Hawaii is not included) are charged the amounts quoted on the charts;
(c) Add to the Shopping Cart a listing that shows the Shipping Charge along with the wine cost, tax and total.
I have FTP, cPanel and shop admin access to the site. I also have some information from the developer who WAS working on it to help get started.
As for timeline, I need it done in the next few days. Deadline is FRIDAY.
Please only bid if you have solid experience in osCommerce / PHP and can communicate via Google Talk and email.
Edit: The deadline is for Friday, Pacific Time (-0800)
7 freelancers are bidding on average $549 for this job
We are very expert on oscommerce,zencart,virtumart, magento and shopping [url removed, login to view] have done many ecommerce related [url removed, login to view] did many complex work of oscommerce,zencart,virtumart, [url removed, login to view] from my previous experience I Mere