Skip to main content

How to Export Product Categories

Updated

Export your complete category structure including hierarchy, settings, display configuration, and SEO metadata. Perfect for site structure audits, bulk category updates, or backup purposes.

Quick Access: Navigate to Import/Export from the top navigation bar → Select Export
📋 When to Use This Feature

Export category data for:

  • Site structure review: Analyze your category organization and hierarchy
  • Bulk updates: Make changes to multiple categories in spreadsheet format
  • SEO audits: Review and optimize category metadata
  • Backup and documentation: Keep records of your category configuration

What You'll Get:

  • Complete category hierarchy structure
  • Category display settings and configuration
  • SEO metadata for all categories
  • Category URLs (optional)
Pro Tip: Include Category URLs when you need to audit or update URL structures for SEO purposes.
📥 Step 1: Access Export Interface

Navigate to Export

1Click Import/Export in top navigation

2Select Export from the menu

3Export options page displays with available export types

⚙️ Step 2: Configure Export Options

Select Category Export

1Select the Category Export radio button

Choose Export Settings

Include Category URL (Optional):

1Check the Include Category URL checkbox if you need category URLs in your export

2When selected, category URLs will appear as the last column in your CSV file

What You'll See: The export file will contain all category data in CSV format, ready to open in Excel or Google Sheets.
💾 Step 3: Generate and Download

Create Export File

1Click the Generate Export File button

2Wait for the system to compile your category data

3Download link appears when file is ready

Download to Your Computer

1Click Download it now to save the CSV file

2File downloads to your default downloads folder

File Format: The export saves as a CSV (comma-separated values) file that opens in any spreadsheet application.
📊 Understanding Your Export

Export File Contents

Your category export CSV includes:

  • Category hierarchy: Parent-child relationships and nesting structure
  • Category settings: Display options and configuration values
  • SEO metadata: Meta titles, descriptions, and keywords
  • Category URLs: Full URL paths (if Include Category URL was checked)

Working with Exported Data

For bulk updates:

  • Open the CSV in Excel or Google Sheets
  • Make your changes to category information
  • Save the file
  • Use the Category Import feature to update your categories
Important: Don't modify column headers or remove required fields if you plan to re-import the data. This ensures successful import processing.
⚠️ Troubleshooting & Best Practices

Export File Not Generating

Solution: Refresh the page and try again. If the issue persists, check that you have proper permissions to export data.

CSV File Won't Open

Solution: Make sure you have a spreadsheet application installed (Excel, Google Sheets, or LibreOffice). Right-click the file and choose "Open with" to select your preferred application.

Missing Category URLs

Cause: The Include Category URL checkbox was not selected during export.

Solution: Generate a new export with the checkbox selected to include URLs in your file.

Best Practices

  • Regular backups: Export your categories periodically as backup before making major changes
  • Include URLs for SEO work: Always check Include Category URL when reviewing site structure or SEO
  • Document your changes: Keep a copy of the original export before making bulk updates
  • Test imports on staging: When re-importing modified data, test on a staging environment first
  • Keep column structure: Don't add, remove, or rename columns if you plan to re-import

Related articles