To import vouchers, go to Sales > Vouchers from the Storefront module menu. Click on the Import link and upload the CSV file.
| Column |
Type |
Data required |
Description |
Example |
| Act |
String |
Yes |
Type of import action to perform (Insert = i, Delete = d) |
i |
| VoucherID |
Integer |
Yes/No |
Database object identifier. This value must be specified when performing a delete action. |
7 |
| AdminNotes |
String |
No |
Notes visible to store administrators only. |
|
| Amount |
Decimal |
Yes |
The balance amount currently available in the voucher. |
10.00 |
| AssignedUserID |
Integer |
No |
Optionally associate this voucher to a user such that only the registered is allowed to redeem the voucher. |
1401 |
| Code |
String |
Yes |
The voucher code must be a unique alphanumeric number (A-Z, 0-9). The code is treated as case-insensitive. |
A60PB98Z0L123 |
| CreateDate |
DateTime |
No |
|
|
| InitialAmount |
Decimal |
Yes |
The starting amount of the voucher when it was first created. |
25.00 |
| IssueDate |
DateTime |
Yes |
The date this voucher was initially issued. This date is used to determine the expiry date if the voucher definition determines there is an applicable expiration on this voucher. |
2013-01-01 00:00:00 |
| SalesOrderDetailID |
Integer |
No |
The SalesOrderDetailID that is associated with this voucher after the purchase is completed. You should leave this field blank when inserting new vouchers. |
|
| Status |
Integer |
Yes |
The status of this voucher. Inactive = 1, Active = 2, Hold = 3, Cancelled = 4 |
2 |
| UpdateDate |
DateTime |
No |
|
|
| VoucherDefinitionID |
Integer |
Yes |
The voucher definition object identifier associated with this voucher. The voucher definition is the template that determines how this voucher can be used. |
23 |