Product Variants and SKUs
Simple Products, Variable Products and Variants
Product variants and SKUs are two ways a shop tracks what it sells. A product variant is a version of the same item that differs in one or more options, such as size or colour. A SKU, or stock-keeping unit, is a code that identifies one specific item the shop can sell and count.
A simple product has one version and one SKU. A variable product is a parent listing that offers choices, such as a T-shirt available in four sizes and three colours. Each combination of those choices is a variant, with its own SKU, price and stock count.
Platforms model this differently. Some treat each variant as a child of a parent product, while others store each combination as a separate item linked to a shared name. The model affects how options are shown to shoppers and how stock is reported. The catalogue is one of the core building blocks of an ecommerce platform.
Attributes, Options and How Platforms Store Them
Variants are built from attributes. An attribute is a property of a product, such as colour, material or size. An option is one value of that attribute, such as red or large. Shops typically keep track of four kinds of data:
- Attributes: the named properties used to describe products and to filter them, such as colour or fabric.
- Options: the values a shopper can choose, which combine to create variants.
- SKUs: the unique identifiers that link each variant to stock, cost and warehouse records.
- Media: many shops show a different photo for each colour, so some variants need their own images.
Good structure keeps the data consistent. A SKU should stay the same when a product is renamed, and the same SKU should never be used for two different items, because stock counts and order records depend on it. When an order management system sits alongside the shop, it matches orders to variant SKUs through this same identifier.
A Clothing Brand With Thousands of Variants
A clothing brand sells 80 designs, and each comes in six sizes and four colours. That makes 1,920 variants. Each one needs its own SKU and stock count, so one product idea becomes a large set of records.
The strain shows in several places. Catalogue filters that work across several attributes must search a large number of combinations. Stock updates from the warehouse must match 1,920 identifiers exactly, and a single mismatched SKU can put the wrong count on the wrong size. Prices may also differ by market, which adds another layer, covered in multi-currency and multi-store setups.
Frequently asked questions
What Is the Difference Between a SKU and a Product ID?
A product ID is usually an internal number the platform assigns to a record. A SKU is a code the merchant defines for a sellable item, and it is the one that links to stock, shipping and accounting. Some platforms use the same value for both, but they serve different purposes, and the SKU is the code to keep stable.
Can Too Many Variants Slow Down an Online Store?
Yes. Every variant adds records to the database and more options to filter and display. A large number of variants can slow catalogue pages, admin screens and stock updates. Shops with very large catalogues need a platform and hosting that handle that volume of data well.