Audit Inventory for Duplicate SKUs
Every Monday, WebRun exports your full item master from NetSuite, checks for exact duplicate SKU codes and near-matches by name or barcode, logs the conflicts in a Google Sheet with a suggested resolution, and posts the weekly audit summary to Slack.
How can I automatically audit my inventory for duplicate SKU entries?
Every Monday, WebRun exports your full item master from NetSuite, scans for exact duplicate SKU codes and near-matches by name or barcode, logs each conflict in a Google Sheet with a suggested resolution, and posts a weekly audit summary to Slack - so ordering errors and book mismatches get fixed before they compound.
- Duplicate SKUs caught weekly before causing ordering errors or accounting mismatches
- Each conflict logged with a suggested resolution to speed up cleanup
- Item master accuracy maintained without manual spot-checks
Built for inventory managers · e-commerce operations · ERP administrators · warehouse teams
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
system.netsuite.comin a real browser with your saved login - no setup, no API keys. -
1
NetSuite - export the item master for audit
netsuite.com
WebRun opens NetSuite to export the item master for audit. - Open Items and export all active item records with SKU, item name, barcode, category, and vendor
- Filter for items marked as Active to avoid noise from retired SKUs
- Capture the creation date for each item to identify which record is likely the original
Done when The full active item master is exported with all key fields.
-
2
Google Sheets - log and classify duplicate SKUs
google.com
WebRun opens Google Sheets to log and classify duplicate SKUs. - Open the SKU Audit sheet and load this week's export
- Flag exact duplicate SKU codes and flag near-matches where item names differ by only punctuation, spacing, or abbreviation
- For each duplicate group, suggest which record to keep based on creation date and stock on hand
Done when All duplicate and near-duplicate SKUs are flagged with a suggested resolution.
-
3
Slack - deliver the weekly duplicate audit report
slack.com
WebRun opens Slack to deliver the weekly duplicate audit report. - Post the weekly duplicate audit: number of exact duplicates, number of near-matches, and total affected records
- Include a link to the Google Sheet with the full conflict list and suggested resolutions
Done when The team has the weekly SKU audit summary with a clear action list.
How is each run configured?
Secure by default
Connect once, stays signed in
WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.
Every action is checked against this policy before it runs.
Questions, answered
Will it merge or delete duplicate SKUs in NetSuite automatically?
Never - merging item records touches stock levels, open orders, and your books. WebRun surfaces the conflicts and suggestions; your team makes the changes.
How does it detect near-duplicates that aren't exact matches?
It compares item names after stripping punctuation and normalising case, and also checks for matching barcodes or vendor part numbers on different SKU codes.
What if we intentionally have similar items for different sizes or colours?
Those will show as near-matches in the Google Sheet. You can mark them as 'Intentional - keep separate' and they'll be excluded from future audit reports.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.