Import 5000 voucher codes to my PrestaShop

Hello, I just bought import coupon codes module and I want to upload about 5000 voucher codes in website.
My question is: How can I upload them via CSV file since your example have only 9 columna (code voucher name voucher desc value quantity quantity per user cumulable type email).

My vouchers should have all these information: 
1. Voucher name 
2. Voucher Code 
3. Highlight: No 
4. Partial use: No 
5. Status: Active 
6. Limit to a single customer: Yes 
7. Validity: from 1.09.2017 to 30.09.2017 
8. Minimum amount: 150 ron 
9. Total available: 1 
10. Total available for each user: 1 
11. Free shipping: No 
12. Apply a discount > Percent (%): 10 
13. Apply discount to.> Order (without shipping) 

Please tell me how to add all these information in CSV file in order to be recognized by your module. Thank you,

Import coupon codes (cart rules) to prestashop

Hello
generally speaking whole import process is based on 4 steps:
  1. prepare an upload CSV file, this is step where you pre-process the csv file with voucher codes you've got and upload it to your shop on module configuration page. .csv file can have these fields:
    - voucher code
    - voucher name
    - description
    - value
    - quantity
    - quantity per user
    - cumulable
    - cumulable reduction
    - date from
    - date to
    - minimal basket
    - currency id
    - partial use
    - id customer
    - customer email
    - free shipping
    You dont have to define all of them. If some required fields will be not available - module will use pattern of voucher code that you can define in step 3
  2. Define file settings. Uploaded .csv file - depending on environment where you saved it - can be saved with various environement-related settings.  These settings are related to file format.
    CSV file formats that use delimiter-separated values store two-dimensional arrays of data by separating the values in each row and column with specific delimiter characters.
    - Row delimiter Any character may be used to separate the lines in CSV file, but the most common delimiters are new line charcode (\n) or (\r)
    - Column delimiter Any character may be used to separate values, but the most common delimiters are comma (,) or semicolon (;)
  3. Define pattern of voucher settings
    Here you define the voucher settings pattern. These settings will be used if your CSV file will not have some of the columns with voucher settings.
  4. Import selected file
    This is the last step where you select what voucher codes from your csv file to import, define the column types. The result is import process of codes to shop database

Based on these informations - regarding to your case,
you can create csv file with one column that represents voucher code,
then in step 3 define all settings of code you want to import, you can set there all settings you mentioned.
Share on Google Plus

About VEKIA

This is a short description in the author block about the author. You edit it by entering text in the "Biographical Info" field in the user admin panel.
    Blogger Comment

5 comments:

  1. I wanna thanks to a great extent for providing such informative and qualitative material therefore often.Wix home page

    ReplyDelete
  2. What a Excellent post. I really found this to much informative. It is what i was searching for.I would like to suggest you that please keep sharing such type of info. Thanks for sharing such useful information.
    Actually I want to know about the website which provides high commission on Affiliate data feeds.I am new in affiliate marketing now i have a plan to build my own affiliate website and work as full time affiliate and earn income but don't want to work with affiliate networks. They eat lot of time and efforts that's why i am searching such kind of services which can provide me affiliate data on some commission share basis.
    I checked many websites but except one I didn't get any best website which offer handsome commission. On searching google I found a UK based website named as Revglue(.)com/bespoke which provides services of coupons site development/coupons site design.
    If you have any idea or experience about this website. Please share with me. This will help me. Keep sharing such a useful information

    Thanks in advanced

    James Adler

    ReplyDelete
  3. Immediately the following superb web-site will obviously irrefutably remain celebrated between a lot of crafting your site both males and females, for the reason that hardworking subject material and customer feedback. free psn codes

    ReplyDelete
  4. It is additionally a lot simpler to sort and record as you go,modcoupons as opposed to assault a gigantic heap of coupons at the same time.

    ReplyDelete