Your Store Gift Cards (plastic, etc) - not working yet?

Hello!

I'm new here to the forums, but have been reading like mad and using the helpful tips to configure my install and so far I'm LOVING zen cart! :D
This particular contribution looks really great too! http://www.zen-cart.com/downloads.php?do=file&id=718

I've installed a few contributions so far and had no problems, but I've just downloaded this one - Your Store Gift Cards (plastic, etc) - which was just added to the downloads section on 5/26/08 and am having some issues.

I didn't see a support thread for this yet and if I've violated some rules or etiquette about this, feel free to flog me for it! lol

I've also sent an e-mail detailing all this to the creator, but until I hear back, I thought I'd see if there's a solution. I'll also repost when I get a response, of course.

When I was on step "C" of the directions (Login to the admin panel and navigate to Modules->Order Total and click on the new giftcard module.):

When I clicked on order totals, I did not see the new gift card module, but instead had this error right above the list of modules:

Parse error: syntax error, unexpected T_STRING, expecting T_OLD_FUNCTION or T_FUNCTION or T_VAR or '}' in /includes/modules/order_total/ot_giftcard.php on line 62

I'm still feeling my way around php, but I rock at internet searches, so I found a way to correct the code (I think!)

I had to change line 62 from this:

public $title;

to this:

var $public_title;

and line 69 from this:

public $output;

to this:

var $public_output;

After making those changes to those 2 lines, the module was visible in the order totals section and I installed it, leaving all information at the defaults (as recommended per the installation instructions).

Then, continuing on, I reached step "F" of the directions (Now navigate to Tools->Gift Card Manager to begin inserting gift card numbers and settings specific to individual cards. This is also where you activate, lock, and edit card-specific settings.), but when I clicked on Tools->Gift Card Manager, I saw this error above the mostly blank page:

1146 Table 'xxx.giftcards' doesn't exist in: [select count(*) as total from giftcards] 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. (I've removed my database name from the above and replaced it with the "xxx" for security reasons)

There is a row of what looks like headers for the gift cards (gift card code - gift card face value, etc.) but nothing else and no buttons or anything.

The other contributions I've used had sql patches to apply, so I'm wondering if a file was missing maybe?

Any advice? Thanks in advance!! :smile:

Gardenbath,

 I was able to re-create the errors you encountered and repaired the bug that was preventing the db table from installing.  I also submitted an updated version (1.1 - 6pm CDT) that should be available on the download page within a day or so.

 Also included is a changelog.txt file that shows the file structure for easier debugging on your system.

 Although I did not recieve your email, thank you for posting this bug and bringing it to my attention.

Please note however, that changing the names of the variables will break (as in your post) the script that your customers access on their checkout page unless you rename all occurences of these variables throughout the script.

Best regards,

T Zinni

Wow, that's fantastic news and terrific turnaround too! Thank you so much for your efforts! :clap:

I'll keep an eye out for the update and re-download and do a fresh install - I'm sure that will do the trick. I'll be sure to keep you posted if I run into any issues, of course.

Thanks again! :D

I’ve been considering using pre-printed Gift Cards since I can have them made inexpensively, but till now it was complicated to do so easily, to so this sound really interesting.

Could you just clarify something for me, from looking through the Readme file I’m trying to understand if these numbers are completely separate from the now existing GV’s or if you just added the functionality to add the card number, amount, activation manually.

Ref:
Allow assignment of card to a particular customer (defeats purpose of "gift") - although you may use initial order # to track purchaser

Would this mean that if a customer A buys a card for customer B , the store issues it, ships it, and then customer B registers on the site he cannot enter the gift card number in the redeem GV and add it to his/her account?

And would this:
“A text box group is displayed on the checkout page just below the coupon group”
Mean that there is one more gift card text box with the module? Or is it using the existing one?

Thanks
nev

nev,

 This module does not interact with the gift voucher/certificate modules of zen-cart as those are for virtual "coupons".  They operate by creating a virtual card, emailing the number or virtual certificate to the customer, and then tying those to the customers account.

 I offer plastic gift cards with pre-printed numbers on them (like you would purchase at Wal-Mart, Target, etc.) that customers can purchase from my brick-and-mortar store and give to friends or relatives as gifts to later make purchases only at my store.  I needed to extend this functionality to my website to extend my customer base but neither zen-cart, oscommerce, or similar shopping cart systems offered this ability, so I created it and released the code as so many other merchants posted similar scenarios.

 To address your questions specifically:

1. "I’ve been considering using pre-printed Gift Cards since I can have them made inexpensively" - this module will allow you to do exactly this.

2. "I’m trying to understand if these numbers are completely separate from the now existing GV’s " - yes.

3. "if you just added the functionality to add the card number, amount, activation manually" - yes. The card information is stored in a new database table completely separate from other zen-cart information. You can find the table in your database as "giftcards".

4. "Allow assignment of card to a particular customer (defeats purpose of "gift") - although you may use initial order # to track purchaser

Would this mean that if a customer A buys a card for customer B , the store issues it, ships it, and then customer B registers on the site he cannot enter the gift card number in the redeem GV and add it to his/her account? " - No.
The card number is not bound to the purchaser. The card is tracked by its card number where the card number is the account number. For example, Aunt Betty buys two gift cards on your website and plans to give one to her neice Susie and keep the other for herself. At this point, Aunt Betty's invoice will show she purchased two gift cards but no numbers will be issued. Next you choose two cards from your stock, login to the Gift Card Manager and activate the two numbers, then ship the cards to Aunt Betty.
Aunt Betty gives one away but decides to make another purchase with the card she kept. When she reaches the checkout page, there will be a new entry box that allows her to enter a gift card number. She types in the number and the page will then check that the card exists in your database, that it has been activated, and retrieve the account balance (in the background - not visually) that may be applied to her order. After she confirms her order, the card account is debited and is reflected on her invoice where the card number is masked.
Now when Susie uses her card, she follows the same process. Aunt Betty never sees the information from Susie's transaction, nor does she have access to it.

5. "“A text box group is displayed on the checkout page just below the coupon group”
   Mean that there is one more gift card text box with the module? Or is it using the existing one?" - a new (and separate) entry box is provided for these gift cards.

Hope this information helps.

T Zinni

just a note - hope you don't mind the long, detailed post...I tend to be a bit retentive! Hopefully these notes will help everyone else though!

OK, for all those interested, I forgot to add the link yesterday. It has already been updated, so you can get it here:

http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=1024

I downloaded and did a fresh install. I found that I still had to make these changes as I noted in my original post - to the file includes/modules/order_total/ot_giftcard.php:

line 62 from this:

public $title;

to this:

var $public_title;

line 69 from this:

public $output;

to this:

var $public_output;

...otherwise the module doesn't show up in your admin panel to install at all (modules - order total) and the error shows up as I noted in the first post.

After making the changes to these 2 lines and making NO other changes, the module shows up available for install, which I did.

Now, I went to tools - gift card manager and it appears to be fully functional now, so the OTHER updates that were made fixed the database problem. :clap:

This will be an AMAZING contribution - one that will (hopefully) allow me to avoid gift certificates altogether!! As much as I love Zen Cart, I HATE the gift certificate system! lol

My next post will be my testing results...

OK, the updated files are available for download and so I've done that and done a re-install.

After re-uploading all the new files, I still go the same error I had in my first post in admin --> modules --> order total and so I still had to change the following lines in the file includes/modules/order_total/ot_giftcard.php:

line 62 from this:

public $title;

to this:

var $public_title;

line 69 from this:

public $output;

to this:

var $public_output;

After doing that, I was able to install the module, just as in my first post. This time, however, when I went to admin --> tools --> gift card manager - everything's working just fine! So, the updates that were made to the database did the trick!

I made NO OTHER changes to the files, but without making those changes noted above, I could not install the module. Please note, that if you have this same issue I did (see post #1), then try this and it should work!

Thanks so much to nzinni for the quick response time on the bug and what I know will be a great mod! :clap:

I've pulled out a gift card to use as a tester, so my next post will be all my test results. :)

OK, I'm THRILLED with this contribution, everything's working just as it should! Here are my notes (sorry this is a bit long - I tend to be retentive, but I'm hoping my notes will help others!)

TESTING

There aren't instructions on how exactly to use the module once it's installed, but it seems pretty self-explanatory.

SETUP CARD IN SYSTEM
Still in your admin screen --> tools --> gift card manager

1. You have to create a gift card in the system by clicking on the "insert" button. You then enter the gift card code from the back (or wherever it shows up on your card), the dollar value of the card, and you have the option of applying a zone restriction (which I did not). To finish, click the "insert" button.

If it worked, you'll see this message at the top of your admin screen: Gift Card Successfully Created! This gift card was successfully created.

2. **VERY IMPORTANT! ** You now need to unlock the card for use by the customer or your customer will get an error message while checking out (ask me how I know! lol). To do this, just select the gift card you just created and click the "unlock" button. The next screen will ask you to enter the "sold on order #" - enter the order # where you actually sold the gift card to someone (I had to make one up as I hadn't actually sold this yet and it seems to work). To finish, click the "unlock" button.

It the card is activated, you'll see this message at the top of your admin screen: Activation Successful! This gift card was successfully activated.

REDEMPTION OF CARD BY CUSTOMER
Now I'm going to log-in as a test customer, add an item to my cart (I did 2 tests - one order with an item that was less expensive than my gift card total and one that was more than the gift card total).

1. Go to checkout as normal and on the "payment method" screen, there's a nice boxed section right under the discount coupon section:

2. Enter gift card in box as requested. ALSO, per the contribution notes, your customer MUST select a payment method besides the gift card, even if the gift card will pay for the entire order. Maybe a little tweaking may be in order to show this message to the customer - I'll try that later. Anyway, entered gift card and checked the payment method "check / money order" and finished checkout just fine.

NOTES
When I went to "my account" as the customer right after placing the orders and viewed the orders, I could see that the gift card paid for the order (whether entirely or partially).

UPDATE BALANCE OF CARD - done automatically
Back in your admin screen --> tools - gift card manager , I was thrilled to see that the gift card balance was now reduced by the order, all automatically! :clap::clap:

SETTINGS

One of the options you can change is whether the gift card numbers are "masked" like credit cards are - ex. default is set to mask and show only the last 4 numbers of the gift card.

On your admin screen --> modules - order total, click on the gift card module you can change this:

Reveal # Char (-1 = all)
The number of card number digits revealed on invoice

Mask Char
Set the printed character used to mask digits

Mask Digits
Mask card number digits on customer invoice.

true
false

There are also several other options:

• to set up taxes (include, recalculate, tax class, add tax to gift card when purchased)
• to determine whether the gift card pays for shipping or not
• to choose the order status for orders made where Gift Card covers full payment (pending, processing, etc)

OTHER GIFT CARD TOOLS

In your admin --> tools - gift card manager, there are several other things you can do with the gift cards:

• lock - this deactivates the card and it removes all other options, so don't do this unless you really mean it. If you needed to reactivate that particular card, you may be able to add it again - I haven't tested this.
• reset - you can add more money to the gift card - only up to the gift card original face value.
• price manager - you can actually update the face value of the card. Would be good if you already sold a card to a customer and they want to add more money - you won't have to send them another card, just update the one they currently have.

SUMMARY

Absolutely AMAZING contribution!!! :clap:

I love Zen Cart, but really can't stand the gift certificate system (sorry, guys) - it's too clumsy and there are too many potential confusing issues for the customer. Now I can just do regular gift cards and all my issues are resolved!

A huge big thanks to T Zinni for this contribution (I'll send a more useful thank you soon $$$)! :D

T Zinni,

Thanks for the explanation. I was trying to understand how it worked and interacted with the rest, and this helped.

Well since this stated here I guess I’ll continue here.

the zen cart GV doesn't have to be e-mailed to the customer and tied to the customer account.

Ok example what I did this last Christmas:

We were doing some live person to person sales promos for the holiday season.

I wanted to be able to offer Gift Cards as a product for sale and also to give clients that purchased over a certain amount a 10$ store gift card as a gift/bonus, redeemable on the site. Those gifts had the additional purpose to bring clients that purchased from us in person to the online store. Great idea, pain in the :censored: to do.

Since the option to input physical gift cards didn’t exist at the time. (your mod now :D) What I did was use the Mail Gift Certificate option in the admin to e-mail a certain amount of 10$ cards to the admin, and a certain amount of other pre determined values 25, 50, 100.

I then had those numbers that came in the e-mail to the admin, printed on the cards with the amounts.

It's a pain to do it this way. But at the time it was the only option. Additionally, all the cards that I had with me, had to be kept secure like cash since they were already issued and only needed to be redeemed.

However those GV numbers are not assigned to a particular customer until used/redeemed, they sit in the gift card sent list as not redeemed.

Anyone who has the right GV code in their hand, whether it’s the customer I sold it to or whoever they gave it to can/did use them.

So the present GV set up can handle those unassigned cards numbers. What it can’t handle from the admin is the manual input of the GV number.

When I started looking into having the cards with numbers pre-printed, to avoid possible conflict with online issued cards I was going to have them with 2 extra digits then the e-cards, I realized that the only way to get a preprinted number to “work” was to issue the GV in the right amount to the admin again, then use phpMyAdmin to change the GV number in the table to the one already on the card. In short possible but too complicated.

However, the “only” thing that is really needed to make this work elegantly from the admin stand point is the admin interface with the present GV’s.

A place where instead of sending a GV with an e-mail to the admin, you can take a preprinted card, enter the amount and card number, and “activate” it.

Once the client has the card they can redeem the card using the same GV module, (assigning it to their account before hand or at the point of purchase) without a need for 2 entry fields for Gift Cards on the check out page.

By the same principle you can sell these preprinted cards online under a different product code then GIFT, so as a physical product. There would be no e-mail to the customer and the card number/amount would only be “assigned” to the final recipient.

This would also make 2 things possible, they would be able to know the balance of their Gift Card in the My Accounts and since the present GV is already set up it would solve the “issue” of needing an alternate method of payment even if the Gift Card amount is enough.

I know the module is done as is already, and you probably have it working on your store just as you like it :D and I DO appreciate it, since it does give me an option to add something I wanted to the store. So don’t bite for the above, it’s just a thought. To make it simpler for the customer and for the 2 to work as one, for anyone who wants/needs to use both. E-cards are great for last minute emergencies. :D

just a though
nev

Great idea to combine the modules in use like that, nev! :D

I'm actually wondering if there isn't a way to create your own gift card codes that could be e-mailed to customers and still redeemed using this great mod.

I know there's software out there that generates the card numbers for the companies who create & print the plastic gift cards, so why couldn't we find some software and create our own codes...then e-mail the unique code to the customer and have them redeem the "virtual" gift card using this mod?

I've seen password generators and license generators, so there must be a software to make random codes like this, right?

I may look into this idea more, but would there be any downsides or security risks to this that I just can't think of?

TheGardenBath:

Great idea to combine the modules in use like that, nev! :D
thank you :D

but what i'm proposing is actually a lot simpler. it uses the present built in GV, and only adds the admin functionality to enter and "activate" the number for preprinted "plastic" card and the ammount the person purchased.

I have manually changed this GV number in the table directly. So I know it can be done.

Nothing changes in the functionality of the present GV system.

I'm actually wondering if there isn't a way to create your own gift card codes that could be e-mailed to customers and still redeemed using this great mod.
<snip> why couldn't we find some software and create our own codes...then e-mail the unique code to the customer and have them redeem the "virtual" gift card using this mod?

There is no need for any of that. That is ALL already built into the base functionality of Zen Cart into the original GV.

It creates random GV codes, e-mails them to the customer, they can redeem it through the built in GV redeem text box, in the My Accounts or on check out.

That would make this mode recreate what the built in GV does. So no need. Just use the original GV system if it’s a virtual card.

4. "Allow assignment of card to a particular customer (defeats purpose of "gift") - although you may use initial order # to track purchaser
   T Zinn didn’t quite understand my question there I think.

I was asking if the card once it is received by the gift recipient can be assigned to his/her account not the original purchaser.

And the fact that the e-card Gift Certificate number is originally assigned to the person that bough it is also irrelevant.

Aunt Beth buys an e-card GV. Decides to give it or part of the amount of it to Susie. She enters her account, finds that the store approved her GV purchase and clicks the ‘Send GV’. She completes her message to Susie, determines the amount of the GV she wants to send. She could have bought a 50$ e-card Gift Certificate but only wants to give Susie 20$, the other 30 she might want to send to Susie’s mom for her b-day in a month, or use it herself.

Now when Susie receives the e-mail with her Gift Certificate number, it is a different number then the one Aunt Beth received. Aunt Beths total GV balance is deducted for the amount she sent and the new number that Susie received is again sitting as Not Redeemed. Meaning its not connected to any particular client account. Once Susie redeems the card its now connected to her account. She can now use it or send it to someone else.

She could have decided that she didn’t even want to redeem it. And without ever redeeming the GV, give the GV code she received to her friend Melanie. And Melanie could be the one to redeem it. As I said, once it’s sent, before its redeemed it belongs to no one.

Where T Zinn said:

Aunt Betty never sees the information from Susie's transaction, nor does she have access to it.

She doesn’t see it with the present built in GV system either, its Susie’s account and Aunt Beth has NO access to it. The moment you send a GV to someone the cart reissues a new number (you don’t see this new number, just the recipient does) for the amount you sent. The new GV number does not need to be approved in the admin like the original purchase since it’s only a “transfer”.

Now here is the difference, if you run an online store and want to offer the physical Gift Certificate to send to your customers, or even like me if you want to additionally offer them to be purchased at live “events” 1-2 times a year then this solution is what you need. You don’t need to track the physical Gift Certificates separately. Actually you don’t want to.

However if you are in the situation like T Zinn then the module he designed is perfect.

He has both an online and brick-and-mortar store. The card has to be redeemable at both. If you can only track the amounts spent on a card if it’s redeemed by a customer in your online store then he would not be able to serve these customers in his brick-and-mortar store. So for that situation tracking Gift Cards through the number only with no possible association to a customer is exactly what he, or anyone to whom the online store is an extension of their brick-and-mortar store, needs/wants. The present GV system, even if you could enter the GC number manually would not work.

And as I said earlier it’s a great mod, and loads of people have been looking for it.

nev

This mod sounds wonderful. I downloaded and installed it with no trouble, created and unlocked a card number, etc. All worked well till I got to checkout. I entered the card number, chose a secondary option in case of overrun, and tried to proceed to the final checkout step, but encountered the following error:

Warning: Missing argument 2 for ot_giftcard::update_giftcard_balance(), called in C:\xampp\htdocs\store\includes\modules\order_total\ot_giftcard.php on line 210 and defined in C:\xampp\htdocs\store\includes\modules\order_total\ot_giftcard.php on line 541

Warning: Cannot modify header information - headers already sent by (output started at C:\xampp\htdocs\store\includes\modules\order_total\ot_giftcard.php:541) in C:\xampp\htdocs\store\includes\functions\functions_general.php on line 44

riiver

I do not know anything about ver 1.37 as this module was designed for ver 1.38a but perhaps someone else may be able to help with this problem. The "argument 2" asked for in the routine is the amount to deduct from the card balance account. This number cannot be negative or zero, and must be a decimal type. The error would not likely be in the script as this number is passed to it from the order_total core module during checkout, so I'm thinking it is a version problem. Sorry for the inconvenience.

T. Zinni

Sorry for the double post; I'm not sure how that happened and was unable to edit the second one for some reason.

I never thought about it being a version issue, duh. I don't remember the mod saying anywhere that it was 1.3.8-specific, or did I miss that? (If not, you might consider putting that into your documentation somewhere.) I know 1.3.8 is supposed to be the best version and all that but I had issues with multiple modules when I upgraded, some of them can't-live-without-it mods, so I downgraded back to 1.3.7.

Well, pooey. I was soooo excited to find this mod, and I was really hoping I could use it. I don't suppose there's a simple fix that makes it 1.3.7-compatible?

Thanx for the reply :)

First of, i have to say, i love this contribution, it is now being used on a site thats not really been introduced yet, but the clients plan to kick site off by giving out 500 - $2.00 item in the hopes they will upsell more products. i have seen where you can set on coupons to make coupon box show on only certain items, and struggled a bit here, but got it figured out and gonna share code in case anyones lookin for same option

original code**

/**

• following line allows to show only if item is in cart
  */

if ($this->use_credit_amount())
{
  $selection = array('id' => $this->code,
                     'module' => $this->title,
                     'redeem_instructions' => MODULE_ORDER_TOTAL_GIFTCARD_REDEEM_INSTRUCTIONS,
                     'checkbox' => $this->use_credit_amount(),
                     'fields' => array(array('title' => MODULE_ORDER_TOTAL_GIFTCARD_TEXT_ENTER_CODE,
                     'field' => zen_draw_input_field('gcard_redeem_code', '', 'id="gcard-'.$this->code.'" onkeyup="submitFunction(0,0)"'),
                     'tag' => 'gcard-'.$this->code
                     )));
}
return $selection;

}
/**

end***********

*** replace with****

/**

• following line allows to show only if item is in cart
  */

  if ($_SESSION['cart']->in_cart_check('products_id','2241178')) {

if ($this->use_credit_amount())
{
  $selection = array('id' => $this->code,
                     'module' => $this->title,
                     'redeem_instructions' => MODULE_ORDER_TOTAL_GIFTCARD_REDEEM_INSTRUCTIONS,
                     'checkbox' => $this->use_credit_amount(),
                     'fields' => array(array('title' => MODULE_ORDER_TOTAL_GIFTCARD_TEXT_ENTER_CODE,
                     'field' => zen_draw_input_field('gcard_redeem_code', '', 'id="gcard-'.$this->code.'" onkeyup="submitFunction(0,0)"'),
                     'tag' => 'gcard-'.$this->code
                     )));
}
return $selection;

}

}
/**

end**********

2241178 is the products id, this hasent really been tested in live envirnment yet, but feeling pretty confident

is there away to bulk upload the number and unlock them all at the same time?

I have a question, this might not be the right place to ask though.

I just installed this mod and I think it'll be perfect for my shop. My question however, is whether there's a way to set the shipping price of the gift card to a specific amount (less than standard shipping), and to make it ship for free if purchased with another product.

I'm using the zones shipping (canada/us) and a store pickup option.

thanks in advance for your help!
Tiff :-)

I am installing this contribution but zc_install ask me information about my database and I can't find them. Where do I have to look for these information?

It seems that I cannot get the module working.
I get an error when I want to check-out / pay the basket.

I get the folowing error:
PHP Warning: Missing argument 2 for ot_giftcard::update_giftcard_balance(),
called in /var/www/html/includes/modules/order_total/ot_giftcard.php on line 210
and defined in /var/www/html/includes/modules/order_total/ot_giftcard.php on line 541

I'm using:
PHP versie: 5.2.9 (Zend versie: 2.2.0) TITLE_PHP_MEMORY_LIMIT 8M
Zen Cart 1.3.8a
Database Patch Level: 1.3.8

Who can help me with the solution to this anoing problem.

riiver_of_dreams:

This mod sounds wonderful. I downloaded and installed it with no trouble, created and unlocked a card number, etc. All worked well till I got to checkout. I entered the card number, chose a secondary option in case of overrun, and tried to proceed to the final checkout step, but encountered the following error:

Warning: Missing argument 2 for ot_giftcard::update_giftcard_balance(), called in C:\xampp\htdocs\store\includes\modules\order_total\ot_giftcard.php on line 210 and defined in C:\xampp\htdocs\store\includes\modules\order_total\ot_giftcard.php on line 541

Now, I know just about enough about php to install zencart mods, but no more. I would really like to use this mod, but I have no clue what to do to fix this error. I am using zen 3.7.something, and have more mods installed than I can list. Everything else works perfectly. I recently installed the checkout without account mod. Help, anyone? My thanks in advance.

riiver

Does anyone know if this works on 1.3.9 ??