Import / Export Blogs Data
How to import and export blog posts in bulk with CSV and XLSX files.Migrato allows you to import and export Shopify blog data using CSV or XLSX files. You can select the required blog fields, export existing blogs and articles, prepare blog data for import, and use filters to export only the blogs or articles that match specific conditions.
You can use Blog import/export to create, update, manage, transfer, or migrate blog data in bulk instead of managing individual blog records manually through Shopify Admin.
Migrato supports blog-related information such as blog details, articles, authors, content, tags, publishing information, images, comments, and metafields, based on the available Blog template fields.
Migrato also supports importing blog data from a publicly accessible file URL, making it possible to work with files hosted on external systems.
We recommend reviewing the Blog Template Documentation and downloading the Blog Demo CSV/XLSX file, if available, to understand the supported fields and expected data structure.
Import Blogs
Migrato allows you to bulk import Shopify Blog data using CSV or XLSX files.
You can upload a prepared Blog file directly to Migrato or provide a publicly accessible URL to the file.
Step 1: Open Blog Import
From your Shopify Admin:
- Go to Apps → Migrato.
- Open the Import section.
- Select Blogs as the entity you want to import.
- Add the Blog file you want to import.
Step 2: Upload or Provide the Blog File
Migrato provides two ways to provide the Blog file.
Option 1: Upload a File
You can upload or drag and drop your Blog file into the upload area.
Migrato supports:
-
CSV
-
XLSX
Option 2: Import from a Public URL
Instead of uploading the file manually, you can provide the full publicly accessible URL of the Blog file.
For example:
https://example.com/blogs.csv
Enter the URL and select Upload from URL.
The file URL must be accessible to Migrato. Make sure the file can be accessed without authentication or a login requirement.
Step 3: Review the Import Details
After the file is uploaded or retrieved from the provided URL, Migrato creates an import job and displays the import details.
The import details can include:
-
Import ID
-
Import state
-
File format
-
Operation
-
Uploaded file
-
Import start information
Review the displayed information before continuing with the import.
Step 4: Review the Blog Sheet
Migrato identifies the Blog data contained in the uploaded file and displays it under the Sheets section.
Review the detected Blog sheet before selecting the import operation.
Step 5: Select an Import Operation
Migrato allows you to select the operation to perform on the Blog data.
Depending on the supported Blog operations, the available options may include:
-
Merge – Update existing records and create new records.
-
Create only – Create new records and skip records that already exist.
-
Update only – Update existing records and skip records that cannot be matched.
-
Replace – Replace matching existing records with the imported data.
-
Delete – Delete matching records if they exist.
The selected operation determines how Migrato handles existing and new Blog records.
Carefully select the operation before starting an import, particularly when using Replace or Delete.
Step 6: Configure Import Options
Open the Options section to configure additional settings available for the Blog import.
Depending on the Migrato Blog import configuration, this section may include options such as scheduling and result-file settings.
Step 7: Schedule the Blog Import
Migrato can schedule an import job when scheduling is enabled for the operation.
You can configure:
-
Schedule date
-
Schedule time
-
Repeat interval
-
Number of repetitions or run until cancelled
This is useful when Blog data needs to be imported repeatedly from an external source.
Step 8: Start the Blog Import
After reviewing the file and selecting the required operation:
- Review the import details.
- Confirm the selected operation.
- Review the available options.
- Click Import.
Migrato will begin processing the Blog import.
Step 9: Monitor the Import
Migrato processes the Blog import as a job and displays the current processing status.
You can use the job information to track the progress of the import.
Step 10: Review Import Results
After processing is completed, review the import results.
The result information can include:
-
Import status
-
Total records
-
Successfully processed records
-
Failed records
-
Skipped records
-
Processing duration
-
Error information
If any records fail, review the reported errors, correct the source file where required, and run the import again.
Export Blogs
Migrato also allows you to export Shopify Blog data into a downloadable CSV or XLSX file.
This can be useful for:
-
Blog content management
-
Content backup
-
Data analysis
-
Store migration
-
Content transfer
-
External system integration
-
Record keeping
Step 1: Open Blog Export
From your Shopify Admin:
- Go to Apps → Migrato.
- Open the Export section.
- Select Blogs.
Step 2: Select Blog Fields
Select the Blog fields and related information you want to include in the export.
Migrato provides multiple groups of Blog-related fields, including:
-
Basic Columns
-
Blogs
-
Comments
-
Metafields
Select only the fields required for your export to keep the resulting file focused and easier to manage.
Step 3: Apply Blog Filters
If you only need specific Blogs or Blog data, use the Filters section to narrow down the export.
Migrato provides the following Blog filter fields:
-
ID
-
Title
-
Handle
-
Tags
-
Blog Handle
-
Created At
-
Updated At
-
Published At
For complete information about available filters and conditions, see 11.3 Filter Blogs.
Step 4: Start the Export
After selecting the required fields and filters, start the export.
Migrato processes the selected Blog data and creates the export file.
Step 5: Review the Export Result
After the export is completed, Migrato displays the export result.
The result page can display information such as:
-
Export status
-
Exported file name
-
File format
-
Number of records exported
-
Processing duration
-
Selected Blog fields
-
Applied filters
You can download the generated export file from the completed export screen.
Supported Blog Data
Migrato's Blog import/export functionality supports the following Blog-related field groups.
| Group | Number of Columns | Description |
|---|---|---|
| Basic Columns | 16 | Core Blog article information, including title, content, author, tags, publishing information, and images. |
| Blogs | 9 | Information about the Shopify Blog associated with the article. |
| Comments | 13 | Supported information related to comments associated with Blog articles. |
| Metafields | 1 | Supported Blog metafield information. |
| Total | 39 | Total available columns across the Blog template groups. |
The exact fields available for import and export depend on the current Migrato Blog Template. Refer to 11.2 Template Documentation for the complete field reference.