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 2

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

Welcome to the Magento Forums. Remember to introduce yourself and read the Magento Forums Guidelines.

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