Purchase Orders updating Cost of goods

Highlighted
Excursionist
16 1 0

Hey all,

 

I'm facing the following problem and would love to hear what i could do.

 

Every 2 weeks I get new inventory in. I have about 200 different products each time so it's a lot of work updating the stock list. What makes it a bit more complicated is that the cost of the good per product changes every time due to quantity discounts, currency exchanges and shipping costs (fluctuating fuel prices)

 

Now i manually open every product. Update the quantity and update the cost of goods. Where i make an average of existing and new stock

Eg:

Existing stock = #5 and cost of good = 5$

New stock = #10 and cost of good  =7$

New updated inventory is #15 with cost of good 6.34$

 

I would have loved to automate this a bit more, i just recently found Purchase order functionality in shopify allowing you to update the inventory quantity automatically when the items come in and it also allows you to add a cost of goods in the PO. But this cost of good is not automatically added to the product itself. This keeps on showing the original 5$ cost of good while inventory quantity gets increased to #15.

 

Anybody have some tips how i can make my life a bit easier?

 

Kind Regards,

Monica

 

0 Likes