cancel
Showing results for 
Search instead for 
Did you mean: 

Tracking varying inventory costs and vendors for same product using FIFO

Tracking varying inventory costs and vendors for same product using FIFO

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?

2 REPLIES

Re: Tracking varying inventory costs and vendors for same product using FIFO

Hi @evolveddistro,

 


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.
Best regards.
Gabriel

If my answer was useful, please give "Kudos" to this post.
If my answer helps you to resolve the problem, click on "Accept as Solution".

Re: Tracking varying inventory costs and vendors for same product using FIFO

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