How to fill in the Blog Posts Template
1. Overview
The Blog Posts Template is a spreadsheet that allows you to import or update blog posts on your Shopify store via BulkFlow. This template supports fields like blog title, author, content, handle, visibility, and more — all in bulk format to save you time and effort.
2. Requirements
Make sure you have:
- Downloaded the correct Blog Posts Template from BulkFlow
- Blog content prepared in Excel or CSV format
- Your Shopify store connected to BulkFlow
3. How to Fill the Blog Posts Template
Step 1: Download the Blog Posts Template
From the BulkFlow Dashboard, click on Download Template. A dropdown menu will appear — choose the option labeled Blog Posts Template.
Step 2: Fill in the Required Fields
You must include:
- Title and Handle for the post.
- Body HTML, if you're creating a new post.
- Blog: Handle or Blog: Title, to specify which blog (category) this post belongs to.
- ID, only if you're updating an existing post.
NOTE: If you're creating new blog posts, leave the ID field blank. If you're updating existing posts, include their Shopify ID.
Basic Blog Info (Available Columns)
Column | Description | Value Format & Example |
|---|---|---|
ID | Shopify ID of the blog post (used only for updates) | Numeric (e.g., 123456789) |
Title | Blog post title (required) | Text (e.g., How to Choose the Right Product) |
Handle | URL slug for the post (must be unique) | Alphanumeric with hyphens (e.g., choose-right-product) |
Author | Blog post author name | Text (e.g., John Doe) |
Body HTML | Full content of the blog post in HTML format | HTML/Text (e.g., <h1>Welcome</h1>) |
Summary HTML | Short summary of the post in HTML format | HTML/Text (e.g., <p>Quick tips...</p>) |
Tags | Tags for categorization | Comma-separated text (e.g., tips, marketing, trends) |
Published | Whether the blog post is published | TRUE / FALSE (e.g., TRUE) |
Published At | Date and time to publish the post | ISO 8601 format (e.g., 2018-05-13T08:30:00-04:00) |
Template Suffix | Custom Shopify template for this post | Text (e.g., custom-post) |
Image Src | URL of the featured image for this post | Publicly accessible image URL |
Image Alt Text | Alternative text for the featured image | Text (e.g., honey) |
Blog: Handle | The handle (slug) of the Blog (category) this post belongs to. | Eg: first-blog |
Blog: Title | The display name of the Blog (category) this post belongs to. Can be used to create a new Blog if it doesn't already exist. | Eg: First Blog |
Blog: Commentable | Whether comments are allowed on this Blog. | yes / no |
Blog: Feedburner URL | Feedburner RSS feed URL for this Blog, if applicable. | URL |
Blog: Feedburner Path | Feedburner path setting for this Blog. | Text |
Blog: Template Suffix | Custom Shopify template for this Blog. | Text |
NOTE: BulkFlow also supports importing blog post comments using the Comment: columns (Author, Body, Body HTML, Email, Status, Published At). A detailed guide for this will be added soon — feel free to contact support if you need help with importing comments in the meantime.
Step 3: Save the File in the Correct Format
- File Upload: Save your file as XLSX or CSV (UTF-8) and upload it manually.
- Google Sheet: Use a shared Google Sheet link.
- File URL: Use a direct URL to connect your file.
- Google Drive: Use a shared Google Drive link.
- FTP/SFTP: You can also upload via FTP or SFTP.
- Dropbox: Use a shared Dropbox link.
- One Drive: Use a shared One Drive link.
Step 4: Run a Demo, Then Process Your Blog Posts Feed
- Click Demo Import to run the feed on a small sample of your data and preview the result before committing to anything.
- Once you're satisfied with the preview, click Full Import to process the entire feed.
- You can check the result and download it to see which posts were successfully imported and which were not.
4. Frequently Asked Questions
- What happens if I leave the ID field blank?
BulkFlow will treat the row as a new blog post and create it accordingly.
- Can I use both Blog: Handle and Blog: Title?
Yes. If Blog: Handle is unknown, the Blog: Title will be used to link or create the blog.
- What format should I use for Body HTML?
Use valid HTML code, including paragraphs, headings, and images if needed.
Updated on: 14/08/2026
Thank you!