Jump to content

brushwood

♥Ambassador
  • Content count

    1,065
  • Joined

  • Last visited

Everything posted by brushwood

  1. Going through the paces here before opening up this new Contrib on my store. I'm going to use it with Discount Coupons as a Gift Certificate module. Coupla small issues. 1: As mentioned, format breaks on checkout_confirmation as well as other areas like admin. 2: Order Editor cuts the string somewhere around 35 characters. 3: When ordering several items, the attributes are in reverse order for all but the last item.(not a big deal, but it makes an impression of an unprofessional site)
  2. brushwood

    Imprint Text Options

    I have moved on to the other contrib for text options and it works much better. Product Attributes Option Type Feature
  3. brushwood

    Imprint Text Options

    Got back here too late to edit previous post. Bad news. Adding another product with another attribute works except the input text on the first one is written over with the second. Back to the drawing board.
  4. brushwood

    Imprint Text Options

    OK, found it. I dropped this: // denuz text attr tep_db_query("delete from customers_basket_text_attributes where products_id = " . tep_get_prid($HTTP_POST_VARS['products_id'][$i]) . " and session_id = '" . $osCsid . "'"); // eof denuz text attr from application_top.php and it seems to work very well now. I have a few details to finish but this is looking great for now.
  5. brushwood

    Imprint Text Options

    OK, I've backed out of the More Entries addition and the single quote issue seems to be resolved. My work-around for it is to generate a regular set of attributes for the gift certificates. Recipients: 1st Gift Certificate, 2nd Gift Certificate, etc. This makes each one into a separate product at checkout and displays just fine in testing. It also encourages the customer to buy for more than 1 person at a time. However, when I remove 1 of them from the cart, all lose the imprint data. I'll try looking in the code to see if there's something I can do but I'd love to hear some thoughts on it.
  6. brushwood

    Imprint Text Options

    I've been working through this contrib with the intention to offer gift certificates in conjunction with the coupon code contrib. So far, it's been pretty good. A problem i hit while testing centers on the customer entering a single quote into the text box like: Hi, Johnnie! We're looking forward to seeing this blah, blah, blah... You get the idea. Sometimes it seems fine and other times it throws errors. I first noticed it when I deleted another product that was in the cart 9not even a custom item). I looked in the DB and saw the single quote there and realized sometimes it would screw with the code depending on where and how and maybe even how many of them were added. Any thoughts?
  7. Please pardon my laziness for not wanting to read all 78 pages in this thread. I've read though many of them and read through the manual briefly. Before I install this, I have a big question. I've been looking for a way to do Gift Certificates for some time. I think CCGV is awkward and not likely to be used by my customers. Also, I've tried installing it with my heavily modded site and ran into serious difficulties with some of my custom work. Maybe it's changed, but I'm against it for now. I want to use something like Imprint Text Options contrib to create a section of gift certificates that the customer just goes in and buys. They enter fields for the gift (the custom imprint text) like name, email and address of the recipient then just check out as usual. They can add several certificates and even order products for themselves at the same time. I convert their custom product to a coupon (with Discount Coupon Codes) and email it to the recipient. (Maybe I'm not remembering CCGV correctly, but it seemed much more awkward for the customer with several steps needed to send the gift. Really, any advice on Gift Certificate knowledge would be welcome) So, first, will this work? Second, can a customer use only part of a coupon and have a remaining balance on it with this contrib or must they apply the entire code balance at once?
  8. I am a very inexperienced coder, just a hackabout at best. I was wondering if anyone is willing/able to modify this Contrib (see topic title) to make the entry a dropdown menu populated on the admin side. I have specific Delivery Dates I'd use to populate it. It would be much simpler. This could/would also be useful for those who simply want another piece of information tagged to an order. This is very useful to me since I ship 6 months of the year but take orders all year. Some folks order up to 4 months in advance of proper planting dates. Other OSC users could populate it and title the question differently for their needs. I could try to do this myself in the off season but, for a real coder, this should be fairly simple to do.
  9. brushwood

    Batch Print Center (support thread)

    OK, brain function needs coffee! I remembered and found the problem. It is a date query issue. I needed to put a space in from of the time 23:59:59 here: . tep_db_input($enddate) . "23:59:59' and h.orders_id = o.orders_id" . $pull_w_status . Working fine now.
  10. brushwood

    Batch Print Center (support thread)

    OK, no. I was wrong. My server was not restarted and I think I loaded an older version of my batch print php file yesterday. Somewhere in the back of my brain there's something about mysql asking for dates in a different way in newer versions. Some minor change in the way to query the db. I may have tweaked it by ftp just after the move to this host (a month ago) and not updated my backup. This is the top of my batch_print.php file and the error is: Fatal error: Call to undefined function: message_handler() in /home/brushwoo/public_html/catalog/amin/batch_print.php on line 48 <?php require('includes/application_top.php'); if ($HTTP_GET_VARS['mkey']) { $key = $HTTP_GET_VARS['mkey']; $message = $error[$key]; $HTTP_GET_VARS['act'] = 0; } if ($HTTP_GET_VARS['act'] == '') { $HTTP_GET_VARS['act'] = 0; } if (strlen($HTTP_GET_VARS['act']) == 1 && is_numeric($HTTP_GET_VARS['act'])) { switch ($HTTP_GET_VARS['act']) { case 1: // CHECK DATE ENTERED, GRAB ALL ORDERS FROM THAT DATE, AND CREATE PDF FOR ORDERS if (!isset($HTTP_POST_VARS[ 'startdate'])) { message_handler(); } if ((strlen($HTTP_POST_VARS['startdate']) != 10) || verify_start_date($HTTP_POST_VARS['startdate'])) { message_handler('ERROR_BAD_DATE'); } if (!is_writeable(BATCH_PDF_DIR)) { message_handler('SET_PERMISSIONS'); } $time0 = time(); $startdate = tep_db_prepare_input($HTTP_POST_VARS['startdate']); if (!isset($HTTP_POST_VARS['enddate'])) { message_handler(); } if ((strlen($HTTP_POST_VARS['enddate']) != 10) || verify_end_date($HTTP_POST_VARS['enddate'])) { message_handler('ERROR_BAD_DATE'); } if (!is_writeable(BATCH_PDF_DIR)) { message_handler('SET_PERMISSIONS'); } $time0 = time(); $enddate = tep_db_prepare_input($HTTP_POST_VARS['enddate']); require(DIR_WS_CLASSES . 'currencies.php'); require(BATCH_PRINT_INC . 'class.ezpdf.php'); require(DIR_WS_CLASSES . 'order.php'); $pdf = new Cezpdf(PAGE); $currencies = new currencies(); $pdf->selectFont(BATCH_PDF_DIR . 'Helvetica.afm'); $pdf->setFontFamily(BATCH_PDF_DIR . 'Helvetica.afm'); if ($HTTP_POST_VARS['show_comments']) { $get_customer_comments = ' and h.orders_status_id = ' . DEFAULT_ORDERS_STATUS_ID; } if ($HTTP_POST_VARS['pull_status']){ $pull_w_status = " and o.orders_status = ". $HTTP_POST_VARS['pull_status']; } $orders_query = tep_db_query("select o.orders_id,h.comments,MIN(h.date_added) from " . TABLE_ORDERS . " o, " . TABLE_ORDERS_STATUS_HISTORY . " h where o.date_purchased between '" . tep_db_input($startdate) . "' and '" . tep_db_input($enddate) . "23:59:59' and h.orders_id = o.orders_id" . $pull_w_status . $get_customer_comments . ' group by o.orders_id'); if (!tep_db_num_rows($orders_query) > 0) { message_handler('NO_ORDERS'); } $num = 0; while ($orders = tep_db_fetch_array($orders_query)) { $order = new order($orders['orders_id']); if ($num != 0) { $pdf->EzNewPage(); } $y = $pdf->ezText("PACKING SLIP",COMPANY_HEADER_FONT_SIZE); $y = $pdf->ezText(STORE_NAME_ADDRESS,SUB_HEADING_FONT_SIZE); $y -= 10; Line 48 is: if (!tep_db_num_rows($orders_query) > 0) { message_handler('NO_ORDERS'); } Any thoughts?
  11. brushwood

    Batch Print Center (support thread)

    My batch print just stopped working yesterday. Now, when I try to pull any status, I get this error: Fatal error: Call to undefined function: message_handler() in /home/brushwoo/public_html/catalog/amin/batch_print.php on line 48 This worked yesterday early morning and not in the afternoon. I looked and saw in my logs that the server was restarted at 11:21 AM. Can anyone guide me to an answer? I had this happen to me on the storefront with credit card entry error messages when I first moved to my new host. I'm concerned that they have upgraded something and I need the batch print almost daily. Any thoughts?
  12. brushwood

    Some credit cards not working

    I've been running osC for years and have been baffled by the occasional error before confirmation that returns a blank pink box at the top of the page. I just tried to run a customer's Amex card on my cart for her and it did that. Then I went over to my Auth.net Virtual Terminal and it went through just fine. This has happened before. I'm wondering if there's something in the module (Auth Consolidated 1.7,I believe) that's rejecting some cards and why. Kills me to think some folks may be surfing away in frustration.
  13. brushwood

    osC mySQL

    Mark, I still think this has the most tremendous potential of just about any Contrib. I run queries manually on a regular basis and this would make it much easier. Please continue to work on it as you get the time! Request: I could use a csv file export option. Trouble: I get an error of headers already sent like this: Warning: Cannot modify header information - headers already sent by (output started at /home/brushwoo/public_html/catalog/amin/includes/application_top.php:11) in /home/brushwoo/public_html/catalog/amin/pdf/fpdf/fpdf.php on line 1071 FPDF error: Some data has already been output to browser, can't send PDF file Then again, I just moved hosts and have a few issues on this. I get it also when I use the search function looking up a customer (in customers.php). I'll probably ask about it in general support but thought I'd mention it here in case it's code specific.
  14. I need to know exactly where the credit card number and expiration date are stripped from the order table when using Auth.net Consolidated (if in fact that contrib is doing it). I've been digging through the files for an hour looking for the spot. It has to happen after the response from Auth.net, but I can't seem to get it.
  15. brushwood

    Held Orders v2.0 MS2 ready

    Just installed this Contrib, which is convenient for Paypal dropoffs, but I'm hoping to log cc numbers for when folks wish to add to their orders. Is there a way to block the orders from clearing from these tables when my CC processor returns a confirmation of payment? That way, I can go back and use my cc virtual terminal to chaarge them for the added product(s). I see a few additions to files calling for deletion from the tables. If I drop one, would that help? Which? Will it mess up anything else?
  16. brushwood

    Automatically send data feed to Froogle

    More likely your database server is down. Maybe rebooting. Ask you host.
  17. brushwood

    Automatically send data feed to Froogle

    I have mine on a weekly cron job. So, yes, it will do that. All automatic once you're up and running.
  18. brushwood

    Automatically send data feed to Froogle

    My friend gets rejected entirely (the entire feed) due to the nature of some of his products. That's why I wanted to create an option to stop individual items from the feed. I'm thinking it could be patterned after the In Stock/Out of Stock radio buttons at the top of the product's page. Then, admin can opt to exclude items from the feed. I'm not a great coder but I plan to hack it together for him if no one else does it first. If I do it, it will be sloppy code and I'll have a hard time making it into a good looking Contribution (a hint and veiled request to any real coders reading this).
  19. brushwood

    Automatically send data feed to Froogle

    The way I remember it, the feed goes to Base and the information contained in the feed tells Base to add it to Froogle. (product, price, description, availability, etc). It should be all set up to do it right for you.
  20. brushwood

    Automatically send data feed to Froogle

    Pardon my laziness for not wanting to read through 85 pages to see if this has been asked before: I have a friend with a store that carries items rejected by Base. I want to figure out how to flag these items in the admin panel so he can continue to use a cron job on the feed instead of manual submission with items removed from the feed. I was figuring some sort of attribute not visible to the customer that could trigger the script to skip it. I was thinking about maybe something in the model number could be used or possibly a parallel to the in stock/out of stock radio button that defaults to yes for feed but could be ticked to disable it from the feed. Maybe this seems a little specialized but I think there will be more disapproved items in the future and many stores could benefit from the ability.
  21. brushwood

    osC mySQL

    I've finally gotten around to installing this and have the same set of errors mentioned on page 1 of this thread. The fixes suggested have stopped the first error but I still get the : Warning: Cannot modify header information - headers already sent by (output started at /homepages/0/d112133822/htdocs/sub1/catalog/amin/includes/application_top.php:11) in /homepages/0/d112133822/htdocs/sub1/catalog/amin/pdf/fpdf/fpdf.php on line 1071 FPDF error: Some data has already been output to browser, can't send PDF file When I try even a simple little column and click the pdf button on the right. Also, is the top area supposed to load the script from the dropdown menu of my saved scripts? I don't think I have anything disabled in my browser that would stop it from functioning.
  22. brushwood

    USPS Labels not working

    Thanks. I think making the switch to the newer version completely would be best. By the way, I just installed this for a client who's thrilled. I had to explain carefully the difference with the first page to them because they didn't quite get it. You may want to consider a layout that looks more like the admin panel so the less-savvy will know where they are. A minor detail, I know. Maybe an alternate page layout in the package?
  23. brushwood

    USPS Labels not working

    Excellent and speedy work on a fine Contrib update! I can't believe they've changed it again! What's that, like 4 times each year on average? I'm looking to update so I can begin using it again. My version is old. I use diffrentshipping.php which is the stripped down version. Is the update sql valid for this or should I look line by line?
  24. brushwood

    osC mySQL

    OK, are there any issues with the current release other than FF compatability?
  25. brushwood

    osC mySQL

    Mark, I'm about to add this excellent tool to my backend but wanted to check to see if you were going to release an update any time soon. Any news, tweaks etc?
×