How to Bulk Import Shopify Discount Codes via CSV

Learn how to bulk import Shopify discount codes from a CSV file and create multiple discount codes at once using the StoreRobo Import Export app.

Bulk importing discounts to Shopify from a CSV file is one of the fastest ways to launch large-scale promotions without drowning in manual data entry. Whether you’re setting up hundreds of unique coupon codes for a flash sale, migrating from WooCommerce or Magento, or scheduling a seasonal campaign, a properly structured CSV file and the right import tool will get you there in minutes.

In this article, we will show you how to bulk import discounts to Shopify using the WebToffee StoreRobo app.

Shopify discounts allow merchants to offer price reductions to customers to encourage purchases and increase sales. Shopify supports several discount types:

• Percentage discounts — e.g., 10% off the order total
• Fixed amount discounts — e.g., $5 off a qualifying order
• Free shipping discounts — waive shipping at checkout
• Buy X Get Y (BOGO) discounts — offer a free or discounted item when a qualifying item is purchased

Store owners can create discount codes that customers enter at checkout, or set up automatic discounts that apply based on predefined conditions, such as a minimum cart value or a specific product purchase.

Shopify also supports one-time, limited-use, and unlimited-use discounts, giving merchants control over the scope of promotions. Additional restrictions include:

• Expiration dates
• Usage limits per customer
• Minimum purchase requirements
• Applicability to specific products, collections, or entire orders

Bulk importing discounts is useful when you need to create or update many Shopify discount codes quickly.

Instead of entering each code manually, you can define all discount details in a CSV file, including discount code, discount type, value, usage limits, customer eligibility, and validity period. Once uploaded, StoreRobo processes the file and creates or updates the discount codes in Shopify.

Bulk importing helps you:

• Save time during campaign setup
• Reduce manual errors
• Create hundreds or thousands of discount codes at once
• Update existing Shopify discounts in bulk
• Schedule discount imports for future promotions
• Migrate discount codes from another platform to Shopify

Before importing discount codes into Shopify, make sure your CSV file follows the correct format. StoreRobo provides demo CSV files for supported Shopify data types, including Discounts, to help you understand the required structure and column mapping.

Required and Common CSV Columns

The exact columns may vary depending on the discount type and the Shopify discount fields you want to import. However, your CSV should generally include the following types of information:

Column	Example Value	Description
Code	SUMMER20	The discount code customers will enter at checkout.
Discount Type	percentage	Defines the type of discount, such as percentage, fixed amount, or free shipping.
Value	20	Discount value. For percentage discounts, use the percentage number. For fixed discounts, use the amount.
Start At	2026-06-01	The date when the discount becomes active.
Ends At	2026-06-30	The date when the discount expires.
Usage Limit	100	Maximum number of times the discount can be used.
Usage Limit Per Customer	1	Restricts each customer to one use.
Minimun Requirement	50	Minimum order value or quantity required to use the discount.
Applies To	entire_order	Defines whether the discount applies to the whole order, products, or collections.
Customer Elligibility	Customer Eligibility	Defines whether all or selected customers can use the discount.

Shopify Discount CSV Example

Here is a simple example of how your discount CSV may look:

Code	Discount Type	Value	Starts At	Ends At	Usage Limit	Usage Limit Per Customer
SUMMER20	percentage	20	2026-06-01	2026-06-30	500	1
SAVE10	fixed_amount	10	2026-06-01	2026-06-30	300	1
FREESHIP	free_shipping	0	2026-06-01	2026-06-15	1000	1

StoreRobo supports importing Shopify discount data using CSV files. The app is listed as supporting discount data as an editable resource and bulk import/export workflows through CSV.

However, not every type of promotional rule from Shopify or another eCommerce platform can be imported in the same way. Some advanced or platform-specific discount rules may need to be recreated manually in Shopify.

Discount Types StoreRobo Can Import

StoreRobo can import discount codes that are supported by Shopify’s discount structure and included in the discount CSV format, such as:

• Percentage discounts — For example, 20% off
• Fixed amount discounts — For example, $10 off
• Free shipping discounts — For example, FREESHIP
• Buy X Get Y / BOGO discounts — If the required Shopify discount fields are available and correctly mapped in the CSV
• Discount codes with usage limits
• Discount codes with start and end dates
• Discount codes with minimum purchase requirements
• Discount codes applicable to products, collections, or entire orders

Discount Types StoreRobo Cannot Import Directly

Some discount setups may not be directly importable through a discount-code CSV workflow, including:

• Automatic discounts without codes. These apply automatically at checkout and do not rely on customer-entered codes.
• Platform-specific promotional rules from WooCommerce, Magento, or other platforms that lack a direct Shopify equivalent.
• Custom coupon logic created by third-party apps.
• Script-based or checkout customization-based discounts.
• Stacked or conditional promotional rules that depend on advanced logic not available in the discount CSV columns.

For unsupported discount logic, recreate the rule manually in Shopify, or convert it to a Shopify-supported discount code format before importing.

To bulk import discounts to Shopify, we will be using the Shopify Import Export app by WebToffee.

Follow the below steps to bulk import discount codes to Shopify:

Step 1: Install StoreRobo Import Export App

• Log in to your Shopify admin account.
• Go to Apps and search for “StoreRobo Import Export Suite.”

• The app is available in free and paid versions. If you are just trying out, you can start with the free version, which lets you import up to 10 discounts.
• After choosing a plan, install and activate the app on your Shopify store site.

Step 2: Upload the Discount Codes CSV File

• Go to Apps and select StoreRobo from the installed apps.
• From the Import section, choose Local as the input file location.
• Then, upload the CSV file with the discount codes.
• You can preview the input file to ensure that the discount codes are formatted correctly.

• Then click on Upload to upload the input file.

Step 3: Import or Update Shopify Discounts

• Enable the Update if Discounts already exist in the store checkbox. This will update existing discount codes on your Shopify store.

Updating discounts will allow you to bulk edit discount codes on your Shopify store.

• Click on Import to import discounts directly to your Shopify store.

You can schedule the import for a later time, and the app will automatically import the discount codes as per the scheduler.

Step 4: Review the Import Log

Once the import job is complete, you will see a detailed log report. Review the log to confirm whether all rows were imported successfully.

That’s it; you have successfully imported discount codes to your Shopify store.

You can then go to the Shopify Discounts page to check the newly created or updated discount codes.

If you’re moving your store from WooCommerce, Magento, BigCommerce, or another ecommerce platform, transferring your discount codes is a step that’s easy to overlook — and painful to rebuild manually.

What the Migration Challenge Looks Like

Every platform structures discounts differently. WooCommerce stores coupon data in the wp_posts and wp_postmeta tables. Magento uses its salesrule and salesrule_coupon tables. BigCommerce exports coupon codes in its own CSV format. None of these maps directly to Shopify’s discount structure.

The core migration challenge is not just moving the codes — it’s translating the rules attached to those codes: the discount type, value, usage restrictions, product/collection applicability, and expiration logic.

How StoreRobo Handles Cross-Platform Migration

StoreRobo accepts a standardized CSV format, which means you can use it as the translation layer between your old platform and Shopify — provided you do the column mapping work first.

Recommended migration workflow:

1. Export your existing discount codes from your current platform (WooCommerce, Magento, etc.) as a CSV or spreadsheet.
2. Map the columns from your export to StoreRobo’s required format. Common mappings include:
   • WooCommerce coupon_code → StoreRobo code
   • WooCommerce discount_type values (percent, fixed_cart) → StoreRobo discount_type (percentage, fixed_amount)
   • WooCommerce expiry_date → StoreRobo ends_at (reformat to ISO 8601)
   • WooCommerce usage_limit → StoreRobo usage_limit
3. Handle unsupported rules manually. Discount types that don’t exist in Shopify (e.g., Magento’s “catalog price rules,” WooCommerce’s product-level percentage rules applied via hooks) will need to be recreated using Shopify’s native discount builder or Shopify Functions.
4. Validate your CSV against StoreRobo’s demo template before importing.
5. Run a test import with 5–10 rows before importing the full dataset.

Platform-Specific Notes

WooCommerce: Most standard coupon types (percentage, fixed cart, fixed product) map cleanly to Shopify equivalents. BOGO and conditional logic coupons created via plugins (e.g., Advanced Coupons) will need manual recreation.

Magento: Catalog price rules (automatic, non-code-based discounts) have no direct Shopify CSV equivalent. Shopping cart price rules with coupon codes map more cleanly and can be exported from Magento’s admin for column remapping.

BigCommerce: BigCommerce’s coupon export CSV is structured similarly to what StoreRobo expects. The primary remapping needed is date format and discount type naming conventions.

After an import, StoreRobo generates a detailed log showing which rows succeeded and which failed. Here are the most common issues and how to resolve them.

1. Failed Rows

The import completes, but some rows show errors in the log.

Common causes:

• A required column is missing or blank for that row
• An invalid discount_type value (must be exactly percentage, fixed_amount, or free_shipping)
• A value field contains a currency symbol (e.g., $20 instead of 20)
• starts_at or ends_at is in the wrong date format

Fix: Download the error log, identify the affected rows, correct the values in your CSV, and re-import only the failed rows. No need to re-run the entire file.

2. Duplicate Discount Codes

Shopify discount codes should be unique. If your CSV contains codes that already exist in your store, the import may fail or skip those rows unless you choose the update option.

Fix:

• Remove duplicate codes from the CSV
• Enable the option to update existing discounts
• Rename the new discount codes before importing.

3. CSV Formatting Mistakes

The upload preview shows garbled data, misaligned columns, or strange characters.

Common causes:

• File saved as XLSX instead of CSV
• File encoded as Windows-1252 instead of UTF-8 (common when editing in Excel on Windows)
• Extra rows at the top (e.g., a merged header row or blank rows before the column header)
• Commas inside field values that are not properly quoted (e.g., a title like Sale, Summer 2025 without surrounding quotes)

Fix: Open the file in a plain-text editor (VS Code, Notepad++, TextEdit) to inspect the raw content. Re-save as UTF-8 CSV. If using Excel, use “Save As” and explicitly choose “CSV UTF-8 (Comma delimited).”

4. Import Appears Stuck or Times Out

The import progress bar stops, or the job appears to hang.

Fix: Large files (thousands of rows) take time. Avoid closing the browser tab. If the job fails entirely, split the CSV into smaller batches of 500–1,000 rows and import sequentially. Alternatively, use the scheduler to run imports during off-peak hours.

5. Discounts Import Successfully but Don’t Apply at Checkout

Symptom: Codes appear in the Shopify Discounts page, but customers report they don’t work.

Common causes:

• starts_at date is in the future
• minimum_purchase_amount is higher than the cart value
• applies_to is set to specific products/collections that aren’t in the customer’s cart
• The code has reached its usage_limit

Fix: Open the specific discount in the Shopify admin and review all conditions. Use a test order to simulate the checkout scenario.

6. Discount Values Are Imported Incorrectly

If discount values appear wrong in Shopify, check whether the value format matches the discount type.

For example:

• Percentage discounts should use a percentage value, such as 20.
• Fixed amount discounts should use a currency amount, such as 10.
• Free shipping discounts may not require a discount value.

7. Unsupported Discount Rules

If your discount rule comes from WooCommerce, Magento, or another platform, check whether Shopify supports the same rule structure.

If the original rule has advanced conditions, custom logic, or third-party app dependencies, convert it into a Shopify-supported discount format before importing.

Bulk importing discount codes to Shopify using the StoreRobo Import Export app is a streamlined solution for businesses looking to manage large-scale promotions efficiently. Using a properly formatted CSV file allows you to upload and update hundreds or even thousands of discounts in one go, saving valuable time and minimizing manual errors.

This approach not only simplifies the setup of discounts but also allows you to focus on optimizing your marketing strategies to engage customers better and drive sales.

We hope this article has helped you easily import bulk discount codes to Shopify. If you have any queries, please drop them in the comments section. We’d be happy to help you.