Can an app generate a custom inventory decrease report for CPB sales?

[KeebMaker]

Hello!

My company uses Custom Product Builder (CPB) to allow customers to create custom keyboards. We build these keyboards in our shop before shipping them out. CPB deducts inventory after each sale, but these are done via API and are not linked to any of the Sales reports that Shopify provides. The COGs report only shows us components that are sold individually, not through the custom products that CPB allows us to create and sell. I believe Shopify sees CPB inventory adjustments as "adjustments" rather than sales, and therefor ignores these types of inventory adjustments in the default Shopify reports.

What I need is a report that tells me how much each product in my inventory decreased in a given time period, regardless of whether it was decreased via API or Sale. I also need this to only show me how much it decreased regardless of how much it increased. If I sell 20000 "keycaps" (through CPB or individual product sales) in a month, then purchase 20000 "keycaps" to replenish that inventory, I still need the report to show me that "keycaps" were deducted by 20000 that month. I then hope to be able to see a real COGs report based on this inventory deduction report.

Do you know of an app that could generate this type of report for me?

[PaulNewton]

Hello @KeebMaker  usemechanic can be scripted to spit out data for custom inventory scenarios

https://tasks.mechanic.dev/?q=report 

It can make pdfs and has an integration for apps like the report toaster app.

You'd basically set it up to initially count the inventory and save it in cache  or in a metafield, then  update the adjustmented/changes/deltas (or current total) in a list when orders come in or inventory quantities change,etc.

I'm not sure if you'd be able to easily backfill the data before this initial count; pretty sure you'd have to parse all orders.

If you need something like this explored you can contact me directly for services.
Please provide context: store url, theme name, post url(s) and any further detail.

Contact Info in signature.

---

@KeebMaker wrote:

 I believe Shopify sees CPB inventory adjustments as "adjustments" rather than sales, and therefor ignores these types of inventory adjustments in the default Shopify reports

---

I'm assuming these adjustments are to the actual inventory items (components) and not solely to some placeholder product inventory the app generates.

In these edge cases if the actual items inventory are not being adjusted and it's the apps placeholder items being adjusted then it's a matter of setting up inventory sync between app-skus and real skus. Again usemechanic can be scripted for inventory sync scenarios. 

I'd follow through with a feature requests to shopify support about how this behavior impacts your business process with inaccurate information.

https://help.shopify.com/en/support/login 

[Report-Pundit]

Hello @KeebMaker ,

In Report Pundit, we offer an option to add customized data to reports.

Regarding your inquiry on inventory replenishment and cost of goods reports based on the Custom Product Builder, we will be able to fetch data as per your request, provided that the meta fields data pertaining to CPB is available in your Shopify API.

In case you're interested. We offer a 14-day free trial, so you can try out our features. In the meantime, we can work on your request.

Cheers!