Rothco as a Source
Summary
Rothco is a wholesale supplier of military, tactical, and outdoor gear. Connect it as a source with a single Rothco API Key from the Rothco API Portal - one connection covers full catalog import, fast inventory and pricing refresh, dropship order submission, and shipment tracking, all on Rothco's V2 API.
In your Rothco source, open Integrations → Get Inventory [Primary], click Start Creating Integrations, choose Rothco, then Create New connection. Paste your API Key, click Test Connection, then Save Connection. The same connection is reused by every Rothco operation.
| Field | What to enter |
|---|---|
API KeyRequired | The single API Key from your Rothco API Portal. New connections must use your Rothco API V2 Key - Flxpoint runs on Rothco's V2 API, so existing connections keep working ahead of Rothco's V1 retirement on June 26, 2026. The same key is reused by every Rothco operation.
One key covers inventory, orders, acknowledgments, and shipments - no separate keys per integration. Obtain it via Rothco's Sandbox → test order → approval → Live Mode flow (see below). |
Billing EmailSetting | The Dealer email that receives order confirmations from Rothco. Entered in the Configure Settings step of Send Fulfillment Requests, not on the connection screen.
Required before submitting dropship orders. |
One API Key covers all operations - no separate keys per integration
The same Rothco connection (API Key) is reused across Get Inventory (Primary), Get Inventory (Secondary), Send Fulfillment Requests, and Get Shipments. Create the connection once in Get Inventory (Primary) and simply select it in every other operation.
New accounts must complete Sandbox approval before live orders can flow
Rothco requires a test order placed in Sandbox Mode and approved by their team before your account can switch to Live Mode. Until approval is complete, live order submission fails. The flow is: switch to Sandbox → place a test order → send the Order Confirmation ID to Rothco → after approval, switch to Live Mode and copy the live API Key.
Enable Archive / Un-Archive on only one inventory job - Primary or Secondary, never both
Turning on Archive/Un-Archive in both Get Inventory (Primary) and Secondary makes items archive then immediately restore each cycle, which can drop products to zero quantity unexpectedly. Pick one job to own archival - typically Primary.
Restricted items won't appear until your account is enrolled in Rothco's Authorized Reseller Program
Some Rothco products are gated behind the Authorized Reseller Program and will not appear in your catalog import until your Rothco Dealer account is approved for those brands. Review your enrollments in the Rothco Dealer Portal under Online Catalog → Authorized Reseller Programs. Once enrollment is confirmed the items appear automatically - no Flxpoint configuration needed.
Invoice mapping for Rothco billing
Flxpoint now retrieves the actual Invoice Number and Invoice ID from Rothco's API rather than using the Web Confirmation ID. This ensures that invoicing data in Flxpoint matches the billing records received by your accounting team. These fields are automatically exposed in the Rothco Get Invoice mapping template after the order details are fetched; no manual remapping of existing fields is required for this update to take effect.
Imports the full Rothco catalog - product lines, variants, attributes, categories, images, pricing, and inventory levels
| Rothco Source Field | Maps To - Flxpoint Field |
|---|---|
| Inventory: SKU Code | → SKU. Variant identifier. Required. e.g. RTH-12345. |
| Inventory: Product Line Code | → Parent SKU. Links variants to a parent product. Required. |
| Inventory: Product Line Name | → Title. Display title. Required. |
| Inventory: Short Description | → Description. Short description. Optional. |
| Inventory: Price | → Cost. Dealer cost in USD. Required. |
| Inventory: MSRP Price | → MSRP. Manufacturer suggested retail price. Optional. |
| Inventory: MAP Price | → MAP. Minimum advertised price. Optional. |
| Variant Inventory Level | → Quantity. On-hand units. Required. High-stock 99+ is converted to a number automatically. |
| Inventory: Weight | → Weight. Product weight. Optional. |
| Inventory: UPC | → UPC. Barcode. Optional. |
| Inventory: Product Category 1 | → Primary Category. Top-level category. Optional. |
| Inventory: Product Category 2 | → Sub Category. Second-level category. Optional. Default template: Rothco V2 GIP. |
Fast refresh of SKU, Cost, MAP, MSRP, and Quantity between full Primary runs - no catalog re-import
| Rothco Variant Field | Maps To - Flxpoint Field |
|---|---|
| Inventory Variant: SKU Code | → SKU. Variant identifier. Required. |
| Variant Inventory Level | → Quantity. On-hand units. Required. |
| Inventory Variant: Price | → Cost. Dealer cost in USD. Required. |
| Inventory Variant: MAP Price | → MAP. Optional. |
| Inventory Variant: MSRP Price | → MSRP. Optional. Reuses the same Rothco connection as Primary; default template Rothco V2 GIS. Catalog fields (titles, images, categories) belong to Primary. |
Submits Flxpoint Fulfillment Requests to Rothco as dropship orders using the same Rothco connection
| Flxpoint FR Field | Maps To - Rothco Order Field |
|---|---|
| Fulfillment Request Number | → PO / Reference. Required. Must be unique - Rothco rejects duplicate references. e.g. FR12345. |
| Billing Email | → Billing Email. Required. Dealer email for order confirmations; set in the Configure Settings step, not the mapping template. |
| Full Name | → Ship To Name. Required. |
| Address Line 1 | → Ship To Address Line 1. Required. |
| Address Line 2 | → Ship To Address Line 2. Optional. |
| City | → Ship To City. Required. |
| State | → Ship To State. Required. |
| Postal Code | → Ship To ZIP. Required. |
| Customer Email | → Customer Email. Required. |
| SKU | → Item: SKU. Required. e.g. RTH-12345. |
| Quantity | → Item: Quantity. Required. |
| Hold for X Hours | → Hold. Optional; set in Configure Settings to delay transmission (default 0). |
| Shipping Method | Most Rothco accounts use vendor-selected shipping - leave this unmapped and let Rothco pick the carrier. Only map a code from Rothco's shipping-codes reference (e.g. UPS - Ground, FXGHD) if your account is configured to receive one. Default template: Send Purchase Orders. |
Pulls tracking number, shipped date, method, and item-level shipped quantities back into Flxpoint
| Rothco Shipment Field | Maps To - Flxpoint Field |
|---|---|
| Shipment: Tracking Number | → Tracking Number (header). Required. |
| Shipment: Shipped At | → Shipped At (header). Optional; add a fallback rule if Rothco omits the date on a shipment. |
| Shipment: Shipping Method Name | → Method (header). Optional. |
| Shipment: Shipping Method Code | → Carrier / Note (header). Optional. |
| Shipment: PO Number | → Order / PO Reference (header). Optional; used to link the shipment to the original FR/PO. |
| Shipment Item: SKU Code | → Shipment Item: SKU (item). Required. |
| Shipment Item: Quantity Shipped | → Shipment Item: Quantity (item). Required. Actual quantity shipped per line - not copied from the PO; partial shipments report exactly what was sent. Default template: Get Shipments 2. |
Connection failing or Test Connection returning an error
Order rejected - required field missing or API validation error
Field "email" of required type "String!" was not provided.). Read the error to find the failing field, then audit your Send Fulfillment Requests mapping template so it supplies a non-empty value for every order. Required fields: Ship To Name, Address Line 1, City, State, ZIP, Customer Email, SKU, and Quantity.Order submission failing - processing error with shipping method
UPS - Ground, FXGHD).Items missing from the catalog import
Products unexpectedly archived / dropping to zero quantity
Shipments or tracking not importing
Do I need to do anything for the Rothco V2 API migration?
What does the "99+" quantity value mean in Rothco inventory?
99+. Flxpoint automatically converts this to a numeric value during Get Inventory - no mapping rule or manual handling needed. The converted quantity appears in your Global Inventory Pool like any other number.