What Orchid Does With This File
Orchid POS imports your non-firearm consignments (optics, accessories, knives, gear) using the same dual-accounting treatment as firearm consignments - on your premises but not on your balance sheet. The structure is similar but Serial Numbers and A&D reconciliation aren't required.
Required File Format
Excel (.xlsx) - one row per consigned item
Required Fields
- Consignor Name (must match Customer List)
- Consignor ID
- Consignor Phone / Email
- Consignor Address
- Item Description
- Manufacturer
- Model
- UPC (if known)
- Manufacturer Part Number (MPN)
- Category / Taxonomy
- Consignment Date
- Agreed Sale Price
- Consignor's Net
- Store Commission % or flat fee
- Listing Status
- Notes
Reconciliation Rules
- Consignor ID MUST match your Customer List export.
- Agreed Sale Price = Consignor's Net + Store Commission.
- UPC, if present, should match your Inventory export's product taxonomy (so the consignment is shelved under the right category in Orchid POS).
Before You Start
- Same as firearm consignments: signed contracts on file, cutoff coordination, accurate state at cutover.
- If you commingle consignment and owned-inventory in the same SKU (e.g., two of the same scope, one owned and one on consignment), call this out - Orchid handles it but needs to know the split.
How to Export from Your Current System
QuickBooks POS
Same caveat as firearms - QBPOS lacks a native consignment module. Track via custom fields or a separate department.
Connected Data Systems (CDS)
Reports > Consignments (non-firearm). Confirm with CDS support.
Celerant
Reports > Consignments. Same module as firearm consignments, filter to non-firearm.
Coreware / coreSTORE
Same Consignments view, filter to non-firearm items.
Trident 1 POS
Reports area > Consignments. Confirm with Trident 1 support.
Bravo
Reports > Consignments. Filter to non-firearm.
Cervelle / Merchant Magic
Same consignment module as firearms.
Watch Out For
- Non-firearm consignments don't need to reconcile to the A&D bound book (no Serial Number requirement).
- Used / pre-owned items often lack UPCs - the description and MPN do the work of identification.
- If a single consignor brought in both firearms and non-firearms (mixed lot), export them in both files but keep the Consignor ID consistent.
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."