Page 1 of 4 123 ... LastLast
Results 1 to 10 of 31
  1. #1
    Join Date
    Mar 2008
    Posts
    29
    Plugin Contributions
    0

    Default Bulk Coupons - Groupons, Living Social, etc.

    I've looked all over but can't seem to find a current answer (for the current 1.3.9 version) on gift certificates.

    We've been approached for a groupon sale and need to issue a bulk lot of gift voucher numbers. Any ideas on how to do this?

  2. #2
    Join Date
    Jan 2006
    Posts
    15
    Plugin Contributions
    0

    Default Re: Bulk Coupons - Groupons, Living Social, etc.

    We've got the same situation and they want us to import a .csv file to activate the gift certificate codes. Not sure if it can be done or not. Hopefully someone has the answer.

  3. #3
    Join Date
    Mar 2008
    Posts
    29
    Plugin Contributions
    0

    Default Re: Bulk Coupons - Groupons, Living Social, etc.

    Anyone? We can't be the only one's who've need of this!

  4. #4
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Bulk Coupons - Groupons, Living Social, etc.

    Gift Certificates are like cash and have NO expiration time ...

    Discount Coupons can have start and end times and limits on categories/products that they can be used for as well as how many times per user/coupon they can be used ...

    Are you giving away Gift Certificates for "cash" to your customers?

    Or, are you trying to give away Discount Coupons?
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  5. #5
    Join Date
    Mar 2008
    Posts
    29
    Plugin Contributions
    0

    Default Re: Bulk Coupons - Groupons, Living Social, etc.

    Quote Originally Posted by Ajeh View Post
    Gift Certificates are like cash and have NO expiration time ...

    Discount Coupons can have start and end times and limits on categories/products that they can be used for as well as how many times per user/coupon they can be used ...

    Are you giving away Gift Certificates for "cash" to your customers?

    Or, are you trying to give away Discount Coupons?

    Which ever is going to be the easiest to do. I don't need to put any limits on the codes. Essentially they need a block of codes to give to their customers who purchase the "30$ of product for $15" deal. So I guess it would be a GC for $30.

    Can I import a csv with 500 numbers into the zen_coupons file in the sql database (it shows both coupons and GC's in that file when I browse it) ? I didn't know if this would wipe out the exhisting coupons that were already living in that file.

  6. #6
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Bulk Coupons - Groupons, Living Social, etc.

    So you want to give 500 customers $30 each ... for Free ... correct?

    And, that $30, should never expire, correct?

    If so, then you need to add the 500 unique
    coupon_code

    to the table:
    coupons

    with the:
    coupon_type

    set to:
    G

    Now, if the Customer enters the Gift Certificate redemption code on your site, they will be credited with a $30.00 Gift Certificate balance that can be applied to ALL Products on your site, up to $30.00 of the charge ...

    Importing the file, unless you specifically write something to delete all of the existing records, will not affect them ...
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  7. #7
    Join Date
    Aug 2004
    Location
    New York City
    Posts
    7,174
    Plugin Contributions
    0

    Default Re: Bulk Coupons - Groupons, Living Social, etc.

    No, what they're really trying to do is sell a $30 coupon (or GV) for $15, but in bulk somehow.
    Mary Ellen
    I came; I saw; I Zenned
    Taking over the world... one website at a time
    Make sure brain is engaged before putting mouth in gear... or fingers to keyboard.

    Holzheimer
    Fan Odyssey

  8. #8
    Join Date
    Mar 2008
    Posts
    29
    Plugin Contributions
    0

    Default Re: Bulk Coupons - Groupons, Living Social, etc.

    Quote Originally Posted by Ajeh View Post
    So you want to give 500 customers $30 each ... for Free ... correct?

    And, that $30, should never expire, correct?

    If so, then you need to add the 500 unique
    coupon_code

    to the table:
    coupons

    with the:
    coupon_type

    set to:
    G

    Now, if the Customer enters the Gift Certificate redemption code on your site, they will be credited with a $30.00 Gift Certificate balance that can be applied to ALL Products on your site, up to $30.00 of the charge ...

    Importing the file, unless you specifically write something to delete all of the existing records, will not affect them ...

    what about:

    coupon_active
    y/n

    does it need to be set to y or n?

  9. #9
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Bulk Coupons - Groupons, Living Social, etc.

    coupon_active would need to be Y for Active ...

    Make sure that is a capital Y ...

    NOTE: Zen Cart is not setup of selling Gift Certificates at a discount, unless you mean walk up and down the street with a handful of Gift Certificate cards worth $30 that people can buy for $15 to then be used on the site ...

    NOTE: Discount Coupons cannot be used to purchase Gift Certificates either ...
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  10. #10
    Join Date
    Mar 2008
    Posts
    29
    Plugin Contributions
    0

    Default Re: Bulk Coupons - Groupons, Living Social, etc.

    Quote Originally Posted by afo View Post
    No, what they're really trying to do is sell a $30 coupon (or GV) for $15, but in bulk somehow.
    Quote Originally Posted by Ajeh View Post
    coupon_active would need to be Y for Active ...

    Make sure that is a capital Y ...

    NOTE: Zen Cart is not setup of selling Gift Certificates at a discount, unless you mean walk up and down the street with a handful of Gift Certificate cards worth $30 that people can buy for $15 to then be used on the site ...

    NOTE: Discount Coupons cannot be used to purchase Gift Certificates either ...
    Great. No, this is for a social media program. Deal of the day thing. They send the 'deal' out to their members to buy. Basically I'm getting exposure to their customers for the deal. It's usually a 50% off deal (I was just using the 30/15 as an example). Their customers buy the deal through them, they give you the portion of the deal you agreed with through them, the customer gets a 'code' to enter in on your website (thus the block of codes that I need to provide to them).

    This should be exactly what I need. Thanks!

 

 
Page 1 of 4 123 ... LastLast

Similar Threads

  1. v150 Fanplayr Social Coupons Support Thread
    By tarwinfanplayr in forum All Other Contributions/Addons
    Replies: 4
    Last Post: 27 Aug 2012, 07:32 PM
  2. Is there a way to upload coupons in bulk?
    By CartCrazy in forum Setting Up Specials and SaleMaker
    Replies: 2
    Last Post: 14 Feb 2011, 10:37 PM
  3. Support thread: Social Bookmarking/Social Shopping
    By swguy in forum All Other Contributions/Addons
    Replies: 100
    Last Post: 27 Oct 2010, 04:09 AM
  4. Social bookmarking - facebook etc
    By spottedhaggis in forum All Other Contributions/Addons
    Replies: 6
    Last Post: 13 Mar 2010, 03:50 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR