I would like to auto generate SKU with 6 or 8 digits which will consist of first 2 digits for manufacturer, next 1 digit for Colour, next 1 digit for Supplier and last 2 or 4 random numbers or auto increment.
eg. I would assign Manufacturer: Sony with number 15, Colour: Red with 5, Supplier: 7
Random or Auto Increment numbers: 0028
Final SKU: 15570028 [Unique entry in database]
Any who could help with this?
Edit: Ideally, it should check which attribute are selected [Colour, Manufacturer] and upon save, numbers assigned against those attributes value will be taken in the process of generating SKU
Edit 1: This would be while add/edit a product from admin. Ideal condition would be when all the required attributes are selected such as Colour, Manufacturer, Supplier - only then it should generate SKU and save it to database.