Book a call
Home/Case studies/Retail and eCommerce
Retail and eCommerce

Marketplace orders integrated directly into NetSuite

Orders from multiple marketplaces were being downloaded and imported by hand, and stock counts drifted between channels every day.

atsovia · case study · retail and eCommerce (sample data)Live

Marketplace orders · after

Celigo flows · Amazon SP-API and Walmart into NetSuite
Running unattended
Orders today512
Settlements matched14 / 14
Manual imports0
Oversells this week0
11:02Amazon order 113-48… → SO-20411created
11:02Walmart order 59-22… → SO-20412created
11:04Stock AT-2042 pushed to 2 channels58
11:10Amazon settlement · fees splitmatched
11:11Deposit reconciled to bank line$18,240
11:15Margin by channel → BigQuerysent
Sample data · demo accountCase studies · Retail and eCommerce
The problem

What was broken

Orders from multiple marketplaces were being downloaded and imported by hand, and stock counts drifted between channels every day.

What we built

What runs now

A Celigo-based integration now brings orders, shipments and settlements in automatically, with inventory writing back to every channel from one source.

  • Orders land in NetSuite automatically
  • Inventory syncs back to every channel
  • Settlement and fee reconciliation
  • No manual imports
How it runs

One flow, end to end.

The path a record takes once this is running. Every step is logged, so when something stops you can see where.

atsovia · workflow (sample)Live
Amazon / Walmart orderCeligo flowSales orderSettlementBank matchStock back
record createdvalidatedpostedloggedreconcileddone
Watch it run

Recorded in a demo NetSuite account.

Sample data throughout. The screens are the kind we build and leave running for clients.

Sample data · demo account
Sample data · demo account

A Celigo-based integration now brings orders, shipments and settlements in automatically, with inventory writing back to every channel from one source.

Start a conversation

Considering NetSuite, or already living with it?

Tell us what is not working. If it is a half-hour fix we will tell you that, and you can decide whether to pay anyone at all.

Emailhello@atsovia.com
Phone+91 97200 78591