DM-Multi Amazon Doormat Parser

Upload a ShipStation CSV. This parser reads Notes - Internal, splits multi-item personalization blocks, builds DM SKUs by Design + Size, and exports one Excel workbook with sheets by SKU family (DM-001/002/003/004/005/022).

No file loaded
Notes:
  • Single-block rows duplicate by Item - Qty.
  • Multi-block rows: if a block contains Quantity: or Qty:, that value is used for that block; otherwise the block is treated as qty 1.
  • Fixes common encoding glitches like ’ → ’.
Locked Design → SKU family
Design 1 → DM-002
Design 2 → DM-001
Design 3 → DM-004
Design 4 → DM-022
Design 5 → DM-005
Design 6 → DM-003
Locked Size → Prefix
16x24 → DM1624
18x30 → DM (SKU uses dash: DM-###)
24x36 → DM2436