Infor CloudSuite and WooCommerce integration

What moves between them

Orders and customers flow from WooCommerce into Infor CloudSuite. When a WooCommerce order arrives via webhook, ml-connector maps order items to CloudSuite products, posts the order as a sales invoice in accounts receivable, and allocates revenue to the GL accounts configured in your product mappings. Customer records also sync one-way from WooCommerce to CloudSuite so invoices reference the correct billing and shipping addresses. Products and pricing flow the reverse direction: ml-connector reads CloudSuite's product master and pricing, updates the WooCommerce product catalog, and syncs inventory quantities so the storefront reflects actual stock. The integration runs continuously via webhooks for order and customer events, and polls CloudSuite daily to fetch updated product and pricing data.

How ml-connector handles it

ml-connector stores WooCommerce API credentials (Consumer Key and Secret) encrypted and generates HTTP Basic Auth headers on each call. For Infor CloudSuite, it extracts the per-customer base URL and OAuth endpoints from the .ionapi credentials file, authenticates with the service account, and manages bearer token refresh before expiry. WooCommerce order webhooks trigger immediately; for CloudSuite, order data is read from WooCommerce and written to CloudSuite's APS100MI (Accounts Payable Invoices) and ARCustomers interfaces with proper GL account mappings per product category. Product sync runs on a daily schedule and reads from CloudSuite's MMS200MI (Items/Products) and CRS610MI (Customers), then writes to WooCommerce product and customer endpoints. Because CloudSuite has no native idempotency keys, ml-connector tracks every posted invoice with a unique external reference (Order ID + timestamp) and validates before re-posting to prevent duplicates. WooCommerce API rate limits are respected with standard backoff, and both systems log every record in a full audit trail for reconciliation and replay.

A real-world example

A mid-sized distributor runs Infor CloudSuite M3 for procurement, inventory, and accounting, and operates a WordPress e-commerce site with WooCommerce to reach smaller customers and retailers. Previously, the operations team exported orders from WooCommerce twice daily as CSV, manually entered line items into CloudSuite to create invoices, and every few days discovered that inventory quantities had drifted because the spreadsheet updates did not sync back. Month-end close required hours of manual reconciliation between the two systems. After connecting CloudSuite and WooCommerce, orders post automatically from the store to the general ledger, inventory is reconciled in real time, and product price changes entered in CloudSuite push to the storefront within hours. The manual order entry step is eliminated, and cash flow visibility improves because invoices are recorded immediately.

What you can do

• •Post WooCommerce orders into Infor CloudSuite as sales invoices with revenue allocated to the correct GL accounts based on product category.
• •Synchronize customer records, names, and addresses from WooCommerce to CloudSuite so that invoices bill the correct contact.
• •Keep WooCommerce product prices and inventory quantities in sync with CloudSuite master data on a daily schedule.
• •Authenticate WooCommerce with API Key Basic Auth and Infor CloudSuite with OAuth 2.0 and per-customer tenant URLs.
• •Track every invoice with an external reference to prevent duplicates, and maintain a complete audit trail for reconciliation.

Questions

Which direction does data move between Infor CloudSuite and WooCommerce?

Orders and customers move from WooCommerce into CloudSuite to create invoices and customer master records. Products, pricing, and inventory move from CloudSuite to WooCommerce to keep the storefront catalog and stock levels current. Both directions run continuously: order changes trigger immediately via webhook, while product and inventory updates run on a daily polling schedule.

How does ml-connector handle CloudSuite's lack of native webhooks?

WooCommerce publishes order and customer events via webhooks, which ml-connector receives immediately. For Infor CloudSuite, which is pull-only, ml-connector polls the product and inventory endpoints on a daily schedule to detect changes. This hybrid approach ensures orders post to CloudSuite instantly while product master data stays synchronized without constant API calls.

What happens if an order fails to post to CloudSuite, and how does ml-connector prevent duplicate invoices?

ml-connector stores the WooCommerce order ID and a unique external reference on every CloudSuite invoice attempt. If a write fails, the order stays in a queue and retries with exponential backoff. Before retrying, ml-connector queries CloudSuite to confirm the invoice was not already created, so that network failures or API timeouts do not result in duplicate invoices being posted.