Flxpoint Knowledge

Contact us

Bill Hicks as Source

Table of Contents

How To Connect Product Operations Order Operations

Bill Hicks & Co. Tackle is a leading distributor of firearms, ammunition, and outdoor sporting goods, specializing in providing a vast array of products to retailers across the United States. By integrating Bill Hicks & Co. Tackle into your Flxpoint system, you can streamline inventory management, automate order processing, and ensure that your e-commerce platform remains updated with the latest products and pricing available from this reputable supplier.

 

How To Connect

📋 Phase 1: Creating Your Bill Hicks Source +
Create Source in Flxpoint
Log into your Flxpoint account, navigate to the Sources tab, and click + Add Source to begin!
Set Up Source Details
Name your source "Bill Hicks Supplier", select the source type (e.g., Vendor Warehouse), and consider assigning a vendor for better tracking. Click Save & Next to proceed.
Tip: Assigning a vendor keeps your reports organized and easy to manage.
Choose Integration Type
In the Integrations section, click Start Creating Integrations if needed. Select these options based on your needs:
  • Get Inventory (Primary): Fetches your main inventory from Bill Hicks.
  • Get Inventory (Secondary): Provides an additional inventory feed.
  • Send Fulfillment Requests: Sends orders to Bill Hicks for processing.
  • Get Shipments: Retrieves shipment updates.
  • Get Fulfillment Request Acknowledgements: Gets confirmation of sent orders.
Note: Mix and match based on what works for you!
🔐 Phase 2: Setting Up Connections +
Credential Info: Get Inventory (Primary) and (Secondary) don’t need credentials—Flxpoint handles it! However, Send Fulfillment Requests, Get Shipments, and Get Fulfillment Request Acknowledgements require a Customer ID. Keep reading to learn how to get it!
Set Up Get Inventory (Primary) and (Secondary)
For Get Inventory (Primary) and Get Inventory (Secondary):
  • In the integration setup, select Bill Hicks as the Integration Type.
  • No additional connection details are needed—click Save and Proceed to move forward.
Tip: These steps are super easy since no credentials are required!
Obtain Your Customer ID
For Send Fulfillment Requests, Get Shipments, and Get Fulfillment Request Acknowledgements, you’ll need a Customer ID. Here’s how to get it:
  • Log into your Bill Hicks account (contact their support if you don’t have one).
  • Navigate to the Account Dashboard or Settings section.
  • Look for a section labeled Account Information, Customer Details, or API Access where your Customer ID is listed.
  • If you can’t find it, generate a new Customer ID or request one from Bill Hicks support (usually via email or their website).
  • Copy the Customer ID and save it securely for the next step.
Important: Keep your Customer ID safe and don’t share it publicly!
Configure Send Fulfillment Requests, Get Shipments, and Acknowledgements
For these integrations:
  • Connection Name: Use "Bill Hicks Fulfillment Connection" (or a name you’ll recognize).
  • Customer ID: Enter the Customer ID you obtained from Bill Hicks.
  • For Send Fulfillment Requests, add fields like Customer ID, Ship To #, and optional settings (e.g., Hold for X Hours, Send During Business Hours).
  • Click Save and Proceed to continue.
Tip: Double-check the Customer ID if the connection test fails (if applicable).
Customer ID Role: The Customer ID is your unique identifier with Bill Hicks, used to authenticate Send Fulfillment Requests, Get Shipments, and Get Fulfillment Request Acknowledgements.
🔄 Phase 3: Configuring Settings +
Configure Settings for Send Fulfillment Requests
In the settings section:
  • Enter your Customer ID.
  • Add a Ship To # if required by Bill Hicks.
  • Optionally, set Hold for X Hours or enable Send During Business Hours for order processing.
  • Click Save and Proceed to save settings.
Tip: Check with Bill Hicks support for specific Ship To # requirements.
Configure Get Shipments and Acknowledgements
For these integrations:
  • Ensure the Customer ID is entered (same as above).
  • No additional settings are needed—Flxpoint will handle the rest.
  • Click Save and Proceed to move forward.
✅ Phase 4: Mapping and Activation +
Define a Mapping Template
For Get Inventory (Primary) and Get Inventory (Secondary):
  • Select or create a mapping template.
  • Map fields like SKU, Price, Quantity, and Description.
  • Save the template to proceed.
Tip: Map all key fields for accurate inventory data!
Activate and Verify
Complete the setup by clicking Save and Proceed. Your Bill Hicks integrations are now active!
Next Steps: Monitor the initial inventory sync in the Fulfillment Sources section of your Flxpoint dashboard.

 



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 update.

Get Inventory (Primary)

Supported | Bill Hicks - Get Inventory [Primary]

Introduction to Bill Hicks - Get Inventory [Primary] Integration
The Bill Hicks - Get Inventory [Primary] integration automates retrieving primary inventory data from Bill Hicks’ FTP server into Flxpoint. It pulls details like SKUs, quantities, and prices from BHC_Catalog.csv and BHC_Inventory.csv files, mapping them to your inventory fields for real-time stock management. The setup involves connecting to the FTP, configuring settings, and defining a mapping template. Let’s walk through each step to get you started!

The Bill Hicks - Get Inventory [Primary] integration connects your Flxpoint system to Bill Hicks to:
  • Fetch primary inventory data (e.g., SKUs, quantities) from the FTP server.
  • Map data to Flxpoint inventory fields for accurate stock tracking.
  • Automate inventory updates, keeping your stock current.

This integration follows a clear, step-by-step process to retrieve inventory data from Bill Hicks to Flxpoint:
  • Data Extraction: Downloads BHC_Catalog.csv and BHC_Inventory.csv files from the FTP server using hardcoded credentials.
  • Field Mapping: Maps data like SKU and Quantity to Flxpoint inventory fields using a mapping template.
  • Data Update: Updates Flxpoint with the retrieved inventory details and adds images if configured.
What Does the Inventory Data Look Like?
Let’s take a peek at a sample inventory data structure from Bill Hicks:
{
"Inventory": {
"SKU": "BH12345",
"Quantity": 75,
"Price": 12.99
},
}
Understanding the Data: The "SKU": "BH12345" identifies the product, and "Quantity": 75 updates the stock level in Flxpoint.

Let’s set up the integration by customizing a few key settings to match your needs:
  • FTP Connection Settings:
    • Connection Name: Give your connection a name, like "BillHicksFTP_Inventory".
    • FTP Host: Set to billhicksco.hostftp.com as hardcoded.
    • FTP User: Use accountsaccounts@inventorysource.com as provided.
    • FTP Password: Input the password.
    • FTP Port: Use port 22 as specified.
  • Archive/Un-Archive Inventory: Archive unmapped inventory (set quantity to 0) or keep it active. Useful if Bill Hicks updates stock status.
  • FETCH SOURCE_IMAGES: Enable to download images from the FTP and save them to S3 if set to "Yes".
What’s FETCH SOURCE_IMAGES? When enabled, it downloads images from the FTP and stores them in S3 for use in Flxpoint.
Archive Setting: Archives items not in the feed, keeping your inventory clean.

Follow these steps to get the Bill Hicks - Get Inventory [Primary] integration up and running:
  • 1 Establish FTP Connection: Select Bill Hicks, set the Connection Name, FTP Host, FTP User, FTP Password, and FTP Port, then click Save and Proceed.
  • 2 Configure Settings: Adjust Archive/Un-Archive and FETCH SOURCE_IMAGES options, then save.
  • 3 Define Mapping Template: Map Bill Hicks fields to Flxpoint inventory fields (see the "Mapping Template" section below).
  • 4 Run the Integration: Run manually or schedule for automation.

The integration setup interface for “Bill Hicks - Get Inventory [Primary]” is where you begin connecting Bill Hicks to your Flxpoint system. Let’s explore what you’ll see:
  • Integration Title: At the top, you’ll see the integration name, “Bill Hicks - Get Inventory [Primary]”, clearly labeled.
  • FTP Connection Settings Section: This section contains fields for Connection Name, FTP Host, FTP User, FTP Password, and FTP Port.
  • Settings Options: Includes Archive/Un-Archive and FETCH SOURCE_IMAGES toggles.
  • Action Buttons: Features Save and Proceed.
Next Steps
Once you’ve set up the integration connection, you’ll move on to defining how Bill Hicks data maps to Flxpoint inventory fields in the "Mapping Template" section below.

The Mapping Template is where you define how Bill Hicks’ inventory data maps to Flxpoint fields. This ensures Flxpoint receives the data in the format you need!
Mapping Fields
Below is a table of key fields you can map, complete with examples and purposes:
Field Maps To Example Purpose Status
SKU (T) Flxpoint Inventory: SKU BH12345 Identifies the product Required
Quantity (N) Flxpoint Inventory: Quantity 75 Updates stock level Required
Price (N) Flxpoint Inventory: Price 12.99 Sets the product price Optional
Available Source Fields
Bill Hicks provides these fields from BHC_Catalog.csv and BHC_Inventory.csv:
  • Inventory: SKU (T), Quantity (N), Price (N), Manufacturer (T), Category (T), etc.
Let’s Break It Down: Mapping "Quantity": 75 ensures your stock reflects the latest data from Bill Hicks!
Mapping Options
Customize with these options:
  • Field: Link a Bill Hicks field (e.g., SKU) to a Flxpoint field.
  • Value: Set a fixed value (e.g., Quantity = 0 if unmapped).
  • Mapping Set: Combine fields for complex mappings.
  • Rules: Apply custom logic (see below).
  • Don’t Map: Skip the field.
  • Set to Empty: Clear the field.
Try This: Set a fixed Quantity value of 0 for unmapped items!
Summary
You’ve mapped key fields like SKU and Quantity. Next, add custom rules if needed!

Mapping Rules allow you to transform Bill Hicks’ inventory data as it’s mapped to Flxpoint fields.
Creating a New Rule
Want to create your own rule? Use the Mapping Dashboard to set up:
  • Rule Name: E.g., "Set Default Quantity".
  • Rule Type: Conditional or Tier.
  • Input Type: Number, etc.
Try This: Create a rule to set Quantity to 0 if the feed data is missing!

As of 04:56 PM -04 on Sunday, June 15, 2025, this integration is ready to retrieve primary inventory from Bill Hicks!
Pro Tip: Enable FETCH SOURCE_IMAGES to include product images in your inventory!

Conclusion
With the Bill Hicks - Get Inventory [Primary] integration, you can seamlessly update your primary inventory with ease. Enjoy the automation!
 
 

Get Inventory (Secondary)

Supported | Bill Hicks - Get Inventory [Secondary]

Introduction to Bill Hicks - Get Inventory [Secondary] Integration
The Bill Hicks - Get Inventory [Secondary] integration automates retrieving secondary inventory data from Bill Hicks’ FTP server into Flxpoint. It pulls additional details like costs and quantities from BHC_Catalog.csv and BHC_Inventory.csv files, mapping them to variant fields for enhanced inventory management. The setup involves configuring settings and defining a mapping template. Let’s dive in!

The Bill Hicks - Get Inventory [Secondary] integration connects your Flxpoint system to Bill Hicks to:
  • Fetch secondary inventory data (e.g., Cost, Quantity) from the FTP server.
  • Map data to Flxpoint variant fields for detailed stock tracking.
  • Automate updates for secondary inventory, complementing the primary feed.

This integration follows a clear process to retrieve secondary inventory data from Bill Hicks to Flxpoint:
  • Data Extraction: Downloads BHC_Catalog.csv and BHC_Inventory.csv files from the FTP server using hardcoded credentials.
  • Field Mapping: Maps data like Quantity and Cost to Flxpoint variant fields using a mapping template.
  • Data Update: Updates Flxpoint with the secondary inventory details.
What Does the Inventory Data Look Like?
Let’s take a peek at a sample secondary inventory data structure from Bill Hicks:
{
"Inventory": {
"SKU": "BH67890",
"Quantity": 30,
"Cost": 8.99
},
}
Understanding the Data: The "Quantity": 30 updates variant stock, while "Cost": 8.99 sets the variant cost!

Customize the integration with these settings:
  • Archive/Un-Archive Inventory: Archive unmapped inventory (set quantity to 0) or keep it active. Helpful if Bill Hicks updates stock status.
  • Allow Create Variant: Enable to create variants while running Get Inventory [Secondary].
  • Automation: Enable or disable job scheduling for automated updates.
Archive Setting: Archives items not in the feed, keeping your inventory organized.
Allow Create Variant: Creates new variants automatically when enabled.

Follow these steps to set up the Bill Hicks - Get Inventory [Secondary] integration:
  • 1 Establish Connection: Select Bill Hicks as the integration type and click Save and Proceed (no additional connection info needed).
  • 2 Configure Settings: Adjust Archive/Un-Archive and Allow Create Variant options, then save.
  • 3 Define Mapping Template: Map Bill Hicks fields to Flxpoint variant fields (see the "Mapping Template" section below).
  • 4 Run the Integration: Run manually or schedule for automation.

The setup interface for “Bill Hicks - Get Inventory [Secondary]” includes:
  • Integration Title: Shows “Bill Hicks - Get Inventory [Secondary]”.
  • Settings Options: Archive/Un-Archive and Allow Create Variant toggles, plus Automation settings.
  • Action Buttons: Save and Proceed.
Next Steps
After connecting, define your mapping template below!

Map Bill Hicks secondary inventory data to Flxpoint variant fields here!
Mapping Fields
Key fields to map with examples:
Field Maps To Example Purpose Status
Quantity (N) Flxpoint Inventory Variant: Quantity 30 Updates variant stock level Required
Cost (N) Flxpoint Inventory Variant: Cost 8.99 Sets the variant cost Required
SKU (T) Flxpoint Inventory Variant: SKU BH67890 Identifies the variant Required
Available Source Fields
Bill Hicks provides these fields from BHC_Catalog.csv and BHC_Inventory.csv:
  • Inventory Variant: Quantity (N), Cost (N), SKU (T), etc.
Let’s Break It Down: Mapping "Quantity": 30 ensures your variant stock is up-to-date!
Mapping Options
Customize with these options:
  • Field: Link a Bill Hicks field to a Flxpoint variant field.
  • Value: Set a fixed value (e.g., Cost = 0 if unmapped).
  • Mapping Set: Combine fields for complex mappings.
  • Rules: Apply custom logic (see below).
  • Don’t Map: Skip the field.
  • Set to Empty: Clear the field.
Try This: Set a fixed Cost value of 0 for unmapped variants!
Summary
You’ve mapped key fields like Quantity and Cost. Next, add custom rules if needed!

Mapping Rules tweak your secondary inventory data.
Creating a New Rule
Want to create your own rule? Use the Mapping Dashboard to set up:
  • Rule Name: E.g., "Set Default Cost".
  • Rule Type: Conditional or Tier.
  • Input Type: Number, etc.
Try This: Create a rule to set Cost to 0 if Quantity is 0!

As of 05:08 PM -04 on Sunday, June 15, 2025, this integration is ready to retrieve secondary inventory from Bill Hicks!
Pro Tip: Enable Allow Create Variant if you expect new variants from Bill Hicks!

Conclusion
With the Bill Hicks - Get Inventory [Secondary] integration, you can enhance your inventory management with secondary data. Enjoy the process!
 
 

 

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 Fulfillment Requests

Supported | Bill Hicks - Send Fulfillment Requests

Introduction to Bill Hicks - Send Fulfillment Requests Integration
The Bill Hicks - Send Fulfillment Requests integration automates sending purchase orders (POs) and fulfillment requests to Bill Hicks via FTP. It maps Flxpoint data like SKUs, quantities, and shipping addresses, sending them securely with a Customer ID and optional Ship To #. This streamlines your order fulfillment process! The setup involves configuring settings and defining a mapping template. Let’s get started!

The Bill Hicks - Send Fulfillment Requests integration connects Flxpoint to Bill Hicks to:
  • Send purchase orders to Bill Hicks by converting Flxpoint fulfillment requests into their required format.
  • Map Flxpoint order data (e.g., shipping details, SKUs) to Bill Hicks’ purchase order fields.
  • Automate order processing, saving you time and reducing manual work.

The process is straightforward:
  • Data Collection: Gathers fulfillment request data from Flxpoint (e.g., SKU, Quantity).
  • Field Mapping: Maps data to Bill Hicks’ fields using a template.
  • FTP Delivery: Sends the mapped data to Bill Hicks’ FTP server as a text file.
What Does the Fulfillment Data Look Like?
Here’s a sample of the data sent to Bill Hicks:
{
"FulfillmentRequest": {
"FulfillmentRequestNumber": "FR54321",
"CustomerID": "CUST123",
"ShipTo": "001"
},
"ShippingAddress": {
"AddressLine1": "456 Oak St"
},
"FulfillmentRequestItem": {
"SKU": "BH12345",
"Quantity": 3
}
}
Understanding the Data: The "FulfillmentRequestNumber": "FR54321" tracks the order, while "ShipTo": "001" routes it to the licensed address if needed!

Customize the integration with these settings:
  • Customer ID Settings:
    • Customer ID: Enter the Customer ID provided by Bill Hicks (e.g., "CUST123") to authenticate your requests.
  • Ship To #: Yes, you can now set your Bill Hicks “Ship To #” directly here—no template edits required. Enter a value (e.g., "001") only if Bill Hicks provides a code. Most dealers use "001" when the shipping address differs from their Federal Firearms License (FFL) address. Leave blank if unsure, and consult your Bill Hicks account manager.
  • Hold for X Hours: Set a delay (e.g., 24 hours) to review orders before sending.
  • Send During Business Hours: Optionally limit sending to business hours only.
  • Automation: Enable or disable job scheduling for automated updates.
What’s Changed? Bill Hicks asked us to move the Ship To # from the mapping template to the integration settings, keeping order files in their exact format.
Hold Setting: Useful if you need time to review orders before sending them.
Important: Ship To # is case-sensitive and must match exactly. The FFL# in your data should only include the license number and dashes—no extra text.

Follow these steps to get the Bill Hicks - Send Fulfillment Requests integration up and running:
  • 1 Establish Connection: Select Bill Hicks, set the Customer ID, and optionally enter the Ship To #, then click Save and Proceed.
  • 2 Configure Settings: Set Hold for X Hours and Send During Business Hours options, then save.
  • 3 Define Mapping Template: Map Flxpoint fields to Bill Hicks fields (see the "Mapping Template" section below).
  • 4 Run the Integration: Run manually or schedule for automation, then confirm with your Bill Hicks rep that the order file was accepted.

The setup interface for “Bill Hicks - Send Fulfillment Requests” includes:
  • Integration Title: Shows “Bill Hicks - Send Fulfillment Requests”.
  • Settings Options: Fields for Customer ID, Ship To #, Hold for X Hours, and Send During Business Hours toggle, plus Automation settings.
  • Action Buttons: Save and Proceed.
Next Steps
After connecting, define your mapping template below!

Map Flxpoint data to Bill Hicks purchase order fields here!
Mapping Fields
Key fields to map with examples:
Field Maps To Example Purpose Status
Fulfillment Request Number (T) Bill Hicks Purchase Order: Cust Po FR54321 Identifies the purchase order Required
Shipping Address: Address Line 1 (T) Bill Hicks Purchase Order: Address 1 456 Oak St Specifies the primary shipping address Required
Shipping Address: Address Line 2 (T) Bill Hicks Purchase Order: Address 2 Apt 5C Provides additional address details Optional
Shipping Address: City (T) Bill Hicks Purchase Order: City Denver Specifies the city for shipping Required
Shipping Address: State (T) Bill Hicks Purchase Order: State CO Specifies the state for shipping Required
Shipping Address: Postal Code (T) Bill Hicks Purchase Order: Zip 80202 Specifies the postal code for shipping Required
Fulfillment Request Item: SKU (T) Bill Hicks Purchase Order: Item BH12345 Identifies the product to be fulfilled Required
Fulfillment Request Item: Quantity (N) Bill Hicks Purchase Order: Qty 3 Specifies the quantity of the item Required
Fulfillment Request Item: Cost (N) Bill Hicks Purchase Order: Price 15.99 Sets the item cost Optional
Available Source Fields
Flxpoint provides these fields for mapping:
  • Shipping Address: Address Line 1 (T), Address Line 2 (T), City (T), State (T), Postal Code (T), etc.
  • Fulfillment Request: Fulfillment Request Number (T), Note (T), etc.
  • Fulfillment Request Item: SKU (T), Quantity (N), Cost (N), etc.
Let’s Break It Down: Mapping "FulfillmentRequestNumber": "FR54321" to Cust Po helps Bill Hicks track your order!
Mapping Options
Customize with these options:
  • Field: Link a Flxpoint field to a Bill Hicks field.
  • Value: Set a fixed value (e.g., Note = "Urgent").
  • Mapping Set: Combine fields for complex mappings.
  • Rules: Apply custom logic (see below).
  • Don’t Map: Skip the field.
  • Set to Empty: Clear the field.
Try This: Set a fixed Note value like "Please expedite" for all orders!
Summary
You’ve mapped key fields like Fulfillment Request Number and SKU. Next, add custom rules if needed!

Mapping Rules tweak your fulfillment data.
Creating a New Rule
Create a rule with:
  • Rule Name: E.g., "Add Urgent Note".
  • Rule Type: Conditional or Tier.
  • Input Type: String, etc.
Try This: Add a rule to append "URGENT" to Note if the order is marked as urgent!

As of 05:15 PM -04 on Sunday, June 15, 2025, this integration is ready to send fulfillment requests to Bill Hicks!
Pro Tip: After setting the Ship To #, test a single Send PO job and confirm with your Bill Hicks rep that the order file is accepted!

Conclusion
With the Bill Hicks - Send Fulfillment Requests integration, you can automate order sending with ease. Enjoy the streamlined process!
 
 

Get Shipments

Supported | Bill Hicks - Get Shipments

Introduction to Bill Hicks - Get Shipments Integration
The Bill Hicks - Get Shipments integration automates retrieving shipment details from Bill Hicks via FTP into Flxpoint. It pulls data like tracking numbers and ship dates from a text file, mapping them to your shipment fields for real-time tracking. The setup involves configuring settings and defining a mapping template. Let’s get started!

The Bill Hicks - Get Shipments integration connects Flxpoint to Bill Hicks to:
  • Fetch shipment details (e.g., tracking numbers, ship dates) from the FTP server.
  • Map shipment data to Flxpoint fields for accurate tracking.
  • Automate shipment updates, keeping you informed about order statuses.

The process is simple:
  • Data Extraction: Downloads a shipment text file from the FTP server using hardcoded credentials.
  • Field Mapping: Maps data like Tracking Number and Quantity Shipped to Flxpoint shipment fields.
  • Data Update: Updates Flxpoint with the retrieved shipment details.
What Does the Shipment Data Look Like?
Here’s a sample of the shipment data from Bill Hicks:
{
"Shipment": {
"TrackingNumber": "1Z9999W999999999",
"ShipDate": "2025-06-14T14:00:00Z",
"QuantityShipped": 2
},
}
Understanding the Data: The "TrackingNumber": "1Z9999W999999999" lets you track the shipment, while "QuantityShipped": 2 confirms the shipped amount!

Customize the integration with these settings:
  • Fetch Shipment for Days: Set the number of days (e.g., 7) to retrieve shipment data for.
  • Customer ID: Enter the Customer ID provided by Bill Hicks (e.g., "CUST123") to authenticate requests.
What’s Fetch Shipment for Days? This limits the shipment data to the specified number of days, helping you manage recent shipments.
Customer ID: Ensures your requests are tied to your Bill Hicks account.

Follow these steps to set up the Bill Hicks - Get Shipments integration:
  • 1 Establish Connection: Select Bill Hicks, click Save and Proceed (no additional connection info needed).
  • 2 Configure Settings: Set Fetch Shipment for Days and Customer ID, then save.
  • 3 Define Mapping Template: Map Bill Hicks fields to Flxpoint shipment fields (see the "Mapping Template" section below).
  • 4 Run the Integration: Run manually or schedule for automation.

The setup interface for “Bill Hicks - Get Shipments” includes:
  • Integration Title: Shows “Bill Hicks - Get Shipments”.
  • Settings Options: Fields for Fetch Shipment for Days and Customer ID.
  • Action Buttons: Save and Proceed.
Next Steps
After connecting, define your mapping template below!

Map Bill Hicks shipment data to Flxpoint fields here!
Mapping Fields
Key fields to map with examples:
Field Maps To Example Purpose Status
Carrier (T) Flxpoint Shipment: Carrier UPS Identifies the shipping carrier Required
Tracking Number (T) Flxpoint Shipment: Tracking Number 1Z9999W999999999 Tracks the shipment Required
Ship Date (D) Flxpoint Shipment: Shipped At 2025-06-14T14:00:00Z Records the shipping date Required
Quantity Shipped (N) Flxpoint Shipment Item: Quantity 2 Confirms the shipped quantity Required
Product ID (T) Flxpoint Shipment Item: SKU BH12345 Identifies the shipped product Required
Available Source Fields
Bill Hicks provides these fields from the shipment text file:
  • Shipment: Carrier (T), Tracking Number (T), Ship Date (D), Quantity Shipped (N), Product ID (T), etc.
Let’s Break It Down: Mapping "TrackingNumber": "1Z9999W999999999" ensures you can track shipments in Flxpoint!
Mapping Options
Customize with these options:
  • Field: Link a Bill Hicks field to a Flxpoint shipment field.
  • Value: Set a fixed value (e.g., Note = "Shipped").
  • Mapping Set: Combine fields for complex mappings.
  • Rules: Apply custom logic (see below).
  • Don’t Map: Skip the field.
  • Set to Empty: Clear the field.
Try This: Set a fixed Note value like "Delivered" for completed shipments!
Summary
You’ve mapped key fields like Tracking Number and Quantity Shipped. Next, add custom rules if needed!

Mapping Rules tweak your shipment data.
Creating a New Rule
Want to create your own rule? Use the Mapping Dashboard to set up:
  • Rule Name: E.g., "Update Shipped Status".
  • Rule Type: Conditional or Tier.
  • Input Type: String, Date, etc.
Try This: Add a rule to set Note to "Delayed" if Ship Date is over 5 days old!

As of 05:23 PM -04 on Sunday, June 15, 2025, this integration is ready to retrieve shipments from Bill Hicks!
Pro Tip: Set Fetch Shipment for Days to match your business needs for accurate shipment retrieval!

Conclusion
With the Bill Hicks - Get Shipments integration, you can keep your shipment data up-to-date effortlessly. Happy tracking!
 
 

Get Fulfillment Acknowledgments

Supported | Bill Hicks - Get Fulfillment Request Acknowledgements

Introduction to Bill Hicks - Get Fulfillment Request Acknowledgements Integration
The Bill Hicks - Get Fulfillment Request Acknowledgements integration automates retrieving acknowledgment details for fulfillment requests from Bill Hicks via FTP into Flxpoint. It pulls data like PO numbers and quantities committed from a text file, updating the status of your requests. The setup involves configuring settings and defining a mapping template. Let’s dive in!

The Bill Hicks - Get Fulfillment Request Acknowledgements integration connects Flxpoint to Bill Hicks to:
  • Fetch acknowledgment details (e.g., PO numbers, quantities committed) from the FTP server.
  • Map data to Flxpoint fulfillment request fields for status updates.
  • Automate acknowledgment processing, keeping your order statuses current.

The process is straightforward:
  • Data Extraction: Downloads an acknowledgment text file from the FTP server using hardcoded credentials.
  • Field Mapping: Maps data like Quantity Committed and PO Number to Flxpoint acknowledgment fields.
  • Data Update: Updates Flxpoint with the acknowledgment details and marks the request as acknowledged.
What Does the Acknowledgment Data Look Like?
Here’s a sample of the acknowledgment data from Bill Hicks:
{
"Acknowledgement": {
"PONumber": "FR54321",
"POAckDate": "2025-06-14T14:00:00Z",
"QuantityCommitted": 2
},
}
Understanding the Data: The "PONumber": "FR54321" links to your request, while "QuantityCommitted": 2 confirms the committed amount!

Customize the integration with these settings:
  • Fetch Acknowledgment for Days: Set the number of days (e.g., 7) to retrieve acknowledgment data for.
  • Customer ID: Enter the Customer ID provided by Bill Hicks (e.g., "CUST123") to authenticate requests.
What’s Fetch Acknowledgment for Days? This limits the acknowledgment data to the specified number of days, helping you manage recent updates.
Customer ID: Ensures your requests are tied to your Bill Hicks account.

Follow these steps to set up the Bill Hicks - Get Fulfillment Request Acknowledgements integration:
  • 1 Establish Connection: Select Bill Hicks, click Save and Proceed (no additional connection info needed).
  • 2 Configure Settings: Set Fetch Acknowledgment for Days and Customer ID, then save.
  • 3 Define Mapping Template: Map Bill Hicks fields to Flxpoint acknowledgment fields (see the "Mapping Template" section below).
  • 4 Run the Integration: Run manually or schedule for automation.

The setup interface for “Bill Hicks - Get Fulfillment Request Acknowledgements” includes:
  • Integration Title: Shows “Bill Hicks - Get Fulfillment Request Acknowledgements”.
  • Settings Options: Fields for Fetch Acknowledgment for Days and Customer ID.
  • Action Buttons: Save and Proceed.
Next Steps
After connecting, define your mapping template below!

Map Bill Hicks acknowledgment data to Flxpoint fields here!
Mapping Fields
Key fields to map with examples:
Field Maps To Example Purpose Status
PO Number (T) Flxpoint Fulfillment Request Acknowledgement: Fulfillment Request Number FR54321 Links to the original fulfillment request Required
PO Ack Date (D) Flxpoint Fulfillment Request Acknowledgement: Acknowledged At 2025-06-14T14:00:00Z Records the acknowledgment date Required
Quantity Committed (N) Flxpoint Fulfillment Request Acknowledgement Item: Quantity 2 Confirms the committed quantity Required
Product ID (T) Flxpoint Fulfillment Request Acknowledgement Item: SKU BH12345 Identifies the acknowledged product Required
Available Source Fields
Bill Hicks provides these fields from the acknowledgment text file:
  • Acknowledgement: PO Number (T), PO Ack Date (D), Quantity Committed (N), Product ID (T), etc.
Let’s Break It Down: Mapping "PONumber": "FR54321" ensures the acknowledgment links to the right request!
Mapping Options
Customize with these options:
  • Field: Link a Bill Hicks field to a Flxpoint acknowledgment field.
  • Value: Set a fixed value (e.g., Note = "Acknowledged").
  • Mapping Set: Combine fields for complex mappings.
  • Rules: Apply custom logic (see below).
  • Don’t Map: Skip the field.
  • Set to Empty: Clear the field.
Try This: Set a fixed Note value like "Confirmed" for acknowledged requests!
Summary
You’ve mapped key fields like PO Number and Quantity Committed. Next, add custom rules if needed!

Mapping Rules tweak your acknowledgment data.
Creating a New Rule
Want to create your own rule? Use the Mapping Dashboard to set up:
  • Rule Name: E.g., "Update Acknowledgment Status".
  • Rule Type: Conditional or Tier.
  • Input Type: String, Date, etc.
Try This: Add a rule to set Note to "Pending" if Quantity Committed is 0!

As of 05:34 PM -04 on Sunday, June 15, 2025, this integration is ready to retrieve fulfillment request acknowledgments from Bill Hicks!
Pro Tip: Set Fetch Acknowledgment for Days to match your business needs for timely updates!

Conclusion
With the Bill Hicks - Get Fulfillment Request Acknowledgements integration, you can keep your order statuses up-to-date effortlessly. Enjoy the automation!
 
 

Related Articles

Shipping Easy

ShippingEasy as a source supports sending fulfillment requests/fulfillment orders...