Maximum Gift Certificate Amount

30 Sep 2006, 9:08 PM

#1

New Zenner

Join Date:: Sep 2006
Location:: Tabriz, Iran
Posts:: 10
Plugin Contributions:: 0

Maximum Gift Certificate Amount

Hello everyone. I am really in problem with GC amounts. As it seems, there is a maximum GC amount which doesn't let you send gc's more than 10,000 and any amount given more than that, appears as 10,000 . Ofcourse more than $10,000 is a little bit strange gift but as I use another currency, this amount means nothing. So I would like to ask if there is a maximum gc amount and if there is a way to modify it. I hope some one could help me.
Happy Zenning.

30 Sep 2006, 9:24 PM

#2

ajeh

Oba-san

Join Date:: Sep 2003
Location:: Ohio
Posts:: 62,757
Plugin Contributions:: 1

Re: Maximum Gift Certificate Amount

The settings on the tables coupon coupon_customer_gv and coupon_gv_queue for the amount is decimal(8,4) ...

These limitations could be causing you issues ...

1 Oct 2006, 12:53 PM

#3

hamed

New Zenner

Join Date:: Sep 2006
Location:: Tabriz, Iran
Posts:: 10
Plugin Contributions:: 0

Re: Maximum Gift Certificate Amount

I changed the values (8,4) but nothing solved. could you please check it yourself and let me know if you come with a conclusion?

1 Oct 2006, 1:04 PM

#4

ajeh

Oba-san

Join Date:: Sep 2003
Location:: Ohio
Posts:: 62,757
Plugin Contributions:: 1

Re: Maximum Gift Certificate Amount

In the Admin Tools ... Insert SQL Patch ... run this:

ALTER TABLE coupons CHANGE coupon_minimum_order coupon_minimum_order DECIMAL( 15, 4 ) NOT NULL DEFAULT '0.0000';
ALTER TABLE coupon_gv_customer CHANGE amount amount DECIMAL( 15, 4 ) NOT NULL DEFAULT '0.0000';
ALTER TABLE coupon_gv_queue CHANGE amount amount DECIMAL( 15, 4 ) NOT NULL DEFAULT '0.0000';

1 Oct 2006, 2:57 PM

#5

hamed

New Zenner

Join Date:: Sep 2006
Location:: Tabriz, Iran
Posts:: 10
Plugin Contributions:: 0

Re: Maximum Gift Certificate Amount

Tried what you said (changed both values to (15,4) ). But still not working for more than 10,000 . :schmoll:
I really hope we find a way soon. If anyone finds a solution, let us know.

1 Oct 2006, 3:00 PM

#6

ajeh

Oba-san

Join Date:: Sep 2003
Location:: Ohio
Posts:: 62,757
Plugin Contributions:: 1

Re: Maximum Gift Certificate Amount

What are your currency settings?

1 Oct 2006, 3:06 PM

#7

hamed

New Zenner

Join Date:: Sep 2006
Location:: Tabriz, Iran
Posts:: 10
Plugin Contributions:: 0

Re: Maximum Gift Certificate Amount

I use IRR (Iranian Rials) as my default currency and below you can see a screenshot which shows the settings.

1 Oct 2006, 3:11 PM

#8

ajeh

Oba-san

Join Date:: Sep 2003
Location:: Ohio
Posts:: 62,757
Plugin Contributions:: 1

Re: Maximum Gift Certificate Amount

I tested this on mine and sent a GV for 100,000.00 and that is working great ...

What version of Zen Cart are you using?

Clean install or an upgrade? If an upgrade from what version to what version and how did you upgrade your site?

1 Oct 2006, 3:16 PM

#9

hamed

New Zenner

Join Date:: Sep 2006
Location:: Tabriz, Iran
Posts:: 10
Plugin Contributions:: 0

Re: Maximum Gift Certificate Amount

I'm using version 1.3.5 and it is a clean install. The problem is surely with the currency. specially after I updated currency rates. before updating, I used to calculate amount with $ and assign them in $ but the amount would appear in default currency (IRR). But after update, any amount assigned, appeared in IRR. so I had to assign the exact IRR amount which exceeded 10,000 and then the problem occured.

1 Oct 2006, 3:18 PM

#10

ajeh

Oba-san

Join Date:: Sep 2003
Location:: Ohio
Posts:: 62,757
Plugin Contributions:: 1

Re: Maximum Gift Certificate Amount

Have you an URL to your site?

1 Oct 2006, 3:19 PM

#11

hamed

New Zenner

Join Date:: Sep 2006
Location:: Tabriz, Iran
Posts:: 10
Plugin Contributions:: 0

Re: Maximum Gift Certificate Amount

It is in beta phase, so I run it in my own computer (localhost) to test and then publish.

1 Oct 2006, 3:21 PM

#12

ajeh

Oba-san

Join Date:: Sep 2003
Location:: Ohio
Posts:: 62,757
Plugin Contributions:: 1

Re: Maximum Gift Certificate Amount

That makes it really hard to test this ... :cry:

1 Oct 2006, 3:23 PM

#13

hamed

New Zenner

Join Date:: Sep 2006
Location:: Tabriz, Iran
Posts:: 10
Plugin Contributions:: 0

Re: Maximum Gift Certificate Amount

I'm gonna upload it today. So, I will let you know. I hope we finally meet a solution.

1 Oct 2006, 5:18 PM

#14

ajeh

Oba-san

Join Date:: Sep 2003
Location:: Ohio
Posts:: 62,757
Plugin Contributions:: 1

Re: Maximum Gift Certificate Amount

Also add this change, I forgot 1 ...

ALTER TABLE coupons CHANGE coupon_amount coupon_amount DECIMAL( 15, 4 ) NOT NULL DEFAULT '0.0000';

1 Oct 2006, 5:32 PM

#15

hamed

New Zenner

Join Date:: Sep 2006
Location:: Tabriz, Iran
Posts:: 10
Plugin Contributions:: 0

Re: Maximum Gift Certificate Amount

woooooooooow. :yes:
It just worked great. Thanx. You're such a great man. :wink2:
Great contribution.

1 Oct 2006, 5:33 PM

#16

ajeh

Oba-san

Join Date:: Sep 2003
Location:: Ohio
Posts:: 62,757
Plugin Contributions:: 1

Re: Maximum Gift Certificate Amount

Woman ... that's great woman ... :smartass:

1 Oct 2006, 5:38 PM

#17

hamed

New Zenner

Join Date:: Sep 2006
Location:: Tabriz, Iran
Posts:: 10
Plugin Contributions:: 0

Re: Maximum Gift Certificate Amount

Sorry :blush: . Such a great woman.

1 Oct 2006, 5:50 PM

#18

ajeh

Oba-san

Join Date:: Sep 2003
Location:: Ohio
Posts:: 62,757
Plugin Contributions:: 1

Re: Maximum Gift Certificate Amount

Note: these fields will be updated in the next release for others with currencies similar to your's that may run across issues such as this ... :smile:

1 Oct 2006, 8:52 PM

#19

hamed

New Zenner

Join Date:: Sep 2006
Location:: Tabriz, Iran
Posts:: 10
Plugin Contributions:: 0

Re: Maximum Gift Certificate Amount

Happy to be a part of issues. Happier to be a part of solved issues. Most happy to be a part of next release.
:smartass: