Page 4 of 4 FirstFirst ... 234
Results 31 to 40 of 40
  1. #31
    Join Date
    Jul 2012
    Posts
    99
    Plugin Contributions
    0

    Default Re: Discount coupon product restriction

    Oh, good idea. I'll try it right now.

  2. #32
    Join Date
    Jul 2012
    Posts
    99
    Plugin Contributions
    0

    Default Re: Discount coupon product restriction

    No change unfortunately.

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

    Default Re: Discount coupon product restriction

    And just to humor me ...

    If you compare your two configure.php files on the server in:
    /includes/configure.php
    /your_secret_admin/includes/configure.php

    are you using the same database on both?
    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!

  4. #34
    Join Date
    Jul 2012
    Posts
    99
    Plugin Contributions
    0

    Default Re: Discount coupon product restriction

    Yes, same data on both.

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

    Default Re: Discount coupon product restriction

    I cannot figure out why your Discount Coupons work this way ...

    You are sure when you check your Restrictions that you are on the right Discount Coupon?

    If you EDIT the Discount Coupon. what do you see in the URL for the cID= ...

    If you look in phpMyAdmin, and search the table:
    coupon_restrict

    for the coupon_id that has the same value, what comes up?
    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!

  6. #36
    Join Date
    Jul 2012
    Posts
    99
    Plugin Contributions
    0

    Default Re: Discount coupon product restriction

    Ok, I found where was the problem.

    When I made this coupon it was te first one and was made as a test. So I deleted it, then tried to create it back, or should I say, to create another one with the same name, which off course didn't work. I saw the thread where you explained to rename, than copy and rename the copy. It worked like a charm and played a little with this to get familiar with he manipulation. It ended with 2 inactive coupons: AT00111R and... AT00111, which has the exact same name as the active coupon. It appears that ZenCart was having hard time to differentiate the active and the inactive one and was showing the description of the inactive one which has no restriction, but was running the restriction associated to the active coupon. So I renamed the inactive one to AT00111R2, et voilą! Weird huh...

    But many many thanks for your help in this Ajeh! I really appreciated the time you gave me!! Best regards.

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

    Default Re: Discount coupon product restriction

    That is very weird ... thanks for hunting down the issue and for letting us know this is resolved ...
    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!

  8. #38
    Join Date
    Jul 2012
    Posts
    99
    Plugin Contributions
    0

    Default Re: Discount coupon product restriction

    Now that I found how to fix this, is there a way to copy the restriction to over 100 coupons without having to edit them one by one? Could I do that directly in the DB?

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

    Default Re: Discount coupon product restriction

    Not easily ...

    You could try to grab, via phpMyAdmin, the records for a valid Discount Coupon and then edit them with the next coupon_id and insert them ... but you are getting into some tricky edit/import and could make a real mess if you mess up ...

    Something like:
    Code:
    SELECT restrict_id, coupon_id, product_id, category_id, coupon_restrict FROM coupon_restrict WHERE coupon_id = '7';
    And you would get something like:
    Code:
    INSERT INTO coupon_restrict (coupon_id, product_id, category_id, coupon_restrict) VALUES
    (7, 0, -1, 'Y'),
    (7, 4, 0, 'N'),
    (7, 6, 0, 'N'),
    (7, 9, 0, 'N'),
    (7, 10, 0, 'N'),
    (7, 11, 0, 'N'),
    (7, 12, 0, 'N'),
    (7, 13, 0, 'N'),
    (7, 17, 0, 'N'),
    (7, 18, 0, 'N');
    then, do a global replace of:
    (7,

    with the next Discount Coupon coupon_id that needs the same restrictions, for example, Discount Coupon coupon_id 12:
    (12,

    to get:
    Code:
    INSERT INTO coupon_restrict (coupon_id, product_id, category_id, coupon_restrict) VALUES
    (12, 0, -1, 'Y'),
    (12, 4, 0, 'N'),
    (12, 6, 0, 'N'),
    (12, 9, 0, 'N'),
    (12, 10, 0, 'N'),
    (12, 11, 0, 'N'),
    (12, 12, 0, 'N'),
    (12, 13, 0, 'N'),
    (12, 17, 0, 'N'),
    (12, 18, 0, 'N');
    then import that ...

    Before attempting it, be sure to backup your whole table:
    coupon_restrict
    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. #40
    Join Date
    Jul 2012
    Posts
    345
    Plugin Contributions
    0

    Default Re: Discount coupon product restriction

    If it possible to restrict coupon if certain product is in cart or other discount in cart.
    Product restriction only work for that particular product but how can we restrict coupon to whole cart content if certain product is in cart or any other discount in cart.

 

 
Page 4 of 4 FirstFirst ... 234

Similar Threads

  1. Coupon restriction error
    By dre in forum Discounts/Coupons, Gift Certificates, Newsletters, Ads
    Replies: 7
    Last Post: 30 Jun 2011, 10:09 AM
  2. Discount Coupon Restriction by URL
    By CooksPlus in forum Discounts/Coupons, Gift Certificates, Newsletters, Ads
    Replies: 3
    Last Post: 16 Mar 2011, 05:47 PM
  3. Coupon Restriction
    By enzo-ita in forum General Questions
    Replies: 2
    Last Post: 29 Nov 2010, 09:28 AM
  4. Coupon restriction logic
    By dbrewster in forum Discounts/Coupons, Gift Certificates, Newsletters, Ads
    Replies: 3
    Last Post: 3 Jul 2006, 06:42 PM

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