MYOB and Walmart Marketplace integration

What moves between them

Orders flow from Walmart Marketplace into MYOB. ml-connector retrieves new Walmart orders via webhook or polling, maps each order line item to the matching MYOB inventory item, and creates a corresponding MYOB sale invoice or purchase order for accounting and GL posting. Inventory quantities flow from MYOB to Walmart on a schedule you set, so Walmart reflects current stock and prevents overselling. Returns and refunds from Walmart (non-WFS only) sync back into MYOB for reconciliation.

How ml-connector handles it

ml-connector stores MYOB API credentials and Walmart client secrets encrypted, manages MYOB's 20-minute token refresh and company file authentication on every call, and regenerates Walmart tokens before expiry. It polls MYOB inventory using OData LastModified filters to detect changes, and subscribes to Walmart webhooks for order arrivals while maintaining a fallback polling schedule. Each MYOB item is mapped to a Walmart SKU, and incoming Walmart orders are matched to MYOB contacts by email address, then line items are resolved to MYOB inventory items by SKU. The integration tracks MYOB RowVersion on updates to prevent 409 conflicts, retries Walmart rate-limited calls (HTTP 429), and stores both a Walmart order ID and the resulting MYOB invoice ID in the audit log so either system can be queried for the full transaction.

A real-world example

A medium-sized retailer in Australia uses MYOB for accounting and inventory management across three warehouse locations. The same retailer sells on Walmart Marketplace to reach US customers. Before the integration, the operations team exported Walmart orders manually every morning, looked up SKUs in MYOB, updated inventory by hand to mark items as sold, and then asked the accounting team to enter the sales into the general ledger. This process took two hours per day and caused regular stock oversells because inventory could not sync back to Walmart fast enough. With MYOB and Walmart Marketplace connected, new Walmart orders arrive automatically as MYOB invoices within minutes of purchase, inventory updates flow from MYOB to Walmart every hour, and the accounts team reconciles sales against actual MYOB records instead of manually re-keying. Oversells have dropped to zero, and the manual workflow step is gone.

What you can do

• •Pull Walmart orders and map them to MYOB inventory items and contacts, then create MYOB invoices for accounting and GL posting.
• •Push MYOB inventory quantities to Walmart Marketplace on a schedule, preventing oversells and keeping listing stock in sync with actual supply.
• •Handle MYOB OAuth2 token refresh every 20 minutes and company file authentication on every call.
• •Bridge Walmart's 15-minute token expiry and non-standard WM_SEC.ACCESS_TOKEN header, with automatic retry on 401 and rate-limit backoff on HTTP 429.
• •Maintain a full audit trail linking each Walmart order to the MYOB invoice it created, with support for return and refund reconciliation.

Questions

Which direction does data move between MYOB and Walmart Marketplace?

Orders and returns flow from Walmart into MYOB, where they become invoices and reconciliation records. Inventory quantities flow from MYOB to Walmart on a schedule you control, so Walmart always reflects your current stock. This keeps Walmart listings accurate and prevents overselling while bringing Walmart sales into MYOB for accounting.

How does ml-connector handle MYOB's company file authentication requirement?

MYOB requires both an OAuth2 bearer token and company file credentials (username and password) on every API call. ml-connector stores the credentials encrypted, refreshes the OAuth token every 20 minutes before expiry, and includes all three required headers (Authorization, x-myobapi-key, and x-myobapi-cftoken) on every request to MYOB.

What happens when Walmart order data does not match an existing MYOB contact or inventory item?

ml-connector matches Walmart customer email addresses to MYOB contacts and Walmart SKUs to MYOB inventory items using your configured mappings. If a match cannot be found, the order is flagged in the audit log and held for manual review. You can then update the mappings or create the missing MYOB records, and ml-connector will replay the order on the next sync cycle.