Audit the sync you already have.
Sync Audit checks that orders and products in Shopify, NetSuite and NewStore actually match, and shows each difference it finds side by side. Keep your connector. Fix at the source.
Sales Audit
Orders requiring review to maintain accurate records across systems
- Shopify sales value does not match NetSuite 3
- Shopify sales that do not exist in NetSuite 1
Product Audit
Monitor the health of your product catalogue
- Shopify product sale price does not match NetSuite 4
- Duplicate UPCs 2
- Missing Product Attribute - UPC 1
Sync Audit is for you if…
- Finance finds Shopify and NetSuite totals that don’t tie
- Someone else runs your integration and you want an independent check
- You have SLAs with your integrator that you want to monitor
- You run several Shopify shops, or stores on NewStore
- Duplicate UPCs or external IDs keep turning up in NetSuite
The checks, and what each one looks for.
Checks are grouped into Product Audit and Sales Audit. Only checks for the systems you connect appear. Each check has its own threshold: a missing-record check can allow a handful before it turns red, while a price difference counts from the first one.
Product Audit
Shopify Validation Rules
- Does not exist in NetSuite Missing
- Sale price value does not match NetSuite Mismatch
NetSuite Validation Rules
- Duplicate External IDs Duplicate
- Duplicate UPCs Duplicate
- Missing Product Attribute - UPC Invalid
- Does not exist in NewStore, but has pricing Missing
- Does not exist in Comestri, but has pricing Missing
NewStore Validation Rules
- Does not exist in NetSuite Missing
- Duplicates Duplicate
- Has invalid HS Code and is in stock Invalid
Comestri Validation Rules
- Does not exist in NetSuite Missing
- Duplicates Duplicate
Sales Audit
Shopify Validation Rules
- Does not exist in NetSuite Missing
- Sales value does not match NetSuite Mismatch
- Does not exist in NewStore Missing
- Sales value does not match NewStore Mismatch
NewStore Validation Rules
- Does not exist in NetSuite Missing
- Sales value does not match NetSuite Mismatch
Five steps, and your records stay yours.
- Step 1
Set up your team
We create your team and switch on the checks you need: products, sales, or both.
- Step 2
Connect your systems
We connect the systems and shops you need with your team. Your current connector stays in place.
- Step 3
Schedule
We set how often your checks run. Each run looks only at what changed since the last one, and results show on the dashboard as green, amber or red cards.
- Step 4
Subscribe to alerts
Pick the checks that matter and the error count that should trigger an alert. Alerts go to each person by email, or to a shared Slack or Microsoft Teams channel.
- Step 5
Investigate side by side
Open any check to see each record with both values and currencies. Search, sort, export to CSV, and fix in the source system. Authorised users can ignore a sales error, and ignored errors stay listed separately for review.
Systems it checks today.
| System | Sales Audit | Product Audit |
|---|---|---|
| NetSuite The record everything is checked against | Available | Available |
| Shopify Multiple shops, online and POS | Available | Available |
| NewStore Store POS and order management | Available | Available |
| Comestri Now part of Ultra Commerce | – | Available |
Available: built and working today. Prices only: Product Management publishes products to NetSuite and sends their prices to Shopify. A dash means the module doesn't cover that system. Plans are on the roadmap. Have another system with an API? Let us know.
The sales and product reconciliation gives us complete peace of mind. We catch discrepancies early, long before they cause issues downstream.
Ethan Lynch Enterprise Systems Manager, Lorna Jane Before you book.
Do we have to replace our current connector?
No. Sync Audit runs beside it and checks the records it produces. Keep your connector, or move the integration to ItSynx later if that suits you.
Does Sync Audit change our records?
No. It reports what differs and where. Your team fixes each record in the system that owns it, so nothing changes without you.
How often do the checks run?
On a schedule set for your business, and each run checks only what changed since the last one. One retailer runs sales checks hourly and product checks daily. You can also refresh a check’s count from the dashboard: it recalculates against the records already imported, rather than fetching new data from each system.
How do we hear about problems?
Subscribe to any Product Audit or Sales Audit check and set the error count that should trigger an alert. ItSynx alerts you when the affected records change, and sends a daily reminder while the same errors remain. Checks run after their imports finish, so you won’t be alerted about a half-finished import. Use email, Slack, Microsoft Teams or any combination, with a different threshold for each.
Is it safe to post alerts in a shared channel?
Yes. Slack and Teams messages show only check names, error counts and times, never your records, so they suit channels that include people without ItSynx access. Email alerts are personal to each user, with one-click unsubscribe.
Will a sale show as missing while it’s still on its way?
Not if your team has processing allowances set. A missing-sale check gives each sale time to reach the next system, counted from payment for Shopify orders, and judged as of the latest successful import rather than the current time. We set the allowances with you and can change them.
Does a clean result mean everything matches?
It means the checks found nothing in the records last imported. The checks cover the comparisons listed on this page, so how recently each system was imported still matters. A failed import doesn’t move the check forward, and the next successful one can add or clear results.
Is this the same as payment or bank reconciliation?
No. Sync Audit checks that orders and products exist and agree across your systems. It doesn’t reconcile payouts, bank feeds or the general ledger.
What access does it need?
Access to each system it checks. Exactly what that involves depends on your setup, so we go through it on the fit check before anything is connected.
Where is our data hosted?
In Sydney, Australia, with daily backups of the application and its database. Only ItSynx staff can see customer details.