Käynnissä

Create report is osCommerce/osMax

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!

Taidot: PHP, tietojärjestelmäarkkitehtuuri

Näytä lisää: create starting date of a month in php, create report, work based report, classification excel, software reseller, status create, create store name, create report excel spreadsheet, year date column, cross reference excel, oscommerce create custom, oscommerce products month, create custom products oscommerce, oscommerce table, class report, create table cart, asterisk statement, spreadsheet oscommerce, similar asterisk, need custom excel spreadsheet, create report php, report page work needed, excel retail report, software retail store, custom field oscommerce

About the Employer:
( 165 reviews ) Parrish, United States

Projektin tunnus: #4270096

Myönnetty käyttäjälle:

developershut

Hi, i am ijaz oscommerce/osmax expert, please check your inbox for detail

100 $ USD 1 päivässä
(53 arvostelua)
6.0

4 freelanceria on tarjonnut keskimäärin 133 $ tähän työhön

jackfromaus

HI there, yes I have a good knowledge of oscommerce. Let's talk through PMB....

250 $ USD 1 päivässä
(10 arvostelua)
6.0
sudhakarsp

Please see my private message

80 $ USD 3 päivässä
(54 arvostelua)
5.3
developerlance

FreeLance Professional.

100 $ USD 2 päivässä
(9 arvostelua)
3.4