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
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?
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