Sophio as a Source

July 2, 2026

Summary

Sophio is a B2B parts distribution platform connected to Flxpoint over its API. The connection authenticates with an API UUID key plus a BasePath (base domain) that are combined into the pattern https://BasePath/Version/UUID/function, and it supports importing product, pricing and inventory data, submitting orders, and pulling shipment tracking back into Flxpoint. Only items already linked in Flxpoint can be ordered, and each item's linecode must be stored in the supplier_product_id field during the inventory import.

What this integration does

Get Inventory (Primary)

Imports the Sophio catalog – product data, pricing and inventory levels – and stores each item's linecode for later ordering

Get Inventory (Secondary)

Refreshes pricing and quantity between full catalog runs to keep availability and cost current

Send Fulfillment Requests

Submits fulfillment requests to Sophio for linked items and receives auto-acknowledgements

Get Shipments

Pulls item-level tracking for each fulfillment-request item back into Flxpoint

How to connect - credentials you need

In Flxpoint Pro, open the Sources section (building icon on the left), click the + button to add a source, search for Sophio, then enter the connection details below and save.

Connection NameRequired

A descriptive name for this Sophio connection so you can identify it within your Flxpoint account.

Free text – choose whatever helps you recognize the connection.

EnvironmentSetting

Selects the Sophio environment the connection targets – Production or Sandbox.

Choose Production for live order fulfillment. Sandbox accepts requests and returns valid responses without placing real orders.

API Key (API UUID)Required

The API UUID key provided by Sophio – used to authenticate every API call for this connection.

Obtain this from your Sophio account representative.

Username & PasswordOptional

Some Sophio configurations require an additional username and password alongside the API UUID.

Provide these only if your Sophio account requires them – confirm with your Sophio representative.

Can't connect? Confirm the API UUID matches exactly what Sophio provided. If your account requires a username and password, make sure both are entered.

Important - read before configuring

Only linked items with a saved linecode can be sent to Sophio

Send Fulfillment Requests requires that each item being ordered is already linked in Flxpoint and has a linecode stored in the supplier_product_id field. This value is expected to be populated during the Get Inventory (Primary) run. If an item is unlinked or the linecode is missing, it cannot be submitted to Sophio.

The API UUID is required – configure it in the connection settings

The connection needs your API UUID. Flxpoint combines it with a fixed base path (e.g. faceted-catalog-api-us1.sophio.com), a version, and a function name to build the full API URL for each operation. Confirm both with your Sophio account representative before configuring the connection.

Select the Production environment – Sandbox returns success without posting real orders

The connection settings include an Environment selector (Production or Sandbox). Always confirm you are using Production for live order fulfillment. Sandbox mode accepts requests and returns valid responses without actually placing orders.

Get Invoices defaults to the last 14 days – adjustable in settings

The invoice retrieval uses a date-range parameter and by default fetches the last 14 days. This window can be changed in the integration settings. Each invoice line includes account number, invoice number, invoice date, PO number, invoice status, linecode, SKU, quantity, price, core price, extended price, shipping and invoice total.

Mapping - fields to know

Get Inventory (Primary) Get Inventory (Secondary) Send Fulfillment Requests Get Shipments

Imports the Sophio product catalog – product data, pricing and inventory levels – into Flxpoint. During this run Flxpoint stores each item's linecode in the supplier_product_id field, which Send Fulfillment Requests later requires. Run this as your full catalog refresh.

Optional. Runs between full catalog imports to keep pricing and quantity current without re-importing the entire catalog, so product availability and cost stay accurate. Attributes, images and categories continue to come from Get Inventory (Primary).

Field	Notes
Store PK	Required. Store primary key in the Send Fulfillment Request configuration.
Customer Id	Required. Your Sophio customer identifier.
Customer Email	Required. The address where Sophio sends the order notification.
Sophio Store Id	Optional. The Sophio-side store identifier.
Sophio FBS Account Id	Optional. The Sophio FBS account identifier.
Shipping Selection	Required. Carrier must be `ups` or `fdx`.
Max Fulfillment Days	Mapping-template field. The maximum amount of time the order may take to fulfill.
Hold Until Entire Order Can Ship	Mapping-template field. Set `True` to hold until the entire order can ship; set `False` to allow split shipments.

Called Send Fulfillment Requests in Sophio. Only items already linked in Flxpoint can be sent, and the linecode must be saved in supplier_product_id (populated by Get Inventory Primary). Supported: Fulfillment Request Number, FR Item Association, Auto Acknowledgements. Not supported: Customer Association, Custom Fields, Attachments.

Fetches item-level tracking for each fulfillment-request (FR) item and writes it back to the order. The tracking response includes order number, tracking number, line code, SKU, shipped date, carrier, ship method, shipping cost and invoice status. Item ID associates each shipment line to its SKU, and partial shipments are supported. Invoice information and custom fields are not returned by this operation.

Common issues

Send Fulfillment Requests failing – items not sending to Sophio

The usual cause is that items are not linked in Flxpoint or their linecode is missing from the supplier_product_id field. Only linked items with a populated linecode can be submitted. Verify the items are linked in the product catalog and that Get Inventory (Primary) ran successfully and populated the linecode. If linecodes are missing, re-run the import and confirm the mapping template includes the supplier_product_id field.

Get Invoices or Get Shipments returns API errors in the logs

Check the integration job log for the specific error message – the error is captured there. Common causes are an incorrect API UUID in the connection settings, a malformed date range for Get Invoices, or a network issue between Flxpoint and the Sophio API endpoint. Verify the API UUID matches what Sophio provided.

Orders appear successful but are not placed in Sophio's system

If Send Fulfillment Requests returns a successful response but nothing appears in Sophio, confirm you are not using the Sandbox environment. Sandbox accepts requests and returns valid success responses without actually placing orders. Open the Sophio connection settings in Flxpoint and set Environment to Production.

FAQs

What are the required connection fields for Sophio?▸

The connection requires a Connection Name, an Environment (Production or Sandbox), and an API Key (your API UUID from Sophio). Some configurations also require a Username and Password. In addition, for Get Shipments and Get Invoices the API UUID must be configured so Flxpoint can build the full endpoint URLs. Contact your Sophio account representative to obtain all credentials.

How does Get Shipments retrieve tracking from Sophio?▸

Get Shipments fetches tracking for each FR item using the pattern https://staging-api.sophio.com/api/v1/{api-uuid}/trackingapi?orderId={orderNumber}. The response is item-level JSON and includes order number, tracking number, line code, SKU, shipped date, carrier, ship method, shipping cost and invoice status. Because tracking is fetched separately for each Fulfillment Request item, partial shipments are supported.

What does Get Invoices return from Sophio?▸

Get Invoices retrieves invoice data using https://staging-api.sophio.com/api/v1/{uuid}/getinvoicesapi?type=JSON&when={daterange}, where the date range format is MMDDYYYY:MMDDYYYY (e.g. 07052024:07192024). Each JSON line item includes account_number, invoice_number, invoice_date, po_number, invstatus, linecode, sku, qty, price, coreprice, extended_price, shipping and invoice_total. The default lookback window is 14 days but can be configured.

What fields are required for Send Fulfillment Requests?▸

Send Fulfillment Requests requires Store PK, Customer Id, and Customer Email (the address where Sophio sends order notifications). Sophio Store Id and Sophio FBS Account Id are also part of the configuration. All items must be linked in Flxpoint and have their linecode stored in the supplier_product_id field before orders can be submitted.

Back to General Supplier Integrations