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
- Export the products with Basic columns and SEO Data.
- Download and filter the unnecessary columns.
- Update the SEO title and SEO description for the products.
- Import the CSV file back into the store.
Step 1: Export products
To export the necessary products,
- Head to StoreRobo Import/Export Suite.
- Click on Proceed under Export.
- Under Select data, choose Products.
- 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
- Keep other options unchanged and click on Export.
- Once the export is done Download the CSV file.
Step 2: Update SEO title and SEO description
Once the CSV file is downloaded,
- Open the downloaded CSV file.
- Remove unnecessary columns, retaining ID, Handle, SEO Title, and SEO Description.
- 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.
- Now, Customize the SEO Title and SEO Description as needed.
- If you wish to modify only the SEO Title, you can leave the SEO Description field empty, and vice versa.
- 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,
- Head back to StoreRobo Import/Export Suite.
- Under Import, select the updated file from the saved location.
- 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
- You can use the preview option to verify the data.
- Under Select data type, select Products.
- Click on Proceed.
- Under options, select Update if products already exist in the store.
- Finally, click on Import to update the data.
On successful import, the status will change to completed, and you will be notified by mail.
Once the import is completed, the SEO Title and SEO Description of the selected products will be successfully updated.