How to Export Customers and Lists from Comic Suite

Migrating from ComicSuite to Manage Comics is easier than it sounds. With a few simple exports and a bit of cleanup, you’ll be ready to import your data into Manage Comics.

Export Your Data from ComicSuite

To begin the process, you'll need two key files from ComicSuite: your customer list and your subscription list.

The best way to get your Customer data out of Comic Suite is with a simple SQL dump, but the second best is RMH's customer export.

Step 1 (option a): 📁 Export Your Customers (basic version)

1. Open Store Manager in RMH.

2. Navigate to Customers > Export to Excel.

3. Save the file to your desktop or another easily accessible location.

Step 1 (option b): 📁 Export Your Customers (advanced version)

1. Open SQL Explorer

2. Run the following Query (replacing **DATABASENAME** with the name of your database).

 IMPORTANT: Do not change any of the fields, don't change orders, don't add fields, don't take away fields.

/****** Script for EXPORTING ALL CUSTOMERS RM  ******/SELECT  [AccountNumber],  [FirstName],  [LastName],  [EmailAddress],  [PhoneNumber],  [Address],  [Address2],  [Country],  [City],  [Zip],  [AccountBalance],  [CreditLimit],  [totalsales],  [totalvisits],  [CurrentDiscount],  [pricelevel],  [taxexempt],  [notes],  [vouchers],  [limitpurchase],  [layawaycustomer]FROM [DATABASENAME].[dbo].[Customer];

3. Save as a CSV (with headers if possible). 

4. Proceed to Exporting your Subscription List

Step 2: 📦 Export Your Subscription List

1. Open Comic Suite.

2. From the top navigation menu, go to:
   Reports > Subscriptions > Master Subscription Summary > By Customer

3. Click File > Save As and choose CSV format.

4. Save this file to your desktop or another easy-to-find location.

🖼️ Below is an image of where to find the Subscription List in ComicSuite.

Congratulations! You are done the Export steps.

The next step is to reach out to help@managecomics with your files and we will take it from there.