How to design the PHP product library SPU and SKU?

The product library design of my current system is really scum. The product specifications, colors, and models are all fixed fields. as a result, N products will be recorded for different colors of the same product, such as an Apple 6 product, we need to record N color products respectively (Apple 6 gold, silver, black ). After reading the concepts of SPUSKU on the internet...

The product library design of my current system is really scum. The product specifications, colors, and models are all fixed fields. as a result, N products will be recorded for different colors of the same product, such as an Apple 6 product, we need to record N color products respectively (Apple 6 gold, silver, black ).

After reading the concept of SPUSKU on the Internet, it seems like a perfect solution.

Because of the food, please tell me how to design it. Give me some ideas or have a good open-source project.

Reply content:

The product library design of my current system is really scum. The product specifications, colors, and models are all fixed fields. as a result, N products will be recorded for different colors of the same product, such as an Apple 6 product, we need to record N color products respectively (Apple 6 gold, silver, black ).

After reading the concept of SPUSKU on the Internet, it seems like a perfect solution.

Because of the food, please tell me how to design it. Give me some ideas or have a good open-source project.