Turn 14 Distribution as a Source
July 17, 2026
Summary
Turn 14 Distribution is a powersports and automotive aftermarket parts distributor connected via API using a single Client ID and Client Secret shared across all five operations — Get Inventory (Primary and Secondary), Send Fulfillment Requests, Get Shipments, and Get Invoices. Turn 14 requires a successful Sandbox test before they grant Production access, so complete testing in the Test environment first. Run Get Inventory Primary once daily for the full catalog and Get Inventory Secondary hourly for incremental quantity refreshes; Send Fulfillment Requests automatically selects the cheapest available shipping method and stores Turn 14's order_id as the confirmation number.
What this integration does
Get Inventory (Primary)
Imports the full Turn 14 catalog daily — products, pricing, and quantity.
Get Inventory (Secondary)
A lighter, frequent refresh of pricing and quantity only.
Send Fulfillment Requests
Sends orders (Fulfillment Requests) to Turn 14.
Get Shipments
Pulls Turn 14 tracking numbers and ship dates back into Flxpoint.
Get Invoices
Imports Turn 14 invoices for reconciliation.
How to connect - credentials you need
Turn 14 connects over API using a Client ID and Client Secret issued by Turn 14. Add the source, start configuring an operation, and when Flxpoint prompts you click + New Connection, enter the Environment, Client ID and Client Secret, then Test Connection → Save Connection.
EnvironmentRequired
Toggles between Test (Sandbox) and Production. Turn 14 requires a successful Sandbox test before they enable Production credentials — use Test first, confirm with Turn 14, then switch to Production.
Client IDRequired
Your Turn 14 API Client ID, provided by Turn 14.
Client SecretRequired
Your Turn 14 API Client Secret, provided by Turn 14.
The same Client ID, Client Secret and Environment are used by all five operations. Several integration settings (not mapping-template fields) also control behavior: Save Vehicle Fitments Ids enables fitment sync on GIP (Mondays/Thursdays only); Exclude Shipping Options and Acknowledge EPA / Prop65 / CARB control Send Fulfillment Requests; Tracking of Last X Days and Invoice of Last X Days set the lookback window for Get Shipments and Get Invoices. Confirm these with your Turn 14 representative and
support@flxpoint.com before going live.Important - read before configuring
Sandbox test required before Turn 14 will grant production access
Turn 14 requires that you complete successful testing in Sandbox mode before they enable your Production credentials. Do not attempt to configure production orders until Turn 14 confirms your sandbox test is successful. Select the Test environment during initial setup, run a test order, and contact Turn 14 to request production access once testing is complete.
GIP once daily max — GIS hourly. Exceeding this triggers API rate limits.
Get Inventory Primary retrieves the full catalog and should not be scheduled more than once per 24 hours. Running it more frequently risks Turn 14 API rate limit failures. Get Inventory Secondary is safe to run hourly — it only pulls changes since the last successful run using the minutes parameter as the lookback window. When both are active, GIS should be your primary recurring job; GIP is for full catalog rebuilds.
Regular Stock field contains special-order units — never map it alone as Quantity
The Regular Stock field returns Turn 14's regular_stock value — units that are available via special order and can supplement regular inventory, but should not replace it. Map it in addition to Total Warehouse Inventory, or use a combined formula (Quantity On Hand + Regular Stock). Mapping Regular Stock alone as your Quantity will misrepresent available stock.
Vehicle fitment IDs sync only on Mondays and Thursdays when enabled
If you use vehicle fitment data, enable Save Vehicle Fitments Ids in GIP settings. Fitment IDs are only synced on Mondays and Thursdays regardless of your schedule — Turn 14 publishes this data on those days only. These hardcoded attributes are not configurable in the mapping template: Shipped in Multiple Boxes, EPA, Prop65, Carb Acknowledgement Required, and Vehicle Fitment ID.
Operations - fields to know
| Field | Maps To — Notes |
|---|---|
| part_number | → Product / Variant → SKU. Turn 14's catalog part number. A predefined Automotive Master SKU (First 3 letters of Brand + MPN) rule is also available in the mapping template for a standardized cross-brand SKU. |
| mfr_part_number | → Identifiers → Manufacturer Part Number (MPN). Feeds the Automotive Master SKU rule when combined with Brand. |
| product_name / part_description | → Product → Title / Description. |
| brand | → Product → Brand. First 3 letters feed the Automotive Master SKU rule. |
| category / subcategory | → Product → Category. |
| purchase_cost (Pricing) | → Pricing → Cost. Fetched live per account — Turn 14 has no universal price list. |
| inventory (per-warehouse map) | → Inventory → Total Warehouse Inventory / Quantity. Required. Turn 14 returns quantity per warehouse; the sum across warehouses is the total available. |
| regular_stock | → Product attribute → Regular Stock. Special-order units. Do not map alone as Quantity — combine with Total Warehouse Inventory (see Important). |
| Item Data files (type=Image) | → Product / Variant → Images. Falls back to the item thumbnail when no image files are mapped. |
| dimensions (length/width/height/weight per box) | → Product → Dimensions / Weight. The largest box by volume is used when an item ships in multiple boxes. |
| EPA / Prop65 / Carb Acknowledgement Required / Shipped in Multiple Boxes / Vehicle Fitment ID | Hardcoded product attributes — not configurable in the mapping template (see Important). |
| Field | Maps To — Notes |
|---|---|
| item_id | No mapping is available for Item-ID or SKU in the mapping template. |
| inventory (per-warehouse map) | → Inventory → Total Warehouse Inventory / Quantity. Required. Without this mapped, no quantities import. |
| Full catalog fields | Not included in GIS — title, pricing details, images and attributes come from Get Inventory Primary. Run GIP daily for the full catalog and GIS more frequently to keep Quantity current. |
| Flxpoint Field | Maps To (Turn 14) — Notes |
|---|---|
| Fulfillment Request line → SKU / Source Variant | Item Identifier (item_id) — Not available in mapping or fields. |
| Fulfillment Request line → Quantity | → Item Quantity. Required. |
| Shipping address | → To Turn 14 Recipient Field — Company, Name, Address, Address 2, City, State, Zip. Required. |
| Ship-to phone | → Recipient → Phone Number. Required. Auto-formatted to ###-###-#### when 10 digits are provided. |
| Max Fulfillment Days (mapping field) | → Max Fulfillment Days. Filters out Turn 14 shipping quotes whose transit time exceeds this value; the cheapest remaining method is auto-selected. |
| Fulfillment Request Number | Not available in mapping or fields. |
| Acknowledge EPA / Prop65 / CARB, Exclude Shipping Options | Set as Integration Config values (not mapping-template fields) — configured once on the job, not per order. |
| Field | Maps To — Notes |
|---|---|
| tracking_number | → Shipment → Tracking Number. Required. |
| carrier_name | → Shipment → Carrier. |
| service | → Shipment → Ship Method / Service. |
| ship_date | → Shipment → Shipped At. |
| item_id | Not available in mapping or fields. |
| product_group_item_id (kit items) | → Product Group Part Number. Auto-matched to the source variant when SKU isn't directly mapped. |
| quantity | → Shipment Item → Quantity. Required. |
| po_number | Not available in mapping or fields. |
| Field | Maps To — Notes |
|---|---|
| invoice_number | → Invoice → Invoice Number. Required. |
| date | → Invoice → Date. |
| total_price | → Invoice → Total Price. |
| discount_amount / freight | → Invoice → Discount Amount / Freight. |
| comments | → Invoice → Comments. |
| purchase_order_number | Match key — links the invoice back to the Flxpoint Fulfillment Request Number (FR#); not itself a mapped field. |
| part_number / product_group_item_id (kit items) | → Invoice Item → SKU. Auto-matched to the source variant when SKU isn't directly mapped. |
| quantity | → Invoice Item → Quantity. Required. |
| unit_price / total_price (line) | → Invoice Item → Unit Price / Total Price. |
| line_notes | → Invoice Item → Line Notes. |
Common issues
No shipping methods available during Send FR — orders failing at quote stage
If Send FR fails because no shipping methods are returned: (1) check whether you have excluded too many methods in the integration config, leaving no viable options; (2) if a Max Fulfillment Days filter is set to a very low value (e.g., 1 day), it may be filtering out all available methods — try increasing the value or removing the filter; (3) review the job log via View Logs for the specific API response. If the quote returns methods but the order still fails, confirm required ship-to fields (Address Line 1, City, Name, Phone, State, Zip) are all mapped and non-empty.
GIS quantities not updating — Minutes parameter misconfigured
If Get Inventory Secondary runs without error but quantities aren't changing, the most common cause is a Minutes parameter that is set too small relative to the run interval. For example, if GIS is scheduled every 60 minutes but Minutes is set to 5, only changes from the last 5 minutes are fetched — changes between 6 and 60 minutes ago are missed. Set the Minutes parameter to match (or slightly exceed) your GIS schedule interval. Also confirm Total Warehouse Inventory is mapped in the GIS template — without it, no quantities import.
Fitment data not syncing after GIP runs
Vehicle fitment IDs are only published by Turn 14 on Mondays and Thursdays. If you run GIP on other days, fitment data will not be included in the response. Confirm: (1) Save Vehicle Fitments Ids is enabled in GIP settings; (2) the last GIP run was on a Monday or Thursday. If fitment data has never synced, also verify your Turn 14 API credentials have access to fitment data for your account tier.
FAQs
What are the recommended scheduling frequencies for GIP and GIS?▸
| Job | Recommended Frequency | Notes |
|---|---|---|
| Get Inventory Primary (GIP) | Once per day | Full catalog — avoid more than once/24h or API throttling occurs |
| Get Inventory Secondary (GIS) | Hourly | Delta only — safe to run frequently; configure Minutes parameter to match interval |
What does the Automotive Master SKU rule do?▸
A predefined mapping rule named "Automotive Master SKU (First 3 letters of Brand + MPN)" is available in the GIP mapping template. It combines the first 3 letters of the Brand (e.g., "Acme" → "Acm") with the full MPN (e.g., "MPN123") to produce a Master SKU (e.g., "AcmMPN123"). This creates a standardized, unique identifier for automotive parts where the Turn 14 Part Number alone may not be sufficient for cross-brand disambiguation.
How does Send Fulfillment Requests select a shipping method?▸
Send FR first requests a quote from Turn14, which returns all available shipping methods with pricing. Flxpoint automatically selects the cheapest available method by default. You can configure exclusions to filter out specific methods (e.g., exclude Express if too expensive), and set a Max Fulfillment Days filter to exclude methods with transit times beyond a threshold (e.g., exclude anything over 5 days). The Turn 14
order_id returned on success is stored as the confirmation number in Flxpoint. Required ship-to fields: Address Line 1, City, Name, Phone, State, Zip.What does Get Shipments retrieve and how does it match to FRs?▸
Get Shipments fetches tracking data using a configurable date range (
start_date and end_date). Available fields: Tracking Number, Carrier Name, Service/Method, and Ship Date at the shipment level; Part Number, Product Group Part Number, and Quantity at the item level. Shipments are matched to Flxpoint FRs via the Fulfillment Request Number (FR#) — confirm this field is mapped in your Get Shipments template. The predefined "Get Shipments - Part number" rule is available for part number transformations.How does Get Invoices work and what does it retrieve?▸
Get Invoices retrieves invoice data using a Number of Days config value (e.g., 7 = last 7 days; end_date is always today, start_date = today minus the configured days). Invoice-level fields: Comments, Date, Discount Amount, Freight, Invoice Number, Purchase Order Number, Total Price, Website Order Number. Invoice item fields: Line Notes, Part Description, Part Number, Product Group Part Number, Quantity, Total Price, Unit Price. Invoices are matched to FRs via Purchase Order Number → Fulfillment Request Number. Map this field to link invoices to the correct orders.