Hello All
I hope this gets to the right people. I am having a really hard time getting an accurate COGS out of Shopify Admin.
We use the COGS report in Shopify to calculate P&L
I use Stocky to create Purchase Orders that feed into Shopify Admin.
We create the product in Shopify Admin
We create the PO in Stocky
We receive the products and it uploads to Shopify Admin.
When we repurchase an existing SKU the newest price over rides in Shopify Admin.
Example I purchase 10 of product X at $ 10.00 on Jan 1 2024
Shopify Admin and Stocky show product X at $ 10.00
We sell 3 leaving 7
I purchase another 10 of product X at 8.00
Stocky will now change the price to 8.00
I want to either see a weighted average of the price - about 8.80 - (Support says this is calculated in Stocky but will not feed to Shopify Admin) or FIFO accounting for this.
Support suggests manually calculating this and then uploading a CSV
There must be a better way
Any help would be greatly appreciated