SKUs identify products; inventory says how many you have. Both sound simple and both break catalogs when mishandled. A duplicated SKU silently overwrites a product on import. A stock count typed as "9,999 units" arrives as text or as the number 9. This guide explains how SKUs and inventory work in the Hyperzod CSV structure and how CSV Pilot keeps them clean.
SKUs: one product, one code
A SKU is a unique code for tracking a product. The rules that matter in a CSV:
- Unique — two rows with the same SKU overwrite each other on import. One product silently replaces another; no error tells you which survived.
- Plain text — a SKU like
00123must keep its leading zeros, which means it must never pass through a spreadsheet that treats it as a number. Excel's default behavior strips those zeros on open and save. - Consistent pattern —
PIZ-MARG,PIZ-PEPbeats a random mix of formats. Patterns make bulk operations possible: "add NEW- in front of every SKU" only works when the SKUs are structured.
When you generate a catalog with CSV Pilot, you can ask for SKUs explicitly: "create 10 products with SKUs in the pattern CAT-001". When converting from Shopify, the Variant SKU column carries over to the matching variants automatically.
Inventory: numbers that mean business
Inventory is the stock quantity in the PRODUCT.INVENTORY column — a plain whole number. Two details trip people up:
- Blank is not zero — an empty inventory cell is ambiguous. Write an explicit number, including zero when you mean zero.
- No symbols or separators —
9999, not9,999or9999 units.
DeliverLogic menu exports use 9999 as their "unlimited stock" sentinel. CSV Pilot carries that to the product inventory when converting, so unlimited items stay unlimited.
Managing both at once
For a catalog-wide update, describe the rule:
- "Set inventory to 100 for every product."
- "Set inventory to 0 for products in the Discontinued category."
- "Add 'NEW-' in front of every SKU."
- "Set the cost price of all Beverages to 40% of the selling price."
CSV Pilot applies the change to the matching rows and shows the result in the preview. Validation flags duplicate SKUs before export, which catches copy-paste duplicates while you can still fix them.
The checklist before import
- Every SKU is unique and keeps its leading zeros.
- Every inventory cell that matters has an explicit number.
- Products you no longer sell are marked inactive rather than left at zero stock — unless zero is the truth.
- Variant SKUs, if used, follow the same uniqueness and pattern rules as product SKUs.
Why these columns cause silent failures
Name and price errors are visible — a wrong name shows up immediately. SKU and inventory errors are invisible until they matter: the duplicate SKU product is missing from the store, the zero-stock item is still orderable. That is why both columns deserve a validation pass before every import, and why CSV Pilot runs those checks continuously rather than at the end.
SKUs and inventory are the columns that look the most boring and cause the most silent failures. Let the preview and validation catch the problems before Hyperzod sees them.