WPSyncSheets For WooCommerce

Documentation

Import WooCommerce Coupons with WPSyncSheets For WooCommerce plugin

If users want to create or update multiple coupons codes at once, adjust discount values, or manage usage limits in bulk, they need to import coupons. It speeds up the process, ensures consistency, and avoids repetitive setup tasks within WooCommerce.

How to Import Coupons?

Step 1

Navigate to WPSyncSheets > For WooCommerce > Coupon Settings and enable the Coupon Settings option.

Coupon Settings

Step 2

Click “Create New Spreadsheet” and give a name of your spreadsheet or “Select Existing Spreadsheet

Google Spreadsheet Settings

Step 3

Find and enable the Import Coupon option and after enabling the import coupons you will see three options.

Find Enable Import Coupon

Step 4

Enable/Disable the options insert/update/delete as per your requirement and Save Settings.

Enable Import Coupons

Step 5

Enabled options will be displayed in the Sheet headers.
You can Enable/Disable the sheet headers as per your requirement.

Sheet Headers

Step 6

After that in Google Spreadsheet Settings click on View Spreadsheet.

View Spreadsheets

Original Spreadsheet

Original Spreadsheets

Insert Coupons


Step 1

Enable Insert to import your desired data and click on save settings.

Enable Insert Coupon

Step 2

Enable/Disable the sheet headers as per your requirement and click on Save.

Sheet Headers

Step 3

After you save the settings you will have the “Insert” column in your connected Google Spreadsheet parallelly Import Coupon option in the settings page.

Insert Google Sheet

Step 4

Leave the Coupon ID column blank (WPSyncSheets plugin will create a new one).

In the same row, under the “Coupon Code” column, enter your desired coupon code.
Coupon Code is mandatory. If it’s missing, the coupon will not be added.

Fill in the required details. Go to the Insert column and type “1” in the row you want to create a new coupon.

Insert Column Google Sheet

Step 5

Click on Import Coupons.

Insert Import Coupon

Step 6

Now, you will have the Proceed option, click on it.

Insert Proceed Coupon

Final Spreadsheet

Final Spreadsheets

Update Coupons

Step 1

Enable Update button to update your desired data.

Update Coupon


Step 2

Enable/Disable the sheet headers as per your requirement and click on Save.

Sheet Headers

Step 3

After you save the settings you will have the “Update” column in your connected Google Spreadsheet parallely Import Coupon option in the settings page.

Update Google Sheet

Step 4

Make the changes you want and in the Update column of that row, type “1”, to update a particular column.

Update Column Sheet


Step 5

Click on the Import Coupon button to apply the updates.

Update Import Coupon

Step 6

Now, you will have the Proceed option, click on it.

Update Proceed Coupon

Final Spreadsheet

Final Spreadsheets

Delete Coupons

Step 1

Enable the Delete button to update your desired data and click on save.

Delete Coupon

Step 2

Enable/Disable the sheet headers as per your requirement and click on Save.

Sheet Headers

Step 3

After you save the settings you will have the “Delete” column in your connected Google Spreadsheet parallely Import Coupon option in the settings page.

Delete Google Sheet

Step 4

In the Delete column of that row, type “1”, to delete a particular column.

Delete Column Sheet

Step 5

Click on Import Coupon

Delete Import Coupon

Step 6

Now, you will have the Proceed option, click on it.

Delete Proceed Coupon

Final Spreadsheet

Final Spreadsheets

Real-Time Import, Export, and Migration of WooCommerce Data.

WPSyncSheets For WooCommerce

5.0
View Plugin

Have a question?

We’re here to help, just send us a message.

Need help?

We're ready to help out & answer questions!