Shopify Product Costs

Hi @oshaugry 

Check out this related Shopify topic: https://community.shopify.com/c/Shopify-APIs-SDKs/Product-API-does-not-contain-Cost-per-item-property/m-p/695549#M47186

Try using the Shopify Inventory API: https://shopify.dev/docs/admin-api/rest/reference/inventory

App API’s can be leveraged via Webhooks app steps in a Zap: https://zapier.com/apps/webhook/integrations#triggers-and-actions

Thanks @Troy Tessalone 

The first article was a little above my head.

Re: The second article, is saying to use the inventory as a place to put the cost of my item and then pull that information through Zapier? Please correct me if I’m missing this. 

If I’m correct, What do you recommend listing it under? Size, style, color, etc? Then next to it ad the cost of my product?

Also and additional info is appreciated.

Thanks

Ryan

orrect me if I’m wrong. 

@Troy Tessalone 

@oshaugry 

Try using the Shopify Inventory API: https://shopify.dev/docs/admin-api/rest/reference/inventory

App API’s can be leveraged via Webhooks app steps in a Zap: https://zapier.com/apps/webhook/integrations#triggers-and-actions

Hey @oshaugry, hope you’re well, I just wanted to check in here!

Were you able to get things working with the info from Troy, or can we still help out here with more info?

Hi William,

Troy was super helpful, but I do not understand where or what to do. i really need to have my handheld with this when it comes to being able to reference the item cost each time a new sale is generated. 

Help is welcome. Video is preferred. Also happy to jump on a video call.

Thanks,

Ryan

Hi @oshaugry!

Thanks for giving us an update on how things are going. Could you perhaps go back to the beginning and explain what you’re trying to do? I know that you want to send information of your Shopify orders to your supplier and that you aren’t seeing the cost of the item. Which Shopify trigger were you using in your Zap? And which actions? And can I double check if you mean the price of the item or the cost? That will give us a better idea of if this is something that you can do with Zapier or if you’ll need to use the Shopify API. Thanks!

Yes happy to give some context. 

When an order is placed I would like to send the cost of those items or my (COGS) and send that information to my supplier in their shopify store.

So it would like something like this.
James places and order on my site for product ABC. His order number is 001. James Paid $100 for Product ABD in Order 001.
The cost of product ABC is $50.

I would like to be able to pull that information ($50) through my shopify store and send that information into my suppliers shopify store. 

I currently am able to pass through orders from my shopify store to my suppliers, but I am unable to extract the COGS for my products.

Currently I’m using the Shopify order triggers so when an order is placed in my store + the order contains products from that specific supplier, the order currently passes through to my supplier’s shopify store with the entire TOTAL order amount. This throws off our accounts payable with our supplier so…. every time there is an order that comes through my site for this specific supplier, I have to log into the suppliers shopify store, duplicate the order and manually edit the amount  of that order to reflect the COGS for the products purchased.

I hope that gives some more clarity. I explained it as thoroughly as possible to give you an idea of exactly what I’m trying to do. 

I have the exact same need. Please let us know when is this updated.

Thank you,

AR

Thanks for reaching out, @arevilla! Of course, I’ve got your vote added to that feature request. We’ll be sure to send you an email and keep this thread updated as soon as we know more. 🙂