Jump to content

curt

Members
  • Content count

    22
  • Joined

  • Last visited

Profile Information

  • Real Name
    curt larson
  1. Seems kind of simple but there is an extra space in the code that generates the Google Checkout button on the checkout page. The space comes right before the merchant_id and a merchant_id=%20<mymerchant_id> gets generated in the url .. Google Checkout doesn't understand this merchant_id with the %20 in front of it. This is about line 473 in my code (yours may differ a little) <input type="hidden" name="cart" value="<?php echo base64_encode($gcheck->getXml());?>"> <input type="hidden" name="signature" value="<?php echo base64_encode( $googlepayment->CalcHmacSha1($gcheck->getXml())); ?>"> <input type="image" name="Checkout" alt="Checkout" src="<?php echo $googlepayment->mode;?>buttons/checkout.gif?merchant_id= <?php echo $googlepayment->merchantid;?>&w=168&h=44&style=trans&variant=$ </form> Should correctly be: <input type="hidden" name="cart" value="<?php echo base64_encode($gcheck->getXml());?>"> <input type="hidden" name="signature" value="<?php echo base64_encode( $googlepayment->CalcHmacSha1($gcheck->getXml())); ?>"> <input type="image" name="Checkout" alt="Checkout" src="<?php echo $googlepayment->mode;?>buttons/checkout.gif?merchant_id=<?php echo $googlepayment->merchantid;?>&w=168&h=44&style=trans&variant=$ </form> Yes sometimes one little extra space can make a difference. My site was in the summer 2008 promotion and the starburst "$10 off" checkout button wasn't appearing because the merchant_id wasn't recognized. <Curt
  2. curt

    FedEx Direct 2.06 Support thread

    Change catalog/Includes to catalog/includes (note the capital I is not supposed to be there) cd'ing to your contrib and using cp -r * /my/site on a *nix box doesn't put the new files in the right place. I would have posted this on the original contributions support thread but I could not find it .. why do people post new topics instead of using the contributions 'official' thread? Curt rants about stupid topics that ask hey do you use 'such and such a contrib' because they cause way too much congestion.
  3. curt

    Automatically send data feed to Froogle

    Everyone seems to use a plain cron entry to the .php file. I found it that a cd /to/your/admin/dir; was neaded for the includes to be right. A simple file (permissions 744) called nameofyourscript with the contents: #!/bin/bash cd /www/yourdirectory/admin; /usr/local/bin/php -q NameOfFeedFile.php; path/to/php should be your $which php then the cron: 0 4 * * 1,4 /www/lilyblooms/admin/nameofyourscript Does upload twice per week (Mon and Thurs at 4:00am) <Curt
  4. Debian Etch (testing) upgraded to MySQL5 today. I saw it come through on dist-upgrade and thought I might end up here soon. Is there a basic thread/post that you all can point me to. The one error that I notice right away is: 1054 - Unknown column 'p.products_id' in 'on clause' select count(p.products_id) as total from products_description pd etc..etc.. I do remember seeing a post refering to this before but I can't seem to find it and your help is appriciated. <Curt
  5. I did have the PriceFormatter.php mod, I don't remember when I added it but it is there. Thanks for all your help again. I was a bit sceptical of myself and it is nice to be confirmed... Time for a 1.3 pb for sppc? <Curt
  6. Sorry about the double post, but that TABLE_PRODUCTS_TO_DISCOUNT_CATEGORIES was from something else and should be TABLE_PRODUCTS_TO_CATEGORIES and should look something more like this: $products_query = tep_db_query("select cb.products_id, pc.categories_id, cb.customers_basket_quantity from " . TABLE_CUSTOMERS_BASKET . " cb LEFT JOIN " . TABLE_PRODUCTS_TO_CATEGORIES . " pc on cb.products_id=pc.products_id where cb.customers_id = '" . (int)$customer_id . "'"); <Curt
  7. I think that this database query (around line 51): $products_query = tep_db_query("select products_to_categories.products_id, categories_id, customers_basket_quantity from " . TABLE_CUSTOMERS_BASKET . " LEFT JOIN " . TABLE_PRODUCTS_TO_CATEGORIES . " using(products_id) where customers_id = '" . (int)$customer_id . "'"); should look like this (or similar): $products_query = tep_db_query("select cb.products_id, pdc.categories_id, cb.customers_basket_quantity from " . TABLE_CUSTOMERS_BASKET . " cb LEFT JOIN " . TABLE_PRODUCTS_TO_DISCOUNT_CATEGORIES . " pdc on cb.products_id=pdc.products_id where cb.customers_id = '" . (int)$customer_id . "'"); Did I get that right? I will that debuging code here in a bit... Thanks <Curt
  8. Jan, The problem lies in pbpc. Probably in shopping_cart_pbpc.php I am no expert, would you mind having a look? I installed ms2.2 and added sppc then pb_sppc then pbpc_sppc and that's when the error appeared. I didn't mod any of the files. I tar'd them up and exctracted them in the proper place. Since this is a new page ;) on the forum, this is the can't delete products with attributes when logged in problem (the product reappears after logout/log back in). Thanks, <Curt
  9. This may take a while then. Stew: when you are logged in and have an item in your cart that has attributes, can you view page source and see if <input="hidden" line exists: <td> <input type="hidden" blah blah blah <tr> <td align="center" class="productListing-heading">Remove</td> <td class="productListing-heading">Product(s)</td> <td align="center" class="productListing-heading">Qty.</td> <td align="right" class="productListing-heading">Total</td> </tr> or <td> <tr> <td align="center" class="productListing-heading">Remove</td> <td class="productListing-heading">Product(s)</td> <td align="center" class="productListing-heading">Qty.</td> <td align="right" class="productListing-heading">Total</td> </tr> thanks ~ curt
  10. I am going to do some more testing later today to see what module might be causing the error. I do have a couple others installed. Have you tested the deleting products with attributes while logged on your test store? wffu? <Curt
  11. Jan, I am having a bit of trouble. When products have attributes and you are logged in the products won't delete from the cart permanetly. I mean permanetly by, if you delete such and such a product that has an attribute from your cart and log out and log back in then the item reappears in your cart. You can delete products with attributes either logged in or not from a stock install. What I have found so far is that when you are logged in the <input type="hidden" is not being returned from this part of shopping_cart.php (shopping_cart.php is unmoddified by sppc or me) if (isset($products[$i]['attributes']) && is_array($products[$i]['attributes'])) { while (list($option, $value) = each($products[$i]['attributes'])) { echo tep_draw_hidden_field('id[' . $products[$i]['id'] . '][' . $option . ']', $value); $attributes = tep_db_query("select popt.products_options_name, poval.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_OPTIONS_VALUES . " poval, " . TABLE_PRODUCTS_ATTRIBUTES . " pa where pa.products_id = '" . $products[$i]['id'] . "' and pa.options_id = '" . $option . "' and pa.options_id = popt.products_options_id and pa.options_values_id = '" . $value . "' and pa.options_values_id = poval.products_options_values_id and popt.language_id = '" . $languages_id . "' and poval.language_id = '" . $languages_id . "'"); $attributes_values = tep_db_fetch_array($attributes); $products[$i][$option]['products_options_name'] = $attributes_values['products_options_name']; $products[$i][$option]['options_values_id'] = $value; $products[$i][$option]['products_options_values_name'] = $attributes_values['products_options_values_name']; $products[$i][$option]['options_values_price'] = $attributes_values['options_values_price']; $products[$i][$option]['price_prefix'] = $attributes_values['price_prefix']; } } } When you are logged in your basket is stored in customer_basket and redundantly in customers_basket_attributes rather then just in the session like being unlogged and there are a few differences in the sessions when you are logged too. I just can't figure out why they product attributes arent be passed to that shopping_cart.php statement. Maybe you can pointme in the right direction? thanks <Curt
  12. Jan, A couple of other important changes needed for that order.php around line 273 /*$shown_price = tep_add_tax($this->products[$index]['final_price'], $this->products[$index]['tax']) * $this->products[$index]['qty'];*/ $shown_price = tep_add_tax($this->products[$index]['final_price'] * $this->products[$index]['qty'], $this->products[$index]['tax']); currencies.php around line 73 /*return $this->format(tep_add_tax($products_price, $products_tax) * $quantity);*/ return $this->format(tep_add_tax($products_price* $quantity, $products_tax)); Plus your shopping_cart.php change That takes care of the whole checkout process. account_history_info.php would still need a change and probably a couple of admin side files so viewing the orders from there would be correct. I am done for the day and probably won't be back until after the holidays... <Curt
  13. Jan, Where are the prices rounded? They seem to be rounded at each then added for qty. This would negate having more than two decimals for products_price. They aren't needed unless you calculate products_price*qty and then round... ie. currently 3 qty at 3.3333 = 9.99 and 3 qty at 3.3350 = 10.02 <Curt
  14. Jan, That would be a very easy way to remove products from counting towards the category discount and would be very easy on the admin side. I have a coulpe of main categories that that are combined to get the discounts. I don't sell wine but say category white wine also has subcategories dry and sweet and category red wine also has dry and sweet and you want all red and white wine to get a discount based on the total bottles of wine. Side note: what if... (hehe) you wanted to give a discount on tier one and tier two base on the single products count only and then wanted to combine the rest of the category for counts for the remaining tiers of discounts. buy 5 of one variety, or buy 10 of one variety but buy 50 or more mix match, buy 100 or more mix match. btw, are you a night owl or in the UK? <Curt
  15. Jan, I hate to double post but I found the answer in another post of yours: Quanity Discount w/Exclusions Using the last option and building a new table products_to_discount_categories allows you do define all your discount groups, and that is the main function of the mod anyway. You should note that if you are reading this and you are not JanZ, you will also have to make a few changes to classes PriceFormatter.php and shopping_cart.php and add a define to database_tables.php for products_to_discount_categories as outlined in the full original post by JanZ. Side note: What if... you wanted a product in more than one category. Primary keys aside, I don't really have the need, it just crossed my mind, and no you don't have to figure this one out too... Thanks again for all your time <Curt
×