100%
automated Mirakl order imports from Spotlight and Freedom into NetSuite as Sales Orders
Daily
inventory synchronisation between NetSuite and Mirakl using Available stock to reduce overselling risks
2
scheduled SuiteScript 2.1 Map/Reduce integrations for marketplace order processing and inventory updates
About
Client
Business
Multi-Marketplace Retail Operations
Mittal (MI Overseas Pty Ltd) sells its products through Spotlight and Freedom, two online marketplaces operating on the Mirakl platform.
Integrated Marketplace and ERP Ecosystem
The business uses NetSuite to manage its orders, inventory, fulfilment and finance, while Mirakl manages its marketplace operations across Spotlight and Freedom.
Manual Order and Inventory Management
Marketplace orders and stock were managed manually, creating a need for automated order processing and accurate inventory synchronisation between Mirakl and NetSuite.
Our Solutions
We built a configurable Mirakl - NetSuite integration using two scheduled SuiteScript 2.1 Map/Reduce scripts, driven entirely by a setup record per marketplace shop - no hard-coded credentials or script parameters.
Mirakl to NetSuite Order Import
Scheduled daily order imports from all active Mirakl shops into NetSuite as Sales Orders, with accurate pricing, date handling, full-quantity fulfilment and order-level tracking.
NetSuite to Mirakl Inventory Sync
Compared NetSuite Available stock with active Mirakl offers daily and updated only changed SKU quantities, with CSV audit records and import tracking.
Marketplace Item Mapping
Created configurable item mappings to support different Product SKUs and Offer SKUs across multiple marketplaces, with alerts for unmapped items.
Reliability, Monitoring & Safety
Implemented duplicate protection, automatic retries, error isolation, daily email reports and environment safeguards to ensure reliable and safe integration operations.
Challenges
The client faced several operational challenges with manual marketplace management, inconsistent product identifiers and the need for reliable order and inventory synchronisation across Mirakl and NetSuite.
Manual Order Entry and Stock Updates
Marketplace orders were entered into NetSuite manually, and stock was updated separately on each marketplace, consuming staff time and increasing the risk of overselling.
Different SKUs Across Marketplaces
Different product and offer SKUs across marketplaces required flexible, marketplace-specific item mapping.
Transaction Accuracy and Integration Reliability
Preventing duplicate orders, partial fulfilments, failed transactions and unintended changes to live marketplace data required robust safeguards.
Results
The Mirakl–NetSuite integration automated marketplace operations, improved inventory accuracy and provided reliable order processing with better visibility and scalability across multiple marketplaces.
Automated Order and Inventory Management
Marketplace orders now flow into NetSuite automatically, while inventory is synchronised daily using NetSuite Available stock to reduce overselling.
Reliable Order Processing
Duplicate protection and automatic retries ensure orders are imported without duplication, while failed transactions can recover once the underlying issue is resolved.
Improved Visibility and Verified Integration
Order records, error logs, stored stock files and daily email reports provide a clear audit trail, with integration workflows tested successfully in the NetSuite sandbox before go-live.
Scalable Multi-Marketplace Integration
Additional Mirakl marketplaces can be connected through setup records and item mappings without requiring code changes.




