Import and Export Gift Card Coupons in WooCommerce

Gift card coupons, or store credit coupons, are becoming increasingly popular in eCommerce. However, managing them can be time-consuming, particularly for stores with a large customer base. WooCommerce allows you to streamline this process by importing and exporting gift card coupons in bulk, reducing the potential for manual errors and saving valuable time.

In this article, we’ll guide you through the steps of importing and exporting gift card coupons created with WebToffee WooCommerce Gift Cards plugin.

Importing and exporting gift card coupons offers several benefits, including:

• Mass Updates: Easily update gift card details such as expiration dates, amounts, or usage restrictions.
• Backup and Restore: Keep a backup of all your gift card coupon data to restore them in case of system failure.
• Bulk Creation: Create multiple gift card coupons at once and upload them in bulk.
• Data Migration: Transfer gift card coupon data between WooCommerce stores or while migrating from other platforms.

To successfully import and export gift card coupons in your WooCommerce store, ensure the following:

1. Install WebToffee WooCommerce Gift Cards plugin to create and manage gift card coupons.
2. Install Order / Coupon / Subscription Export Import Plugin for WooCommerce to enable the import and export of gift card coupons.

Once the necessary plugins are installed and activated, follow the below-mentioned steps to export gift card coupons:

• Go to Gift Cards > General Settings > Export/Import from your WordPress dashboard, and click Export. Alternatively, head to WebToffee Import Export(Basic) > Export.

• Under the Export: Select a post type section, choose Coupon as the post type, and proceed to the next step.

In the Export Coupon: Select an export method section, choose Advanced export as your method, and proceed.

• In the Export Coupon: Filter data section, select Store credit as the coupon type to export only gift card/store credit coupons. Then, proceed to the next step.
• You can also apply additional filters, such as coupon status, price range, or expiration date, to narrow down your export.

• You can adjust the export columns by renaming or reordering them here. However, the default column settings are usually sufficient for most users.
• Once done, proceed to the next step.

• In the Export Coupon: Advanced options/Batch export section, configure the batch size and set your CSV file’s column separator (default is ,).
• Once configured, click Export.

• After the export is complete, you can download the CSV file containing the gift card coupons from your WooCommerce store.

Importing gift card coupons is just as easy as exporting them. Follow these steps to import gift card coupons into your WooCommerce store:

• Ensure your CSV file is correctly formatted with fields like post_title, post_excerpt, post_status, and other necessary details.
• If you are updating existing coupons, include an ID column. For new coupons, ensure the discount_type field is set to store_credit.
• If using a previously exported file, you can modify it before re-importing, such as updating expiration dates or coupon amounts.

• Go to Gift Cards > General Settings > Export/Import from your WordPress dashboard, and click Export. Alternatively, head to WebToffee Import Export(Basic) > Export.

• Choose Coupon as the post type under Import: Select a post type, and proceed to the next step.

• Under the Import Coupon: Select an import method section and choose Advanced import.
• Upload the CSV file that contains your gift card coupons.
• Choose the correct delimiter used in the file, typically a comma (,), and move to the next step.

• Map the columns in your CSV file to the coupon fields in your store. The plugin will automatically map columns if it detects matching header names. You can manually map any unmapped fields as needed.
• Once all the columns are mapped correctly, proceed to the next step.

In the Import Coupon: Advanced options section, you can update existing coupons or skip duplicates and set batch import count to avoid timeout issues.

After configuring these options, click Import.

Wait for the import to finish, and the gift card coupons will be added or updated in your store.