SOS Inventory Integration
The SOS Inventory integration syncs products, inventory, customers, orders, invoices, shipments, and payments between SOS Inventory and WizCommerce. Confirmed orders, new customers, and payments push from WizCommerce to SOS in real time, and inventory, invoices, shipments, and SOS-origin customer/order updates pull from SOS on a regular schedule.
This article walks through how the integration is set up, what data syncs, when, and how to handle the common scenarios.
Platform: WizCommerce (with SOS Inventory) | Who is this for: Admins
Table of Contents
| Sections | Topics |
| A | How the Connection Works |
| B | What Data Syncs Between SOS and WizCommerce |
| C | Sync Timing |
| D | Troubleshooting and Common Issues |
| E | FAQs |
Before You Begin
- Confirm you have an active SOS Inventory account.
- Have your SOS Inventory account email and password ready, these are required to authenticate the integration with SOS Inventory.
- Decide on sales rep mapping with WizCommerce team. If a rep isn't mapped, WizCommerce falls back to a configured contact (for example, a default rep or team) depending on your account setup.
- Make sure every product in WizCommerce has a valid Reference ID. Orders containing a product without a Reference ID will fail to push to SOS.
A. How the Connection Works
You share your SOS Inventory access token and account details with WizCommerce team through a secure channel. WizCommerce team configures the WizCommerce-side mapping (sales rep, catalog/price tier, address handling) and runs a first sync.
Once configured, WizCommerce pushes confirmed orders, new customers, and payments to SOS in real time and pulls inventory, invoices, shipments, and customer/order updates from SOS on a regular schedule.
B. What Data Syncs Between SOS and WizCommerce
The integration between SOS and WizCommerce keeps your data in sync across both platforms. Below is a quick overview of the entities that sync, the direction of the data flow, and what each covers.
|
Entity |
Direction |
Notes |
|
Products |
SOS → WC |
Product pull from SOS Inventory is not currently supported. If required in the future, this will need to be built as part of a separate development effort. |
|
Inventory |
SOS → WC |
Pulled every two hours. See the inventory mapping below. |
|
Customers |
Both ways |
New customers and edits push from WizCommerce to SOS in real time. SOS-origin customers and updates pull on schedule. |
|
Orders |
Both ways |
Confirmed WizCommerce orders push to SOS in real time. SOS-origin orders pull every two hours. |
|
Invoices |
SOS → WC |
Pulled every two hours. Cannot be created in WizCommerce. |
|
Shipments |
SOS → WC |
Pulled every two hours. Cannot be created in WizCommerce. |
|
Payments |
Both ways |
Online payments push to SOS in real time. SOS-recorded payments pull on schedule. |
» Inventory mapping
Here is how SOS inventory values are mapped to WizCommerce fields and the logic behind each.|
WizCommerce |
Description |
Logic |
|
Available |
Quantity available to sell |
max(0, SOS Available − SOS onPO) |
|
Back Order Limit |
Excess quantity order limit |
max(0, min(SOS Available, SOS onPO)) |
|
On Order |
Quantity in transit |
max(0, SOS onPO) |
» Reference ID requirement on products
Every product synced through SOS must have a valid Reference ID. Products without one are skipped during sync, and orders containing a product without a Reference ID will fail to push.
To add a new product correctly:
- Create the product in SOS first.
- Export your current products from WizCommerce.
- Add the new product to the export/import sheet, making sure Reference ID is filled in.
- Re-import the sheet into WizCommerce.
To fix an existing product missing a Reference ID, contact help@wizcommerce.com. Support can either delete and re-upload the product or update the Reference ID manually to avoid duplicates.
C. Sync Timing
Confirmed orders, new customers, and payments push to SOS in real time. Inventory, invoices, shipments, and SOS-origin customer/order updates pull on a scheduled interval (typically every two hours, starting at 12 PM PST). These schedules are configurable and can be adjusted to match your operational needs.
D. Troubleshooting and Common Issues
» An order failed to push because a product doesn't exist in SOS
If an order in WizCommerce contains a product that doesn't exist in SOS, the push will fail. Add the product in SOS first, then retry the order push.
» An order failed to push because a product is missing a Reference ID
The Reference ID is what links a product between the two systems. Orders containing a product without a valid Reference ID will not push. See the Reference ID requirement on products note in Section C for how to add or fix Reference IDs.
» An edit to a WizCommerce order didn't reach SOS
Edits push to SOS in real time unless shipments or invoices have already been created in SOS for that order. After that point, any WizCommerce-side edits (addresses, items, discounts, quantities) will not push. Make the edit in SOS directly.
» A line item note isn't appearing in SOS
Notes added at the line item level in WizCommerce are not pushed — SOS doesn't support line item notes. If the note is critical, capture it in customer notes or the order memo instead.
» Inventory in WizCommerce doesn't match SOS
Inventory pulls every two hours, so WizCommerce shows the last sync, not real time. The Available quantity is calculated as max(0, SOS Available − SOS onPO). If a product in SOS doesn't have a mapping in WizCommerce (no Reference ID match), inventory for it is skipped during sync.
» Prices look different between WizCommerce and SOS
WizCommerce uses catalog-based pricing, while SOS uses a fixed list price with price tier discounts. The price applied to an order is correct in both systems, but the catalog assignment shown on the SOS side may differ if the WizCommerce order used a different price tier at order time. This is a display difference, not a pricing error.
» A customer in SOS isn't getting updates from WizCommerce
Edits to customers in WizCommerce push to SOS in real time. If a customer update made in WizCommerce doesn't appear in SOS, check whether the customer exists in SOS with a matching Reference ID. If the customer is WizCommerce-origin and hasn't yet been pushed, the push happens at the next sync.
FAQs
1. Are product images synced from SOS Inventory?Still need help? Reach out to our support team at help@wizcommerce.com.