Kinsey's is a wholesale distributor of archery, hunting, and outdoor sporting goods — bows, crossbows, arrows, firearms, optics, and related gear from top brands. As a source in Flxpoint, Kinsey's provides reliable catalog imports, pricing and inventory sync, fulfillment-request submission, shipment tracking, invoice retrieval (including line-by-line breakdowns of product, fee, shipping, and tax), and product image retrieval.
How To Connect
Product Operations
The primary operation handles the bulk of your inventory management needs, while the secondary operation allows for more detailed control, such as focusing on specific products or updates
Get Inventory and Pricing & Quantity
- Import the full Kinseys catalog with core details (brand, title/description, categories, images, weight).
- Update dealer pricing and MSRP/Retail when available to your account.
- Keep on-hand quantities current by warehouse; sum when multiple locations are selected.
- 1Choose Connection — FTP (Basic Auth) or Kinseys API Token.
-
2Retrieve Data —
FTP: Reads the latest CSV from your provider’s FTP (you supply folder + file pattern). API: Requests product, price, and qty using Group Code / User ID / Password.When API is connected, API price/qty is used; otherwise, FTP is used per your configuration.
- 3Map Fields — Match incoming columns to your Mapping Template.
- 4Persist — Values are saved to the Global Inventory Pool and flow to channels after your next push.
-
Quantity (On-hand) FTP —
ftp.sprich.com| useronhand| passonhand| filesprfull.ezoh(typically quantity-only). -
Pricing FTP (Customer-Specific) — Credentials and filename are provided by KNS per customer (name varies, e.g.,
JPR.x12_832_0724.csv) and include your dealer pricing columns.
-
1Connect an Integration — Choose Kinseys, then create a connection.
Connection Type
-
FTP (Basic Auth)
Fields: Connection Name, FTP Host/Port, FTP User, FTP Password.
Advanced: File Transfer Mode (Binary), Maintain Constant Connection, Use Unbuffered Private Data Channel (FTPS 534 policy only).
Tip: Use Test Connection to validate credentials and folder visibility. -
Kinseys API Token
Fields: Connection Name, Group Code, User ID, Password.
Use When: You need dealer pricing and direct price/qty from the API.
-
FTP (Basic Auth)
-
2Configure Settings
-
Remote File Name Pattern (FTP) — e.g.,
*.csvor an exact filename. -
Inbound Remote File Folder (FTP) — e.g.,
/incoming/products. - File Action — set to Read for this job.
- Warehouses — choose All or specific locations. Selected warehouses are summed for Available Quantity.
- Archive/Un-Archive Inventory — Optionally archive SKUs missing from the feed and auto-restore when they reappear.
Recommendation: Avoid enabling Archive on both this job and any secondary import for the same source. -
Remote File Name Pattern (FTP) — e.g.,
- 3Create a Mapping Template — Start with the recommended fields below and adjust as needed.
- 4Save & Schedule — Run manually or set a schedule (jobs run in UTC).
Kinsey's API uses two endpoints: the Products API (/v2/Products) for catalog data such as name, description, images, brand, and barcode; and the Inventory API (/v2/Inventory) for real-time stock levels, cost, MAP, and MSRP. Map each Flxpoint field to the correct source field per the table below.
| Flxpoint Field | Kinsey's Source Field | Status | Notes |
|---|---|---|---|
| SKU (T) | Inventory: SKU | Required | Primary product identifier |
| Title (T) | Product: Name | Required | Product display name |
| Description (T) | Product: Description | Optional | Short or long description |
| UPC (T) | Product: Barcode | Optional | ⚠️ Map to Product: Barcode (Products API), NOT Inventory: UPC. UPC values live in the Products API barcode field — the Inventory API does not carry UPC. |
| Cost (N) | Inventory: Cost | Optional | Unit cost from inventory feed |
| Quantity (N) | Inventory: Quantity | Optional | Real-time stock from Inventory API |
| MSRP (N) | Inventory: MSRP | Optional | Retail price |
| MAP (N) | Inventory: MAP | Optional | Minimum advertised price |
| Weight (N) | Product: Weight | Optional | Shipping weight |
| Image (T) | Product: Image URL | Optional | Primary product image |
| Brand (T) | Product: Brand | Optional | Manufacturer/brand name |
Barcode field. They are not present in the Inventory API response.
To import UPC values correctly, map:
- Flxpoint field: UPC (T)
- Source field: Product: Barcode
If UPC is mapped to an Inventory API field instead, any product not present in the Inventory API (~9K items in a typical Kinsey's catalog) will import with a blank UPC.
-
Quantity (On-hand) FTP —
ftp.sprich.com| useronhand| passonhand| filesprfull.ezoh.
This file is typically quantity-only. -
Pricing FTP (Customer-Specific) — Provided by KNS per customer; filename varies.
Sample:JPR.x12_832_0724.csv| Specs: Price File Header List & Descriptions.xlsx.
| Flxpoint Target | KNS Column | Description |
|---|---|---|
| Wholesale Cost | CI — “Promo Level 1 Dealer Cost” | Dealer/contract cost used as item cost. |
| MSRP | AF — “Current Retail Price” | Retail/MSRP reference. |
| Field | Kinseys Field | Notes |
|---|---|---|
| SKU |
Sku / Catalog Sku
|
Unique identifier. |
| Title |
Description 1 (fallback Description 2/3) |
Readable product name. |
| Brand |
Brand Name / Manufacturer Name
|
Normalize as needed. |
| Quantity | Quantity |
Summed across selected warehouses. |
| Client Price | Dealer Price |
Account-specific dealer pricing (when present). |
| Cost | CI — “Promo Level 1 Dealer Cost” | Map from pricing FTP/API. |
| MSRP | AF — “Current Retail Price” | Map from pricing FTP/API. |
| Category 1 | Department Name |
Top-level category. |
| Category 2 | Class/Subclass Name |
Second-level category. |
| Weight | Weight |
Pounds. |
| UPC | Upc |
Barcode when present. |
| Attributes |
Specifications / Marketing Text … |
Map as custom fields. |
| Images | (Image URL fields) | Single primary image; extras as custom fields if desired. |
If UPC values are blank on some or all imported Kinsey's items, check your Get Inventory (Primary) mapping template:
- Open Get Inventory (Primary) → Mapping Template.
- Find the UPC (T) field row.
- Confirm it is mapped to Product: Barcode (not to any Inventory API field).
- Save the template and re-run Get Inventory (Primary). UPC values should populate on the next run for all products where Kinsey's provides a barcode in their Products API.
Kinsey's Products API (~29K items) and Inventory API (~20K variants) do not have full overlap. Products not present in the Inventory API will still be saved to Flxpoint, but quantity, cost, MAP, and MSRP will be blank. This is expected behavior — those fields are sourced exclusively from the Inventory API. Contact Kinsey's if you believe a specific SKU should be present in their inventory feed.
| Price Source | API or FTP | API takes precedence when connected. |
| Currency | USD | Values imported as provided by Kinseys. |
| Rounding | NONE | Imported raw; apply pricing rules downstream if desired. |
| Quantity Logic | SUM | Sum of selected warehouses. |
| Variations | NOT SUPPORTED | Simple products only. |
| Delta vs Full | FULL FEED | Processes full catalog. |
| Archive | SUPPORTED | Missing SKUs archived; re-appear when present. |
| Custom Fields | SUPPORTED | Extra attributes saved at variant level. |
-
Costs are empty:
- Confirm you have a pricing FTP from KNS (customer-specific credentials) or use the API. The onhand FTP (
ftp.sprich.com/onhand/onhand) is typically quantity-only. - Verify you’re pulling the correct pricing file (name varies; example
JPR.x12_832_0724.csv) and mapping CI → Cost, AF → MSRP per “Price File Header List & Descriptions.xlsx”. - If KNS confirms the FTP file no longer carries pricing, request API credentials (Group Code, User ID, Password) and switch the connection to API.
- Confirm you have a pricing FTP from KNS (customer-specific credentials) or use the API. The onhand FTP (
- FTP auth errors: Re-check host/port/user/pass; try Test Connection. For FTPS 534, toggle “Use Unbuffered Private Data Channel.”
- API credential errors: Confirm Group Code, User ID, Password and endpoint access.
-
Missing qty: Ensure the same warehouse selection is used consistently and that the source returns non-zero
Quantity. - Items missing post-run: If Archive is enabled, SKUs absent from the feed are archived until they reappear.
Order Operations
It submits orders to vendors for fulfillment and subsequently imports the shipment details, ensuring an integration between order processing and shipment tracking.
Send Orders
- Create one supplier-ready XML order per eligible Fulfillment Request.
- Deliver the XML to Kinseys via FTP using your outbound folder path.
- Control timing with Hold for X hours and Only Send During Business Hours.
- 1Build XML — The job assembles an order XML using your Mapping Template (header + lines).
- 2Upload — The file is posted to your configured Outbound Remote File Folder on Kinseys’s FTP.
- 3Mark Sent — If the upload returns no error, the order is marked as sent/processed.
#PO-78431 → XML to /outbound/orders/. No upload errors ⇒ marked sent.- 1Connect an Integration — Choose Kinseys and select your FTP (Basic Auth) connection.
-
2Configure Settings
- Outbound Remote File Folder * — Remote path where order XML files will be written.
- Ship To Account Number * — Required header value used by Kinseys to route the shipment.
-
Advanced
- Hold for X hours — Delay sending for X hours to allow review or edits.
- Only Send During Business Hours — Restrict transmissions to business hours.
- 3Select a Mapping Template — Pick an existing template (e.g., Send Orders 1) or create a new one.
- 4Save & Schedule — Run now or schedule (jobs run in UTC).
Enable scheduling so orders go out automatically. The status page will show Connected, Configured, and Mapped (e.g., template Send Orders 1). Schedules run in UTC.
| Field | Purpose | Status |
|---|---|---|
CustomerPONo |
Unique order/FR number sent to Kinseys. | Enable |
ShipToAccount |
Ship-to account number associated with your Kinseys account. | Enable |
ShipToName |
Customer name shown on the shipping label. | Enable / Disable |
ShipToAddress1, Address2, City, State, PostalCode, Country
|
Destination address details. | Enable / Disable |
Email, Phone
|
Buyer contact info for carrier notifications (if supported). | Enable / Disable |
ParcelZone / Carrier fields |
Pass a requested shipping method/carrier code to supplier. | Enable / Disable |
Notes / Reference
|
Free-text notes or internal reference for the supplier. | Enable / Disable |
| Field | Purpose | Status |
|---|---|---|
SKU |
Supplier-recognized SKU for the item. | Enable |
Quantity |
Units to fulfill for this SKU. | Enable |
UnitPrice |
Dealer price per unit (if required by supplier). | Enable / Disable |
LineNotes |
Optional notes per line. | Enable / Disable |
CustomerPONo, ShipToAccount, SKU, and Quantity set to Enable. Disable optional fields you don’t want to transmit.
| Transport | FTP | Uploads to your configured outbound folder. |
| Payload | XML | Supplier-defined XML schema. |
| Acknowledgement | Not expected | Upload success (no error) marks order as sent. |
| Shipping Method UI | Not supported | Pass method via mapped fields (e.g., ParcelZone). |
| Attachments | Not supported | Only the XML order is transmitted. |
- Upload failed? Re-check FTP host/port/user/pass and the outbound path; re-run after fixing.
- Supplier rejected? Validate required fields (PO number, ShipToAccount, SKU, Quantity) are Enabled and present.
- Missing lines? Ensure each item maps an SKU and Quantity and that they’re Enabled.
-
Wrong shipping method? Map and Enable the supplier shipping method field (e.g.,
ParcelZone).
Get Shipments
- Fetch shipment XMLs from the supplier’s FTP inbound folder.
- Update orders with carrier, shipping method, tracking ID, and ship date.
- Associate shipped items by SKU and support partial shipments.
- 1Pull XML — Reads files matching your Remote File Name Pattern from the configured Inbound Remote File Folder.
- 2Parse — Extracts carrier, method, tracking, carton/BOL, and line items (SKU & shipped qty) into your mapping template.
- 3Apply Lookback — Only Fulfillment Requests created within the FR Lookback Period are considered (default 90 days).
- 4Save — Posts shipment data back to the order; supports partials.
- 1Connect an Integration — Choose Kinseys and select your FTP (Basic Auth) connection.
-
2Configure Settings
-
Remote File Name Pattern * — Mask for shipment XML files (e.g.,
kns_shipments_*.xml). - Inbound Remote File Folder * — FTP directory to read shipment files from.
- File Action — Read (leave files) or other actions per your policy.
- Advanced → FR Lookback Period for Get Shipments — Maximum age of FRs to match (default 90 days).
-
Remote File Name Pattern * — Mask for shipment XML files (e.g.,
- 3Define a Mapping Template — Use the recommended fields below.
- 4Save & Schedule — Run manually or schedule (UTC).
- Files are fetched over your configured FTP connection.
- Format is .xml; a sample file is referenced in internal docs.
- If tracking is absent, use Carton ID or BOL and map accordingly.
Enable scheduling to pull shipments automatically. The status page will show Connected, Configured, and Mapped (e.g., template Get Shipments 2). Schedules run in UTC.
Toggle each field to control what is saved to the shipment record. Only fields set to Enable will be imported.
| Field | Kinseys Field | Notes | Status |
|---|---|---|---|
| Carrier | Carrier |
Header text value. | Enable / Disable |
| Shipping Method | Shipping Method |
Supplier method string. | Enable / Disable |
| Tracking ID | Tracking ID |
May be blank on LTL. | Enable / Disable |
| Carton ID | Carton Id |
Use when tracking is missing. | Enable / Disable |
| BOL | BOL |
Bill of Lading for freight/LTL. | Enable / Disable |
| Shipped At | Ship Date |
Maps to shipment timestamp. | Enable |
| PO / FR Number | Purchase Order Number |
Links XML to FR/Order. | Enable |
| Total Weight | Actual/Estimated Weight |
If provided. | Enable / Disable |
| Field | Kinseys Field | Notes | Status |
|---|---|---|---|
| SKU | SKU |
Line association key. | Enable |
| Shipped Quantity | Shipped Quantity |
Supports partials. | Enable |
| UOM | UOM |
Optional; reporting. | Enable / Disable |
| Line Weight | Weight |
If present per line. | Enable / Disable |
PO / FR Number, Shipped At, SKU, and Shipped Quantity set to Enable. Add Carton ID and BOL as fallbacks when Tracking ID is missing.
| Carrier & Method | SUPPORTED | Available in XML header. |
| Shipment Item Association | SUPPORTED | By SKU. |
| Partial Shipments | SUPPORTED | Multiple files/lines can complete fulfillment. |
| Invoice Information | NOT SUPPORTED | Not included in this feed. |
| Custom Fields | NOT SUPPORTED | Standard shipment fields only. |
- No shipments found? Confirm file pattern/folder and Lookback window cover targeted FRs.
- Missing tracking? Map Carton ID or BOL as alternates and surface them for customer notifications if needed.
- Lines didn’t attach? Ensure each line includes a mapped SKU and that it’s Enabled.
Troubleshooting
Common issues for the Kinsey's integration. Expand each item to learn more.
What's happening
The Kinsey's connection isn't authenticating or Test Connection returns an error.
- API key may be incorrect or rotated.
- Your Kinsey's account may not have API access enabled.
How to fix it
- Open the source and click Test Connection — re-enter the API key from Kinsey's.
- Contact your Kinsey's rep to confirm API access is active on your account.
What's happening
Get Inventory (Primary or Secondary) isn't importing data or pricing looks off.
- Kinsey's pricing tier may differ from what you expect.
- The schedule may be inactive or the mapping template isn't selected.
How to fix it
- Run the integration manually and check the run log.
- Confirm with Kinsey's that your account's price tier matches what's expected.
- Verify the mapping template is attached to the integration.
What's happening
Send Fulfillment Requests fails to submit orders, or specific orders are rejected.
- Required Ship To fields, SKU, or Quantity may not be mapped correctly.
- Kinsey's may have held the order for review (large quantity, restricted product).
How to fix it
- Re-check Ship To mapping (Line 1, City, State, Postal, Country).
- Confirm SKU + Quantity in the Send FR template match what Kinsey's expects.
- For held orders, contact Kinsey's with the PO number to clear the hold.
What's happening
Get Shipments runs but tracking doesn't import, or specific shipments are missing.
- Order may not have shipped yet on Kinsey's side.
- Tracking Number / Carrier / Order Number may not be mapped.
How to fix it
- Confirm the order has actually shipped in Kinsey's portal.
- Open the Get Shipments mapping template and confirm Tracking Number, Carrier, and Order Number are mapped.