Sophio as a Source

Overview 

Sophio is a source that integrates with Flxpoint, allowing businesses to manage product data, inventory, and order processing directly from their Sophio account. It supports importing product catalogs, updating inventory levels, and automating order fulfillment. Sophio offers comprehensive product and pricing data for seamless synchronization with your Flxpoint store, streamlining operations for eCommerce businesses by keeping inventory updated and orders efficiently processed. Integration with Sophio ensures real-time product availability and accurate pricing updates within the Flxpoint platform.    

 

How to connect      

Access the Sources Section:

  • Navigate to the Sources section in Flxpoint Pro by clicking on the building icon on the left side of the dashboard.

Add a New Source:

  • Click on the plus button to add a new source.
  • Search for "Sophio" in the list of available sources.

Enter Required Connection Details:

  • Connection Name: Choose a descriptive name for the Sophio connection to easily identify it within your Flxpoint account.
  • Environment: Select Production, unless you want to test a sandbox.
  • API Key: Enter the API UUID key provided by Sophio to authenticate the connection.
  • Other Required Credentials: Provide any additional information like Username and Password.

Configure Data Mapping:

  • Once the connection details are entered, map the necessary data fields (e.g., product information, pricing, inventory levels) from Sophio to your Flxpoint setup.
  • Set up synchronization settings to automate updates for inventory and product information.

Finalize and Activate:

  • After completing the configuration, save your settings and activate the source.
  • The Sophio connection will now be live, enabling automatic import and updates of data from Sophio into your Flxpoint environment.
     
     

Order Operations

It submits orders to vendors for fulfillment and subsequently imports the shipment details, ensuring a seamless integration between order processing and shipment tracking. 
 

Send Fulfillment Requests
Get Shipments
Get Invoices 
Supported
Operations Details
Pro Tip

Yes, we Support Send Fulfillment Requests

This feature allows you to streamline your order processing and ensure that orders are fulfilled efficiently and accurately. By integrating with various fulfillment sources, you can automate order submissions, track fulfillment status, and handle exceptions more effectively.

Operation Workflow:

  • Integration Config
  • Store PK *
  • Sophio Store Id
  • Customer Id *
  • Sophio FBS Account Id
  • Customer Email *
  • Email to send order notification

Only linked items in Flxpoint can be sent to Sophio. The linecode is required, and it is expected to be saved through GIP in the 'supplier_product_id' field in the database.

×

 

Supported
Operations Details
Pro Tip

Yes, we support Get Shipments

This operation allows you to retrieve shipment tracking details and updates for your orders, ensuring that accurate delivery information is always available.

Operation Workflow

  • You need to configure BASE PATH and API UUID in connection config.
  • URI is structured as https://BasePath/Version/UUID/function.
  • Example BasePath = 'faceted-catalog-api-us1.sophio.com'.

Tracking is fetched using URL: https://staging-api.sophio.com/api/v1/api-uuid/trackingapi?orderId=orderNumber

This provides a JSON response with order tracking information, for example:


                    [
                      {
                        "order number": 1003,
                        "trackingnumber": "UPS:1ZE00A800390133294",
                        "line code": "MOT",
                        "SKU": "AST12275",
                        "shipped": "2020-05-07T00:30:47.999Z",
                        "Carrier": "UPS",
                        "ship method": "UPS GROUND",
                        "shipping cost": 10,
                        "invoice_status": "NEEDS REVIEW (3)"
                      }
                    ]
                    

Shipment is available at the item level, and tracking is fetched for each fulfillment request (FR) item.

Troubleshooting

Common Error #1: While fetching the invoice, you may encounter API errors due to various reasons.

Resolution Steps #1: Check the log where the error is captured to identify the exact issue and resolve it.

Supported
Operations Details
Pro Tip

Yes, we support Get Invoices

This operation enables you to access detailed invoices from suppliers, providing essential billing and payment information for your orders.

Operation Workflow:

  • Configure BASE PATH and API UUID in the connection settings.
  • Structure the URI as: https://BasePath/Version/UUID/function
  • Example: BasePath = 'faceted-catalog-api-us1.sophio.com'

Invoice Fetching:

The invoice is retrieved using the URL: https://staging-api.sophio.com/api/v1/7bc39c80-a2cc-4c41-89b7-6a9d8b64ec7b/getinvoicesapi?type=JSON&when=07052024:07192024

  • Type: JSON
  • When: Date range to fetch invoices, separated by a colon. Example: 07052024:07192024
  • By default, invoices for the last 14 days are fetched, but this can be modified in the settings.

The response is in JSON format:

{
    "account_number": "281923",
    "invoice_number": "405689-1",
    "invoice_date": "2020-06-05T19:28:43.997Z",
    "po_number": "49527293",
    "invstatus": "F",
    "linecode": "E29",
    "sku": "9006",
    "qty": 1,
    "price": 1.63,
    "coreprice": 0,
    "extended_price": 1.63,
    "shipping": 10,
    "invoice_total": 11.63
}
                    

Troubleshooting:

If there are errors when fetching the invoice, check the logs for detailed error information to resolve the issue.

 

How can we improve this article?

Share additional info and suggestions