Importing and Exporting Accounts
Authenticated accounts in your Reflow store can be imported and exported using standard CSV files.
- Exporting is useful when you need to keep a backup account data, or when you need to import user info into third-party software such as newsletter or CRM systems.
- Importing can be used for migrating to Reflow from another service or for moving your users between Reflow stores.
Exporting User Accounts
To export the authenticated user accounts of your store, go to the users page and click the export button. This will generate and download a CSV file with account data. The format of this file is documented below, and you can find an example here.
Export CSV Format
|User ID||A unique numeric identifier for this user (e.g. |
|A string indicating the user's email address.|
|Name||A string indicating the name of the user.|
|Photo URL||A url leading to the user's avatar photo, hosted on the Reflow servers.|
|Meta||A stringified JSON with meta data about the user.|
|Provider||The provider the user initially used to create their account.|
|Created||The date on which the user account was created. Uses fo format |
|Is Subscribed||Indicated whether or not the user has an active subscription. Valid values are |
The remaining columns (listed below) will be filled only if the value of this is
|Subscription Status||The status of the user's subscription.|
|Subscription Plan||The name of the user's subscription plan.|
|Subscription Price||The price per period for the user's subscription.|
|Subscription Period||The billing period of the subscription, either |
|Billing||A stringified JSON with all the billing information about the subscription.|
|Stripe Customer ID||The ID of the corresponding customer record in Stripe.|
Importing User Accounts
Importing into Reflow is done by visiting the users page and clicking the Import button.
Reflow expects a CSV file with the following columns (see an example here).
Import CSV Format
|Yes||A string indicating the user's email address.|
|Name||Optional||A string indicating the name of the user.|
|Meta||Optional||A stringified JSON with meta data about the user.|
If this column exists and the user row contains a valid JSON, the object will be imported as account meta data and will be available in the
The format is compatible with the one Reflow exports, but only the
Meta columns are taken into account, other columns are ignored. In practice this means that you can export a CSV from one Reflow store and import it in another.
The email addresses of your Reflow users need to be unique. Any imported records with an email address that already exists in your store will be ignored.