Revindex Storefront


Last updated on 2020-06-02 2 mins. to read

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





Powered by Revindex Wiki