We make cricket bats from willow clefts, combining modern CNC technology with traditional craftsmanship.
When a customer places an order on our Shopify store, we create a production sheet and assign a unique serial number to each bat. This lets us track key information about the bat’s “DNA”—including the design, serial number, CNC machine code, wood density, and final weight.
If a customer returns a bat for repair or refurbishment, we update the original production sheet with that information.
Currently, we use an old ERP system that’s not integrated with Shopify. It’s slow, creates a lot of duplicate data, and is no longer efficient.
We’re looking for an app that can generate a production sheet directly from a Shopify order and store all related data in a parent-child database structure.
Any help or recommendations would be greatly appreciated!
Katana MRP could be a good fit — it integrates with Shopify and supports serial numbers and production data. Alternatively, you could use Airtable connected via Zapier or Make to create and update production sheets with a parent-child structure.
Embrace ERP could be worth considering. It integrates with Shopify and it has all the functionality you’re looking for. It also supports configurable products with its configure price quote (CPQ) functionality which would enable more options, for example the handle types, bat profiles, weight, sweet spot location, grip color etc. You can easily set those options up in the Embrace user interface so a customer can choose those options with a sales consultant in the retail store (if you have one), but it can also come from Shopify, which then spawns the production job when the order synchronizes. The whole history as well as future refurbishment/repair visits can be tracked as well.
Embrace also has a wide range of functionality, from Manufacturing, to Service and Workshops, CRM, Financials, Rental and Hire, WMS, Shipping, Retail, Sales, Supply Chain Management and more. That, combined with the dedicated implementation, customization and support teams, means that you’re in good hands, well beyond go-live.