Sophio as a Source
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.
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.
| Field | What to enter |
|---|---|
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. |
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.
Imports the Sophio catalog (product data, pricing and inventory levels) and stores each item's linecode for later ordering
supplier_product_id field, which Send Fulfillment Requests later requires. Run this as your full catalog refresh.Refreshes pricing and quantity between full catalog runs to keep availability and cost current
Submits fulfillment requests to Sophio for linked items and receives auto-acknowledgements
| 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. |
supplier_product_id (populated by Get Inventory Primary). Supported: Fulfillment Request Number, FR Item Association, Auto Acknowledgements. Not supported: Customer Association, Custom Fields, Attachments.Pulls item-level tracking for each fulfillment-request item back into Flxpoint
Send Fulfillment Requests failing: items not sending to Sophio
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
Orders appear successful but are not placed in Sophio's system
What are the required connection fields for Sophio?
How does Get Shipments retrieve tracking from Sophio?
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?
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?
supplier_product_id field before orders can be submitted.