Exporting Open Inventory from Gun Store Master

Orchid eBound imports your open firearms and links them to UPCs and POS inventory. Historical records stay archived in GSM.

Published May 25, 2026 Updated Jun 04, 2026 2 views
Gun Store Master
Note: Some menu paths may vary by version. Your Orchid consultant can confirm the exact steps for your configuration.

Gun Store Master (sometimes one word, 'Gun StoreMaster' or 'GSM') is an older electronic bound book system. Public KB is minimal - most documentation sits behind customer login. The most reliable public step-by-step is FastBound's competitor walk-through at fastbound.com/faq/gun-storemaster-login-download-open-items/.

What Orchid Does With This File

Orchid eBound imports your open firearms and links them to UPCs and POS inventory. Historical records stay archived in GSM.

Before You Start

  • Confirm which GSM tier you're on (BASIC, STANDARD, or PRO). Feature gating may affect what's exportable. BASIC is bound-book-only with the fewest options.
  • If you have multi-store, you'll run this export once per store account.
  • If you've been running GSM's InStore feature (local PC sync), you may already have a local copy of your data. Ask about it.

Step-by-Step Instructions

  1. Sign in to Gun StoreMaster at gunstoremaster.net/Main/Login.
  2. On the top menu, click Manage.
  3. Hover over the Bound Book tile - the tooltip will read 'View/Print/Export.' Click the tile.
  4. On the Manage Bound Book page, on the right side under the Export heading, click the General Data button.
  5. On the Export General Data page, configure these settings: Record State dropdown = 'Open (Acquired)'; check the boxes for Acquisition Information, Contact Information, Record Notes, AND Record Annotations.
  6. Click Create.
  7. A download link appears below the Create button. Click the Excel logo/text to save the file.
  8. The file downloads as an .xlsx (Excel) workbook to your browser's downloads folder.

Expected File Format

Excel (.xlsx) - GSM's default. PDF is also available for visual archive (use the Print/Save option from the same screen).

Expected Columns

  • Manufacturer (or PMF / Private Maker for self-manufactured)
  • Importer (if any)
  • Country of Manufacture (when applicable)
  • Model
  • Serial Number
  • Type
  • Caliber / Gauge
  • Acquisition Date
  • Name and Address (or Name and FFL Number) of source
  • Annotations
  • Notes

Watch Out For

  • Output is .xlsx by default, not CSV. If you need CSV for any downstream use, save-as carefully and protect serial-number columns first (set them to Text type).
  • All four checkboxes (Acquisition Information, Contact Information, Record Notes, Record Annotations) must be CHECKED - if any are unchecked, the relevant fields are missing from the export. Always check all four.
  • Acquired-from contacts may be in a combined field rather than structured columns. Orchid splits these on import.
  • Pawn/consignment/repair sub-books are tracked in the same eSAFE Bound Book but tagged by transaction type. Verify your 'Open (Acquired)' export captures pawn-held and consignment items - those are technically still open A&D dispositions and you're legally responsible for them.
  • Do NOT open the file and re-save as CSV unless you're sure about Excel's mangling behavior on serial numbers.
API Alternative: GSM does not publish a public REST API. The UI export is the only documented path. If you need a database-level extract for a very large or complex book, contact GSM support and ask.
UPC Warning: Critical: do not let Excel destroy your UPCs. If your exported file is a CSV, do NOT open it in Excel and save it. Excel will silently strip leading zeros from 12- or 13-digit UPCs (turning 012345678901 into 12345678901) and may convert long numbers to scientific notation (1.23457E+11). If you must inspect the file, open it in a plain text editor like Notepad or VS Code, or open the CSV in Excel using Data > From Text/CSV and set the UPC column type to Text before importing. The cleanest path is to export directly to .xlsx where the column types are preserved.

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

Was this article helpful?

Thanks for your feedback!

More in Gun Store Master