applelinks

Hi I'm Having some problems with the Coupon admin. After coupons are rehemmed or expired the coupons do not become in active. I have to use MySql to change the status from Y to N When selecting Inactive coupons from the drop down menu it displays the inactive coupons, but when I try to pull a page # from the pull down menu or click the >> link to go to the next page it takes me to the active coupons. My last problem is when a person checks out the Gift Voucher code is no entered on the invoice, so we have to look all of them up manually. Is anyone having similar problems, did I miss some code? Any help is appreciated. Joe

Hi Yes the files have been change and look the same as you listed. I have been over the installation 3 times. It is very weird because it worked fine on our test server. Maybe another Contributions is causing the problem? joe

I moved the Contribution from our test server to our live server and now i'm getting 2 errors. I have been over the code several times and can't seem to find where i went wrong the first error is when i click on the cancled order link in the admin section i get this error The requested URL /admin/FILENAME_CANCELLED_ORDERS was not found on this serve the second error is when i replace FILENAME_CANCELLED_ORDERS with cancelled_orders.php i get the following error 1146 - Table 'oscommerce.TABLE_CANCELLED_ORDERS' doesn't exist select count(*) as total from TABLE_CANCELLED_ORDERS o left join TABLE_CANCELLED_ORDERS_TOTAL ot on (o.orders_id = ot.orders_id), orders_status s where o.orders_status = s.orders_status_id and s.language_id = '1' and ot.class = 'ot_total' [TEP STOP] Any idea? thanks joe

That was the problem. I deleted the extra fields and it works great Thanks Joe

Hi After installing the Cancel/Void Shopping Cart Orders Modification. get the following error when trying to cancel an order 1136 - Column count doesn't match value count at row 1 insert into cancelled_orders_products select * from orders_products where orders_id = '5004' [TEP STOP] has anyone has a similar problem? Joe

Hi We did not have time to look into the code so we did all 557 vouchures manually. We did use it for a single product, it worked like a charm It seems that all discount coupons that have been redeemed stay active. We have even change the active date of the coupon to yesterday and it still satys active. The only way to make it inactive is to go into PHPmyAdmin and change the status fro 'Y' to 'N' It there is a way to automate this process please let me know. We need to generate a report for our coustomer with the 557 vouchures. Viewing the inactive coupons would be a big help BTW: this is a great addition to OSC. Joe

Hi Quick question I have added a coupon to only be used once. Once the coupon is redeemed should it then be listed as an inactive coupon? This is the info of the redeemed coupon. Eventhough it has been redeemed it is still shoing up as active? oupon Name?::? exo3 Coupon Amount?::? $29.85 Start Date?::? 12/04/2003 End Date?::? 01/04/2004 Uses per Coupon?::? 1 Uses per Customer?::? 1 Valid Product List?::? View Valid Categories List?::? NONE Date Created?::? 12/04/2003 Date Modified?::? 12/04/2003

Jason Thanks for all your help. It was the sore order Joe

I see the problem, there is no checkbox on the checkout_payment.php page. I know i have missed some code here. on the checkout_payment.php page there is a box to enter the Gift Vouchers/Discount Coupons code and there is a redeem button,but no check box. can you give me a hint as to where to look for the missing code Thanks joe

This is weird When I Mail Gift Voucher and receive the email, I click the link to redeeme the voucher. I procced to the check out and get an error message that says im using an invalid gift voucher code. When i check the databse it shows the voucher has been redeemed and is not active. The next gift voucher i sent i did not cilk the link in the email. instead i went to the store, proceeded to check out and entered the voucher code. This time the code was taken, but the $10.00 from the voucher was not deducted from the price of the order. What did happen was it added the $10.00 to the balance of my voucher account So now i have paid full price for the order, but have $20.00 worth of gift vouchers. Has anyone heard of this problem before. I have been over the code but could not find the problem. Thanks Joe

HI From the Coupon Admin page. is ther any way to copy a coupon? We have to generate several hundred coupons for a single item. all the coupons will have all the same info (price, date, product etc). Instead of having to enter several hundres one at a time. Is there a way to copy the coupon with a unique Coupon Code? thanks Joe

is it possible to send that email to [email protected] Thanks again Joe

HI Severl questions about Gift voucher. We have a comapny that is giving away 500 iPods. They want us to supply these customers with iPod cases What we want to do is generate 500 unique vouchure codes. The unique code will sent with the iPod so that the people who receive the free iPods can come to our store to get their free case. Can the Credit Class & Gift Voucher create 500 unique vouchure codes and can this be limited to a single item Thanks for your help Joe

tep_array_merge is no longer a function used in ms2.2, the solution is to search for tep_array_merge and replace with array_merge. This should only be requried in the help_orders.php file on the admin side. Thanks to Dave from puddled support for this one.

I recently installled the add-on for held_orders. Everything seemed to go fine until i went to the admin/held_orders.php page where this error was generated "Fatal error: Call to undefined function: tep_array_merge() in /admin/held_orders.php on line 349". That code looks like this: <td class="smallText" align="right"><?php echo HEADING_TITLE_STATUS . ' ' . tep_draw_pull_down_menu('status', tep_array_merge(array(array('id' => '', 'text' => TEXT_ALL_ORDERS)), $orders_statuses), '', 'onChange="this.form.submit();"'); ?></td> I've run through the setup twice following the documentation to the letter, but I keep getting the same results. If comeone sees something obvious please LMK. Any help would be greatly appreciated. Thanks, Pete <_<