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
Orchid maps your inventory to our normalized Master Catalog and carries your pricing, cost, and quantity into Orchid POS. We translate Celerant's Style/SKU hierarchy into Orchid's UPC-keyed structure.
Before You Start
- Confirm which Celerant product you're on (Command Retail, Cumulus Retail, or Stratus Enterprise) - the menu chrome differs slightly. Your Celerant subscription invoice or your Celerant rep can confirm.
- On Stratus, you have access to the Stratus Analytics data-warehouse layer; for very large catalogs (100K+ SKUs) that's actually a better export source than the operational Reports.
- Allow 15-30 minutes for the export run; very large catalogs may take longer.
Step-by-Step Instructions
- Sign in to Celerant (Command, Cumulus, or Stratus).
- Open the Reports menu.
- For a full SKU dump, choose Inventory Summary (or Inventory On-Hand by Department).
- If you need every field including custom attributes, use the Custom Report Designer (Cumulus and Stratus only) to build a report against the item master with all columns selected.
- Run the report.
- In the upper-right of the report viewer, click the Export dropdown.
- Choose Excel (preferred for protecting UPC formatting) or CSV. On Command Retail you may also see an ASCII option - do not use that.
- Save the file to a folder you can find later.
Expected File Format
Excel (.xlsx) - preferred. CSV is also offered. Do NOT use ASCII on Command Retail.
Expected Columns
- Department
- SKU / Style
- Description
- Vendor
- UPC
- On-Hand
- On-Hand at Retail
- On-Hand at Cost
- Units Sold
- Retail Sold
- COGS
- (and any custom attributes you've added)
Watch Out For
- On older Command Retail builds, 'Export to Excel' actually outputs CSV with a .xls extension. Confirm by opening the file in a text editor before assuming it's a true Excel file.
- Celerant has its own data-conversion services group that markets to customers leaving the platform. They may charge a fee or slow-walk the request. Pull your own data via the report exports first - then engage them only if needed.
- Celerant uses a Style/SKU hierarchy. A 'Style' can have multiple SKUs (size/color variants). Orchid's import handles this, but expect more rows in the export than you have 'products' in your head.
- Stratus Enterprise has a sub-second query data warehouse - if you're on Stratus and have a very large catalog, ask your Celerant rep to point you at the Stratus Analytics dashboards as an alternative export source.
- For bound book / A&D data (Stratus only): FastBound documents the export as Inventory Management > Acquisitions/Dispositions > Acq/Disp tab > Records to Display = "Current Only", Disposed = "No", Records Type = "Inventory Only" > Action > Print List > Export > EXCEL.
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."