magento backorder report to show stock shortfall

This project received 24 bids from talented freelancers with an average bid price of $571 USD.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
Total Bids
Project Description

we have magento ce 1.7 running 4 shops on 1 instance of magento.

we have 100,000 SKUs but only 100 orders each day.

we allow backorders and so we need a report to show products on customer orders where stock qty is less than the total orders qty...

we would like to see a new datagrid view in catalog similar to 'Manage Products' and having the fields :



Attrib. Set Name




Reqd <- this is a new field that would represent the shortfall

year <- this is a new field for the qnty sold in the last 12 months

Supplier <- this is a value from a custom attribute

the Reqd field would contain the count of each SKU contained in open sales orders (status=processing) less the qnty in stock (Qty)

we require an export to pdf feature to list all the items selected after applying filters to the grid.

this pdf can share the same layout as the default invoice pdf

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online