Hicks Inc as a Source
Summary
Hicks Inc is a hunting, fishing, and outdoor sporting goods distributor available as a source in Flxpoint, connected using a Connection Name, Username/API Key, and Password provided by Hicks Inc. The integration runs Get Inventory (Secondary) for pricing and quantity refreshes, Send Fulfillment Requests (with automatic FFL handling for firearm items), and Get Shipments; Get Inventory (Primary) is not currently available. Hicks Inc is a separate integration from Bill Hicks & Co., so credentials are not interchangeable — for extended mapping guidance contact support@flxpoint.com.
Add a Hicks Inc source using the Source Wizard, then start configuring Get Inventory (Secondary), Send Fulfillment Requests, or Get Shipments. When Flxpoint prompts you for a connection, click + New Connection, enter your FTP Host, FTP Username, FTP Password, and FTP Port (all provided by Hicks Inc), then Test Connection → Save Connection. The same connection is reused across all Hicks Inc operations.
support@flxpoint.com.Hicks Inc and Bill Hicks & Co. are two separate integrations — do not confuse credentials
Hicks Inc uses an FTP connection (FTP Host, FTP Username, FTP Password, and FTP Port that you supply) and is a separate integration from Bill Hicks & Co. (which uses hardcoded FTP credentials for GIP/GIS plus a Customer ID for order operations). Credentials for one cannot be used with the other. Confirm which supplier you are working with before configuring your connection.
FTP credentials (Host, Username, Password, Port) come from Hicks Inc — not a website login
Your FTP Host, FTP Username, FTP Password, and FTP Port are FTP credentials provided directly by Hicks Inc. They are separate from any Hicks Inc dealer website or portal login. Contact your Hicks Inc account representative to obtain FTP credentials if you don't have them. Without valid credentials, Test Connection will fail.
GIP daily for full catalog; GIS more frequently for delta updates — Archive on one job only
Run Get Inventory Primary once daily to import the full Hicks Inc hunting and outdoor gear catalog. Use Get Inventory Secondary on a more frequent schedule for pricing and quantity refreshes. Enable Archive/Un-Archive on one job only — enabling it on both GIP and GIS simultaneously creates conflicting inventory states.
For operation-specific setup and mapping guidance, contact Flxpoint Support
Extended documentation — including required Send FR fields, Get Shipments configuration, and any Hicks Inc-specific API behavior — is available from Flxpoint Support. Email support@flxpoint.com with your account details and the operations you need to configure.
| Field | Maps To — Notes |
|---|---|
| itemNumber (full.csv) | → Product / Variant → SKU. Required. Primary identifier joining the catalog, pricing/quantity, and MAP price feeds. |
| shortDescription / longDescription | → Product → Title / Description. |
| category | → Product → Category. |
| manufacturerNumber | → Product → Manufacturer / MPN. |
| upc | → Identifiers → UPC. |
| price (qtyprc.csv, joined by item number) | → Pricing → Cost. |
| msrp | → Pricing → MSRP. |
| mapPrice (MAP price feed, joined by item number) | → Pricing → MAP. Minimum advertised price. |
| quantityOnHand (qtyprc.csv) | → Inventory → Quantity. |
| weight / length / width / depth | → Shipping → Package dimensions. |
| status | → Product → Active / Archived state. Drives Archive/Un-Archive handling — enable Archive on only one Get Inventory job (see Important notes). |
| linkToImage | → Product & Variant → Images. HTTP image links are upgraded to HTTPS automatically before import. |
| firearmCode = "Y" | → Variant → Custom Field: is_firearm. Flags the variant so Send Fulfillment Requests can apply FFL (firearm license) handling automatically. |
| Source Field | Maps To (Hicks Inc) — Notes |
|---|---|
| Fulfillment Request / PO Number | → PurchaseOrder. Required. Tracks the order at Hicks Inc. |
| Ship-To Name | → ShipToName. |
| Shipping Address Line 1 | → ShipToAddress1. Required. |
| Shipping Address Line 2 | → ShipToAddress2. Optional. |
| City | → ShipToCity. Required. |
| State | → ShipToState. Required. |
| Postal Code | → ShipToZipCode. Required. |
| Item SKU | → HicksItemNumber. Required. |
| Item Quantity | → Quantity. Required. |
| Item Price | → Price. |
| FFL Number (from your FFL license info) | → FFLNumber. Auto-populated for firearm orders — not set via the mapping template. Required for firearm items; missing or oversized (20+ character) FFL numbers block the order. |
| FFL Address Type | → FFLAddressType. Automatically set to F for firearm orders — not a mapped field. |
| Dealer/Consumer Name (from FFL info) | → ConsumerName. Auto-populated for firearm orders; required, max 40 characters. |
| Dealer/Consumer Phone (from FFL info) | → ConsumerPhone. Auto-populated for firearm orders; required. |
| Shipping Method | Not currently populated by the mapping template — sent blank on every order. |
| Field | Maps To — Notes |
|---|---|
| Ship Date | → Shipment → Shipped At. Parsed as yyyy-MM-dd. |
| Tracking Number | → Shipment → Tracking Number. Required. Duplicate tracking rows for the same order are de-duplicated, keeping the heaviest package. |
| Carrier | → Shipment → Ship Method / Carrier. |
| Item SKU / Quantity | → Shipment Item → SKU / Quantity. Required. Taken from your original Fulfillment Request line items rather than the Hicks Inc tracking file — quantity is split evenly across however many tracking numbers are returned for that order. |
| PO Number | → Lookup key. Matches tracking file rows to your Fulfillment Request — not itself a mapped field. |
| Download Last X Days (setting) | Controls how many days back Flxpoint looks for new tracking/error files on the Hicks Inc feed — configured in the operation's integration settings, not the mapping template. |