Fixes to include:
1.) Getting UPS XML to work. It is currently installed and was working, however one of our recent contrib additions must have conflicted as we now get: Rating and Service [url removed, login to view] errors.
2.) Verify shopping cart PayPal set-up is correct as we recently had a customer place an order and pay via PayPal echeck. We saw the payment but had no copy of the order in our order history nor did we receive the normal email confirmation of the order.
3.) Correcting database errors that are shown for certain categories of the admin:
a) Customers Orders-Totals
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*) as total from customers c, orders_products op, orders o where c.customers_id' at line 1
Mods to include:
1.) Change Order ID setup so that it starts at order # 1000 instead of 1.
2.) Successfully install Discount Code module that allows us to create coupon codes, gift certificates, account credits.
Successful bids should include ability to handle all listed mods/fixes. We would like 1 programmer to handle all tasks.
PM with any questions or additional detail needs.