Fixing meta data errors one by one is incredibly time-consuming. The Bulk Edit via CSV feature allows you to update multiple pages at once, saving hours of manual work. Follow these 3 easy steps to optimize your store's SEO efficiently.

Tips: Identify SEO Errors in Your Store

Before you can fix errors in bulk, you need to identify what needs fixing. Here is a tip for you.

1. Navigate to SEO Audit in the app's left menu
2. Click the Rescan button to fetch the most current errors from your store
3. Click Export to download the .xlsx file containing all detected errors

This Excel file will serve as your reference for what needs to be corrected.

Step 1: Access the Bulk Edit via CSV Feature

You can access this feature through two different paths:

Option 1: Through SEO Booster

1. Go to SEO Booster in the left menu
2. Select Configure Meta title/description optimization
3. Click Manual optimize
4. Click the Bulk edit via CSV button in the top right corner

Option 2: Through Content Optimization

1. Go to Content Optimization in the left menu
2. Click the Bulk edit via CSV button in the top right corner
   

Step 2: Prepare Your CSV File

This is where you'll do the actual work of fixing your meta data errors.

2.1 Choose Your Page Type

Create separate CSV files for each type of page you're optimizing:

• Products

• Articles (Blog pages)

• Landing pages

• Collections

Pro tip: Open both the Excel errors file and your CSV file in split-screen mode for quick reference and editing.

Once you're in the feature, click Download sample CSV to get the template file you'll use for editing. The sample CSV templates are now on Google sheet, but the process of filling all fields in the CSV file is unchanged. 

2.2 Understanding CSV Columns

Each column in the CSV file corresponds to a specific element of your page's SEO. Here's what you need to know:

Column A: Handle (Required)

1. The URL handle is the last part of your page's URL. 
   

Important: The CSV only accepts handles, not full URLs

1. When copying from the Excel errors file, remove the domain and keep the handle only 
2. Sample product page: 
1. Full URL: https://devmax3.myshopify.com › products › the-multi-location-snowboard
   
2. Handle: the-multi-location-snowboard
3. Sample article (blog) page - MUST include the blog category
1. Full URL: https://devmax3.myshopify.com/blogs/news/10-coding-shortcuts-to-instantly-double-your-development-speed
2. Handle: news/10-coding-shortcuts-to-instantly-double-your-development-speed
4. Sample collection page: 
1. Full URL: https://devmax3.myshopify.com/collections/snowboard-collection
2. Handle: snowboard-collection
5. Sample landing page: 
1. Full URL: https://www.tapita.io/pages/seo-solutions
2. Handle: seo-solutions

Column B: Language

1. You can edit SEO Title and SEO Description for multiple language versions in one file
   

Column C: Title (H1)

1. This serves as your product/collection/page title
2. Common errors: Confuse readers about the purpose of the page if missing.
   

NOTE: Fixing Title in Bulk edit in CSV will overwrite the existing value in Shopify admin config.

Column D: Description

1. The main description content for your product/collection/page
2. Common errors: Missing description
3. Ideal length: At least 300 words for optimal SEO

NOTE: Fixing Description in Bulk edit in CSV will overwrite the existing value in Shopify admin config.

Column E: SEO Title (Meta Title)

1. The title that appears in search engine results
2. Common errors: Missing, duplicate, too short, too long
3. Ideal length: 30-70 characters

NOTE: Fixing SEO Title in Bulk edit in CSV will only change the value on frontend - Tapita config, not Shopify admin config. 

Column F: SEO Description (Meta Description)

1. The description snippet that appears in search engine results
2. Common errors: Missing, duplicate, too short, too long
3. Ideal length: 70-160 characters

NOTE: Fixing SEO Description in Bulk edit in CSV will only change the value on frontend - Tapita config, not Shopify admin config.

Column G: Focused Keywords

Choose keywords strategically based on page type:

For Products and Collections:

1. Base keywords on the product or collection name
2. Remove special characters and variant names
3. Example:
1. Product: "VANS | AUTHENTIC | (MULTI EYELETS) | GRADIENT/CRIMSON"
2. Focus keyword: "vans authentic multi eyelets"

For Blog Pages:

1. Use the shortest phrase that covers the main topic
2. Example:
1. Blog title: "How to wash running shoes for beginners"
2. Focus keyword: "wash running shoes" or "wash running shoes for beginners"
   

1. You can update new handles for your existing pages that have "Too long URLs" error by uploading a new handle under the New handle column at the end. 

2.3 Sample Workflow

Here's a practical example of how to fix an error:

1. In the Excel errors file: You find qwerty.com/keyboard marked with error "Too short meta title"
2. Current SEO title: "keyboard" (too short)
3. In your CSV file:
1. Paste the handle: keyboard
2. Add optimized value to SEO Title column: "Most common keyboard layout for English-language keyboards"

Repeat this process for all errors you want to fix, working through each page systematically.

NOTES: If you enter focused keywords, please make sure your Title, Description, SEO Title, SEO Description contain the exact focused keywords, so you can achieve a high SEO score. Otherwise, those missing will be detected as need-improvement errors and take time to edit later.

Step 3: Upload Your CSV File

1. Return to the Bulk Edit via CSV feature in the app
2. Click Add files
   

1. Select and upload your edited CSV file
2. Review the summary of data inputs displayed on screen
3. Click Start updating

What Happens Next

1. A status banner will appear showing the update progress
2. Once complete, navigate to the pages you edited
3. You'll see updated content and improved SEO scores for each page

Before and After: Compare your pages' SEO scores to see the improvement from your bulk updates.

Before Bulk edit via CSV

After Bulk edit via CSV

Frequently asked questions. (FAQs)

1. What columns are required?  

→ Handle column is required. 

2. What values on my store will be replaced when I upload the CSV file? 

→ Existing values will be replaced for all columns included in the CSV. 

3. Do Tapita auto-fill the values I left empty? 

→ Empty values in the CSV will be ignored. 

4. Do the new SEO Title and SEO Description value change in Shopify admin config? 

→ Please note that SEO Title and SEO Description columns will change values in Tapita meta data config only (Frontend), not overwrite the existing values in Shopify admin config. 

Now you know how to use the Bulk edit in CSV function to save time fixing meta data errors for multiple pages at once. If you have any questions, please contact us via support@tapita.io