Vendor Inventory Audit & Prep for NetSuite Import / Shopify Sync

1. Vendor Submission Input

This tool trims spaces, normalizes text, removes “#N/A”, highlights structural issues, and prepares a strong NetSuite-ready import that keeps SKUs aligned with Shopify variants.

2. Cleaned / Import-Ready CSV

Original
Cleaned
Error
Warning

3. Original vs Cleaned & Error Highlights

Left columns show original vendor cells; right columns show cleaned values. Cells with structural errors (keys, prices, inventory, barcodes, variants) are highlighted.

4. Audit Summary & Error Navigator

Critical: key, price, qty, barcode Variants: color/size, parent/child Info: header, blanks, extra text
Waiting for analysis. Paste data and click “Audit & Assess Vendor Submission”.

5. Suggested NetSuite Import Mapping

Based on your header row, we propose a canonical NetSuite import structure and a Shopify-safe SKU alignment. Adjust as needed, then keep this mapping locked for repeat imports.
Vendor Column Detected Role Suggested NetSuite Field Shopify Consideration
A strong baseline header set for inventory imports typically includes: Item Name/Number Display Name Parent Item Matrix Option: Color Matrix Option: Size UPC / EAN Base Price Quantity Available Cost

6. Alignment Notes (Working Pad)