📊 Export Summary
Complete SEO metadata optimization for your product catalog
Total Items
1,823
products, collections, blog
Products
1,626
with meta & FAQs
Collections
146
with meta & FAQs
Blog Posts
51
with meta & FAQs
Total FAQs
8,764
questions & answers
✅ What Was Updated
- 1,626 products with optimized meta titles & descriptions (Dubai/UAE focused)
- 146 collections with optimized meta titles & descriptions
- 51 blog posts with optimized meta titles & descriptions
- 8,764 FAQ pairs generated based on People Also Ask search data
- All content ready for Shopify import via CSV
📥 Download Files
All files ready for review and Shopify import
Interactive HTML Report
Browse all products, collections & blog posts with searchable and filterable interface
Complete Export CSV
All 1,823 items (products, collections, blog posts) with meta titles, descriptions & FAQs
📝 How to Import Products to Shopify
- Export your current products from Shopify: Go to Admin → Products → Export → Select "All products" → Export as CSV
- Open both CSV files: Open the Shopify export and our SEO export in Excel or Google Sheets
- Add SEO columns to your Shopify CSV:
- Add a column called
SEO Title(copy values from ourmeta_titlecolumn) - Add a column called
SEO Description(copy values from ourmeta_descriptioncolumn) - Match rows using the
Handlecolumn (must be identical)
- Add a column called
- Import back to Shopify: Go to Products → Import → Upload your updated CSV
- Check "Overwrite existing products with the same handle": This updates the SEO fields without creating duplicates
📚 Full Shopify Import Guide:
help.shopify.com/en/manual/products/import-export/import-products
📦 Collections & Blog Posts
Shopify does not support native CSV import for collections or blog posts. Snezzi will provide automated scripts to update these via the Shopify API.
- Products: Use CSV import (instructions above)
- Collections: Automated API script (provided by Snezzi)
- Blog Posts: Automated API script (provided by Snezzi)
⚠️ Important Warning
Do NOT sort the CSV file in Excel/Sheets before importing. Sorting can disassociate product variants and images, causing data loss that cannot be recovered.
💡 Column Mapping Reference
| Our Export Column | Shopify CSV Column | Purpose |
handle |
Handle |
Match products (required) |
meta_title |
SEO Title |
Google search title |
meta_description |
SEO Description |
Google search description |
faqs |
Custom metafield | Requires FAQ app setup |