Marketplace Orders
- 1Marketplace Portal
- 2Download Spreadsheet
- 3Microsoft Access
- 4Custom Script
- 5SAP-Compatible Spreadsheet
- 6Import into SAP Business One
Customer Story
How One Retailer Centralized Orders Across Shopify, Amazon, Walmart and SAP Business One
Selling across multiple marketplaces and websites, this customer replaced several manual workflows with one centralized platform that automates order processing, shipping and tracking updates.
Industry
Retail
ERP
SAP Business One
Shipping Platform
ShipStation
Customer
North American multichannel retailer
ShopifyAmazonWalmartWayfairOverstockHome DepotPartner WebsitesEmail OrdersEDI Orders
Background
Customer Overview
A North American multichannel retailer sells products through its own Shopify store while also operating across several online marketplaces including Amazon, Walmart, Wayfair, Overstock and Home Depot.
In addition, the business partners with smaller ecommerce websites that either submit orders by email or require custom integrations. SAP Business One remains the ERP and source of truth for inventory and operations.
Before
Before Okomano
Every morning the operations team had to collect orders from each sales channel before fulfillment could begin.
Email Orders
- 1Customer Email
- 2Operations Team
- 3Manual Entry
- 4SAP Business One
EDI Orders
- 1Trading Partner
- 2EDI Provider
- 3SAP Business One
Shipping
- 1SAP
- 2Third-party Tool
- 3ShipStation
- 4Tracking Numbers
- 5SAP Business One
- 6Manual Tracking Updates
- 7Marketplace / Website / Customer Email
Challenges
Operational Challenges
Manual SAP Entry
Marketplace orders required downloading spreadsheets and importing them into SAP after several manual steps.
Tracking Updates
After shipping, tracking numbers had to be manually copied back into marketplaces or emailed to customers.
Complex Custom Scripts
Microsoft Access and custom scripts became difficult to maintain as new marketplaces were added.
EDI Complexity
EDI remained necessary for some trading partners but was expensive and unsuitable for newer marketplace integrations.
No Central Visibility
Each sales channel followed a different workflow, making operations difficult to monitor.
Decision
Why They Chose Okomano
The customer wanted one platform capable of supporting modern marketplace automation while fitting into the SAP Business One and EDI processes already running the business.
- Connecting modern marketplaces through APIs
- Supporting Shopify natively
- Handling websites without APIs
- Keeping existing EDI workflows
- Centralizing every order
- Automating shipping updates
Solution
The New Workflow
Order Sources
Home Depot
Partner Sites
Email Orders
EDI Orders
1
SAP Business One
SAP Business One2
ShipStation
ShipStation3Tracking Updates
4Marketplaces, partner sites and customer emails
Shopify
Connected through Okomano's native Shopify application.
Marketplaces
Connected using official marketplace APIs where available.
Websites without APIs
Orders can be imported by uploading files or email content. Okomano uses AI to extract structured order information and convert it into a standardized format.
EDI Orders
Existing EDI integrations remain unchanged. Orders already arriving in SAP Business One are imported into Okomano so users can manage all orders from one place regardless of how they were received.
Shipping
Orders are automatically sent to ShipStation. Once shipped, SAP Business One is updated, marketplace tracking numbers are updated automatically, and shipping confirmation emails can be sent when required.
Results
Results
Less Manual Work
Marketplace and website orders no longer require spreadsheet manipulation or manual SAP entry.
One Centralized Workflow
Regardless of where an order originates, operations are managed through a single platform.
Scalable
Adding new marketplaces no longer requires building another Microsoft Access workflow or custom script.
Better Visibility
Operations teams can monitor all orders from one centralized dashboard.
Automated Shipping Updates
Tracking information is synchronized automatically instead of being copied manually.
Future Ready
Modern APIs replace older manual import processes while still supporting existing EDI partners.
Features Used
Okomano Features Used in the Implementation
The implementation combined ecommerce integrations, SAP Business One workflows, shipping automation and centralized order management.
Related
Related Pages
Centralize Operations
Need to Centralize Your Ecommerce Operations?
Whether your orders come from Shopify, marketplaces, EDI or email, Okomano helps centralize your operations and automate the flow between your sales channels, SAP Business One and shipping platform.