Done For You

DoneForYou is an e-commerce operations integration project that automates the complete order lifecycle between the Rithum (ChannelAdvisor) multi-channel marketplace platform and SAP ByDesign ERP. The client sells across marketplaces including eBay and TikTok Shop, and required a fully automated, error-resilient pipeline to ingest orders, create sales records in SAP, extract fulfillment data, and push tracking updates back to each marketplace, eliminating all manual data entry and reducing order processing delays.

The client faced fragmented, manual order management across Rithum marketplaces and SAP ByDesign ERP. Key technical challenges included SAP's rigid SOAP/XML interface requiring precise envelope construction, SAP record-locking issues with concurrent webhook requests, tax math discrepancies between Rithum and SAP, the need for SKU cross-referencing between Rithum product IDs and SAP Material IDs, and the complexity of handling split/partial shipments. The absence of deduplication logic also risked duplicate order creation.

Automation Platform: Make.com

Source System: Rithum (ChannelAdvisor) REST API + Webhooks

Target System: SAP ByDesign (SOAP/OData, ManageSalesOrderIn)

Internal Storage: Make.com Data Stores (Deduplication, Tracking, Errors)

Alerting: Slack & Email notifications

Project Management: Atlassian Jira

A fully automated, bidirectional order management bridge was built on Make.com connecting Rithum and SAP ByDesign. The solution covers inbound order ingestion with deduplication, SAP Customer/SKU validation, SOAP Sales Order creation, outbound fulfillment polling, marketplace tracking updates, and a comprehensive error handling layer with auto-retry, alerting, and a Dead Letter Queue.

Discovery & Architecture A technical discovery was conducted analyzing Rithum webhook JSON payloads, SAP ByDesign SOAP/OData WSDL documents, and Make.com subscription tier limits. A field-by-field translation matrix was created mapping Rithum JSON to SAP XML, defining SKU cross-referencing logic, tax rounding rules (Rithum as source of truth), and SAP Customer Master creation rules. Make.com Data Stores were architected for deduplication, tracking, and error management.

Inbound Pipeline (Rithum → SAP) A Make.com webhook listener ingests real-time Rithum order payloads with sanitization filters and deduplication via Data Store lookup. SAP Customer Master lookups (SOAP/OData) verify buyer existence, with dynamic XML generation to create new customer records on miss. SKU cross-referencing routes unmatched products to an error queue. The SAP ManageSalesOrderIn SOAP envelope was hand-crafted with 100+ dynamic variables injected into the XML schema, with orphaned record rollback if Sales Order creation fails after Customer creation.

Outbound Pipeline (SAP → Rithum) A Make.com scheduled scenario polls SAP's Outbound Delivery API every 10-15 minutes with exact timestamp filters. SAP status codes are translated to Rithum-accepted shipment statuses, with marketplace-specific handling for eBay vs. TikTok Shop. Tracking numbers and carrier codes are pushed via Rithum REST API, and the Tracking Data Store is updated to mark order lifecycles as closed.

Error Handling & Reliability Every HTTP module includes Make.com error directives (Break/Resume/Ignore). Failed payloads are logged with timestamps to a centralized Error Data Store. A standalone sweep scenario auto-retries transient failures every 30 minutes with exponential backoff for HTTP 429 rate limits. Real-time Slack/Email alerts handle hard failures requiring human intervention. A Dead Letter Queue (DLQ) offloads permanently failed payloads to an external sheet. A daily health-check digest email summarizes successes and unresolved errors. Additional cancellation (SOAP ChangeStateID) and refund (credit memo) flows were delivered as an extended scope.