How to Import csv gift codes?


  • Default avatar
    walko7    
     12 years ago
    0

    Hi,

    The component works great!
    But now i need to import some gift certificate codes.
    Insert coupon codes with a csv file, was not a problem.
    But i don't now how to import the gift certificate codes.
    I become errors by importing. (not enoughe collums to .....)
    Can you tell me how much collums you need in the csv file, and wich are these collums?

    I use Joomla 2.5.4 and AwoCoupons Pro 2.0.6

    Thanks,
    Walko
  • Your avatar
    seyi    
     12 years ago
    0

    Hi Walko,

    The file format is listed on the imports page and it requires the first 8 columns. The easiest way to get a valid csv import is to go to reports, run the coupon list and export it.
  • Default avatar
    walko7    
     12 years ago
    0

    Hi Seyi,

    Sorry, but maybe i'm doing something wrong.

    These are the fields i have in the csv-file.
    If i use these fields with import, coupons. That works.

    ~ID, Couponcode, Gepubliceerd, Functie Type, Functie Type 2, Percentage of bedrag, Kortingstype, Waarde, Waardedefinitie, Aantal gebruikt, Aantal gebruikt, Minimum waarde, Aanvangsdatum, Verloopdatum, Klanten, Klanten, Eigenschap, Eigenschap, Eigenschap 2, Eigenschap 2, Sluit speciale produkten uit, Sluit cadeaubonprodukten uit, Admin commentaar, Klanten, Eigenschap, Eigenschap 2


    But if i use the first 8 colums ( ~ID, Couponcode, Gepubliceerd, Functie Type, Functie Type 2, Percentage of bedrag, Kortingstype, Waarde) by Giftcards, codes, import, then i become errors.

    The csv-input is:
    1 SuperSportDeal01 actief Coupon Produkt Bedrag Specifiek 30

    These are the errors:
    ID: 1;SuperSportDeal01;actief;Coupon;Produkt;Bedrag;Specifiek;30
    -- Niet genoeg kolommen om te verwerken

    ID: 2;SuperSportDeal02;actief;Coupon;Produkt;Bedrag;Specifiek;30
    -- Niet genoeg kolommen om te verwerken

    and that for all the ID's.

    But do i wrong??

    Gr. Walko
  • Your avatar
    seyi    
     12 years ago
    0

    by default csv uses comma as the delimiter. So it is seeing "1;SuperSportDeal01;actief;Coupon;Produkt;Bedrag;Specifiek;30" as one column. Go to awocoupon->configuration and change the csv delimiter to ";".