If you have customers and customer lists in Comic Suite, migrating to Manage Comics doesn't take a ton of effort, you just need to export the files so that we can massage them a little bit and make them work for Manage Comics.
Step 1: Export Customers from Comic Suite
- Go to Store Manager
- Customers > Export to Excel
- Save the file to your desktop (or another location that you can easily find it later)
Step 2: Export your subscription lists
- Go to Retail Management Hero
- In the top navigation navigate to :
- Reports > Subscriptions > Master Subscription Summary > By Customer
- Go up to File > Save As, and save as a CSV file
- Save the file to your desktop (or another location that you can easily find later).
Your next step is going to be to normalize the data on the Customer Export file.
Below is an image of where you will find your Subscription List in Comic Suite.
Normalizing your Data:
Get started by looking at the Manage Comics example import file : https://docs.google.com/spreadsheets/d/1oYpOtMt6S_zZSNIVlkuIcMpRro7-4PU2q9NLQSxQGHU/copy
This link will open up our file and let you make a copy of our version.
In this you'll find 5 Sheets.
CSSubs - this is your ComicSuite subscriptions file.
CSCustomer - this is your ComicSuite customers list
TempSubs - this is going to be a joined table between CSSubs and CSCustomer, we'll use this to generate email addresses for all customers.
ShopifyCustomersGENERATED - this is your generated Shopify Customers table, you get this by mapping all of your CSSubs customers to this mapping.
MC2ImportGENERATED - this is your generated Manage Comics 2 Subscriptions file, this will be created by mapping the TempSubs to the MC2 format.
Step 1: Copy your Comic Suite Subscriptions Export file into the CSSubs sheet.
Step 2: Copy your Comic Suite Customers Export file into the CSCustomer sheet.
Step 3: Fix your customer data. Your customer data needs to be clean to be imported into Shopify, you need to format all of the phone numbers into 10 digit phone numbers (area code + 7 digits). Addresses need to use proper 2 digit state and country codes (Canada is CA, USA is US) - 2 digit country codes.
Step 4: Ensure all customers have an email address. If you have subscription customers without an email address, you should create a fake one for them. We recommend firstname+lastname@yourwebsite.com as a good start.
Once your data is normalized, you can move on to Step 2: Vlookups and other wizardry.
Step 2: Vlookups and other Wizardry.