RE: Creating Item Variants on the Fly
I have worked with multiple ERPs only for the purpose of Integration with CPQ tools, either on Salesforce, MS Dynamics or whatever it is called today and others. One of feature I frequently used was either creation of a unique Item based on certain selections or creation of a new variant (more often) on the fly when placing the order .
So we sell H/W and well as software products as subscriptions. Currently we have over 20K SKUs in Salesforce, a lot more in the ERP. We are moving to NetSuite as our ERP.
I want to convert a lot of the Subscription SKUs that were created to manage various combinations for pricing or discount purposes or both into a SKU+Attribute. I do not want to create the Variant unless SKU+Attribute is actually selected on the Order.
There is no need to create them upfront since there are no BOMs so to speak and have already gone through Provisioning. It solves a lot of problems in syncing the product catalog and not having SKUs created due to the drastic change in Product Definition.
Well, I come here with great humility and even greater expectations.
This is really a matter that would be settled with you implementation team. NetSuite requires items to be unique irrespective of how you define that uniqueness. So if you define a unique item as sku + attribute then that item must be set up and be unique in NetSuite in order to transact with it. You have options for managing attributes to reduce the item catalogue in NetSuite, but again, something for the implementation team