> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://bulkflow.crisp.help/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# 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
1. *What happens if I leave the ID field blank?*
BulkFlow will treat the row as a new blog post and create it accordingly.
2. *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.
3. *What format should I use for Body HTML?*
Use valid HTML code, including paragraphs, headings, and images if needed.