Jump to content
Vger

[CONTRIBUTION] CCGV (trad)

Recommended Posts

I am thinking about installing this contribution, but before doing so I have a question to all those who have already installed it:

 

Does CCGV allows the customer to use more than 1 Discount Voucher on the same purchase?

Can I limit it to allow only one?

 

 

Thanks in advance.

 

 

P.S.

Can any of you post a link to a store which uses this contribution?

Share this post


Link to post
Share on other sites

Hey cafri,

 

I asked this question of Vger just the other day. The short answer is that as it stands, a customer can only apply a single voucher to a particular purchase.

 

Cheers,

Max

 

I am thinking about installing this contribution, but before doing so I have a question to all those who have already installed it:

 

Does CCGV allows the customer to use more than 1 Discount Voucher on the same purchase?

Can I limit it to allow only one?

Thanks in advance.

P.S.

Can any of you post a link to a store which uses this contribution?

Share this post


Link to post
Share on other sites
Hey cafri,

 

I asked this question of Vger just the other day. The short answer is that as it stands, a customer can only apply a single voucher to a particular purchase.

 

Cheers,

Max

OK, great. I'll try to install it later today.

Hope I won't have difficulties.

Share this post


Link to post
Share on other sites

Hi everybody,

 

First, I'd like to thank Vger for this contribution. This is the only one I could install easyly after having tried installing classic CCGV contribution v5.1x.

 

Few things are not functional yet and I don't understand why :

 

When a customer has a gift voucher balance, it can indefinitely use this balance ( when "Tick to use Gift Voucher account balance" is checked) !! It seems there's no delete or update in the database concerning the gift voucher linked to the customer.

 

The balance can be reset to zero only in the following case : when the customer decides to send its balance to anyone else via email.

 

Do you have any idea ?

 

Much thanx in advance

Share this post


Link to post
Share on other sites

Gday from Oz-tralia!

Thanks heaps for this amazing contrib - I made a real mess trying to get the other CCGV to work & then found this THANKYOU Rhea!

 

I have one issue that I'm sure is simple but I just can't figure it.

 

The discount code seems to work except when a customer selects Paypal (I have the latest Paypal IPN) where it ignores the discount & charges the customer full price.

 

I have noted that in the install of CCGV(trad) there is some notes on IPN / CCGV manual edits to the /includes/modules/payment/paypal_ipn.php file.

I have started to do this - but stopped as it seems to be written (maybe) for an older IPN?

 

The reason I thought this is because the 2nd piece that is meant to be edited doesn't exist in the file from the IPN install. The piece of code I refer to is:

 

find this code:
//------insert customer choosen option eof ----
       $total_weight += ($order->products[$i]['qty'] * $order->products[$i]['weight']);
       $total_tax += tep_calculate_tax($total_products_price, $products_tax) * $order->products[$i]['qty'];
       $total_cost += $total_products_price;

       $products_ordered .= $order->products[$i]['qty'] . ' x ' . $order->products[$i]['name'] . ' (' . $order->products[$i]['model'] . ') = ' . $currencies->display_price($order->products[$i]['final_price'], $order->products[$i]['tax'], $order->products[$i]['qty']) . $products_ordered_attributes . "\n";
     }

and below add this:
$order_total_modules->apply_credit();// CCGV

 

 

 

Can anyone help getting the order total to work?

 

THANKS in advance... Adam

Share this post


Link to post
Share on other sites

I would like to manually enter gift voucher codes rather than have them generated when sending an email. The reason for this is because I have actual gift cards that have numbers on the back to use to redeem. They are randomly generated as well and cannot change them (they are already paid for...)

 

Now, in order to properly use these with customers, I need to be able to enter these codes as the redeem codes. Is that possible? So far I have found that with CCGV(trad) the coupon code is automatically generated at line 42 in admin/gv_mail.php:

 

$id1 = create_coupon_code($mail['customers_email_address']);

 

I found it calls to admin/includes/add_ccgvdc_application_top.php:

 

function create_coupon_code($salt="secret", $length=SECURITY_CODE_LENGTH) {
$ccid = md5(uniqid("","salt"));
$ccid .= md5(uniqid("","salt"));
$ccid .= md5(uniqid("","salt"));
$ccid .= md5(uniqid("","salt"));
srand((double)microtime()*1000000); // seed the random number generator
$random_start = @rand(0, (128-$length));
$good_result = 0;
while ($good_result == 0) {
$id1=substr($ccid, $random_start,$length); 
$query = tep_db_query("select coupon_code from " . TABLE_COUPONS . " where coupon_code = '" . $id1 . "'"); 
if (tep_db_num_rows($query) == 0) $good_result = 1;
}
return $id1;
}

 

Is there a way to just use a text box and input the coupon code I want to use? I am by far no programmer, but this system is so simple to use thanks to all of the contributions and great support!

 

Thanks!


Jesse Rooney

Share this post


Link to post
Share on other sites

Hiya all,

 

 

Installed as per Installation note, Started a Complete fresh install, and then a manual install, but no matter what i try i get the following error:

 

Discount Coupons Status : Active CouponsInactive CouponsAll Coupons  

Coupon Name Coupon Amount Coupon Code Action  
1146 - Table 'mydbase_osc1.TABLE_COUPONS' doesn't exist

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 from TABLE_COUPONS where coupon_active='Y' and coupon_type != 'G'


 

I have looked on my Php panel/sql and the Table Coupons does exist any help PLEASE????

Share this post


Link to post
Share on other sites
Hiya all,

Installed as per Installation note, Started a Complete fresh install, and then a manual install, but no matter what i try i get the following error:

 

Discount Coupons Status : Active CouponsInactive CouponsAll Coupons  

Coupon Name Coupon Amount Coupon Code Action  
1146 - Table 'mydbase_osc1.TABLE_COUPONS' doesn't exist

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 from TABLE_COUPONS where coupon_active='Y' and coupon_type != 'G'


 

I have looked on my Php panel/sql and the Table Coupons does exist any help PLEASE????

 

Did you by chance miss the step of importing the SQL file included in the package? You have insert those tables into mysql, try using phpmyadmin if it is installed on your server. use the import function and browse to that sql file.


Jesse Rooney

Share this post


Link to post
Share on other sites
Did you by chance miss the step of importing the SQL file included in the package? You have insert those tables into mysql, try using phpmyadmin if it is installed on your server. use the import function and browse to that sql file.

 

 

As i said on the bottom of that message... the Tables do exist in PHPmyadmin

 

I am really stumped

Share this post


Link to post
Share on other sites
As i said on the bottom of that message... the Tables do exist in PHPmyadmin

 

I am really stumped

 

 

I found the problem..... it is looking for 'mydbase_osc1.TABLE_COUPONS' when mine is 'eoghan_osc1.TABLE_COUPONS' ... any clue where i can configure the right dbase name??

Share this post


Link to post
Share on other sites
I found the problem..... it is looking for 'mydbase_osc1.TABLE_COUPONS' when mine is 'eoghan_osc1.TABLE_COUPONS' ... any clue where i can configure the right dbase name??

nope not that.. argh i am lost

Share this post


Link to post
Share on other sites

Hi,

I've got a problem with CCGV(trad) and my 2checkout.com module.

I was running the pm2checkout payment module (http://addons.oscommerce.com/info/5343) before and it worked fine and dandy.

 

After installing CCGV(trad) the 2checkout module sends the wrong URL to 2checkout.com (it seems to send the whole product page in the URL-bar).

 

Does anyone know what could be wrong? :blink:

 

Thanks for reading.

Share this post


Link to post
Share on other sites

Hello,

 

Does anybody have an example of this contribution so I could see how it looks and functions? I just want to make sure its what I need before I install it.

 

Thanks.

Share this post


Link to post
Share on other sites

Hi Everyone :D

 

First of all Rhea ... you are an absolute genius ... thank you, thank you so much for a FANTASTIC contribution. After months of late nights, sifting through contributions, adding fixes, installing and uninstalling more times than I care to remember I've finally got it right. Its working on my version of RC1, but also not without the help of the fixes mentioned here by Scott olsonsp4c. Thank You Scott for sharing that with all of us.

 

I also got the same error on the create-account.php file and applied the fix you mentioned by commenting out the following:

 

//	  $insert_id = tep_db_insert_id($insert_query);

 

To the others that have also managed to get the CCGV(trad) successfully installed on RC1 , I do however have one very small problem and was wondering if any one else is experiancing the same. if so any ideas on how to fix this would be appreciated.

 

On the coupon_admin.php page, after adding discount coupons, I find that the coupon name is not updating. Its not really making any difference to the operation of the module but if I could get it fixed, I'd be happy.

 

Again I say a heartfelt thank you to Rhea for all the time an effort that has been put into creating the module and for the many hours spent answering posts here in the forum and all the time spent trying to meticulously put to gether all the install notes. To everyone else that has contributed to this terrific module Thank You. :thumbsup:


Rose

The strong survive BUT the best succeed !!

1064 - You have an error in your SQL syntax

Share this post


Link to post
Share on other sites
Hi Everyone :D

 

First of all Rhea ... you are an absolute genius ... thank you, thank you so much for a FANTASTIC contribution. After months of late nights, sifting through contributions, adding fixes, installing and uninstalling more times than I care to remember I've finally got it right. Its working on my version of RC1, but also not without the help of the fixes mentioned here by Scott olsonsp4c. Thank You Scott for sharing that with all of us.

 

I also got the same error on the create-account.php file and applied the fix you mentioned by commenting out the following:

 

//	  $insert_id = tep_db_insert_id($insert_query);

 

To the others that have also managed to get the CCGV(trad) successfully installed on RC1 , I do however have one very small problem and was wondering if any one else is experiancing the same. if so any ideas on how to fix this would be appreciated.

 

On the coupon_admin.php page, after adding discount coupons, I find that the coupon name is not updating. Its not really making any difference to the operation of the module but if I could get it fixed, I'd be happy.

 

Again I say a heartfelt thank you to Rhea for all the time an effort that has been put into creating the module and for the many hours spent answering posts here in the forum and all the time spent trying to meticulously put to gether all the install notes. To everyone else that has contributed to this terrific module Thank You. :thumbsup:

 

Yes matge I have the same issue - says BOX_FEATURED or something - don't know a fix I just put up with it!

Share this post


Link to post
Share on other sites

Hello,

 

I have the install complete but I cannot locate the Gift Voucher Queue in admin - I have looked behind every link ... can you give me a hand?

 

Thanks

 

mcclaura

Share this post


Link to post
Share on other sites

Hi there,

I've installed CCGV(trad)_1_2_3_4_5_6_7_8_9_10_11 and run the SQL file on a new install. Then I've added Gift Vouchers to my catalog. However, when someone purchases a gift voucher, it is not in the Queue for me to release. What am I missing?

 

Karen

Share this post


Link to post
Share on other sites

Hi,

 

I was reading about how to use gift vouchers

But if you have redeemed a Gift Voucher and it's in your account and you want to spend part or all of it on your own purchases then you just tick the box next to Redeem and then click Redeem.

I can't seem to find this tick box. Im not seeing any error messages either. Any suggestions or what code is responsible for the checkbox and session variables so I can try to debug?

Share this post


Link to post
Share on other sites

I'm still looking for suggestions on why my gift vouchers once purchased are not appearing in the queue list for me to release... anyone?

Share this post


Link to post
Share on other sites

Hello there,

 

I am in the middle of setting up my new online shop: and I am looking for a voucher/coupon system.

 

I have been looking at Credit Class & Gift Voucher 5.19 as an option. I have already modified my shop a little to reflect that I am in the UK, etc.

 

I am a complete begin at OS Commerce, PHP and MySQL/phpMyAdmin.

 

I would appreciate it if anyone could give me any pointer for installing this software and also its capabilities and limitations. I have looked at the INSTALL instructions which came with the download and I get stuck on...

 

STEP 1) Install the sql file on your mysql database using phpmyadmin or other software. (as long as there are no errors you are good to continue)

 

Any help would be much appreciated.

 

Mark.

Edited by Jan Zonjee

Share this post


Link to post
Share on other sites
Hi,

 

I was reading about how to use gift vouchers

 

I can't seem to find this tick box. Im not seeing any error messages either. Any suggestions or what code is responsible for the checkbox and session variables so I can try to debug?

 

Have you redeemed them in admin? If you've purchased them as porducts from the shop you need to redeem them from admin, after that you'll be in a position to use them at checkout.


Upon receiving fixes and advice, too many people don't bother to post updates informing the forum of how it went. Until of course they need help again on other issues and they come running back!

 

Why receive the information you require in good faith for free, only to then have the attitude to ignore the people who gave it to you?

 

There's no harm in saying, 'Thanks, it worked'. On the contrary, it creates a better atmosphere.

 

CHOOCH

Share this post


Link to post
Share on other sites
Hello there,

 

I am in the middle of setting up my new online shop and I am looking for a voucher/coupon system.

 

I have been looking at Credit Class & Gift Voucher 5.19 as an option. I have already modified my shop a little to reflect that I am in the UK, etc.

 

I am a complete begin at OS Commerce, PHP and MySQL/phpMyAdmin.

 

I would appreciate it if anyone could give me any pointer for installing this software and also its capabilities and limitations. I have looked at the INSTALL instructions which came with the download and I get stuck on...

 

STEP 1) Install the sql file on your mysql database using phpmyadmin or other software. (as long as there are no errors you are good to continue)

 

Any help would be much appreciated.

 

Mark

Use the same format you used to add the .SQL file that came with your oscommerce. Whatever means you used to upload or add the oscommerce.SQL file to your database is the same whay you add the ccgv SQL file

Edited by Jan Zonjee

Upon receiving fixes and advice, too many people don't bother to post updates informing the forum of how it went. Until of course they need help again on other issues and they come running back!

 

Why receive the information you require in good faith for free, only to then have the attitude to ignore the people who gave it to you?

 

There's no harm in saying, 'Thanks, it worked'. On the contrary, it creates a better atmosphere.

 

CHOOCH

Share this post


Link to post
Share on other sites
Use the same format you used to add the .SQL file that came with your oscommerce. Whatever means you used to upload or add the oscommerce.SQL file to your database is the same whay you add the ccgv SQL file

 

 

Hi there,

 

Thank you for your reply. OSC was auto-installed onto the host server...so I don't know how it was done.

 

Mark.

Share this post


Link to post
Share on other sites

Hi guys...

 

Does anyone know how I can do the following:

 

1. remove Gift Voucher FAQ from the navbar

2. re-route all existing links to GV_FAQ to my standard FAQ page (which will include Gift Voucher FAQs)

 

I know there are several pages on which links to GV_FAQ are listed. After I remove Gift Voucher FAQ from the navbar, I will obviously need to re-route existing links. Does anyone know off-hand which pages I would need to edit?

 

As you can see, my php knowlege is quite limited. I am trying to learn everything I can about osc, but I am still pretty new. I normally pay an osc specialist to help, but I am trying to accomplish all I can on my own.

 

Thanks (in advance) for your patience, guys! ;)

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×