We need to a custom report added to the admin of our osMax store. We already have a similar report that can be used as a starting point, but we need new fields added to create the new report. The report should be able to be viewed on screen and also downloaded as an Excel spreadsheet.
Here are the fields that are needed in the new report (new items are marked with an asterisk, and the table/field they come from is included in parentheses where relevant.)
?Order_ID
?Status
?Product_ID
?Product_Model
?Date
*Year (based on Date column)
*Month (based on Date column)
*country_vl (orders/customers_country)
*class_vl (products/classification...but we really need to see the classification name, so it then needs to cross-reference to class/class_name)
*retail_vs_reseller (logic statement based on Customer_Group column: if Customer_Group = retail, enter "Retail" otherwise enter "Reseller")
Customer_Group
*customer_id_vl (orders/customers_id)
*customer_name_vl (orders/customers_name)
*customer_company_vl (orders/customers_company)
?Product_Name
?Product_Price
?Price_Paid
?Discount
?Product_Quantity
We're looking for someone with good knowledge of osCommerce/osMax cart, who provides good documentation of the work they're doing, and creates a well commented page. When placing your bid, please let me know how long you think the job will take you to complete. Thanks so much!