I have an osCommerce shop with number of contribution installed and I want to do one small
update. I would like to add one field to the orders table or one record type to the
orders_total table (whichever makes more sense) to store the actual "cost" of the order (ONE
amount that will reflect the cost of goods, shipping, fees etc). We will need to add a form
filed to enter this data to the system in two places
The default order preview page
[url removed, login to view];page=1&oID=123456&action=edit
And the "Edit order page" (contribution "order editor 5.x installed)
[url removed, login to view];page=1&oID=123456
Then I would like to create one report that looks very similar to [url removed, login to view] (in the admin
section) with the added data in a new column and the totals at the bottom. To generate this one
would select a start date, end date and one or more orders status. I have a screenshot of an
html mockup of this report.
In short, this project calls for making the necessary changes to 2 forms in the admin section
to write data into a new field in the database. Secondly, it calls for a new report to reflect
the new piece of data, which is generated upon user input of date range and order status.