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.
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.
| 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. |
| 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. |
| 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. |
| 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. |
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.UPS - Ground, FXGHD).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.