SP Richards as a Source
Summary
SP Richards is a wholesale distributor of office supplies, furniture and business products, available as a pre-built Source integration in Flxpoint. The base product catalog and on-hand quantity feed connect automatically — you only add a connection for pricing, either a customer-specific pricing FTP or the SPRichard API (Group Code, User ID, Password), which brings in Cost and MSRP alongside the catalog. Five operations are supported: Get Inventory Primary (full catalog, daily), Get Inventory Secondary (price/quantity refresh, more frequent), Send Fulfillment Requests, Get Shipments, and Get Invoices.
SP Richards supports two connection types for pricing. Use the one your SP Richards representative confirms for your account. Add an SP Richards source, start configuring an operation, and when Flxpoint prompts you click + New Connection, enter the values, then Test Connection → Save Connection.
support@flxpoint.com.Cost and MSRP need a pricing connection — the base catalog feed is quantity-only
SP Richards provides your product catalog and on-hand quantities automatically; no connection setup is required for that base feed. To bring in Cost and MSRP, add a connection for pricing — either a customer-specific pricing FTP (credentials and file name are provided by SP Richards per account) or the SPRichard API (Group Code, User ID, Password), which returns price and quantity together. When mapping a pricing FTP file, use the “Price File Header List & Descriptions” spec SP Richards provides for your account to confirm which columns map to Dealer Cost and MSRP — without one of these two connections, Cost and MSRP fields will import empty.
Send FR requires Ship Node as exactly two digits, and a Ship To Account Number
The Ship Node field in your Send Fulfillment Requests mapping template must be a two-digit distribution center code (e.g., 01, 16, 31) — not a single digit and never prefixed (DC 01 is invalid). Ship Node is required even when using Source Complete “C”. A Ship To Account Number must also be set, either in the connection settings or mapped in the template — if neither provides a value, the job fails. Each SP Richards source supports a single Ship To Account Number; if you need to route orders to different accounts, duplicate the SP Richards source and use order routing rules to direct orders between them.
Run GIP daily for the full catalog, GIS more often for price/quantity — Archive on one job only
Get Inventory Primary imports the full catalog — titles, descriptions, categories, images and dimensions — and should run once daily. Get Inventory Secondary is a lighter delta update for Cost, MSRP and Quantity only, and is designed to run more frequently (commonly hourly) to keep pricing and stock current between full catalog syncs. Flxpoint already enforces that Archive/Un-Archive can be enabled on either GIP or GIS, but not both at the same time (Primary is recommended).
Quantity aggregates across every warehouse you select
Both Get Inventory Primary and Secondary let you choose which SP Richards warehouses to include (SP Richards operates over 30 U.S. and Canada locations). Flxpoint sums quantity across all selected warehouses — for example, if one location shows 4 units and another shows 7, Available Quantity in Flxpoint will be 11. Select only the warehouses relevant to your fulfillment geography so you don’t show stock you can’t actually reach.
| Field | Maps To — Notes |
|---|---|
| SKU / Catalog SKU | → Product / Variant → SKU. Required. Primary identifier for the catalog item. |
| Description 1 | → Product → Title. Item description, used as the product title. |
| Brand Name / Manufacturer Name | → Product → Brand. Manufacturer/brand attribution. |
| Department / Class / Subclass Name | → Product → Category. SP Richards’ category hierarchy. |
| Dealer Price | → Pricing → Cost. Populated once a pricing connection (FTP or API) is configured. |
| MSRP / Retail Price | → Pricing → MSRP. Same pricing-connection dependency as Cost. |
| Weight | → Product → Weight. Shipping weight in pounds. |
| UPC | → Identifiers → UPC. Manufacturer barcode. |
| Images (multiple resolutions) | → Product → Images. |
| Field | Maps To — Notes |
|---|---|
| Item Number | → Inventory Variant → SKU. Required. Matches the SKU imported by Get Inventory Primary. |
| Per-warehouse quantity | → Inventory → Quantity. Flxpoint sums quantity across every warehouse selected in the operation’s settings. |
| Full catalog fields | Not included in Secondary — titles, images, categories and long descriptions come from Get Inventory Primary. Run Primary daily for the full catalog and Secondary more frequently to keep Cost, MSRP and Quantity current. |
| Source Field | Maps To (SP Richards) — Notes |
|---|---|
| Fulfillment Request Item → SKU | → Order Line → Customer Item. Required. Sent per line item. |
| Fulfillment Request Item → Quantity | → Order Line → Ordered Quantity. Required. Units requested per line. |
| Shipping address | → Ship To. Required. End-customer shipping address. |
| Billing address / contact | → Contact Info. Buyer contact details sent with the order. |
| Source Shipping Method | → Ship Method. Map only if your SP Richards representative has confirmed your account is set up to receive one. |
| Ship Node (mapping template field) | → Distribution Center. Required. Two-digit DC code — no prefix, no single digits. |
| Ship To Account Number | → Account Reference. Required. Set in connection settings or mapped in the template; one per Flxpoint source. |
| Field | Maps To — Notes |
|---|---|
| Ship Date | → Shipment → Shipped At. Date SP Richards marks the shipment shipped. |
| Tracking Number | → Shipment → Tracking Number. May be blank on some LTL shipments — Carton ID or BOL can be mapped as a fallback. |
| Carton ID / BOL | → Shipment → Tracking Reference (fallback). Used when a carrier tracking number isn’t provided. |
| Carrier / Method | → Shipment → Ship Method. Carrier and service description returned by SP Richards. |
| Purchase Order Number | → Shipment → FR Reference. Required. Links the shipment back to the originating Fulfillment Request. |
| Shipped Quantity | → Shipment Item → Quantity. Required. Units shipped for the line. |
The line SKU is not mapped on this operation — Flxpoint matches the shipped line to your catalog itself. Map the shipped quantity as usual.
| Field | Maps To — Notes |
|---|---|
| Invoice Number | → Invoice → Invoice Number. Required. SP Richards’ invoice reference. |
| Invoice Date | → Invoice → Invoice Date. Date the invoice was issued. |
| Freight / Handling / Tax / Other Cost | → Invoice → Header Charges. Saved as separate invoice line items alongside the item lines. |
| Total Cost | → Invoice → Total. Invoice grand total. |
| Shipped Quantity / Extended Amount | → Invoice Item → Quantity / Amount. Units invoiced and the line’s extended cost. |
The line SKU is not mapped on this operation — Flxpoint links the invoice line to your catalog and the originating fulfillment request itself.
support@flxpoint.com if you need help configuring the transformation.01, not 1), never prefixed with DC; required even with Source Complete “C”. (2) Ship To Account Number is not set in either the mapping template or the connection settings — if neither provides a value, the job fails. Check both locations, then test with a single order before re-enabling automatic sending.What is the difference between Get Inventory Primary and Get Inventory Secondary?▸
What warehouses does SP Richards support, and how does multi-warehouse quantity work?▸
How do I change which SP Richards distribution center my orders are sent to?▸
16, 05) — exactly two digits, with a leading zero if needed, and never prefixed with DC. After saving, validate by confirming the next order sent to SP Richards arrives at the correct distribution center.