I work for an athletic apparel company which sells blank products, as well as products for clients (sports teams) which are the blank products with applied logos. Because we create collections and turn them into team shops for clients, we have to duplicate the products and swap out the photos with ones that have the team logos on them.
Each product/color/size has a unique SKU, and when we duplicate the products to create a team-specific version, those SKU’s carry over. For some clients, we also have multiple variations for each product to display a different logo as some have primary and secondary logos.
We want to make sure that since these are all the same product, the quantities are synched across all comparable products using the same SKU for inventory management purposes. For example, I have a performance shirt available as a blank, with a second product being the same shirt that we apply a logo to. If someone buys a shirt from a team with a logo, we would like the quantities for all of those shirts to go down, not just the product from which it was bought.
I thought that this was working initially as when I duplicated the blank product it carried over the quantities, but as we are selling more customized products than blanks, our quantities for the customized products go down while the blank ones don’t change, despite having the same SKU. This is an issue, as both products are essentially the same base product.
Is there a way to fix this and sync the quantities for different product profiles that share SKU’s?