Microsoft Dynamics GP and Walmart Marketplace integration

What moves between them

Orders flow from Walmart into Dynamics GP as receivables invoices, mapped to customers and GL accounts with order date and amount. Inventory quantities and prices sync from GP into Walmart on a cadence you control, so live-listing quantities reflect your GP on-hand balances. GP can also receive order status updates from Walmart to track fulfillment. Financial reconciliation reports are pulled from Walmart on a schedule tied to your settlement calendar.

How ml-connector handles it

ml-connector stores your Windows domain account encrypted and uses it to authenticate to Dynamics GP's SBA or SOAP endpoint. For Walmart, it exchanges your OAuth2 client credentials for a 15-minute bearer token, refreshing it before each call. On the GP side, Walmart orders are written as unposted receivables invoices with line items and GL account mappings, respecting GP's constraint that only unposted transactions can be created. Inventory items are matched by SKU, and quantities are synced by polling both systems at intervals you define. Because GP does not push webhooks, the integration polls Walmart's orders endpoint (which returns up to 10,000 orders per call) at the cadence you select, deduplicating by order number to avoid duplicate invoices. Walmart's price-update throttle of 100 per hour is respected with backoff and retry. Every record carries a full audit trail, and failed writes are queued for replay when the next sync runs.

A real-world example

A three-store retail group sells apparel and home goods on Walmart Marketplace and uses Dynamics GP on their Windows Server for accounting, inventory, and vendor management. Before the integration, order data was exported from Walmart daily and re-entered into GP as invoices by hand, a process taking two hours and prone to entry errors. Inventory counts were checked manually each week and typed into both systems. With Walmart Marketplace and Dynamics GP connected, Walmart orders arrive in GP automatically as AR invoices, inventory syncs every four hours keeping both systems aligned, and the team spends no time on data re-entry. Month-end close is faster because order totals in GP match Walmart's settlement report without reconciliation work.

What you can do

• •Sync Walmart orders into Dynamics GP as receivables invoices with line items, customer references, and GL account mappings.
• •Keep inventory quantities and prices aligned between GP and Walmart Marketplace on a schedule you control.
• •Authenticate to GP with Windows domain credentials stored encrypted, and refresh Walmart OAuth2 tokens automatically on each call.
• •Poll both systems at intervals you define, deduplicate by order number, and respect Walmart's rate limits and token expiry constraints.
• •Track every order, price, and inventory change in a full audit trail with error queues for replay.

Questions

How does ml-connector handle the different authentication methods between Dynamics GP and Walmart Marketplace?

ml-connector stores your Windows domain account encrypted for GP and exchanges your Walmart OAuth2 client credentials for a 15-minute bearer token on each sync run, refreshing it before it expires. The integration bridges the two auth systems transparently, so you do not need to manage multiple credential sets yourself.

What happens if a Walmart order fails to write to Dynamics GP?

Failed orders are queued in the audit trail and retried at the next scheduled sync. ml-connector deduplicates by order number, so retrying an order that partially succeeded does not create duplicate invoices. The full error context is logged, so you can investigate what prevented the write - for example, a missing customer in GP or a closed fiscal period.

Why does the integration poll instead of relying on webhooks from Dynamics GP?

Dynamics GP does not support webhooks or push notifications; it is pull-only. ml-connector polls your GP instance at intervals you define using ModifiedDate filters to find new and changed orders efficiently. Walmart Marketplace does support webhooks, so the integration can optionally receive order and inventory events from Walmart to reduce polling overhead.