Companion version that combines initial cleanup, parent-child variant diagnostics, normalization logic, vendor rules, and corrected rebuild output for NetSuite or Shopify reconciliation.
1. Paste Exported Inventory
This version preserves your original cleanup approach, then adds higher-level review for parent-child problems, taxonomy drift, duplicate identifiers, stranded inventory risk, pricing conflicts, and rebuild output.
2. Cleaned Output
Audit Controls + Dictionaries
1 loose • 2 light • 3 standard • 4 stringent
Master Color Dictionary
Master Size Dictionary
Vendor-Specific Rules
Vendor rules here are lightweight text rules. They help this tool decide when a vendor is drifting from its normal data pattern.
0
Rows
0
Flags
0
Error Types
0
Auto Fixes
Original vs Cleaned Preview
Left is original. Right is cleaned. Use this as your first QA step before moving to audit and fix logic.
Top 12 Error Checks
Current Check Summary
These 12 checks are weighted toward expensive apparel catalog problems: missing children, missing parents, inconsistent color or size logic, duplicate identifiers, orphan stock, vendor coding drift, and missing grouping keys.
Flagged Output for Selected Error
Fix-Applier + Rebuild Output
Fix Notes
Reconciliation Notes / Mapping
Corrected Rebuild Output
The rebuild output tries to preserve the original structure while standardizing colors, sizes, whitespace, and a number of common parent-child and taxonomy issues. It does not invent missing business facts, but it will normalize where a safe correction is reasonable.
Field Best Practices
Item / SKUKey – stable and unique, avoid random spacing differences, avoid accidental duplicates.
Display Name / Title – keep variant identity compact; do not overload with marketing text.
UPC / EAN / BarcodeNumeric – store as text in spreadsheets to preserve full digits.
Parent Item / Style / Handle – at least one grouping logic must exist consistently.
Color – use one approved term per actual color inside a family.
Size – do not mix Roman, alpha, and numeric systems casually in the same style family.
Status + Qty – inactive items with on-hand inventory are often expensive hidden problems.