QuickBooks Online and Walmart Marketplace integration

What moves between them

The main flow is Walmart Marketplace into QuickBooks Online. New orders placed on Walmart Marketplace are polled at a configurable interval and posted into QuickBooks Online as invoices, with each order line item mapped to the corresponding QuickBooks Online item and the customer matched to a QuickBooks Online customer record. Item and inventory data flows back from QuickBooks Online to Walmart Marketplace so price and quantity changes in your accounting system are reflected on the marketplace, keeping listings accurate and reducing overselling. Settlement and reconciliation reports from Walmart Marketplace can also be pulled for accounting records.

How ml-connector handles it

ml-connector maintains both OAuth 2.0 credential sets encrypted and refreshes QuickBooks Online tokens before expiry while requesting new Walmart Marketplace tokens every 14 minutes (well within the 15-minute expiry window). On the read side, it polls Walmart Marketplace orders with a schedule you control, maps each order to a QuickBooks Online customer record by email or external ID, creates or updates a corresponding invoice in QuickBooks Online with line items matched to QuickBooks Online items, and includes the Walmart Marketplace order ID in the invoice memo for traceability. Item updates from QuickBooks Online (price, description, SKU) are mapped to Walmart Marketplace items and pushed via the bulk feed API to avoid the single-item price throttle. Inventory quantities are synchronized bidirectionally using QuickBooks Online's quantity-on-hand field and Walmart Marketplace's shipNode inventory. All API calls include the required Walmart Marketplace headers, and retries handle 5xx responses and 429 rate-limit responses with exponential backoff. Every order, item, and inventory record carries a full audit trail so failed transactions can be replayed.

A real-world example

A mid-sized online seller runs QuickBooks Online for accounting and bookkeeping and sells inventory through Walmart Marketplace. Previously, the seller exported Walmart Marketplace orders each day, manually created invoices in QuickBooks Online by re-typing customer names and line item amounts, and then manually reconciled item quantities between systems at month-end to catch stock discrepancies. With QuickBooks Online and Walmart Marketplace connected, each Walmart Marketplace order automatically becomes a QuickBooks Online invoice on a schedule the seller controls, item and inventory changes sync both directions, and the month-end reconciliation is automated. The accounting team can focus on financial analysis instead of data entry, and overselling risk is eliminated because inventory levels are always in sync.

What you can do

• •Sync Walmart Marketplace orders into QuickBooks Online as invoices with line items mapped to QuickBooks Online items and customers.
• •Keep QuickBooks Online inventory quantities aligned with Walmart Marketplace shipNode inventory across multiple fulfillment nodes.
• •Push QuickBooks Online item changes (price, description, SKU) to Walmart Marketplace using bulk feeds to bypass single-item throttling.
• •Authenticate both systems with OAuth 2.0 (user consent for QuickBooks Online, Client Credentials for Walmart Marketplace) and refresh tokens automatically before expiry.
• •Poll Walmart Marketplace orders on a schedule you define, with retries on rate limits and a full audit trail on every record.

Questions

Which direction does data move between QuickBooks Online and Walmart Marketplace?

The main flow is Walmart Marketplace orders into QuickBooks Online as invoices. Items and inventory also sync bidirectionally so QuickBooks Online item changes push to Walmart Marketplace and shipNode inventory pulls back to update QuickBooks Online quantities. Settlement and reconciliation data flow from Walmart Marketplace to QuickBooks Online for accounting records.

How does the integration handle OAuth token refresh given the different expiry times?

QuickBooks Online tokens expire in 1 hour, while Walmart Marketplace tokens expire in 15 minutes. ml-connector monitors both and requests fresh tokens before they expire - QuickBooks Online before each batch of API calls and Walmart Marketplace every 14 minutes. If a token does expire in-flight, the integration retries the call with a fresh token.

What happens to Walmart Marketplace orders that don't have a matching QuickBooks Online customer?

ml-connector maps Walmart Marketplace customers to QuickBooks Online records by email address or an external ID field. If no match is found, the order is held in the audit queue and flagged for review so a customer can be created or linked manually. This prevents orphaned invoices and ensures all transactions are traceable.