ORDER_MISSING
Order #10492
- Shopify
- Paid, fulfilled, $742.18
- NetSuite
- Missing in NetSuite saved search
- Impact
- $742.18 revenue not visible in NetSuite
- Recommended action
- Replay order through connector and verify customer mapping.
ArchRelay
Illustrative sample - not customer data
Shopify to NetSuite audit sample report
This example shows the report format delivered after ArchRelay compares Shopify exports against NetSuite saved searches for one primary reconciliation problem.
Start My Sync Audit - $1491,000
records analyzed
23
exceptions found
$8,940
potential impact
1
primary issue
Executive summary
We analyzed Shopify orders and the matching NetSuite transaction saved search for the same date range. The highest-risk pattern was paid Shopify orders missing from NetSuite, followed by amount and status mismatches that should be reviewed before close.
Records analyzed
Shopify Orders CSV plus NetSuite saved search
Date range: illustrative 30-day sample. Record limit: 1,000 rows.
Exceptions found
23 exceptions across 5 finding types
Each exception includes source evidence, likely cause and recommended action.
Financial and operational impact
The sample exceptions represent $8,940 in revenue, refund or settlement records that would require manual review. Inventory and fulfillment mismatches increase oversell, late shipment and support risk.
INVENTORY_MISMATCH
SKU HN-422
- Shopify
- 18 available
- NetSuite
- 12 available in NetSuite
- Impact
- 6-unit oversell risk
- Recommended action
- Review last inventory sync job and location mapping.
PAYMENT_MISMATCH
Order #10507
- Shopify
- Captured $318.40
- NetSuite
- NetSuite invoice total $301.90
- Impact
- $16.50 settlement variance
- Recommended action
- Compare discount, tax and shipping mappings.
REFUND_MISSING
Refund #R-1182
- Shopify
- Refunded $129.00
- NetSuite
- No NetSuite credit memo found
- Impact
- $129.00 refund absent from close package
- Recommended action
- Create or replay credit memo after confirming refund timestamp.
FULFILLMENT_MISMATCH
Order #10531
- Shopify
- Fulfilled with tracking
- NetSuite
- NetSuite item fulfillment still open
- Impact
- Customer support and inventory status conflict
- Recommended action
- Validate fulfillment status mapping and carrier event sync.
Detailed finding
ORDER_MISSING_DOWNSTREAM: Order #10492
What we found
Shopify shows a paid and fulfilled order for $742.18, but no matching sales order or invoice appears in the NetSuite saved search.
Why it matters
Finance may miss recognized revenue and fulfillment support will not have a NetSuite source of truth.
Likely cause
Connector mapping rejected the customer record before order creation.
Recommended action
Replay the order after confirming customer mapping, then verify the NetSuite sales order number and invoice total.
Finding templates
The same report format is used across discrepancy types so each exception is reviewable and actionable.
ORDER_MISSING_DOWNSTREAM
Shopify order exists but the matching NetSuite sales order or invoice is absent.
DUPLICATE_ORDER
One Shopify order appears as multiple NetSuite sales orders, invoices or transaction records.
ORDER_TOTAL_MISMATCH
Shopify total, tax, shipping or discount amount differs from NetSuite.
SKU_MAPPING_MISMATCH
Shopify line item maps to the wrong NetSuite item, SKU or internal ID.
QUANTITY_MISMATCH
Line-item, fulfillment or inventory quantity differs between Shopify and NetSuite.
Recommended actions
Replay missing high-value orders and verify NetSuite identifiers.
Review connector customer, SKU and tax mappings tied to repeated failures.
Schedule a follow-up check after connector fixes are applied.
ArchRelay