Import & export

Overview

Expiration Dates for WooCommerce provides two ways to work with expiration dates in bulk: a dedicated CSV export/import tool within the plugin (free), and — with Pro — integration with WooCommerce’s built-in product CSV import/export system.

Plugin CSV export

The plugin includes its own export tool for expiration date data:

1. Go to Products → Expirations → Import / Export.
2. Click Export.
3. A CSV file will download containing all products with expiration dates.

The exported CSV includes:

• Product ID
• SKU
• Product name
• Product type (simple, variation, grouped, or external)
• Expiration date
• Stock status and price (for context)

Use this export to back up your expiration data, share it with your team, or prepare data for re-import.

Download a template

The quickest way to start is the Download template button on the Import / Export page. It produces a CSV pre-filled with every product and its current expiration date, ready for you to edit and re-upload.

How variable products appear

Variable products round-trip through the CSV in two parts:

• Each dated variation is exported as its own row (matched by its variation ID/SKU), carrying that variation’s own expiration date.
• The parent product is exported as a single row only when it has a default (inherited) date set — the date dateless variations fall back to. That parent row carries the default date, not the earliest variation date.

On import, a parent row sets the product’s default date, and variation rows set each variation’s own date — so a file you export re-imports cleanly. If a variable product has no default date and no dated variations, it isn’t included (there’s nothing to round-trip). This mirrors how the Reports table shows one row per product.

Plugin CSV import

To import expiration dates from a CSV file:

1. Go to Products → Expirations → Import / Export.
2. Drag and drop your CSV file onto the upload area, or click to browse for a file.
3. Click Import. Columns are detected automatically — there is no mapping step.

CSV format

Your import CSV needs:

• ID or SKU — Used to match each row to an existing product (ID is checked first, then SKU).
• Expiration date — In YYYY-MM-DD format. Leave it blank to clear a product’s date.

Other columns (Name, Type, Stock status, Price) are read-only context and are ignored on import. Rows that can’t be matched to a product are skipped, and you’ll see a summary of results when the import completes.

WooCommerce product CSV integration Pro

The plugin also integrates with WooCommerce’s standard product CSV import and export system, which you may already be using to manage your catalog.

Exporting with WooCommerce

When you export products via Products → Export, the CSV will include an additional expiration date column added by the plugin. No extra steps are needed — the column is included automatically.

Importing with WooCommerce

When you import products via Products → Import, the plugin recognizes the expiration date column and applies the dates to the matching products. This means you can manage expiration dates as part of your regular product data workflow.

To add expiration dates during a product import:

1. Include an expiration-date column in your CSV (use the YYYY-MM-DD format).
2. Import through Products → Import, and on WooCommerce’s column-mapping screen map your column to Expiration date.
3. WooCommerce applies the dates to the matching products as part of the import.

Tips

• Always back up first — Export your current data before running a large import, so you can restore if needed.
• Use YYYY-MM-DD format — This avoids ambiguity between date formats (e.g., is 01/02/2026 January 2nd or February 1st?).
• Check the import summary — After an import, review the results to confirm all products were matched and updated correctly.
• Combine approaches — Use the plugin’s CSV tool for expiration-specific work, and WooCommerce’s CSV for full product catalog management.