Turn 14 Distribution as a source can be completely managed using Flxpoint integrations. We support all the functionalities for Turn 14 Distribution.
How to connect
Before You Begin: Test in Sandbox Mode
When setting up the integration between Turn 14 Distribution and Flxpoint, it’s essential to start by testing with the sandbox integration. This testing phase allows you to ensure that all configurations and workflows function as expected. Turn 14 Distribution requires that you complete this step successfully before they grant you production access, ensuring that your live environment is error-free and fully optimized.
- Get Inventory - Retrieves current inventory data from Turn 14
- Send Fulfillment Requests - Sends orders to Turn 14 automatically
- Get Shipments - Pulls shipping information from Turn 14
- Navigate to the Account Settings or API Access section (this may vary depending on Turn 14's dashboard layout).
- Look for an option like Generate API Credentials or API Keys.
- Generate a new set of credentials, which will include a Client ID and Client Secret.
- Note down the Environment (e.g., Production or Test) that Turn 14 specifies for API usage.
- Connection Name: "Turn 14 API Connection" (or any descriptive name)
- Environment: Select the environment (e.g., Test for sandbox mode initially, as noted in the "Before You Begin" section)
- Client ID: Enter the Client ID provided by Turn 14
- Client Secret: Enter the Client Secret provided by Turn 14
- Ensure the connection name matches the one you created (e.g., "Turn 14 API Connection").
- Verify that the Environment, Client ID, and Client Secret are correctly entered.
- Toggle Automatically Send Orders ON to have Flxpoint automatically send orders to Turn 14.
- Set any additional order rules or conditions as needed (e.g., order thresholds or specific product categories).
- Choose an existing mapping template or create a new one.
- Map essential fields like SKU, Price, Quantity, etc.
- Set up any transformations needed (e.g., price markups).

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 (Primary)
- Retrieve product inventory data, including stock levels, pricing, and shipping estimates.
- Sync detailed product attributes like brand, category, and descriptions for better catalog management.
- Support automotive-specific data, such as vehicle fitment IDs, for more precise inventory tracking.
- Calculate dropship fees automatically to help with cost planning.
-
Base URL: All API requests are made to
https://api.turn14.com
. -
Generate Token: We start by generating an authentication token using the
/v1/token
endpoint, passing yourclient_id
andclient_secret
. -
Fetch Item IDs: A GET request is made to the
/v1/items
endpoint to retrieveitem_id
anddropship_id
for each product. -
Retrieve Product Data: Using the
item_id
, we make GET requests to multiple endpoints:-
/v1/items/data
: Fetches full product data (e.g., brand, category, descriptions). -
/v1/pricing
: Retrieves pricing details (e.g., MAP, retail). -
/v1/inventory
: Gets inventory levels (e.g., total warehouse inventory). -
/v1/shipping/item_estimation
: Obtains shipping cost estimates. -
/v1/dropship/{dropship_id}
: Fetches dropship fee data. -
/v1/items/fitment
: Retrieves vehicle fitment IDs (only if the "Save Vehicle Fitments Ids" config is enabled; runs on Mondays and Thursdays).
-
-
Dropship Fee Calculation: The dropship fee is calculated in the backend:
- If
getChargedFee
is null, the fee is set to 0. - If
getChargedFee
has a value, that value is used. - If
getChargedPercent
has a value, the fee is calculated by multiplyinggetChargedPercent
withgetPurchaseCost
.
- If
-
Hardcoded Attributes: Some attributes are hardcoded and not configurable:
- Shipped in Multiple Boxes
- EPA
- Prop65
- Carb Acknowledgement Required
- Vehicle Fitment ID
- Syncing: The retrieved data is mapped to Flxpoint fields (e.g., SKU, Quantity) and saved to your system. You can run this manually with Run Sync or schedule it via "Adjust Schedule."
- Save Vehicle Fitments Ids: Enable to retrieve vehicle fitment data on Mondays and Thursdays (options: Yes/No).
- Scheduling: Run the integration manually or schedule it (e.g., daily at 8 AM UTC) using "Adjust Schedule." Refer to the Job Scheduling Requirements section for recommended frequencies.
- Mapping Template: Define which fields to import and how they map to Flxpoint fields (see Mapping Templates section).
- 1 Add the Integration: Go to the Integrations section, select Turn 14 as the integration type, and choose “Get Inventory [Primary].”
-
2 Connect to Turn 14: Enter your API credentials:
- Client ID: Your Turn 14 client ID (e.g., client123).
- Client Secret: Your Turn 14 client secret (e.g., secret456).
- 3 Configure Settings: Decide if you want to enable "Save Vehicle Fitments Ids" for automotive data and set your sync schedule according to the Job Scheduling Requirements.
- 4 Create a Mapping Template: Use the "Manage Mapping" option to define which fields to import (see Mapping Templates section).
- 5 Run the Integration: Start manually with Run Sync or schedule via "Adjust Schedule."
Job Name | Recommended Frequency | Notes |
---|---|---|
Get Inventory Primary (GIP) | Once per day | Avoid scheduling more than once daily to prevent API throttling. |
Get Inventory Secondary (GIS) | Hourly | Can safely run hourly. Only pulls updates since the last successful run. |
- GIP should not be scheduled more than once per 24 hours.
- GIS is designed to be run more frequently and is safe to schedule hourly.
- Running GIP too often can reduce overall performance and increase the chance of failures due to Turn 14's rate limits.
- When both GIP and GIS are enabled, GIS should be your primary recurring update job.
- GIP can still be run manually if needed, but consecutive executions should have a minimum interval.
- The mapping screen is labeled “Turn 14 → Flxpoint” under “Get Inventory [Primary].”
- Buttons: Delete, Duplicate, and Save.
- Columns: Left (Turn 14 fields), Right (Flxpoint fields).
- Don’t Map: Ignore the field entirely.
- Set To Empty: Clear any existing data in that field.
- Direct Copy: Directly copy the Turn 14 field to the Flxpoint field.
- Field: Map a specific Turn 14 field (e.g., “Brand”) to a Flxpoint field.
- Value: Set a constant value for all inventory items.
- Mapping Set: Apply a predefined transformation or mapping table.
- Turn 14 Item Attributes: Barcode, Brand, Category, Mfr Part Number, Part Description, Part Number, Product Name, Regular Stock, Sub Category, Weight (combined).
- Turn 14 Item Data: AAIA Part Type Description, Application Summary, Associated Comments, Label Description, Market Description, Product Description (Abbreviated, Extended, Invoice, Long, Short), Slang Description, UN/SPSC Description.
- Turn 14 Pricing: Dealer, Jobber, MAP, Purchase Cost, Retail.
- Turn 14 Inventory: Total Warehouse Inventory.
- Turn 14 Dimensions: Height, Length, Width (of largest package).
- Turn 14 Dropship Fee: Dropship Fee.
- Turn 14 Estimated Ground Continental US Base Rate: Average, Maximum, Minimum.
- Inventory Parent Fields: Includes fields like Parent SKU, All Images, Brand, Category 1, Category 2, Category 3, Description, and Title. For each field, you can select mapping options (e.g., Don’t Map, Set To Empty, Direct Copy, Field, Value, Mapping Set) and apply rules if needed.
- Inventory Variant Fields: Includes fields like Master SKU, SKU, ASIN, All Images, Allow Backorders, Archived, Bin Location, Cost, Description, Dimension Unit, Dropship Fee, GTIN, Height, Length, MAP, MPN, MSRP, Quantity, Reference Identifier, Shipping Cost, Source List Price, Title, UPC, Weight, Weight Unit, and Width. Similar mapping options and rules are available for each field.
- Custom Fields: There are sections for 100 custom parent fields, 100 custom variant fields, and 10 custom aggregate fields, allowing for additional flexibility in mapping.
- Rules Section: A specific rule named “Automotive Master SKU (First 3 letters of Brand+MPN)” is visible, which combines the first three letters of the Brand with the MPN to create a unique Master SKU. You can also create new rules using the “New Rule” button.
Turn 14 Field | Maps To | Example | Purpose | Status |
---|---|---|---|---|
Part Number (Item Attributes) | Flxpoint Inventory Parent: Parent SKU | PART123 | Identifies the parent product in Flxpoint | Don't Map |
All Images | Flxpoint Inventory Parent: All Images | - | Imports product images | Don't Map |
Brand (Item Attributes) | Flxpoint Inventory Parent: Brand | Acme | Records the product brand | Direct Copy |
Category (Item Attributes) | Flxpoint Inventory Parent: Category 1 | Accessories | Assigns the first-level category | Direct Copy |
Sub Category (Item Attributes) | Flxpoint Inventory Parent: Category 2 | Helmets | Assigns the second-level category | Direct Copy |
Category 3 | Flxpoint Inventory Parent: Category 3 | - | Assigns the third-level category | Don't Map |
Product Description - Long (Item Data) | Flxpoint Inventory Parent: Description | A high-quality helmet for safety. | Provides the product description | Direct Copy |
Product Name (Item Attributes) | Flxpoint Inventory Parent: Title | Acme Safety Helmet | Sets the product title | Direct Copy |
Part Number (Item Attributes) | Flxpoint Inventory Variant: Master SKU | PART123 | Primary identifier for linking in Flxpoint | Direct Copy |
SKU | Flxpoint Inventory Variant: SKU | - | Identifies the variant in Flxpoint | Don't Map |
ASIN | Flxpoint Inventory Variant: ASIN | - | Records the Amazon Standard Identification Number | Don't Map |
All Images | Flxpoint Inventory Variant: All Images | - | Imports variant images | Don't Map |
Allow Backorders | Flxpoint Inventory Variant: Allow Backorders | - | Determines if backorders are allowed | Don't Map |
Archived | Flxpoint Inventory Variant: Archived | - | Marks the variant as archived | Don't Map |
Bin Location | Flxpoint Inventory Variant: Bin Location | - | Records the warehouse bin location | Don't Map |
Purchase Cost (Pricing) | Flxpoint Inventory Variant: Cost | 50.00 | Records the cost to purchase the item | Direct Copy |
Description | Flxpoint Inventory Variant: Description | - | Provides the variant description | Don't Map |
Dimension Unit | Flxpoint Inventory Variant: Dimension Unit | - | Specifies the unit for dimensions (e.g., inches) | Don't Map |
Dimension Unit (Abbreviated) | Flxpoint Inventory Variant: Dimension Unit (Abbreviated) | - | Short form of the dimension unit (e.g., in) | Don't Map |
Dropship Fee (Dropship Fee) | Flxpoint Inventory Variant: Dropship Fee | 5.00 | Records the calculated dropship fee | Direct Copy |
GTIN | Flxpoint Inventory Variant: GTIN | - | Records the Global Trade Item Number | Don't Map |
Height (of largest package) (Dimensions) | Flxpoint Inventory Variant: Height | 10.00 | Records the height of the largest package | Direct Copy |
Length (of largest package) (Dimensions) | Flxpoint Inventory Variant: Length | 20.00 | Records the length of the largest package | Direct Copy |
MAP (Pricing) | Flxpoint Inventory Variant: MAP | 75.00 | Records the Minimum Advertised Price | Direct Copy |
Mfr Part Number (Item Attributes) | Flxpoint Inventory Variant: MPN | MPN123 | Records the Manufacturer Part Number | Direct Copy |
Retail (Pricing) | Flxpoint Inventory Variant: MSRP | 100.00 | Records the Manufacturer's Suggested Retail Price | Direct Copy |
Total Warehouse Inventory (Inventory) | Flxpoint Inventory Variant: Quantity | 50 | Records the available stock quantity | Direct Copy |
Reference Identifier | Flxpoint Inventory Variant: Reference Identifier | - | Additional identifier for the variant | Don't Map |
Shipping Cost | Flxpoint Inventory Variant: Shipping Cost | - | Records the shipping cost for the variant | Don't Map |
Source List Price | Flxpoint Inventory Variant: Source List Price | - | Records the source list price | Don't Map |
Title | Flxpoint Inventory Variant: Title | - | Sets the variant title | Don't Map |
Barcode (Item Attributes) | Flxpoint Inventory Variant: UPC | 012345678905 | Records the Universal Product Code | Direct Copy |
Weight (combined) (Item Attributes) | Flxpoint Inventory Variant: Weight | 2.5 | Records the combined weight of the item | Direct Copy |
Weight Unit | Flxpoint Inventory Variant: Weight Unit | - | Specifies the unit for weight (e.g., pounds) | Don't Map |
Weight Unit (Abbreviated) | Flxpoint Inventory Variant: Weight Unit (Abbreviated) | - | Short form of the weight unit (e.g., lb) | Don't Map |
Width (of largest package) (Dimensions) | Flxpoint Inventory Variant: Width | 15.00 | Records the width of the largest package | Direct Copy |
-
Automotive Master SKU Rule: A predefined rule named "Automotive Master SKU (First 3 letters of Brand+MPN)" is applied. It:
- Runs always with 3 actions modifying the Incoming Value.
- Combines the first 3 letters of the Brand (e.g., "Acme" → "Acm") with the MPN (e.g., "MPN123") to create a Master SKU (e.g., "AcmMPN123").
-
Hardcoded Attributes: The following attributes are hardcoded and not configurable:
- Shipped in Multiple Boxes
- EPA
- Prop65
- Carb Acknowledgement Required
- Vehicle Fitment ID
-
Authentication Failure:
- Verify your Turn 14 API credentials (Client ID and Client Secret).
- Test the connection using the Test Connection button.
-
Missing Inventory Data:
- Ensure required fields like “Quantity” are mapped correctly in the mapping template.
- Check if the Turn 14 API is returning data by reviewing logs using "View Logs."
-
Fitment Data Not Syncing:
- Confirm that the "Save Vehicle Fitments Ids" setting is enabled.
- Ensure the sync is running on a Monday or Thursday, as fitment data is only retrieved on those days.
-
Sync Failure:
- Review logs using the "View Logs" option to identify specific errors, such as API rate limits or authentication failures.
- Contact Flxpoint support if problems persist, providing the item ID and log details for investigation.
- Current Date and Time: As of 06:05 PM -04 on Thursday, May 22, 2025, this integration is fully operational for retrieving inventory from Turn 14.
-
API Connection: Uses the Turn 14 API at
https://api.turn14.com
to fetch inventory data via multiple endpoints. - Fitment Data Schedule: If "Save Vehicle Fitments Ids" is enabled, fitment data is synced only on Mondays and Thursdays.
-
Dropship Fee Logic: Automatically calculated based on
getChargedFee
andgetChargedPercent
values.
Get Inventory (Secondary)
- Retrieve updated inventory quantities since the last sync, ensuring your stock levels are current.
- Sum quantities across all warehouses for a consolidated inventory view.
- Map inventory data to Flxpoint fields for seamless updates.
-
Base URL: All API requests are made to
https://api.turn14.com
. -
Generate Token: We start by generating an authentication token using the
/v1/token
endpoint, passing yourclient_id
andclient_secret
. -
Fetch Inventory Updates: A GET request is made to the
/v1/inventory/updates
endpoint to retrieve inventory data. Query parameters include:- page: Specifies the page number for pagination (e.g., 1 for the first page).
- minutes: Indicates the time since the last sync in minutes (e.g., 60 to fetch updates from the last hour).
-
Sum Quantities: The integration sums the
Total Warehouse Inventory
quantities across all warehouses for each item, providing a consolidated stock level. - Syncing: The updated inventory data is mapped to Flxpoint fields (e.g., Quantity) and saved to your system. You can run this manually with Run Sync or schedule it via "Adjust Schedule."
- Minutes Parameter: Set the time interval (in minutes) for fetching updates since the last sync (e.g., 60 minutes).
- Scheduling: Run the integration manually or schedule it (e.g., every 15 minutes) using "Adjust Schedule." Refer to the Job Scheduling Requirements section for recommended frequencies.
- Mapping Template: Define which fields to import and how they map to Flxpoint fields (see Mapping Templates section).
- 1 Add the Integration: Go to the Integrations section, select Turn 14 as the integration type, and choose “Get Inventory [Secondary].”
-
2 Connect to Turn 14: Enter your API credentials:
- Client ID: Your Turn 14 client ID (e.g., client123).
- Client Secret: Your Turn 14 client secret (e.g., secret456).
- 3 Configure Settings: Set the “minutes” parameter to determine the time interval for updates and configure your sync schedule according to the Job Scheduling Requirements.
- 4 Create a Mapping Template: Use the "Manage Mapping" option to define which fields to import (see Mapping Templates section).
- 5 Run the Integration: Start manually with Run Sync or schedule via "Adjust Schedule."
Job Name | Recommended Frequency | Notes |
---|---|---|
Get Inventory Primary (GIP) | Once per day | Avoid scheduling more than once daily to prevent API throttling. |
Get Inventory Secondary (GIS) | Hourly | Can safely run hourly. Only pulls updates since the last successful run. |
- GIP should not be scheduled more than once per 24 hours.
- GIS is designed to be run more frequently and is safe to schedule hourly.
- Running GIP too often can reduce overall performance and increase the chance of failures due to Turn 14's rate limits.
- When both GIP and GIS are enabled, GIS should be your primary recurring update job.
- GIP can still be run manually if needed, but consecutive executions should have a minimum interval.
- The mapping screen is labeled “Turn 14 → Flxpoint” under “Get Inventory [Secondary].”
- Buttons: Delete, Duplicate, and Save.
- Columns: Left (Turn 14 fields), Right (Flxpoint fields).
- Don’t Map: Ignore the field entirely.
- Set To Empty: Clear any existing data in that field.
- Direct Copy: Directly copy the Turn 14 field to the Flxpoint field.
- Field: Map a specific Turn 14 field (e.g., “Total Warehouse Inventory”) to a Flxpoint field.
- Value: Set a constant value for all inventory items.
- Turn 14 Inventory: Total Warehouse Inventory.
- Inventory Variant Fields: Includes fields like Allow Backorders and Quantity. For each field, you can select mapping options (e.g., Don’t Map, Set To Empty, Direct Copy, Field, Value) and apply rules if needed.
- Custom Aggregate Fields: There’s a section for 5 custom aggregate fields, allowing for additional flexibility in mapping.
- Minimal Mapping: Since this integration focuses on inventory updates, only a few fields are available, primarily centered around stock quantities.
Turn 14 Field | Maps To | Example | Purpose | Status |
---|---|---|---|---|
Allow Backorders | Flxpoint Inventory Variant: Allow Backorders | - | Determines if backorders are allowed | Don't Map |
Total Warehouse Inventory (Inventory) | Flxpoint Inventory Variant: Quantity | 50 | Records the summed stock quantity across all warehouses | Direct Copy |
-
Authentication Failure:
- Verify your Turn 14 API credentials (Client ID and Client Secret).
- Test the connection using the Test Connection button.
-
Inventory Not Updating:
- Ensure the “Total Warehouse Inventory” field is mapped correctly in the mapping template.
- Check the “minutes” parameter; if set too low, it may miss updates (e.g., set to 60 to cover the last hour).
- Verify the API response by reviewing logs using "View Logs."
-
Sync Failure:
- Review logs using the "View Logs" option to identify specific errors, such as API rate limits or authentication failures.
- Contact Flxpoint support if problems persist, providing the item ID and log details for investigation.
- Current Date and Time: As of 06:05 PM -04 on Thursday, May 22, 2025, this integration is fully operational for retrieving updated inventory from Turn 14.
-
API Connection: Uses the Turn 14 API at
https://api.turn14.com
to fetch inventory updates via the/v1/inventory/updates
endpoint. - Incremental Updates: Only fetches inventory changes since the last sync, based on the “minutes” parameter.
- Quantity Summation: Combines stock quantities across all warehouses for a unified total.
Order Operations
It submits orders to vendors for fulfillment and subsequently imports the shipment details, ensuring a seamless integration between order processing and shipment tracking.
Send Fulfillment Requests
- Send fulfillment requests to Turn 14, automating the order creation process.
- Select the cheapest shipping method automatically, with options to exclude specific methods or filter by transit days.
- Map order details like recipient information and fulfillment settings to Turn 14 fields for accurate order processing.
- Store the Turn 14 order confirmation number in Flxpoint for easy tracking.
-
Base URL: All API requests are made to
https://api.turn14.com
. -
Generate Token: We start by generating an authentication token using the
/v1/token
endpoint, passing yourclient_id
andclient_secret
. -
Request a Quote: A GET request is made to the
/v1/quote
endpoint to retrieve a quote, which returns aquote_id
and available shipping methods. -
Select Shipping Method: The integration selects the cheapest shipping method by default, with the following filters:
- If a shipping method is marked for exclusion in the integration config, it’s excluded from the available options.
- If a transit days filter is set in the mapping template (e.g., “Max Fulfillment Days”), methods with transit days exceeding this value are excluded.
-
Create Order: Using the selected shipping method and
quote_id
, an order is created via the/v1/order/from_quote
endpoint. The response includes anorder_id
, which is saved as the confirmation number in Flxpoint’s database. - Syncing: Order details (e.g., recipient address, order notes) are mapped to Turn 14 fields as per the mapping template and sent during the order creation process. You can run this manually with Run Sync or schedule it via "Adjust Schedule."
- Shipping Method Exclusion: Specify shipping methods to exclude from the selection process (e.g., exclude “Express Shipping” if it’s too costly).
- Max Fulfillment Days: Set a transit days filter in the mapping template to exclude shipping methods with longer transit times (e.g., exclude methods with more than 5 days).
- Scheduling: Run the integration manually or schedule it (e.g., every 15 minutes) using "Adjust Schedule."
- Mapping Template: Define how Flxpoint fields map to Turn 14 fields for order details (see Mapping Templates section).
- 1 Add the Integration: Go to the Integrations section, select Turn 14 as the integration type, and choose “Send Fulfillment Requests.”
-
2 Connect to Turn 14: Enter your API credentials:
- Client ID: Your Turn 14 client ID (e.g., client123).
- Client Secret: Your Turn 14 client secret (e.g., secret456).
- 3 Configure Settings: Set up shipping method exclusions, define the Max Fulfillment Days in the mapping template if needed, and configure your sync schedule.
- 4 Create a Mapping Template: Use the "Manage Mapping" option to define which fields to send to Turn 14 (see Mapping Templates section).
- 5 Run the Integration: Start manually with Run Sync or schedule via "Adjust Schedule."
- The mapping screen is labeled “Flxpoint → Turn 14” under “Send Fulfillment Requests.”
- Buttons: Delete, Duplicate, and Save.
- Columns: Left (Flxpoint fields), Right (Turn 14 fields).
- Don’t Map: Ignore the field entirely.
- Set To Empty: Clear any existing data in that field.
- Direct Copy: Directly copy the Flxpoint field to the Turn 14 field.
- Field: Map a specific Flxpoint field (e.g., “Shipping Address: Address Line 1”) to a Turn 14 field.
- Value: Set a constant value for all fulfillment requests.
- Mapping Set: Apply a predefined transformation or mapping table.
- Billing Address: Address Line 1, Address Line 2, City, Company Name, Country, Country Code, Email, First Name, Full Name, Last Name, Phone, Postal Code, State, State Code.
- Fulfillment Request: Estimated Dropship Fee, Estimated Shipping Cost, Fulfillment Request Number, Generated At, Note, Sent At, Total Cost, Total Weight (lbs).
- Fulfillment Request Item: Bin Location, Cost, MPN, PO Line Item #, Quantity, SKU, Subtotal, Title, UPC.
- Shipping Address: Address Line 1, Address Line 2, City, Company Name, Country, Country Code, Email, First Name, Full Name, Last Name, Phone, Postal Code, State, State Code.
- Turn 14 Max Fulfillment Days Field: Includes the Max Fulfillment Days field, where you can set a transit days filter (e.g., to exclude shipping methods with transit times exceeding a specified value).
- Turn 14 Order Field: Includes the Order Notes field, allowing you to send additional notes with the order.
- Turn 14 Quote Location Field: Includes the Hold Until Entire Order Can Ship field, which determines if the order should wait until all items are ready to ship.
- Turn 14 Recipient Field: Includes fields like Address Line 1, City, Is Shop Address?, Name, Phone Number, State, Zip, Address Line 2, Company, Country, and Email Address. These fields map recipient details for the order, such as the shipping address.
Flxpoint Field | Maps To | Example | Purpose | Status |
---|---|---|---|---|
Max Fulfillment Days | Turn 14 Max Fulfillment Days Field: Max Fulfillment Days | - | Sets a transit days filter to exclude slower shipping methods | Don't Map |
Order Notes | Turn 14 Order Field: Order Notes | - | Adds notes to the order for Turn 14 | Don't Map |
Hold Until Entire Order Can Ship | Turn 14 Quote Location Field: Hold Until Entire Order Can Ship | True | Determines if the order waits until all items are ready | Direct Copy |
Shipping Address: Address Line 1 | Turn 14 Recipient Field: Address Line 1 | 123 Main St | Sets the primary address line for the recipient | Direct Copy |
Shipping Address: City | Turn 14 Recipient Field: City | New York | Sets the city for the recipient’s address | Direct Copy |
Is Shop Address? | Turn 14 Recipient Field: Is Shop Address? | False | Indicates if the address is a shop address | Direct Copy |
Shipping Address: Full Name | Turn 14 Recipient Field: Name | John Doe | Sets the recipient’s name | Direct Copy |
Shipping Address: Phone | Turn 14 Recipient Field: Phone Number | 555-123-4567 | Sets the recipient’s phone number | Direct Copy |
Shipping Address: State | Turn 14 Recipient Field: State | New York | Sets the state for the recipient’s address | Direct Copy |
Shipping Address: Postal Code | Turn 14 Recipient Field: Zip | 10001 | Sets the zip code for the recipient’s address | Direct Copy |
Shipping Address: Address Line 2 | Turn 14 Recipient Field: Address Line 2 | - | Sets the secondary address line for the recipient | Don't Map |
Shipping Address: Company Name | Turn 14 Recipient Field: Company | - | Sets the company name for the recipient | Don't Map |
Shipping Address: Country | Turn 14 Recipient Field: Country | - | Sets the country for the recipient’s address | Don't Map |
Shipping Address: Email | Turn 14 Recipient Field: Email Address | - | Sets the recipient’s email address | Don't Map |
-
Authentication Failure:
- Verify your Turn 14 API credentials (Client ID and Client Secret).
- Test the connection using the Test Connection button.
-
No Shipping Methods Available:
- Check if you’ve excluded too many shipping methods in the integration config, leaving no viable options.
- Ensure the Max Fulfillment Days filter isn’t too restrictive (e.g., set to 1 day might exclude all methods).
- Verify the API response by reviewing logs using "View Logs."
-
Order Creation Failure:
- Ensure required fields like Address Line 1, City, Name, Phone Number, State, and Zip are mapped correctly in the mapping template.
- Check for API errors (e.g., rate limits, invalid quote ID) in the logs using "View Logs."
-
Sync Failure:
- Review logs using the "View Logs" option to identify specific errors, such as API rate limits or authentication failures.
- Contact Flxpoint support if problems persist, providing the fulfillment request ID and log details for investigation.
- Current Date and Time: As of 06:29 PM -04 on Thursday, May 22, 2025, this integration is fully operational for sending fulfillment requests to Turn 14.
-
API Connection: Uses the Turn 14 API at
https://api.turn14.com
to send fulfillment requests via the/v1/quote
and/v1/order/from_quote
endpoints. - Shipping Method Selection: Automatically selects the cheapest method, with options to exclude methods or filter by transit days.
-
Confirmation Number: The Turn 14
order_id
is saved as the confirmation number in Flxpoint for tracking.
Get Shipments
- Retrieve shipment details, including tracking numbers, carrier names, and shipping methods, for fulfilled orders.
- Sync shipment data for multiple fulfillment requests using the Fulfillment Request Number (FR#) for accurate mapping.
- Map shipment and item details to Flxpoint fields for seamless tracking and record-keeping.
-
Base URL: All API requests are made to
https://api.turn14.com
. -
Generate Token: We start by generating an authentication token using the
/v1/token
endpoint, passing yourclient_id
andclient_secret
. -
Fetch Tracking Details: A GET request is made to the
/v1/tracking/package_details
endpoint to retrieve shipment data. Query parameters include:- start_date: Specifies the start date for the shipment data range (e.g., 2025-05-01).
- end_date: Specifies the end date for the shipment data range (e.g., 2025-05-22).
- Map Shipments to Fulfillment Requests: The integration retrieves tracking details for multiple fulfillment requests. The Fulfillment Request Number (FR#) is used to map tracking data to the corresponding request in Flxpoint.
- Syncing: Shipment data (e.g., tracking number, carrier, ship date) is mapped to Flxpoint fields as per the mapping template and saved to your system. You can run this manually with Run Sync or schedule it via "Adjust Schedule."
-
Date Range: Specify the
start_date
andend_date
parameters to control the range of shipment data retrieved (e.g., last 7 days). - Scheduling: Run the integration manually or schedule it (e.g., daily) using "Adjust Schedule."
- Mapping Template: Define which shipment fields to import and how they map to Flxpoint fields (see Mapping Templates section).
- 1 Add the Integration: Go to the Integrations section, select Turn 14 as the integration type, and choose “Get Shipments.”
-
2 Connect to Turn 14: Enter your API credentials:
- Client ID: Your Turn 14 client ID (e.g., client123).
- Client Secret: Your Turn 14 client secret (e.g., secret456).
- 3 Configure Settings: Set the date range for shipment data retrieval and configure your sync schedule.
- 4 Create a Mapping Template: Use the "Manage Mapping" option to define which fields to import (see Mapping Templates section).
- 5 Run the Integration: Start manually with Run Sync or schedule via "Adjust Schedule."
- The mapping screen is labeled “Turn 14 → Flxpoint” under “Get Shipments.”
- Buttons: Delete, Duplicate, and Save.
- Columns: Left (Turn 14 fields), Right (Flxpoint fields).
- Don’t Map: Ignore the field entirely.
- Set To Empty: Clear any existing data in that field.
- Direct Copy: Directly copy the Turn 14 field to the Flxpoint field (available for certain fields like All Custom Fields).
- Field: Map a specific Turn 14 field (e.g., “Tracking Number”) to a Flxpoint field.
- Value: Set a constant value for all shipments.
- Mapping Set: Apply a predefined transformation or mapping table.
- Turn 14 Package: Carrier Name, Service (Method), Ship Date, Tracking Number.
- Turn 14 Package Item: Part Number, Product Group Part Number, Quantity.
- Shipment Fields: Includes fields like Tracking Number, Carrier, Fulfillment Request Number, Method, Note, Shipped At, Shipping Cost, and Tracking URL. For each field, you can select mapping options (e.g., Don’t Map, Set To Empty, Direct Copy, Field, Value, Mapping Set) and apply rules if needed.
- Shipment Item Fields: Includes fields like Quantity, All Custom Fields (with a note that Direct Copy imports all serial numbers), and SKU. Similar mapping options and rules are available for each field.
- Rules Section: A predefined rule named “Get Shipments - Part number” is visible, which has 1 condition and 1 action modifying the Incoming Value. You can also create new rules using the “New Rule” button or test existing rules with the “Test Rules” button.
Turn 14 Field | Maps To | Example | Purpose | Status |
---|---|---|---|---|
Turn 14 Package: Tracking Number | Flxpoint Shipment Field: Tracking Number | 1Z9999W99999999999 | Records the tracking number for the shipment | Direct Copy |
Turn 14 Package: Carrier Name | Flxpoint Shipment Field: Carrier | UPS | Records the carrier used for the shipment | Direct Copy |
Fulfillment Request Number | Flxpoint Shipment Field: Fulfillment Request Number | - | Maps the shipment to the correct fulfillment request | Don't Map |
Turn 14 Package: Service (Method) | Flxpoint Shipment Field: Method | Ground | Records the shipping method used | Direct Copy |
Note | Flxpoint Shipment Field: Note | - | Adds any notes related to the shipment | Don't Map |
Turn 14 Package: Ship Date | Flxpoint Shipment Field: Shipped At | 2025-05-20 | Records the date the shipment was sent | Direct Copy |
Shipping Cost | Flxpoint Shipment Field: Shipping Cost | - | Records the cost of shipping | Don't Map |
Tracking URL | Flxpoint Shipment Field: Tracking URL | - | Provides a URL to track the shipment | Don't Map |
Turn 14 Package Item: Quantity | Flxpoint Shipment Item Field: Quantity | 2 | Records the quantity of items shipped | Direct Copy |
All Custom Fields | Flxpoint Shipment Item Field: All Custom Fields | - | Imports all serial numbers if set to Direct Copy | Don't Map |
Turn 14 Package Item: Product Group Part Number | Flxpoint Shipment Item Field: SKU | ABC123 | Records the SKU for the shipped item | Direct Copy |
-
Get Shipments - Part number Rule: A predefined rule named "Get Shipments - Part number" is applied. It:
- Has 1 condition and 1 action modifying the Incoming Value.
- Can be tested or modified using the "Test Rules" or "New Rule" options in the mapping interface.
-
Authentication Failure:
- Verify your Turn 14 API credentials (Client ID and Client Secret).
- Test the connection using the Test Connection button.
-
No Shipment Data Returned:
- Ensure the
start_date
andend_date
parameters cover a period where shipments exist (e.g., check the date range in Turn 14). - Verify the API response by reviewing logs using "View Logs."
- Ensure the
-
Incorrect Mapping of Shipments:
- Ensure the Fulfillment Request Number (FR#) is correctly mapped in the template to match shipments to the right requests.
- Check the "Get Shipments - Part number" rule to ensure it’s not altering data unexpectedly.
-
Sync Failure:
- Review logs using the "View Logs" option to identify specific errors, such as API rate limits or authentication failures.
- Contact Flxpoint support if problems persist, providing the shipment ID and log details for investigation.
- Current Date and Time: As of 06:33 PM -04 on Thursday, May 22, 2025, this integration is fully operational for retrieving shipment data from Turn 14.
-
API Connection: Uses the Turn 14 API at
https://api.turn14.com
to fetch shipment details via the/v1/tracking/package_details
endpoint. -
Date Range Parameters: Requires
start_date
andend_date
to specify the shipment data range. - Mapping by FR#: Uses the Fulfillment Request Number (FR#) to map tracking details to specific fulfillment requests.
Get Invoices
- Retrieve invoice details, including invoice numbers, dates, totals, and itemized costs, for fulfilled orders.
- Sync invoice data for fulfillment requests, linking them via the Fulfillment Request Number.
- Map invoice and invoice item details to Flxpoint fields for accurate financial tracking.
-
Base URL: All API requests are made to
https://api.turn14.com
. -
Generate Token: We start by generating an authentication token using the
/v1/token
endpoint, passing yourclient_id
andclient_secret
. -
Fetch Invoice Details: A GET request is made to the
/v1/invoices
endpoint with query parameters:- start_date: Calculated as the `end_date` minus the number of days specified in the integration config.
- end_date: Set to the current date (the date of the sync).
- Map Invoices to Fulfillment Requests: The integration retrieves invoice data for fulfillment requests, using the Fulfillment Request Number to link invoices to the corresponding requests in Flxpoint.
- Syncing: Invoice data (e.g., invoice number, total price, item quantities) is mapped to Flxpoint fields as per the mapping template and saved to your system. You can run this manually with Run Sync or schedule it via "Adjust Schedule."
- Number of Days: Specify a numeric value in the integration config to define the date range for invoice retrieval (e.g., 7 days to pull invoices from the last week).
- Scheduling: Run the integration manually or schedule it (e.g., daily) using "Adjust Schedule."
- Mapping Template: Define which invoice fields to import and how they map to Flxpoint fields (see Mapping Templates section).
- 1 Add the Integration: Go to the Integrations section, select Turn 14 as the integration type, and choose “Get Fulfillment Request Invoices.”
-
2 Connect to Turn 14: Enter your API credentials:
- Client ID: Your Turn 14 client ID (e.g., client123).
- Client Secret: Your Turn 14 client secret (e.g., secret456).
- 3 Configure Settings: Set the number of days for invoice data retrieval and configure your sync schedule.
- 4 Create a Mapping Template: Use the "Manage Mapping" option to define which fields to import (see Mapping Templates section).
- 5 Run the Integration: Start manually with Run Sync or schedule via "Adjust Schedule."
- The mapping screen is labeled “Turn 14 → Flxpoint” under “Get Fulfillment Request Invoices.”
- Buttons: Delete, Duplicate, and Save.
- Columns: Left (Turn 14 fields), Right (Flxpoint fields).
- Don’t Map: Ignore the field entirely.
- Set To Empty: Clear any existing data in that field.
- Direct Copy: Directly copy the Turn 14 field to the Flxpoint field (available for certain fields like All Custom Fields).
- Field: Map a specific Turn 14 field (e.g., “Invoice Number”) to a Flxpoint field.
- Value: Set a constant value for all invoices.
- Mapping Set: Apply a predefined transformation or mapping table.
- Option: Select a specific option for certain fields (e.g., Invoice Date, Cost).
- Turn 14 Invoice: Comments, Date, Discount Amount, Freight, Invoice Number, Purchase Order Number, Total Price, Website Order Number.
- Turn 14 Invoice Item: Line Notes, Part Description, Part Number, Product Group Part Number, Quantity, Total Price, Unit Price.
- Source Invoice Fields: Includes fields like Fulfillment Request Number, Invoice Number, Fee Cost, Invoice Date, Invoice Status, Other Cost, Shipping Cost, and Tax Cost. For each field, you can select mapping options (e.g., Don’t Map, Set To Empty, Direct Copy, Field, Value, Mapping Set, Option) and apply rules if needed.
- Source Invoice Item Fields: Includes fields like Quantity, All Custom Fields, Cost, Invoice Item Type, Per Unit Cost, SKU, and Title. Similar mapping options and rules are available for each field.
Turn 14 Field | Maps To | Example | Purpose | Status |
---|---|---|---|---|
Turn 14 Invoice: Purchase Order Number | Flxpoint Source Invoice Field: Fulfillment Request Number | FR12345 | Links the invoice to the correct fulfillment request | Direct Copy |
Turn 14 Invoice: Invoice Number | Flxpoint Source Invoice Field: Invoice Number | - | Records the invoice number from Turn 14 | Don't Map |
Fee Cost | Flxpoint Source Invoice Field: Fee Cost | - | Records any additional fees on the invoice | Don't Map |
Invoice Date | Flxpoint Source Invoice Field: Invoice Date | - | Records the date of the invoice | Don't Map |
Invoice Status | Flxpoint Source Invoice Field: Invoice Status | - | Records the status of the invoice | Don't Map |
Other Cost | Flxpoint Source Invoice Field: Other Cost | - | Records other miscellaneous costs | Don't Map |
Shipping Cost | Flxpoint Source Invoice Field: Shipping Cost | - | Records the shipping cost on the invoice | Don't Map |
Tax Cost | Flxpoint Source Invoice Field: Tax Cost | - | Records the tax amount on the invoice | Don't Map |
Turn 14 Invoice Item: Quantity | Flxpoint Source Invoice Item Field: Quantity | 3 | Records the quantity of items invoiced | Direct Copy |
All Custom Fields | Flxpoint Source Invoice Item Field: All Custom Fields | - | Imports all custom fields if set to Direct Copy | Don't Map |
Cost | Flxpoint Source Invoice Item Field: Cost | - | Records the total cost of the item | Don't Map |
Invoice Item Type | Flxpoint Source Invoice Item Field: Invoice Item Type | - | Records the type of invoice item | Don't Map |
Turn 14 Invoice Item: Unit Price | Flxpoint Source Invoice Item Field: Per Unit Cost | 25.00 | Records the cost per unit of the item | Direct Copy |
Turn 14 Invoice Item: Product Group Part Number | Flxpoint Source Invoice Item Field: SKU | XYZ789 | Records the SKU for the invoiced item | Direct Copy |
Title | Flxpoint Source Invoice Item Field: Title | - | Records the title of the invoiced item | Don't Map |
-
Authentication Failure:
- Verify your Turn 14 API credentials (Client ID and Client Secret).
- Test the connection using the Test Connection button.
-
No Invoice Data Returned:
- Ensure the date range (based on the number of days in the config) covers a period where invoices exist (e.g., check the date range in Turn 14).
- Verify the API response by reviewing logs using "View Logs."
-
Incorrect Mapping of Invoices:
- Ensure the Fulfillment Request Number field is correctly mapped in the template to match invoices to the right requests.
- Check that required fields like Quantity and Per Unit Cost are mapped to capture essential invoice details.
-
Sync Failure:
- Review logs using the "View Logs" option to identify specific errors, such as API rate limits or authentication failures.
- Contact Flxpoint support if problems persist, providing the invoice ID and log details for investigation.
- Current Date and Time: As of 06:36 PM -04 on Thursday, May 22, 2025, this integration is fully operational for retrieving invoice data from Turn 14.
-
API Connection: Uses the Turn 14 API at
https://api.turn14.com
to fetch invoice details via the/v1/invoices
endpoint. - Date Range Configuration: The date range is defined by a number of days in the config, with `end_date` as the current date and `start_date` calculated as `end_date` minus the specified days.
- Mapping by FR#: Uses the Fulfillment Request Number to map invoice details to specific fulfillment requests.