Product Data

A four-segment SKU broken into brand, family, colour and size, with a list of fields to keep or drop.
Product Data

The SKU Is a Decision, Not a Label

/

A SKU looks like a formality until the catalogue passes a few thousand items and nobody can tell which variants belong together. Here is the structure I use, the two identifiers people confuse, and the habits that quietly destroy a scheme.

A validation column listing the errors spreadsheets introduce into product data, with row counts.
Product Data

Cleaning Product Data Before It Reaches the Store

/

A product CSV is not a transport format, it is the deliverable — and spreadsheets damage it in ways that stay invisible until import. Here is the prep sequence I run on supplier data, the validation column that replaces manual checking, and the point where a spreadsheet stops being the right tool.

Scroll to Top