I've spent 20 hours looking in to inventory systems for magento and can't find any thing that performs this seemingly simple task.
I need a system that allows me to track where my inventory comes from (vendors), and how much it sells for so I can track my margin. I need to assign COGS in a fifo fashion in cases where I am holding one SKU that was replenished by more than one vender.
So last week I bought 10 widgets from company A for $6 each
This week I bought 10 widgets from company B for $4 each
Today I sold:
6 widgets for $10
7 for $12
Company A gets logged for 6 widgets sold at $10 each and 4 at $12 each all costing $
Company B gets logged for the remaining 3 widgets at $12
10 widgets cost me $6 each
3 cost me $4
Quantity in inventory is now 7 widgets
Any ideas what extension could do this?
Since this has been posted several days ago, I would like to know if you were able to find the solution.
Please let us know.
No it hasn't. We are looking at Odoo as an option at this point. There doesn't seem to be any modules or built in functionality for Magento that can handle inventory in a sane manner. We are thinking of using Odoo for inventory and connecting that to magento