Closed

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
N/A
Total Bids
24
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 :
Select
Name
Attrib. Set Name
SKU
Price
Qty
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