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 vendor import. Note that Cervelle splits 'Manufacturer' and 'Distributor' as two separate entity types - Orchid consolidates these into our vendor master.
Before You Start
- Cervelle distinguishes Manufacturers and Distributors as separate entity types in their data model. You'll likely need to export BOTH lists.
- Cervelle's inbound data conversion accepts CSV files for customer, inventory, distributor and FFL data - which implies both Manufacturer and Distributor tables are exportable.
Step-by-Step Instructions
- Open Merchant Magic.
- Locate the Distributor list export (Reports menu or Tools menu - the exact path varies by version).
- Run the export and choose CSV.
- Repeat for the Manufacturer list.
- Repeat for the FFL list if applicable (Cervelle stores FFLs as a discrete table).
- If you can't find any of these export options, call Cervelle support.
Expected File Format
CSV
Expected Columns
- TODO: confirm. Expected: Distributor/Manufacturer ID, Name, Contact, Phone, Email, Address, FFL Number (in the FFL table), Terms, Account Number.
Watch Out For
- TODO/CONFIRM: exact menu paths with Cervelle support.
- Cervelle's split of Manufacturer/Distributor/FFL into three tables is unusual - other POS systems use one 'Vendor' table. Orchid's import consolidates them, but be ready to send all three files.
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."