FFLBoss is the Hyatt Guns-built electronic bound book. The customer-facing knowledge base is at fflsoftwarepro.freshdesk.com but may require login. The most reliable public step-by-step is FastBound's competitor walk-through at fastbound.com/faq/ffl-boss-login-download-open-items/ - the procedure below follows that documented path.
What Orchid Does With This File
Orchid eBound imports your open firearms and links each one to a UPC and POS inventory record. Historical records stay archived in FFLBoss (or via the FFLBoss Dropbox integration if you use it).
Before You Start
- If you have multiple bound books in FFLBoss (e.g., a separate gunsmith, NFA, or consignment book), each needs its own export.
- If you have more than 1,000 open items, you'll need to download the file once per UI page (FFLBoss has a 1,000-row UI cap). Plan accordingly.
- If you've enabled FFLBoss's Dropbox integration, a current daily export of your entire bound book is already in your Dropbox - that's an easier path. See the Dropbox option in step 7 below.
Step-by-Step Instructions
- Sign in to FFLBoss at app.fflboss.com.
- On the dashboard, click the Bound Books button (top-level menu item).
- From the Bound Books dropdown, select the specific book you want to export (start with your main A&D book; repeat for any gunsmith/NFA/consignment books).
- In the Status dropdown, choose 'Open Entries Only.'
- Scroll to the bottom of the list and change the page-size dropdown from '20 rows' to '1,000 rows.'
- Scroll back to the top. Click the menu icon (three-line / hamburger style). CRITICAL: make sure all 3 checkboxes are UNCHECKED - if any are checked, the export will include extra non-ATF columns that break Orchid's import.
- Click the Download button. The file is saved to your browser's downloads folder as a .csv.
- If you have more than 1,000 open items: paginate through the list and download each page, then send all the CSVs to Orchid (we'll concatenate and de-dupe).
- ALTERNATE: if you have the FFLBoss Dropbox integration enabled, navigate to your linked Dropbox folder and grab the daily CSV that FFLBoss replicates there. This sidesteps the pagination and gives you a single complete file.
Expected File Format
CSV (the default and only documented format from the Bound Books export)
Expected Columns
- Manufacturer
- Model
- Serial Number
- Type
- Caliber
- Acquisition Date
- Acquired From (often a combined name/address field)
- Disposition Date (blank for open items)
- Other ATF fields per the Bound Book CSV schema
Watch Out For
- 1,000-row pagination cap - if you have a large bound book, you'll be doing multiple downloads. Send all of them to Orchid.
- Non-licensee addresses are NOT included in FFLBoss's export (a known gap). If you've acquired firearms from non-licensees (private sales, estates), the address won't be in the CSV. You'll need to add those manually in a follow-up step.
- Acquired-from contact fields may be combined into a single name+address blob (rather than separate FirstName/LastName/Address). Orchid splits these on import.
- FFL numbers in your export may be stored as 'first-3-last-5' (8-character partial format) rather than the full 15-character FFL. Orchid reconstructs the full FFL during import.
- Per-bound-book export - if you keep multiple bound books (gunsmith, NFA, consignment), each one is a separate export run.
- Do NOT open the CSV in Excel and save it. Excel will mangle serial numbers, leading zeros, and dates.
This file may contain sensitive information (customer addresses, pricing, costs). Send it to Orchid using the secure upload link your consultant provided. Do not email exports as unencrypted attachments.
Questions about this export? Reach out to your Orchid implementation consultant, or email implementations@joinorchid.com with the subject line "[Migration] [Your Store Name] - [Legacy System] [File Type] export."