We regularly receive many requests about how to customize an output SKU of a product with custom options in an order. In most cases it’s necessary to upload orders to 3rd party inventory or ERP systems.
Standard Magento adds SKU’s of all selected custom options to the SKU of the main product. Example: let’s assume a product has the SKU – mainSKU, its 1st option has the SKU – option1SKU and the 2nd option – option2SKU. If a customer purchases this product with both options selected, the main product’s SKU will become mainSKU-option1SKU-option2SKU. As you can see, SKU’s of all selected options were added to the main SKU. And if you upload this product to your inventory system, it won’t find such a product and won’t update the inventory correctly.
We developed a solution for this problem. The Advanced Product Options extension has the SKU Policy feature. Please see below what it is and how it works.
There are several modes for you to try out. Remember the setting is applicable to either orders or orders&cart.