This guide explains how to migrate your blog from non-WordPress platforms (such as Color Me Shop or custom CMS) to Shopify using a CSV file. You can follow the exact same steps to import collections and product data.
If your data is exported in formats other than CSV, such as JSON or XML, you can use online converters to transform it into a CSV format before importing.
Prerequisites
- CSV data exported from your original platform (if applicable)
- A Google account (for using Google Sheets)
- The Blog Importer Shopify App
Open the CSV Template
For the best results, start with the official Blog Importer CSV template. This template already includes the required column headers necessary for a successful Shopify import.
Article Template
Do not change the column headers (the first row) of the template. Altering these headers will cause import errors.
Import Your Data into Google Sheets
If you can export your original data as a CSV, load it into Google Sheets:
- Open Google Sheets.
- Go to File > Import.
- Select and import your CSV file.
Format Data to Match the Template
Next, map your original data (such as titles and content) by copying it into the corresponding columns of the template.
Field Definitions
title
The title of the article. Example: Spring New Arrivals Summary
handle
The URL slug for the article. Alphanumeric characters and hyphens are recommended. Duplicates will affect whether the system skips or overwrites the data. Example: spring-new-items
body_html
The main content of the article (in HTML format).
author
The author’s name. You can leave this blank if not needed.
published
The publication status. Use TRUE for published and FALSE for draft (hidden). Example: TRUE
published_at
The publication date and time. Must be in ISO 8601 format. 2025-09-24T11:02:14Z
tags
Article tags. Separate multiple tags with commas. Example: news, spring, campaign
image
The image URL for the article’s thumbnail. Example: https://…/cover.jpg
template_suffix
Specifies the Liquid template suffix.
Using custom metafields is an advanced feature, as data types must match strictly. Ensure you have created the required custom metafields in Shopify beforehand. To prevent data inconsistency, we highly recommend running a test import with about 5 records first.
Export as CSV
Once your data is properly formatted, export it as a CSV file:
- Go to File > Download > Comma Separated Values (.csv).
- Save the downloaded CSV file to your computer.
Upload via Blog Importer
Open the Blog Importer app, drag and drop your CSV file, and start the import process.
