Yes, Get Inventory (Primary) is supported!

The "Get Inventory (Primary)" integration allows seamless access to Bill Hicks' product inventory, ensuring your business stays updated with accurate and current product data. Here's a simple breakdown of how this feature can help you:

Connect Your Integration

Getting started is straightforward:

• Select Bill Hicks as the integration type.
• No additional connection credentials are required, just choose the integration and you're ready to proceed.

Configure Your Settings

Fine-tune how inventory data is handled to suit your needs:

Archive/Un-Archive Inventory:

• Automatically archive products not found in the inventory feed, helping you keep your catalog clean.
• Items can be unarchived when they return to the feed, maintaining a consistent stock list.

Fetch Source Images from External Sources:

• Optionally download product images from an FTP source and upload them to your platform. This ensures your listings include high-quality product visuals.

Mapping Flexibility:

• Use predefined or customizable mapping templates to ensure product attributes, categories, and data flow seamlessly into your platform.

Define a Mapping Template

• Match fields from Bill Hicks’ inventory feed to your platform’s requirements using an easy-to-use mapping tool.
• Adjust categories, product data, and custom fields based on your preferences.

Automate the Process

• Enable scheduling to automatically refresh inventory updates at regular intervals.
• Notifications keep you informed about each run, so you’re always in the loop.

Technical Details Simplified

Connection Configuration: Hardcoded credentials are used to download the inventory feed files.

• Default Directory: /Flexpoint/Feeds
• Files Downloaded:
  • BHC_Catalog.csv: Contains complete product and pricing data.
  • BHC_Inventory.csv: Contains item-level inventory data.
• Active Vendor List: An additional file, Active Vendor List.xlsx, is downloaded from an S3 bucket (Check file here) to map the product’s manufacturer name. If a SKU's prefix does not map to a manufacturer, the manufacturer field will remain empty.

Product images can also be fetched via FTP and hosted on S3, streamlining image management for your listings.

Yes, Get Inventory (Secondary) is supported!

This integration facilitates fetching secondary inventory data from Bill Hicks to supplement your primary inventory feed. It allows you to retrieve item pricing and quantities, providing more flexibility in managing your inventory. Below is a breakdown of this functionality:

Connect Your Integration

• Choose Bill Hicks as the integration type.
• No additional connection details are required for this setup, simply click "Save and Proceed."

Configure Your Settings

Archive/Un-Archive Inventory:

• Enables automatic archiving of items not found in the feed.
• Automatically unarchives items when they reappear in the feed with updated quantities.
• Tip: This is helpful for maintaining an accurate catalog.

Allow Create Variant:

• Optionally enables the creation of variants when running the secondary inventory integration.
• Recommendation: Use only if you want to generate variants based on secondary inventory fields.

Define a Mapping Template

• Map fields from the Bill Hicks feed to your platform using a flexible and customizable mapping template. Example mappings include:
  • SKU → Inventory Variant Field
  • Cost → Generic Pricing
  • MSRP → List Price
  • Quantity → Available Stock
• Mapping ensures data flows accurately to your platform.

Automate the Process

• Automate the inventory update process by enabling scheduling.
• Receive notifications upon each successful inventory sync to stay updated.

Technical Details

• Files Processed:
  • BHC_Catalog.csv: Contains item pricing.
  • BHC_Inventory.csv: Provides item quantities.
• Default Directory: /Flexpoint/Feeds
• Data is retrieved from the Bill Hicks FTP and mapped to your platform.

Supported Features

• Generic Pricing: Cost and MSRP values are pulled for each item.
• Quantity: Fetches stock quantities.
• Delta Feed vs. Full Feed: Only pricing and quantities are fetched.
• Archive Support: Items not found in the feed are archived.

Not Supported Features

• Custom Fields (Variants Only): Not supported.
• Client Pricing: Not supported.
• Multiple Warehouses: Not supported.
• Weights & Dimensions: Not included in the feed.

Yes, Send Fulfillment Requests is supported!

The Send Fulfillment Requests integration allows you to submit orders to Bill Hicks seamlessly. This integration uses a file-based approach to transfer orders efficiently and accurately, ensuring all required details are captured.

Connect Your Integration

Simply select Bill Hicks as the integration type and provide your Customer ID during the setup. This ensures your orders are associated with the correct Bill Hicks account.

Configure Your Settings

Customize the following options to match your business requirements:

• Customer ID: This is required to identify your account with Bill Hicks.
• Hold for X Hours: Add a delay before the order is sent (e.g., hold for 2 hours).
• Send During Business Hours: Limit order submissions to occur only during business hours, ensuring smooth processing.
• Advanced settings are optional but can help streamline your order submission process.

Define a Mapping Template

Using the mapping template, map your platform’s fields to the Bill Hicks order format. This ensures all necessary details are included, such as:

1. Customer Details:
   • Customer ID
   • Address fields (Address 1, Address 2, City, State, ZIP)
2. Order Details:
   • SKUs
   • Descriptions
   • Quantities
   • Prices
3. Shipping Details:
   • Shipping methods
   • Fulfillment Request Number (FR#)
   • Notes
   • FFL# for items requiring a Federal Firearms License.

The mapping template ensures compatibility between your platform’s fields and Bill Hicks’ order requirements.

Automate the Process

Enable scheduling to automate order submission. You will receive notifications every time the process runs, keeping you updated on submission statuses.

Technical Details Simplified

Connection Configuration:

• Default Directory: /Flexpoint/To_BHC
• Orders are sent as .txt files via FTP configured in the settings.
• Each fulfillment request is marked as processed once the file is uploaded to the FTP.

Order File Contents:

• Includes customer information, shipping details, and order lines in a predefined format.
• If required, the FFL# (Federal Firearms License) is included in the same file for items that need it.

Example Order 

×

Operation Details

Yes, Get Shipments is supported!

Yes, Get Fulfillment Acknowledgments is supported!

The "Get Fulfillment Request Acknowledgments" integration provides an efficient way to retrieve and manage supplier responses for your submitted fulfillment requests, ensuring accurate tracking and updates for your orders.

Connect Your Integration:

• Choose the integration type (e.g., Bill Hicks) to start connecting.
• No additional connection information is required apart from entering the Customer ID.
   

Configure Your Settings:

• Fetch Acknowledgment for Days: Specify the number of days for which you want to fetch fulfillment request acknowledgments (default is 7 days).
• Customer ID: Enter the identifier required by the supplier for the integration.
• Save and proceed to finalize the configuration.

Define a Mapping Template:

• Map fields from the acknowledgment feed to your system using the customizable mapping utility.
• Key mappings include:
  • BHC Order Number → Confirmation Number
  • PO Number → Fulfillment Request Number
  • Quantity Committed → Quantity
  • Product ID → SKU
  • Additional fields, such as response messages, can be configured as needed.

Automate the Process:

• Enable job scheduling to automate fetching acknowledgments. Notifications will alert you whenever the process runs.
• All processes are scheduled based on UTC time.
  
   

Technical Details:

• Directory: /Flexpoint/From_BHC
• File Name: ACK.ffv.txt (updated with the latest acknowledgments).
• Process Flow:
  • Once a fulfillment request (FR) is posted on the FTP server, the system retrieves the acknowledgment file.
  • Matches FR#, SKU, and the quantity committed in the acknowledgment file to update and mark the fulfillment request as acknowledged.

Operation Details:

Limitations:

• Cancellations are not included in the acknowledgment feed.
• Ensure accurate field mapping for seamless integration.