I need the following requirement to be converted into all project management documents with all details as per se.
I am an owner of a webshop based on Magento, and I need a custom work to get some reports.
I need an external php file with some filters and show on screen the following data, with the option to export to CSV
Filter 1: Select box with tree options: Show Orders, Show Invoices, Inventory
Filter 2: Date from - to
Filter 3: Order Status (no need for "Inventory")
Filter 1: show orders. I need the following info on screen:
ORDER ID - STATUS OF ORDER - DATE - TOTAL ITEMS - TOTAL WEIGHT - SUBTOTAL - SHIPPENT COST - TAX - GRAND TOTAL - COUNTY
Filter2: show invoices. I need the same, but only the orders that are invoiced.
INVOICE ID - DATE - TOTAL ITEMS - TOTAL WEIGHT - SUBTOTAL - SHIPPENT COST - TAX - GRAND TOTAL
I need at the end a resume of the data i´m showing on screen:
TOTAL ORDERS (INVOICED OR SIMPLE ORDERS), TOTAL ITEMS - SUBTOTAL - TOTAL SHIPMENT COST - TOTAL TAX - TOTAL GRAND TOTAL
Filter3: inventory (we have a lot of grouped products)
ID - SKU OF PRODUCT - NAME OF PRODUCT - QTY SOLD - WEIGHT.
Only Magento experienced developers (Backend).
Thanks and Regards