Discount Coupon Guide?!

[Ajeh]

Sounds like you have Admin Profiles installed and that this page has not been defined for your access ...

[lauriesscraps]

OK, I feel really stupid. I added a module for admin profiles. I thought because I was the admin, everything would stay the same. But my clearance was changed as to not allow me access to 3 module pages that I had installed but did give me access to everything else. Not sure why, I think it just reset to that when I installed the module. But thank you for having me check there. I should have thought of that on my own, but thank you for reminding me.

[Ajeh]

You are most welcome ... thanks for the update that you were able to fix the Admin Profiles permissions to get the proper security access to this section of code pages ...

[TicosUSA]

Thanks Ajeh, it worked. I created the coupon but didn't see it until I accesed modules > order totals > ot_shipping > edit and I set the Provide free shipping for orders over the set amount option to equal the amount of the coupon. Now it works beautifully just like any known brand e-store

[Ajeh]

Thanks for the update on how you got this working for you ...

[Craftystash]

Hi everyone

I am currently using version v1.3.9f.

As a promotional aspect to my site I offer discount coupons as prizes for a monthly competition. Is there any way I can offer a £10 discount coupon which the customer does not have to use in one transaction?

I would like somehow to be able to offer the voucher, and if say the customer used £4 of that voucher the remaining £6 would still be redeemable at a later date.

I apologise if this question has already been answered, I have read through all of these posts and the FAQ but am not really getting very far in the process.

Any help or advise would be greatly appreciated, thanks so much for taking the time to read my post

[Ajeh]

Discount Coupons are for a specific Amount or Percentage or Free Shipping ...

Discount Coupons are setup to then be used by a number of times per Discount Coupon, or unlimited, and a number of times per customer, or unlimited, and then for a date range ...

There isn't a setting to give a $10.00 Discount Coupon where it can be used like a balance ...

Gift Certificates, on the other hand, are a balance, as they are "cash" and never expire ...

However, Gift Certificates have a limit of being for a specific customer and then can be used on an order in total or in part and can also be sent in total or in part to another person ...

NOTE: While Discount Coupons can expire ... Gift Certificates never expire ...

[Craftystash]

Thank you so much Ajeh - I really appreciate your reply

Guess I've been looking for something that can't be done, so at least now I can just forget the idea

Thanks again

[cmallenfln]

I am using version 1.3.8a

I have never been able to create a coupon. The module is installed. But the top of that page appears to contain an error message and no option to edit or create.

I tried uninstalling the module and reinstalling. The problem has existed for a long time. We did several upgrades thinking it would go away but this particular items remains.

The "error" reads
1054 Unknown column 'coupon_zone_restriction' in 'field list'
in:
[select coupon_id, coupon_code, coupon_amount, coupon_type, coupon_start_date,coupon_expire_date,uses_per_user,uses_per_coupon,restrict_to_p roducts, restrict_to_categories, date_created,date_modified, coupon_active, coupon_zone_restriction from zen_coupons where coupon_active='Y' and coupon_type != 'G' limit 0, 5]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields

So that gives me the impression that at some point a coupon was attempted and failed but now there appears to be no way to fix it or move on to create a new one.

[Ajeh]

NOTE: that you are using a very old version of Zen Cart that has since been updated with all of the Known Bug Fixes from:
http://www.zen-cart.com/forum/showthread.php?t=82619

and Security Patches and Updates:
http://www.zen-cart.com/forum/showthread.php?t=131115

and more in the current version of Zen Cart (v1.3.9h) from our Home page ...

Was this a Clean install of v1.3.8 or an Upgrade?

What do you see in the Tools ... Server Info ... on the Zen Cart version information and Database Patch list ...