Export Products

Export Products dialog

The Export feature allows you to export products to various formats for backup, analysis, or use in other systems.

Opening Export

Open using one of these methods:

  • Menu: File > Export Products
  • Toolbar: Import/Export dropdown > Export Products (N)

The number in parentheses shows how many products are selected.

What Gets Exported

Export options:

  • Selected products - Only products you've selected
  • All products - Every product in the grid (respects filters)
  • Filtered products - Products matching current filter

Supported Formats

Format Extension Use Case
CSV .csv Universal compatibility
Excel .xlsx Spreadsheet analysis
TSV .tsv Tab-delimited data
Google Shopping .xml Product feeds

Export Options

Format Selection

Choose your output format from the dropdown.

Variant Mode

How to export products with multiple variants:

Mode Description Use Case
One row per product Product fields only, first variant Product-level analysis
One row per variant Separate row for each variant Full variant data
Summary Product with variant count Quick overview

Column Selection

Choose which fields to include:

Product Fields

  • Title, Handle, Description
  • Vendor, Product Type, Tags
  • Status, Published At
  • SEO Title, SEO Description

Variant Fields

  • Price, Compare At Price
  • SKU, Barcode
  • Weight, Inventory
  • Option Values (Size, Color, etc.)

Select All / Deselect All

Quickly toggle all columns on or off.

Mapping Profile

Apply a mapping profile to:

  • Rename columns for compatibility
  • Reorder columns
  • Apply transformations

Built-in Profiles

Profile Description
Shopify CSV Standard Shopify export format
Google Shopping Google Merchant Center feed
Custom Your saved profiles

Export Process

  1. Select products to export
  2. Choose format and options
  3. Click Export
  4. Choose save location
  5. Wait for completion

Progress

  • Progress bar shows completion
  • Cancel available for large exports
  • Success message with file location

File Output

CSV/TSV Format

  • Header row with column names
  • UTF-8 encoding with BOM
  • Properly escaped special characters
  • Quoted fields containing delimiters

Excel Format

  • Single worksheet "Products"
  • Formatted headers (bold)
  • Auto-sized columns
  • Numeric fields as numbers

Google Shopping XML

  • Valid RSS 2.0 format
  • Google namespace (g:) elements
  • Required fields mapped automatically
  • Ready for Merchant Center upload

Column Customization

Reordering Columns

  1. Click Customize Columns
  2. Drag columns to reorder
  3. Changes apply to current export

Renaming Columns

  1. Select a column
  2. Enter custom header name
  3. Original data is preserved

Common Export Scenarios

Backup All Products

  1. Clear all filters
  2. File > Export Products
  3. Choose Excel format
  4. Select all columns
  5. Use "One row per variant" mode
  6. Save with date in filename

Price List Export

  1. Select products for price list
  2. Export to CSV
  3. Select: Title, SKU, Price, Compare At
  4. "One row per variant" mode

Google Shopping Feed

  1. Export all active products
  2. Choose Google Shopping XML format
  3. Google Shopping profile auto-applies
  4. Upload to Merchant Center

Inventory Report

  1. Export with Inventory column
  2. Include: Title, SKU, Inventory
  3. "One row per variant" mode
  4. Use for stocktake

Re-importing Exports

Exports can be re-imported:

  1. Make changes in Excel/CSV
  2. Import back to ProductManager
  3. Use same mapping profile
  4. Choose "Update Only" mode

This enables bulk editing in spreadsheet software.

Performance

Large Exports

For exports with many products:

  • Excel format is fastest
  • Progress updates in real-time
  • Memory usage increases with size
  • Consider exporting in batches for very large catalogs

Estimated Times

Products CSV Excel
100 Seconds Seconds
1,000 ~10 sec ~5 sec
10,000 ~1 min ~30 sec

Troubleshooting

"No products to export"

  • Select products in the grid
  • Clear filters if needed
  • Verify products are loaded

"Export failed"

  • Check available disk space
  • Verify write permissions to save location
  • Try a different format

"File won't open in Excel"

  • Check file encoding (UTF-8)
  • Try importing as text with delimiter
  • Use .xlsx format instead of CSV

"Special characters corrupted"

  • Ensure UTF-8 encoding
  • Excel may need "Import from Text" for CSV
  • Use Excel format for best compatibility

"Google Shopping validation errors"

  • Check required fields are included
  • Verify data format (prices, availability)
  • Review Google Merchant Center requirements

Best Practices

  1. Regular backups - Export all products weekly
  2. Use Excel - Best compatibility for editing
  3. Include SKU - Enables re-import matching
  4. Date filenames - products_2024-01-15.xlsx
  5. Test re-import - Verify export is importable

See Also