Home > Docs > StoreRobo - Shopify Product Import Export App > Bulk Update Product SEO Titles and Descriptions in Shopify

Bulk Update Product SEO Titles and Descriptions in Shopify

Last updated on October 3, 2024

SEO plays a crucial role in the success of an online store. Regularly updating SEO titles and descriptions based on current trends is key to boosting your products’ visibility in search results. While Shopify offers a way to manage this data from the dashboard, handling SEO updates for a large number of products can be more challenging than anticipated.

StoreRobo Import Export Suite offers a solution by consolidating all SEO data into a CSV file for easy updating, streamlining the process, and eliminating the need to switch between multiple product pages.

To update the SEO data

  1. Export the products with Basic columns and SEO Data.
  2. Download and filter the unnecessary columns.
  3. Update the SEO title and SEO description for the products.
  4. Import the CSV file back into the store.

Step 1: Export products

To export the necessary products,

  1. Head to StoreRobo Import/Export Suite.
  2. Click on Proceed under Export.
Export Shopify products
Export Shopify products
  1. Under Select data, choose Products.
  2. Expand the data type and select Basic Columns and SEO Data.

Required columns

  • Basic Columns: ID, Handle
  • SEO Data: SEO Title, SEO Description

You can also use the filter option to choose only selected products. For example, let’s select the products with the Type: Outdoor. To know more about how filters products, refer to, StoreRobo Export Filters for Shopify Product Data

  1. Keep other options unchanged and click on Export.
Exporting products to update SEO title
Exporting products to update SEO title
  1. Once the export is done Download the CSV file.
Download exported file
Download exported file

Step 2: Update SEO title and SEO description

Once the CSV file is downloaded,

  1. Open the downloaded CSV file.
  2. Remove unnecessary columns, retaining ID, Handle, SEO Title, and SEO Description.
exported product data
Exported product data
  1. Also if you don’t want to change the SEO Title and SEO Descriptions of selected products you can delete that row from the CSV.
  2. Now, Customize the SEO Title and SEO Description as needed.
  3. If you wish to modify only the SEO Title, you can leave the SEO Description field empty, and vice versa.
Updated product data
Updated product data
  1. Finally, save the file in CSV format.

Step 3: Import the CSV file back into the store

Once you have successfully modified and saved the CSV file,

  1. Head back to StoreRobo Import/Export Suite.
  2. Under Import, select the updated file from the saved location.
  3. Choose a delimiter as the one you set while saving the file. (comma is the default one). To know more on delimiters and how they work, refer to:

>> Uncovering Delimiters: Crucial Data Organization Techniques

  1. You can use the preview option to verify the data.
  2. Under Select data type, select Products.
  3. Click on Proceed.
Import updated data
Import updated data
  1. Under options, select Update if products already exist in the store.
  2. Finally, click on Import to update the data.
updating existing products
Updating existing products

On successful import, the status will change to completed, and you will be notified by mail.

 Product import completed
Product import completed

Once the import is completed, the SEO Title and SEO Description of the selected products will be successfully updated.

updated SEO title and description
Updated SEO title and description