Purchase Orders updating Cost of goods

Highlighted
Excursionist
17 1 3

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

 

3 Likes
Highlighted
New Member
2 0 0

Did you get any solution to this?

0 Likes
Highlighted
New Member
6 0 0

Did you find any solution for this?

0 Likes
Highlighted
New Member
1 0 0

Still no update/response from Shopify, huh?

0 Likes
Highlighted
Shopify Partner
127 0 14

Hi, my app Simple Purchase Orders can definitely meet your shop's needs. It allows you to set up suppliers and import products and set cost prices. You can then automatically generate purchase orders from orders your customers make and it will import all of the items they order and their address and email it to your supplier. It can also handle splitting orders into multiple POs where the items have different suppliers. This should help you reduce time spent fulfilling orders and eliminate mistakes.

Please check it out and let me know if you have any questions

0 Likes