Exporting Customers from Celerant

Standard customer-list import - deduplication, format standardization, merge with bound-book addresses where appropriate.

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

Celerant ships three different products with overlapping names: Command Retail (legacy on-premise), Cumulus Retail (SMB cloud), and Stratus Enterprise (large-retailer cloud with data-warehouse layer). The general Reports > Export pattern is the same across all three, but menu labels and column names differ slightly. The steps below cover the common path. Public Learning Center is at celerant.com/learning-center; deeper KB sits behind a customer login.

What Orchid Does With This File

Standard customer-list import - deduplication, format standardization, merge with bound-book addresses where appropriate.

Before You Start

  • Decide whether to bring loyalty point balances into Orchid POS. If yes, Orchid will need a separate loyalty balance export (your consultant will walk you through it).

Step-by-Step Instructions

  1. Sign in to Celerant.
  2. Open the Reports menu and navigate to Customer reports.
  3. Choose Customer List (or use Custom Report Designer on Cumulus/Stratus to build an extract with all fields).
  4. Run the report.
  5. Click the Export dropdown and choose Excel.
  6. Save the file.

Expected File Format

Excel (.xlsx)

Expected Columns

  • Customer ID
  • First Name
  • Last Name
  • Address 1
  • Address 2
  • City
  • State
  • Zip
  • Phone
  • Email
  • Loyalty Tier
  • Loyalty Balance
  • Created Date
  • Notes

Watch Out For

  • Loyalty point balances are sometimes a separate Celerant export - if your store runs loyalty, ask your consultant about a separate loyalty extract.
  • Tax-exempt customer flags may not export as a standard column - check that they round-trip correctly after import.

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 Celerant