Jump to content


  • Content count

  • Joined

  • Last visited

Everything posted by curt

  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
  16. Jan, I was thinking of if/else'ing the per catagory mods and say add a on/off column to the database. I need to think about this more, but maybe it might be easier to have a fake catagory with the product in it kind of like discount_categories only discount_categories_to_products.
  17. Speaking of Quantity Price Break Per Product for SPPC... I have this running with price break per category and everything works great. Is it possible to give a quantity break on an item without calculating the product category quantity "also". I guess is there a way to use it both ways where some products price breaks come from product category counts and some come from only the product getting the price break?
  18. Jan and Marvin ---- thank you.... Everything works great. I have SPPC (716), SPPC price break w/ mod for catagories (3039), more category boxes (3327), category descriptions (1373), big images (614), header tags controller (207), all products (1501) and will probably add a few more. I have over two dozen store fronts that are being redeveloped with oscommerce from another cart solution and this has saved me weeks and weeks of time, not to mention I didn't even need much asprin. To anyone other than Jan and Marvin installing this mod, save yourself some time and trouble and install this one first, preferably with a default MS2 install and copy (or rar) the files in. Thanks Again. <Curt Larson
  19. I think I stumbled upon the answer. You know these things will just bug a person until they figure it out. There is an option in admin for 'Use Search-Engine Safe URLs (still in development)' and when this is set to true only one box will work with the expanding of subcategories. Interestingly, it is the first box that you would click a category in. For example, I clear the cache and reload the catalog with option true for safe url, and click in box1 on a category everything works fine in box1 but box2 subgategories will not show. If i do exactly the same thing (with cache and reload) and click box2 category first, then subcategories in box1 will not expand. If I change the option to false categories behave as they should.
  20. Well, I would like to say that I figured out why it wasn't working, but... I ran several different debugging scenarios and finally ended up making a new installation and rar'ed in the more category boxes mod (*-50.sql incl.) then sql'ed in just categories, categories_descriptions, more_categories, products, product_descriptions and products_to_categories from my original install. Now it is working as it should. After two days screwing with it I really wanted to figure out the root cause but I guess the old saying goes ' alls well that ends well'. <Curt
  21. I wiped the store and added your mod again but I can't seem to get the second category to expand the submenus. I thought maybe another mod was effecting it so I deleted everything except the sql database and then started over... <Curt
  22. It seems that categories/subcategories work fine in the first new box but not in the second. I will see if I can work it out. I have checked a few other sites listed here in this topic and they seem fine. At least the ones that have subcategories. I stumbled upon this anomaly trying to enable the category enhancement and at first thought that was the cause. I then reverted to a basic install and that's when I came here. example The domain has nothing to do with the commerce site, just my place to test it. I am not a ie user so I couldn't say if it worked there but I did check firefox, mozilla and epiphany. <Curt