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

0 comments:

Post a Comment