Our first app, Migrato, is live on the Shopify App Store - free plan, no credit card. Take a look
Home / Documentation / Import / Export Discounts
Discounts Import/Export

Import / Export Discounts

How to import and export discounts in bulk with CSV and XLSX files.
6 min read Updated 14 October 2026 Applies to Migrato on all plans

Migrato allows you to import and export Shopify discount data using CSV or XLSX files. You can select the required discount fields, export existing discount data, prepare discount data for import, and use filters to export only the discounts that match specific conditions.

You can use discount import/export to create, update, replace, merge, delete, or migrate discount data in bulk, depending on the operation supported by Migrato. This makes it easier to manage large numbers of discounts without handling each discount individually through Shopify Admin.

Migrato supports different types of Shopify discount information, including amount-based discounts, Buy X Get Y discounts, free shipping discounts, customer eligibility, usage limits, discount combinations, subscription purchase settings, and shareable links. Shopify's discount model supports fixed-amount and percentage-based amount-off discounts, Buy X Get Y discounts, and free-shipping discounts.

Discounts Import Video Demonstration
Discounts Import Video Demonstration
★
Before importing or exporting discounts

We recommend reviewing the Discount Template Documentation and downloading the Discount Demo CSV/XLSX file, if available, to understand the supported fields and expected data structure.

Import Discounts

Migrato allows you to bulk import Shopify discount data using CSV or XLSX files.

You can upload a prepared discount file directly to Migrato or provide a publicly accessible URL to the file.

Step 1: Open Discount Import

From your Shopify Admin:

  1. Go to Apps → Migrato.
  2. Open the Import section.
  3. Select Discounts as the entity you want to import.
  4. Add the discount file you want to import.
Discount Import
Discount Import

Step 2: Upload or Provide the Discount File

Migrato provides two ways to provide the discount file.

Option 1: Upload a File

You can upload or drag and drop your prepared discount file.

Migrato supports:

  • CSV
  • XLSX
Upload Discount File
Upload Discount File

Option 2: Import from a Public URL

You can also provide the full publicly accessible URL of the discount file instead of uploading it manually.

For example:

Example
https://example.com/discounts.csv

Enter the URL and select Upload from URL.

Import Discounts from URL
Import Discounts from URL
i
Note

The file URL must be accessible to Migrato. If the file requires authentication, a login, or restricted permissions, Migrato may not be able to retrieve it.

Step 3: Review the Import Details

After the file is uploaded or retrieved from the provided URL, Migrato creates the import job and displays the available import information.

The import details may include:

  • Import ID
  • Import state
  • File format
  • Operation
  • Uploaded file
  • Import information
Discount Import Details
Discount Import Details

Review the displayed information before continuing.

Step 4: Review the Discount Sheet

Migrato identifies the discount data contained in the uploaded file and displays the available sheet information.

Review the detected sheet before selecting the import operation.

Discount Import Sheet
Discount Import Sheet

Make sure the expected discount columns are available and correctly structured.

Step 5: Select an Import Operation

Migrato allows you to select the operation that should be performed on the discount data.

Depending on the supported Migrato discount operations, the available options may include:

  • Merge – Update matching records and create new records.
  • Create only – Create new records and skip records that already exist.
  • Update only – Update existing records and skip records that cannot be matched.
  • Replace – Replace the existing matching record with the imported data.
  • Delete – Delete the matching record when it exists.
Discount Import Operations
Discount Import Operations

The selected operation determines how Migrato handles existing and new discount records.

!
Important

Carefully review the selected operation before processing discount data, especially when using Replace or Delete.

Step 6: Configure Import Options

Open the Options section to configure any additional settings available for the discount import.

Depending on the current Migrato configuration, available options may include settings related to scheduling and result files.

Discount Import Options
Discount Import Options

Step 7: Schedule the Discount Import

If scheduling is available for the import operation, you can configure the discount import to run automatically.

You can configure options such as:

  • Schedule date
  • Schedule time
  • Repeat interval
  • Number of repetitions or run until cancelled

This can be useful when discount data is maintained by an external system and needs to be imported regularly.

Schedule Discount Import
Schedule Discount Import

Step 8: Start the Discount Import

After reviewing the file and configuring the required settings:

  1. Review the import details.
  2. Confirm the selected operation.
  3. Review the available options.
  4. Click Import.
Import Discounts Button
Import Discounts Button

Migrato will begin processing the discount import.

Step 9: Monitor the Import

Migrato processes the discount import as a job and displays the current processing status.

Discount Import in Progress
Discount Import in Progress

You can use the job information to monitor the progress of the import.

Step 10: Review Import Results

After the import has completed, review the results displayed by Migrato.

The results may include:

  • Import status
  • Total records
  • Successfully processed records
  • Failed records
  • Skipped records
  • Processing duration
  • Error information
Discount Import Results
Discount Import Results

If any records fail, review the reported errors, correct the source data, and run the import again as required.

Export Discounts

Migrato allows you to export Shopify discount data into a downloadable CSV or XLSX file.

Discount exports can be useful for:

  • Discount reporting
  • Campaign management
  • Data analysis
  • Backup
  • Store migration
  • Bulk data processing
  • External system integration
  • Record keeping

Step 1: Open Discount Export

From your Shopify Admin:

  1. Go to Apps → Migrato.
  2. Open the Export section.
  3. Select Discounts.
Select Discounts for Export
Select Discounts for Export

Step 2: Select Discount Fields

Select the discount fields you want to include in the export.

Migrato organizes the available discount fields into logical groups to make it easier to select the required information.

The available groups include:

  • Basic Columns
  • Type-Specific
  • Eligibility
  • Purchase Type
  • Combinations
  • Shareable Links
Discount Export Fields
Discount Export Fields

You can select the fields required for your reporting, migration, or data-management requirements.

Step 3: Apply Discount Filters

If you only need specific discounts, use the Filters section to narrow the export.

Migrato currently provides filters for:

  • ID
  • Title
  • Tags
  • Status
  • Method
  • Starts At
  • Ends At
  • Updated At
  • Created At
  • Total Used Count
Discount Export Filters
Discount Export Filters

For complete information about the available filters and conditions, see 7.3 Filter Discounts.

Step 4: Start the Export

After selecting the required discount fields and filters:

  1. Review the selected fields.
  2. Review the applied filters.
  3. Confirm the export settings.
  4. Start the export.
Start Discount Export
Start Discount Export

Migrato processes the selected discount data and creates the export file.

Step 5: Review the Export Result

After the export is completed, Migrato displays the export result.

The result can include information such as:

  • Export status
  • Exported file name
  • File format
  • Number of records exported
  • Processing duration
  • Selected fields
  • Applied filters
Discount Export Completed
Discount Export Completed

You can download the generated CSV/XLSX file from the completed export screen.

Supported Discount Data

Migrato's Discount template contains 40 supported columns organized into six logical groups.

Group Number of Columns
Basic Columns 24
Type-Specific 5
Eligibility 2
Purchase Type 2
Combinations 3
Shareable Links 4
Total 40

Ready to run this on your own store?

Migrato's free plan handles 25 items per job - enough to follow any page in these docs end to end before you pay anything.

Free plan forever No credit card 2-minute setup Uninstall anytime