Tagged articles
sku
13 articles · Page 1 of 1
This article demonstrates how to generate all possible SKU combinations in PHP by using Cartesian product on color, size, and version arrays, includes a full code example and the resulting array output.
BackendCode Examplearray
0 likes · 3 min read

This article explains how to generate all possible product SKU combinations for an e‑commerce system by computing the Cartesian product of specification arrays, and provides two PHP implementations—one that returns SKU strings and another that returns nested arrays—along with sample output.
Backendcartesian productcode
0 likes · 6 min read


政采云技术Aug 31, 2021 · Frontend Development
This article explains the theory and practice of handling SKU (Stock Keeping Unit) in e‑commerce platforms, covering product creation, cart selection, Cartesian‑product based SKU generation, adjacency‑matrix and set‑theory approaches, and provides complete JavaScript implementations for front‑end developers.
JavaScriptcartesian producte-commerce
0 likes · 18 min read

This article explains the essential concepts, functional architecture, and detailed design of an e‑commerce product center, covering SPU/SKU definitions, front‑ and back‑end categories, attribute types, CRUD operations, and specific features such as product publishing, review, unpublishing, editing, and category management.
Product CenterSPUbackend design
0 likes · 8 min read

This article explains how abstracting front‑end data into reusable models—illustrated with product, SKU, and exception handling examples—improves code safety, testability, and maintainability for complex applications such as a multi‑variant e‑commerce product publishing page.
Exception HandlingTypeScriptdata model
0 likes · 15 min read

This article provides a comprehensive guide to building and operating a fresh food e‑commerce platform, covering the design of basic category trees, attribute and brand libraries, product lifecycle management, SKU handling, series and combo products, and front‑end classification strategies.
attribute librarycategory treee-commerce
0 likes · 14 min read

This article explains the core concepts and architecture of an e‑commerce product center, covering SPU, SKU, sales and non‑sales attributes, pricing models, inventory control, scheduled on/off‑shelf operations, and optimization techniques for querying product data.
BackendInventoryProduct Modeling
0 likes · 5 min read

This comprehensive guide explains the core concepts of e‑commerce product systems—including SPU and SKU definitions, their relationships, and the complete product management workflow covering publishing, editing, inventory, payment, logistics, and status transitions—providing essential knowledge for building robust online retail platforms.
CatalogInventorySPU
0 likes · 11 min read

The article analyzes the evolution of e‑commerce product modeling, introduces categories, brands, and attribute‑based filtering, distinguishes products from SKUs, and proposes a backend‑centric data model that supports flexible search, display, and integration with other business services.
attributesdatabase designe-commerce
0 likes · 5 min read


21CTOJan 24, 2018 · Product Management
This article walks through the evolution of e‑commerce product modeling, explaining how categories, brands, attributes, SPU and SKU concepts combine to form a flexible system that supports browsing, filtering, and detailed product pages while keeping the architecture maintainable.
CatalogSPUattribute design
0 likes · 10 min read

The article explains the fundamental concepts of SPU and SKU in e‑commerce, describes how to model products, attributes, and specifications in database tables, and illustrates the design with diagrams while discussing trade‑offs such as redundancy and extensibility for large‑scale systems.
BackendSPUdatabase design
0 likes · 7 min read

This article explains how to design a flexible product model for e‑commerce by evolving from simple category‑article structures to a richer schema that includes brands, attributes, specifications, and separate SKU entities, enabling effective filtering, search, and integration with other services.
Data Modelingattributese-commerce
0 likes · 6 min read

This article explains Taobao's product and SKU concepts, the relationship between attribute name and value tables, how to fetch and process attribute data via the API, and techniques for dynamically building forms and handling SKU combinations in e‑commerce systems.
APIProduct Modelingsku
0 likes · 8 min read
