Importing/exporting voucher codes in bulk
You can use the voucher code import system to create voucher codes in bulk. Voucher codes can also be edited in bulk by taking an export, editing the file, and uploading it back into the import system.
Creating new voucher codes
To create new voucher codes:
- Navigate to Discounts & offers > Vouchers
- Select
import - Select
download the import template - Use spreadsheet editing software to populate the template with the voucher codes you want to create (detailed below)
- Save the file as a file
- Select
importfrom the voucher codes page - Select the CSV file from your device's hard drive
- Select
import
Editing voucher codes in bulk
Editing voucher codes in bulk
To edit voucher codes:
- Navigate to Discounts & offers > Voucher codes
- Select
export - Select
prepare your export - Use spreadsheet editing software to edit the details of each voucher code, do not change the value in the Voucher ID column
- Save the file as a file
- Select
importfrom the voucher codes page - Select the CSV file from your device's hard drive
- Select
import
Voucher code import column definitions
Voucher code import column definitions
| Column Name | Description | Guidance/Instructions | Example Values |
|---|---|---|---|
| Voucher ID | Leave blank for new voucher codes, otherwise provide the unique ID of the voucher code | Leave this field empty when creating a new voucher. If updating an existing voucher, provide the unique ID, which can be obtained from an export of existing voucher codes | 123456 |
| Code | The code that users will input at checkout | Ensure the code is unique and not already in use by another voucher | 10OFF |
| Discount Type | Specifies the discount type | Choose from percent, amount, or shipping depending on the type of voucher code being created |
percent |
| Discount Value | The value of the discount | For percent or amount, specify the value of the discountFor shipping, indicate the discount valueEnter 0 for free shipping |
1014.950 |
| Valid From | The start date for the voucher's validity | Use DD/MM/YYYY format(or MM/DD/YYYY for US accounts) |
01/12/2024 |
| Expires On | The expiry date for the voucher | Use DD/MM/YYYY format(or MM/DD/YYYY for US accounts). Leave blank if the code should not expire |
31/12/2024 |
| Target Type | Determines which orders the code applies to | Leave blank for all orders Or enter orders_over, category, product, or product_sku for specific targets (specified in the target value column) |
orders_over |
| Target Value | The value related to the target type | Specify the minimum order value for orders_overThe ID(s) for category or productThe SKU code(s) for product_sku |
10012345SKU123 |
| Active | Indicates if the code is active | Choose Yes for active, No for inactive |
Yes |
| Uses Max | The maximum number of uses allowed for the voucher code | Leave blank if there is no maximum | 100 |
| Customer Uses Max | The maximum number of uses per customer | Leave blank if there is no maximum | 1, 5 |
| Comments | Internal notes about the voucher code | For internal use only, these comments are not available to website visitors and only recorded on the voucher code in your ShopWired account | |
| Shipping Rates | For voucher codes for specific delivery rates, enter applicable delivery rate IDs separated with a comma | Leave blank to apply to all delivery rates, or specify the IDs of applicable delivery rates by generating a | 123456, 123457, 123458 |
| Dynamic Amount | Indicates if the code applies to multiple quantities of the same product | Choose Yes or No.Applicable only for amount discount type |
Yes |
| Automatic | Indicates if the code should be applied automatically to the visitors' basket | Choose Yes for automatic application, No for manual entry |
No |
| Tags | Tags for internal reference | Separate multiple tags with a comma | summer, holiday |
| Excluded Products | Products to exclude from the voucher | Specify product IDs separated by commas and spaces, generate a to obtain product IDs | 123456, 123457 |
| Excluded Categories | Categories to exclude from the voucher | Specify category IDs separated by commas and spaces, generate a to obtain category IDs | 234567, 234568 |
| Delete | Marks a voucher for deletion | Include a 1 to delete the voucher code, else leave this blank |
1 |
