I have a live working OS Commerce 2.2 RC2 site.
This site is for an internal-company use; hosted on a Windows server.
I need to modify the order process by appending Department information to the order.
As I figure it, the following would need to be implemented:
The department would need to assigned, preferably via a pop-down, in the “My Account” information screen as well as the Customers screen in the admin.
Second, I also want to append the Department information to the ORDER. During the checkout process, the department should default to the customer’s department, but must be able to be changed if they require it. This is necessary because some employees order for different departments.
Finally, I need a report designed that will have the following information:
Orders_id, customers_name,delivery_name,department, date_purchased, products_name,product_price, products_quantity, and a calculated field of products_price*products_quantity.
Please note that I will only be available 9:00 am – 5:00 pm Central US time Monday-Friday to discuss this project. (Yes, I’ve had some bad experiences with programmers who only want to talk at 1:30 am on Sunday).
Also note that this is a live system. We’re going to have to use a little caution how and when we push changes. And, our IT staff is going to have to make any changes to the mySQL database structures ourselves; sorry, we can’t grant you phpMyAdmin privileges.
Also note that this site has already been customized somewhat, and for the most part, successfully. So, you can’t just go get a fresh release of 2.2 RC2 and make the changes to that.
On the bright side, this is far from the only change I need to make. I’ve been burnt before when I have requested more than one set of changes in the same bid; therefore, I’ll just stick with this for right now. Obviously, this could yield quite a few more simple projects for the right person or team.
This report needs to be selectable by date range.