Credit Class/Gift Vouchers/Discount Coupons 5.10

[oscommerceking]

oscommerceking ,

 

That?s not to good :'( , I would suggest you are missing some code as this is the first time I have heard of this problem. Here is a few pointers :-

 

(I think) All account updates us the code in

\includes\add_ccgvdc_application_top.php

\includes\modules\order_total\ot_gv.php and the reduction is in apply_credit()

 

This should then be called just before the checkout email is send in checkout_process.php around line 335 with

$order_total_modules->apply_credit();//ICW ADDED FOR CREDIT CLASS SYSTEM

 

HTH

 

Si.

 

 

THREE CHEERS :thumbsup: :thumbsup: :thumbsup:

 

$order_total_modules->apply_credit();//ICW ADDED FOR CREDIT CLASS SYSTEM

 

Was missing from my checkout_process.php file

 

Funny thing was i didnt have installation instructions i went through each modded file and implemented the modifications that were in each of the new gv files, must have left this out.

 

You've saved me a great deal of anguish thanks again

 

Cheerio

 

Jon

[brochad]

Hello,

Hopefully someone has the easy fix for this...

 

It looks like my discount code is not discounting the whole order total, but only the shipping.

 

Flat Rate (Best Way): $1.00

Discount Coupons:SHIFT_ca: -$0.20

Sub-Total: $3.50

Total: $4.30

 

I imagine that it is a matter of changing the way the dicount is assessed. Any halp would be most appreciated.

 

Chad

[scranmer]

Hello,

Hopefully someone has the easy fix for this...

 

It looks like my discount code is not discounting the whole order total, but only the shipping.

 

Flat Rate (Best Way): $1.00

Discount Coupons:SHIFT_ca: -$0.20

Sub-Total: $3.50

Total: $4.30

 

I imagine that it is a matter of changing the way the dicount is assessed. Any halp would be most appreciated.

 

Chad

 

 

Chad,

 

To gain help on this you will need to at least post some information about the setup of your order_totals, there sequence and the voucher you have created otherwise it will be pure guess work.

 

Si.

[Guest]

I have a strange problem with the email that is sent to the user. Basically it inserts the message and you have received text from the store twice, does anyone know why this is? I have searched the forums for the past hour looking for the answer but it appears no one else seems to be having this problem :(

 

Here is a copy of the email they receive. (i have taken out blank lines)

Store Name

 

----------------------------------------------------------------------------------------

 

, You have received a store name Gift Voucher value ?10.00

 

----------------------------------------------------------------------------------------

 

This Gift Voucher has been sent as a gift to you by senders name

 

With a message saying

 

Hello, billy@email address

 

To redeem your store name Gift Voucher please click on the link below. Please also print this message or write down the redemption code which is 000000000. In the event of any problems.

 

To redeem please click http://www.sitename.co.uk/mine/gv_redeem.p...v_no=fa9e319fb1

<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>

storename

 

----------------------------------------------------------------------------------------

 

, You have received a store name Gift Voucher value ?10.00

 

----------------------------------------------------------------------------------------

 

This Gift Voucher has been sent as a gift to you by senders name

 

With a message saying

 

Hello, billy@email address

 

To redeem your store name Gift Voucher please click on the link below. Please also print this message or write down the redemption code which is 00000000. In the event of any problems.

<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>

If you have any problems redeeming your Penlan Perennials Gift Voucher using the automated link above, you can also enter the Gift Certificate code during the checkout process at our store.

 

I have surrounded the repeated part with

<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>

[brochad]

Thank you for your patience... I am running "Credit Class/Gift Voucher/Discount Coupons 5.10b Author: Ian Wilson, Updated for MS2." I imagine that in one of my OT files I can change the order when the voucher takes effect.

 

chad

 

 

 

 

Chad,

 

To gain help on this you will need to at least post some information about the setup of your order_totals, there sequence and the voucher you have created otherwise it will be pure guess work.

 

Si.

[scranmer]

I have a strange problem with the email that is sent to the user. Basically it inserts the message and you have received text from the store twice, does anyone know why this is? I have searched the forums for the past hour looking for the answer but it appears no one else seems to be having this problem :(

 

Here is a copy of the email they receive. (i have taken out blank lines)

I have surrounded the repeated part with

<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>

 

hotnuts (I cannot believe I just typed that),

 

checkout_process.php around line 345 is where that email is built it the variable $email_order and I suspect you will have somewhere (maybe at the end or in the call to tep_mail) $email_order .= $email_order. Check and work backwards from the tep_mail call

 

HTH

 

Si.

[Guest]

HI Scranmer,

 

The email is actually sent from gv_send.php, its when the buyer sends a gift voucher to the recipient not the standard gv order email.

 

This is the set of code that compiles and sends the gv to the recipient, about lines 68-89

 

        $gv_email = "\n" .
             EMAIL_SEPARATOR . "\n" .
             sprintf(EMAIL_GV_TEXT_HEADER, $currencies->format($HTTP_POST_VARS['amount'])) . "\n" .
             EMAIL_SEPARATOR . "\n" . 
             sprintf(EMAIL_GV_FROM, stripslashes($HTTP_POST_VARS['send_name'])) . "\n";
     if (isset($HTTP_POST_VARS['message'])) {
       $gv_email .= EMAIL_GV_MESSAGE . "\n";
       if (isset($HTTP_POST_VARS['to_name'])) {
         $gv_email .= sprintf(EMAIL_GV_SEND_TO, stripslashes($HTTP_POST_VARS['to_name'])) . "\n\n";
       }
       $gv_email .= stripslashes($HTTP_POST_VARS['message']) . "\n\n";
     } 
     $gv_email .= sprintf(EMAIL_GV_REDEEM, $id1) . "\n\n";
     $gv_email .= EMAIL_GV_LINK . tep_href_link(FILENAME_GV_REDEEM, 'gv_no=' . $id1,'NONSSL',false);
     $gv_email .= "\n\n";  
     $gv_email .= EMAIL_GV_FIXED_FOOTER . "\n\n";
     $gv_email .= EMAIL_GV_SHOP_FOOTER . "\n\n";;
     $gv_email_subject = sprintf(EMAIL_GV_TEXT_SUBJECT, stripslashes($HTTP_POST_VARS['send_name']));             
     tep_mail('', $HTTP_POST_VARS['email'], $gv_email_subject, nl2br($gv_email), STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS, '');
   }
 }

Edited November 5, 2005 by hotnuts21

[faris10]

Anyone can tell me hoe to use thius contribution. I installed it and I get the next error

1146 - Table 'heatandc_p_os1.TABLE_COUPONS' doesn't exist

 

select coupon_code from TABLE_COUPONS where coupon_id=''

 

[TEP STOP]

[scranmer]

faris10,

 

Check you are not missing the filename definition from inc/add_ccgvdc_application_top.php or the require of this file from application_top.php

 

 

hotnuts,

 

That code all looks fine to me HOWEVER noticed this

$gv_email .= EMAIL_GV_SHOP_FOOTER . "\n\n";; <----(double semi colon)

dont think it would cause your problem (since it does not on my windows system) but it is at the right level to cause the results you are seeing.

 

 

HTH

 

Si.

Edited November 7, 2005 by scranmer

[Giacomo79]

Somebody has the english traduction for the "ot_gv.php" file pls?

 

For these lines for the precision:

... ('Inclure taxe', 'MODULE_ORDER_TOTAL_GV_CREDIT_TAX', 'false', 'Voulez-vous ajouter la taxe sur le chèque cadeau ?'...);

Thanks

[scranmer]

Somebody has the english traduction for the "ot_gv.php" file pls?

 

For these lines for the precision:

... ('Inclure taxe', 'MODULE_ORDER_TOTAL_GV_CREDIT_TAX', 'false', 'Voulez-vous ajouter la taxe sur le ch?que cadeau ?'...);

Thanks

 

Try these

 

ot_gv

define('MODULE_ORDER_TOTAL_GV_TITLE', 'Gift Vouchers');

define('MODULE_ORDER_TOTAL_GV_HEADER', 'Gift Vouchers/Discount Coupons');

define('MODULE_ORDER_TOTAL_GV_DESCRIPTION', 'Gift Vouchers');

define('SHIPPING_NOT_INCLUDED', ' [shipping not included]');

define('TAX_NOT_INCLUDED', ' [Tax not included]');

define('MODULE_ORDER_TOTAL_GV_USER_PROMPT', 'Tick to use Gift Voucher account balance -> ');

define('MODULE_ORDER_TOTAL_GV_BALANCE_OWING', '(This would leave you with a balance owing of ?%s )');

define('MODULE_ORDER_TOTAL_GV_BALANCE_REMAINING', '(This would leave you with a voucher balance of ?%s )');

define('TEXT_ENTER_GV_CODE', 'Enter Redeem Code ');

define('MODULE_ORDER_TOTAL_GV_TEXT_ERROR', 'Gift Voucher/Discount coupon');

 

 

& ot_coupon

define('MODULE_ORDER_TOTAL_COUPON_TITLE', 'Discount Coupons');

define('MODULE_ORDER_TOTAL_COUPON_HEADER', 'Gift Vouchers/Discount Coupons');

define('MODULE_ORDER_TOTAL_COUPON_DESCRIPTION', 'Discount Coupon');

define('SHIPPING_NOT_INCLUDED', ' [shipping not included]');

define('TAX_NOT_INCLUDED', ' [Tax not included]');

define('MODULE_ORDER_TOTAL_COUPON_USER_PROMPT', '');

define('ERROR_NO_INVALID_REDEEM_COUPON', 'Invalid Coupon Code');

define('ERROR_INVALID_STARTDATE_COUPON', 'This coupon is not available yet');

define('ERROR_INVALID_FINISDATE_COUPON', 'This coupon has expired');

define('ERROR_INVALID_USES_COUPON', 'This coupon could only be used ');

define('TIMES', ' times.');

define('ERROR_INVALID_USES_USER_COUPON', 'You have used the coupon the maximum number of times allowed per customer.');

define('REDEEMED_COUPON', 'a coupon worth ');

define('REDEEMED_MIN_ORDER', 'on orders over ');

define('REDEEMED_RESTRICTIONS', ' [Product-Category restrictions apply]');

define('TEXT_ENTER_COUPON_CODE', 'Enter Redeem Code ');

 

Si.

[ps05]

Hello everybody,

 

Can someone tell me, how I could move the description text from the backend from the sql database into a language file? I need to have the backend in 3 languages (english, german and french), but as I have noticed the description texts get filled into the database. Where must I change the code and how, so that I can make language files for the descriptions (e.g. define)?

 

Thanks a lot for your answers and best regards,

 

Pascal

[faris10]

faris10,

 

Check you are not missing the filename definition from inc/add_ccgvdc_application_top.php or the require of this file from application_top.php

hotnuts,

 

That code all looks fine to me HOWEVER noticed this

$gv_email .= EMAIL_GV_SHOP_FOOTER . "\n\n";; <----(double semi colon)

dont think it would cause your problem (since it does not on my windows system) but it is at the right level to cause the results you are seeing.

HTH

 

Si.

It still doesnt work for me. I'm installing a new Os commerce in new store. Can you tell me the steps so I make that work. I looked in the installation file, for some reason did not work for me .Thanks

[scranmer]

It still doesnt work for me. I'm installing a new Os commerce in new store. Can you tell me the steps so I make that work. I looked in the installation file, for some reason did not work for me .Thanks

 

faris10,

 

...MAKE A BACKUP OF YOUR FRESH OSC...

 

Go to http://www.oscommerce.com/community/contributions,282

 

Start by reading and following "Notes for new install of CCGV"

 

If this is too technical then download and run "Use this to easily install CCVG 5.14" by Jessman on 7 Aug 2005. This exe will install on top of a fresh (windows) osc. If this is not happy point the install to a BLANK directory then go through and drop each item it creates into the correct osc folder overwriting the osc file (There are a few minor bugs that this has but nothing that affects the CCGV basics).

 

We are trying to create another more stable release but time is precious.

 

HTH

 

Si.

[♥akmac]

When I enter the code on the payment page, the message "The coupon code has been successfully applied for" shows up (I'm guessing it should read "The coupon code has been successfully applied for XX% off your purchase") but on the confirmation page, the discount hasn't been applied.

 

If I enter the coupon code and hit "redeem" again, then it will actually apply, but the confirmation text is still wrong. Anyone fixed this?

 

I read this whole thread to get me Gift Vouchers to work, now this...

[scranmer]

When I enter the code on the payment page, the message "The coupon code has been successfully applied for" shows up (I'm guessing it should read "The coupon code has been successfully applied for XX% off your purchase") but on the confirmation page, the discount hasn't been applied.

 

If I enter the coupon code and hit "redeem" again, then it will actually apply, but the confirmation text is still wrong. Anyone fixed this?

 

I read this whole thread to get me Gift Vouchers to work, now this...

 

Akmac,

 

Dont think so but you have to be carefull, I think I had a quick look at it and if I remember right this and a few other messages are used for voucher & coupon discounts for % and value discounts.

 

Si.

[♥akmac]

Akmac,

 

Dont think so but you have to be carefull, I think I had a quick look at it and if I remember right this and a few other messages are used for voucher & coupon discounts for % and value discounts.

 

Si.

 

 

You're right, i looked in the language file ant it doesn't specify that it should show the percentage off-so I just changed the text a bit to fit.

 

Now, what about the coupon not applying unless I enter it and redeem it twice?

[molafish]

akmac,

check your sort order as explained in the install instructions for 5.13 Full Package by Rigaden.

And also check that the order has met any minimum dollar amount limitations which you specified for that coupon.

 

Until the code gets fixed to give an error for that case, it will continue to act as you are witnessing.

[♥akmac]

akmac,

check your sort order as explained in the install instructions for 5.13 Full Package by Rigaden.

And also check that the order has met any minimum dollar amount limitations which you specified for that coupon.

 

Until the code gets fixed to give an error for that case, it will continue to act as you are witnessing.

My sort order is:

 

Discount Coupons 9

Gift Certificates 740

Shipping 2

Sub-Total 1

Tax 3

Total 900

Customer Discount 899

 

There is no minimum for the coupon, and it does apply-just not the first time you try.

[molafish]

When you apply the coupon the first time, does it show this under the shopping cart info box?

 

Coupon : more info

[scranmer]

akmac,

 

As molafish stated check to see if it appears at the bottom of your shopping cart info box the first time you type it in. I have rearanged my order totals to be the same as yours (although I dont have Customer Discount 899) and I do not get this problem so I would say you are missing part of the mod.

 

The coucher field gets held in a variable called gv_redeem_code, this is then processed in includes/modules/order_total/ot_gv.php & ot_coupon.php so I woud start by rechecking these 2 programs.

 

HTH

 

Si.

[scranmer]

All,

 

After lots of comments about this, I have just uploaded a fix for the redeem message here.

Dont forget to read the README.TXT!!!

 

Akmac,

 

Check my version of ot_coupon.php against yours, hopefully this will help you find your error.

 

HTH

 

Si.

Edited November 9, 2005 by scranmer

[faris10]

faris10,

 

...MAKE A BACKUP OF YOUR FRESH OSC...

 

Go to http://www.oscommerce.com/community/contributions,282

 

Start by reading and following "Notes for new install of CCGV"

 

If this is too technical then download and run "Use this to easily install CCVG 5.14" by Jessman on 7 Aug 2005. This exe will install on top of a fresh (windows) osc. If this is not happy point the install to a BLANK directory then go through and drop each item it creates into the correct osc folder overwriting the osc file (There are a few minor bugs that this has but nothing that affects the CCGV basics).

 

We are trying to create another more stable release but time is precious.

 

HTH

 

Si.

 

OKay , I went back and read everything. How do I add the .SQL File ?

[scranmer]

Same way you did when you setup oSC. If you had it set it up with your hosting then hopefully they will also provide access to your db from your control panel via something like phpmyadmin. Alternatively you can download dbtools, set that up and use it to ?import? the SQL file.

 

HTH

 

Si.

[Guest]

Scranmer,

I deleted the whole section and re-wrote it, it works fine now, although I cant see where it went wrong. That double ;; i had spotted but it didnt seem to make much difference.

 

Go figure!

Thnkx anyway.

 

A tip for anyone else I changed this

tep_mail('', $HTTP_POST_VARS['email'], $gv_email_subject, nl2br($gv_email), STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS, '');

 

to this

tep_mail('', $HTTP_POST_VARS['email'], $gv_email_subject, $gv_email, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS, '');

 

I removed the nl2br, because the tep_mail function already does this. So all my emails had double <br> in the HTML versions. However I also altered the tep_mail function so it replaces with <br /> too.

Edited November 9, 2005 by hotnuts21