How to import voucher codes from external file

Anyone, who has started an advertising campaign in own online store knows, that voucher codes are awesome tool for increase sales and income. Very often we want to organize actions in other webpages like livingsocial, groupon, mydeal etc. and we get listed special codes form this sites.  Customer after buying there some stuff gets one idividual code from voucher codes list. We must add all of listed vouchers to our shop system, but there is a little problem: what to do when there are hundred of codes on list?
How does it looks in Prestashop system?
In prestashop we can generate one voucher code per one request. It’s problematic, because we spend much time in back office, only for adding voucher codes. Moreover, it is really tedious.  Simple measures say that the addition of about 100 discount codes with advanced specification take about 5 hours!  It’s ridiculous to spend 5 hours on adding a discount code in prestashop back office. All of this is by the fact that we can’t import voucher codes from files in Prestashop back office. But we create a special module:  Import Voucher from CSV  Our module can import a thousand codes listed in some file (CSV or other).
Ok, so how to import many voucher codes in prestashop?
First we need to describe the basic functionality of this module. Module Import Voucher Codes form CSV  is the simplest and quickest way to add as many voucher codes from CSV file as you want by one mouse click! Import Vouchers From CSV module saves your time which you can spend to make more money. If you want this module, go to  Import Vouchers from CSV   section in our shop. We guarantee your satisfaction with the choice of just this solution.

With Import Vouchers from CSV you can set up General CSV file settings:

  • setup the char for row delimiter (line)
  • setup the char for col delimiter (elements in line)

And you can set up default voucher settings:

  • setup the default voucher type (discount on order in % / amount, free shipping, etc.)
  • setup the default voucher currency (all currencies in your shop)
  • setup the default voucher value (in % / amount in selected currency)
  • setup the default voucher description (description will be displayed in customer basket)
  • setup the default voucher quantity
  • setup the default voucher quantity per user
  • setup the default value of voucher cumulable (with other voucher codes – true or false)
  • setup the default value of voucher cumulable (with price reductions – true or false)
  • setup the default minimal basket value, from which voucher code will be active
  • setup the default expiry date of voucher code
  • setup the categories to which the discount is to be applied
  • you can upload CSV file into server
  • upload as many CSV files as you want
  • manage uploaded files

And most important:

  • you can upload CSV file into server
  • you can import uploaded CSV file into prestashop voucher database
  • manage colls and rows in CSV file
  • selection of as many CSV file row as you want (row will be added to the database)
  • selection of as many CSV file cols as you want (cols define the voucher specification)
Live preview in back office:
login  :   test@vekia.pl  
Password  :   vouchers
Tutorial of adding many voucher codes in prestashop
In first step you must go to your prestashop back office into the modules section, exactly as shown in the picture:   
In Next step, you can see modules list page. Search module Import Voucher from CSV. If you can’t find module try to use search form, type there “Import Voucher”. If module exists, click odntooltip cloud with modules full name and icon. (Just like we shown on picture). If module doesnt exists you must to reupload it with module upload form. If you don’t have module Import Voucher from CSV, click here to go module product page.
After clicking on tooltip you can click “Configure” to go to the module back office. Modules back office section is a powerful tool for configuring the properties of codes, import files and add codes to your store. Now you can set up the CSV file settings. Type signs of delimiters in your csv file.
In next step configure the voucher properties. Remember that this is not necessary. You can always change these settings, even after loading the file.
 
 

Now you can upload CSV file or files (module supports multiple files too) with simple upload form:
after selecting file from disc and click submit, you will see new file in “Uploaded CSV files” section:
Of course you can manage uploaded files. You can delete them in anytime you want. To import voucher codes listed in file you must click “Import to database”. After click you will see simple configuration tool, where you can select or deselect vouchers. You can manage columns also. After all you can import vouchers to prestashop database.

Adding voucher codes in prestashop

In the “Vouchers” tab, you can give your customers discounts (by value or by percent) or offer free
shipping on their orders. Under this tab are all of the previously created vouchers, along with their
status of validity.

You can also enable/disable vouchers at the bottom of the screen.

Creating a New Voucher

Vouchers can be created automatically after a product return, but you can create a new voucher at any time manually, and be very specific about its properties.

  • Give it a unique code. You can either create one manually (and therefore use readable words, like 1VOUCH4JOE), or have PrestaShop generate one unique string by clicking the “New” button. Of course, you can also use another string generator (such as random.org’s). You can use up to 32 characters.
  • The “Type” field enables you to choose the method of the applied discount:
    • Discount on order (%). The voucher applies to a percentage of the order total. For instance, let’s say the order is valued at $200 before taxes. The voucher has a value of -15%. When applying this coupon the customer will only have to pay $170 before taxes.
    • Discount on order (amount). This choice is applied to a monetary discount on the entire order. For instance, let’s say the order is valued at $100 before taxes. The discount offers $20 off the purchase. By using the discount the customer pays only $80 before tax.
    • Free shipping. With this discount, you can treat your customers to free shipping. They can use the code when paying and it will apply to their offer.
  • Choose the voucher’s behavior – meaning how it should behave when the order’s amount is less that the voucher’s:
    • reduce the voucher to the total order amount: do this if you want vouchers to be used only once.
    • create a new voucher with the remaining amount: do this if your customers can use their voucher’s value for as long as it has some.
    • create a negative invoice: do this if you want vouchers to be used only once, but you still need to know the final value for your accounting book. The user won’t receive any kind of further voucher or discount.
  • Give it a proper description, in every languages that your shop supports (click on the flag to change language). Customers will be able to read this, so write a proper sentence.
  • Indicate which categories the voucher applies to – because sometimes you’d rather have customers not use vouchers for certain products.
  • Set a quantity of available vouchers: either “1” if it is intended for a single customer, or any number if the voucher is for whoever uses one first.
  • You can set the number of times a voucher can be used. That number must be at least equal to the quantity of available vouchers.
    • If that number is inferior to the total quantity of available vouchers, then one single customer won’t be able to use all of them.
    • Keeping it to “1” makes sure that each of your customers can only the voucher once. In that case, make sure the voucher applies to a group rather than a customer…
  • Set a minimum amount under which the voucher is not applicable. Your voucher will only be applicable if the customer’s order is above the given amount.
  • You can choose whether or not the vouchers are allowed to be used with other promotions on your products or other vouchers. Make your preferences known by ticking the checkboxes.
  • The “To be used by” field enables you to restrict your voucher to only one of your customers. For instance, if you had a delivery delay and you want to apologize, you can create a voucher for this customer that only he or she can access. To quickly find the customer, type in the first few letters of their First or Last name in the “Filter” field.
  • The voucher can have a time limit (for instance, a discount for launch week). Click the “From” and “To” fields in order to choose your dates using the calendar. By default, a new voucher lasts a year.
  • You can decide whether the voucher should be shown in the cart summary or not. Do this if you want to inform a customer that they can use a voucher. If you’d rather not push for the voucher’s usage, then do not show it.
  • Finally, the “Enable” field allows you to enable or disable the vouchers.

Once everything has been saved, you can send your voucher to your customers.

Your voucher will appear in the “Vouchers” tab, and you can delete or edit it at any time. If the voucher was set to a specific group or customer, then it will appear in the Front-Office, in the customer’s “Vouchers” section of his account:

…as well as in the cart (if you chose to), where they can choose which one to apply to their order:

Vouchers that are set to apply to all customers do not appear in these locations: the customer has to know about them in order to use them.

In order to apply the voucher, the customer needs to visit his cart and enter the voucher in the suitable field and click “Add”. The customer won’t be able to apply the voucher if he checks out immediately.

Once applied, the cart summary displays the voucher’s impact on the order’s amount:

Read how to import voucher codes from external file

Adding voucher in PrestaShop

1) Login Into your prestashop back office

Prestashop Back office, source: prestashop user guide

2) Go to payment section and Vouchers subsection

In the “Vouchers” tab, you can give your customers discounts (by value or by percent) or offer free shipping on their orders. Under this tab are all of the previously created vouchers, along with their status of validity.” Source: Prestashop User Guide

You will see something like that:
That is a list of voucher codes already defined in your shop. For first, check the Enable Vouchers, it must be set to Yes. If you want to turn off voucher codes in your shop, set this option to “No” 🙂

3) Adding a voucher code into your shop

For add new voucher, click “+ Add new” button.
you will see something like that:
  • Give it a unique code. You can either create one manually (and therefore use readable words, like 1VOUCH4JOE), or have PrestaShop generate one unique string by clicking the “New” button. Of course, you can also use another string generator (such as random.org’s). You can use up to 32 characters.
  • The “Type” field enables you to choose the method of the applied discount:
    • Discount on order (%). The voucher applies to a percentage of the order total. For instance, let’s say the order is valued at $200 before taxes. The voucher has a value of -15%. When applying this coupon the customer will only have to pay $170 before taxes.
    • Discount on order (amount). This choice is applied to a monetary discount on the entire order. For instance, let’s say the order is valued at $100 before taxes. The discount offers $20 off the purchase. By using the discount the customer pays only $80 before tax.
    • Free shipping. With this discount, you can treat your customers to free shipping. They can use the code when paying and it will apply to their offer.
  • Choose the voucher’s behavior – meaning how it should behave when the order’s amount is less that the voucher’s:
    • reduce the voucher to the total order amount: do this if you want vouchers to be used only once.
    • create a new voucher with the remaining amount: do this if your customers can use their voucher’s value for as long as it has some.
    • create a negative invoice: do this if you want vouchers to be used only once, but you still need to know the final value for your accounting book. The user won’t receive any kind of further voucher or discount.
  • Give it a proper description, in every languages that your shop supports (click on the flag to change language). Customers will be able to read this, so write a proper sentence.
  • Indicate which categories the voucher applies to – because sometimes you’d rather have customers not use vouchers for certain products.
  • Set a quantity of available vouchers: either “1” if it is intended for a single customer, or any number if the voucher is for whoever uses one first.
  • You can set the number of times a voucher can be used. That number must be at least equal to the quantity of available vouchers.
    • If that number is inferior to the total quantity of available vouchers, then one single customer won’t be able to use all of them.
    • Keeping it to “1” makes sure that each of your customers can only the voucher once. In that case, make sure the voucher applies to a group rather than a customer…
  • Set a minimum amount under which the voucher is not applicable. Your voucher will only be applicable if the customer’s order is above the given amount.
  • You can choose whether or not the vouchers are allowed to be used with other promotions on your products or other vouchers. Make your preferences known by ticking the checkboxes.
  • The “To be used by” field enables you to restrict your voucher to only one of your customers. For instance, if you had a delivery delay and you want to apologize, you can create a voucher for this customer that only he or she can access. To quickly find the customer, type in the first few letters of their First or Last name in the “Filter” field.
  • The voucher can have a time limit (for instance, a discount for launch week). Click the “From” and “To” fields in order to choose your dates using the calendar. By default, a new voucher lasts a year.
  • You can decide whether the voucher should be shown in the cart summary or not. Do this if you want to inform a customer that they can use a voucher. If you’d rather not push for the voucher’s usage, then do not show it.
  • Finally, the “Enable” field allows you to enable or disable the vouchers.
Once everything has been saved, you can send your voucher to your customers.

As you see, adding new voucher into your shop is very simple but it takes a lot of time…