Note: This system does not publish a public help center. The steps below are based on typical patterns for similar systems. Your Orchid implementation consultant will confirm the exact menu paths for your version.
Cervelle is a small firearms-industry POS, distributed under the product name 'Merchant Magic.' Windows desktop application running on a local SQL database. Support is high-touch / phone-based; no public knowledge base or user manual is published.
What Orchid Does With This File
Standard catalog mapping to Orchid's Master Catalog.
Before You Start
- Cervelle does not publish a public help center, so the menu path below is based on the typical pattern for Windows desktop POS systems. Your Orchid consultant or Cervelle support will confirm the exact path for your version.
- Cervelle markets that they ARE good at importing FROM QuickBooks POS (their 'specialty') - but their outbound export tooling is less documented. Expect to lean on Cervelle support to extract.
- As a fallback, ask Cervelle for a copy of your local database file (often a Microsoft Access .mdb file or a SQL Server backup .bak file). This is your insurance policy if the in-app export is incomplete.
Step-by-Step Instructions
- Open Merchant Magic on your store's PC.
- Look for an Export option in the Reports menu or the File menu (the exact location varies by Cervelle version).
- Locate the Inventory or Product Master export option.
- Run the export.
- Choose CSV (the documented Cervelle output format).
- Save the file.
- If you can't find the export option in the UI, call Cervelle support and request a CSV export of your product master. They confirm they support manual CSV export of product descriptions.
Expected File Format
CSV (Cervelle's documented output format)
Expected Columns
- TODO: confirm. Expected: SKU/Item ID, Description, Department, Manufacturer (distinct from Distributor in Cervelle), Distributor, UPC, Cost, Retail, Quantity on Hand, Serial Number (where applicable).
Watch Out For
- TODO/CONFIRM: exact menu path. Cervelle does not publish a public KB.
- Cervelle distinguishes Manufacturers and Distributors as separate entity types - this means you may need to export both lists (see the Vendors guide).
- ATF-compliant A&D bound book lives within Merchant Magic but is a separate export from the inventory file - see the separate Cervelle A&D guides.
- Windows desktop POS - ALWAYS ask Cervelle for a copy of your local database file (.mdb or .bak) as a fallback in case the in-app export is incomplete.
- For bound book / A&D data: FastBound documents the Cervelle/Merchant Magic export as Reports > ATF Reports > ATF Report > ATF Bound Book Dashboard > File > Export > "Export LIVE Bound Book - IN STORE ONLY to CSV Test File". When saving, you must manually add ".csv" to the filename.
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."