We need a reorder script made that works with our magento shopping cart. It should work as follows:
FIND THE RATE OF SALE
Divide the number of items sold per SKU from our database in the last 30 days by 30. This will calculate the Rate of Sale. Ex: 15 sold in 30 days = (15/30 = 0.5). Rate of sale is 0.5.
Once you click the “What to reorder” button, it should show us what we need to reorder by calculating:
1) If it needs to be reordered
2) How many to reorder
1) IF IT NEEDS TO BE REORDERED: IF (current qty)X (Rate of Sale) < Lead Time, then you need to reorder. If its not less than the lead time, you do not need to reorder.
To calculate HOW MANY WE NEED TO ORDER: (Rate of Sale)x(Lead Time)
Here is what the page should look like: http://tinyurl.com/prajg2
When you click “What to reorder”, it should show which SKUs need to be reordered, the quantity to reorder, then in the other columns: the current stock level, the rate of sale, and if it has been ordered.
The lead time should be gathered from this page which needs to be created as well. It should be a page with all of our skus listed by category and then we can fill in the “lead time” column.
http://tiny.cc/jyqpE
If you check the “ordered” box and hit submit, it should go down below into the “ordered” section so that it does not show up again when you click “what to reorder” next time.
If you click the check box that it has been received and submit it, it should be removed from this section and can be reordered. If you read this far, start your bid with the word “readit” so I know you didnt just blindly bid.