Jump to content

augustinparis

Members
  • Content count

    28
  • Joined

  • Last visited

1 Follower

Profile Information

  • Real Name
    Florence
  1. augustinparis

    PayPal Express Loop to Login Page

    thanks Chris I have uninstalled and installed again Paypal, renewed the API credentials, to no avail. it turns out I installed Security Pro very recently (and since my shop is not very active, it's not suprising I just encounter the problem now !). I turned it off but the problem remains. I contacted Paypal and here is their response I admit I have no idea where these setting are sitting. I checked for any hacking of the files, but everythings seems OK... can you help a little more ? thank you :-)
  2. augustinparis

    PayPal Express Loop to Login Page

    Hi Chris I am experiencing a similar problem : my costumers get directed to Paypal but, while on the site, when it's time to enter their credit card details, it brings them back to the login page. I was wondering whether you had identified a solution to your problem, and whether it could help me. Many thanks ! Florence
  3. augustinparis

    SiteMonitor

    Hi guys ! thanks for this really useful contribution. I am installing it but at the last steps something strange happens : I get easily to the configuration step but when I open the congif on my admin and try tu update I get this message : Warning: opendir(/home/username/public_html/shop/) [function.opendir]: failed to open dir: No such file or directory in /home/(myusername)/public_html/shop/admin/includes/functions/sitemonitor_functions.php on line 392 Can you help ? many thanks ! florence
  4. augustinparis

    Header Tags SEO

    Thanks Jack I actually went step by step to copy and paste the code into categories, and used winmerge for the particular pieces of code linked to Multi image add-on. Now I can access the main categories, subcategories and browse through my products, but I cannot VIEW a product page, EDIT an existing product or ADD a new product : when I click, it just brings me back to my main list of categories... I have no idea where the mistake can be hidden... any hint ? thanks a lot florence PS just for the benefit of others here are the pieces of code with Multi image and Header tags SEO mixed together, in two instances... // Simple multi image addon if (isset($HTTP_GET_VARS['pID']) && empty($HTTP_POST_VARS)) { // Simple multi image addon and Header tags SEO $product_query = tep_db_query("select pd.products_name, pd.products_description, pd.products_head_title_tag, pd.products_head_desc_tag, pd.products_head_keywords_tag, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_image_array, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "'"); $product = tep_db_fetch_array($product_query); $products_image_array = unserialize($product['products_image_array']); if (!is_array($products_image_array)) $products_image_array = array(); // EOF Simple multi image addon and Header tag SEO <!-- /*** Begin Header Tags SEO ***/ //--> <?php } elseif ($action == 'new_product_preview') { if (tep_not_null($HTTP_POST_VARS)) { $pInfo = new objectInfo($HTTP_POST_VARS); $products_name = $HTTP_POST_VARS['products_name']; $products_description = $HTTP_POST_VARS['products_description']; $products_head_title_tag = $HTTP_POST_VARS['products_head_title_tag']; $products_head_desc_tag = $HTTP_POST_VARS['products_head_desc_tag']; $products_head_keywords_tag = $HTTP_POST_VARS['products_head_keywords_tag']; $products_url = $HTTP_POST_VARS['products_url']; } else { // Simple multi image addon $product_query = tep_db_query("select p.products_id, pd.language_id, pd.products_name, pd.products_description, pd.products_head_title_tag, pd.products_head_desc_tag, pd.products_head_keywords_tag, pd.products_url, p.products_quantity, p.products_model, p.products_image, p.products_image_array, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "'"); $product = tep_db_fetch_array($product_query); /*** End Header Tags SEO ***/ $pInfo = new objectInfo($product); $products_image_name = $pInfo->products_image; $products_image_array = unserialize($product['products_image_array']); if (!is_array($products_image_array)) $products_image_array = array(); } // EOF Simple multi image addon
  5. augustinparis

    Header Tags SEO

    Hi Jack ! thanks a lot for this very complete contribution ! I am installing it today and things seemed to be working fine until... I clicked on the categories of my admin interface ;)I end up with a syntax error, unexpected T_ELSEIF (what a joy ! ;) ) I have carefully re-read all instructions and I know that categories.php is the toughest to adapt... it seems that my problem is beyond just checking the merging of files as it involves another contribution which is "Simple multi image addon" that I had installed previously. Header tag SEO and multi image addon codes overlap at times and especially there... Here is the original OSCommerce code : Around line 679, find this section of code in admin/categories.php <?php } elseif ($action == 'new_product_preview') { if (tep_not_null($HTTP_POST_VARS)) { $pInfo = new objectInfo($HTTP_POST_VARS); $products_name = $HTTP_POST_VARS['products_name']; $products_description = $HTTP_POST_VARS['products_description']; $products_url = $HTTP_POST_VARS['products_url']; } else { $product_query = tep_db_query("select p.products_id, pd.language_id, pd.products_name, pd.products_description, pd.products_url, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "'"); $product = tep_db_fetch_array($product_query); Here is what I have with Multi image add-on } elseif ($action == 'new_product_preview') { if (tep_not_null($HTTP_POST_VARS)) { $pInfo = new objectInfo($HTTP_POST_VARS); $products_name = $HTTP_POST_VARS['products_name']; $products_description = $HTTP_POST_VARS['products_description']; $products_url = $HTTP_POST_VARS['products_url']; } else { // Simple multi image addon $product_query = tep_db_query("select p.products_id, pd.language_id, pd.products_name, pd.products_description, pd.products_url, p.products_quantity, p.products_model, p.products_image, p.products_image_array, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "'"); $product = tep_db_fetch_array($product_query); $pInfo = new objectInfo($product); $products_image_name = $pInfo->products_image; $products_image_array = unserialize($product['products_image_array']); if (!is_array($products_image_array)) $products_image_array = array(); } // EOF Simple multi image addon Here is what I am supposed to inject in the file ... <!-- /*** Begin Header Tags SEO ***/ //--> <?php } elseif ($action == 'new_product_preview') { if (tep_not_null($HTTP_POST_VARS)) { $pInfo = new objectInfo($HTTP_POST_VARS); $products_name = $HTTP_POST_VARS['products_name']; $products_description = $HTTP_POST_VARS['products_description']; $products_head_title_tag = $HTTP_POST_VARS['products_head_title_tag']; $products_head_desc_tag = $HTTP_POST_VARS['products_head_desc_tag']; $products_head_keywords_tag = $HTTP_POST_VARS['products_head_keywords_tag']; $products_url = $HTTP_POST_VARS['products_url']; } else { $product_query = tep_db_query("select p.products_id, pd.language_id, pd.products_name, pd.products_description, pd.products_head_title_tag, pd.products_head_desc_tag, pd.products_head_keywords_tag, pd.products_url, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "'"); $product = tep_db_fetch_array($product_query); /*** End Header Tags SEO ***/ And here is what I tried to do with Header tag SEO code and Multi image addon code... <!-- /*** Begin Header Tags SEO ***/ //--> <?php } elseif ($action == 'new_product_preview') { if (tep_not_null($HTTP_POST_VARS)) { $pInfo = new objectInfo($HTTP_POST_VARS); $products_name = $HTTP_POST_VARS['products_name']; $products_description = $HTTP_POST_VARS['products_description']; $products_head_title_tag = $HTTP_POST_VARS['products_head_title_tag']; $products_head_desc_tag = $HTTP_POST_VARS['products_head_desc_tag']; $products_head_keywords_tag = $HTTP_POST_VARS['products_head_keywords_tag']; $products_url = $HTTP_POST_VARS['products_url']; } else { // Simple multi image addon $product_query = tep_db_query("select p.products_id, pd.language_id, pd.products_name, pd.products_description, pd.products_head_title_tag, pd.products_head_desc_tag, pd.products_head_keywords_tag, pd.products_url, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "'"); $product = tep_db_fetch_array($product_query); /*** End Header Tags SEO ***/ $pInfo = new objectInfo($product); $products_image_name = $pInfo->products_image; $products_image_array = unserialize($product['products_image_array']); if (!is_array($products_image_array)) $products_image_array = array(); } // EOF Simple multi image addon I hope you can help in merging these two correctly... thanks in advance ! Florence
  6. First of all, many thanks for taking the trouble to look into my code, I really appreciate it :) I have upheld the quantity box feature so far, wanting to be sure of the code, so I am still in need of help ;) That's exactly what I have got : a table letting the customer know how many pieces there are left in the stock depending on size and color... so if I understand you well your suggestion will not fit. In any case, it made me think : in my business (kids clothes) it's unlikely a customer will want two pieces of the same size and same color (it can happen, but not very often). To purchase different models of the same item would require me to add to the page the possibility of selecting color/size several times, and that's just going to be a mess. Customers will have to go back to the product listing, and do the selection again with different attributes, and that's all... I wonder if I should note that on the screen though... In any case THANKS again for your help : I found a solution through your comments and that's really good :) Flo
  7. Hi Rus ! thanks for replying :) Unfortunately I cannot answer your first question for sure as I installed QT Pro before looking into the shipping issue. However, I have in my server a "virgin"version of OS Commerce, which I use to check what would be the usual behaviour of OS Commerce in case things go wrong, and this one does not have QT Pro on, and this virgin version works fine. As for the rest I have Easypopulate and Multiple Image with Fancy Box. My shop still doesnt want to calculate shipping costs according to the weight so I decided to charge per price (I sell kids clothes, so the weight is not so much an issue). In the meantime I want to install Product Quantity Drop Down add on, and there QT Pro complicates my life . Here is what I am supposed to do in the includes/application_top file : "Open includes/application_top.php Find: (374) // customer adds a product from the products page case 'add_product' : if (isset($HTTP_POST_VARS['products_id']) && is_numeric($HTTP_POST_VARS['products_id'])) { $cart->add_cart($HTTP_POST_VARS['products_id'], $cart->get_quantity(tep_get_uprid($HTTP_POST_VARS['products_id'], $HTTP_POST_VARS['id']))+1, $HTTP_POST_VARS['id']); } tep_redirect(tep_href_link($goto, tep_get_all_get_params($parameters))); break; "Replace with: // customer adds a product from the products page case 'add_product' : if (isset($_POST['products_id']) && is_numeric($_POST['products_id'])) { if (tep_has_product_attributes($_POST['products_id']) && PRODUCT_LIST_OPTIONS != 'true' && basename($PHP_SELF) != FILENAME_PRODUCT_INFO) tep_redirect(tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $_POST['products_id'])); $add_quantity = (isset($_POST['cart_quantity']) ? (int)$_POST['cart_quantity'] : 1); $cart->add_cart($_POST['products_id'], $cart->get_quantity(tep_get_uprid($_POST['products_id'], $_POST['id']))+$add_quantity, $_POST['id']); } tep_redirect(tep_href_link($goto, tep_get_all_get_params($parameters))); break; " But here is the code that I have in my file and specifically QTPro code // customer adds a product from the products page case 'add_product' : if (isset($HTTP_POST_VARS['products_id']) && is_numeric($HTTP_POST_VARS['products_id'])) { //++++ QT Pro: Begin Changed code $attributes=array(); if (isset($HTTP_POST_VARS['attrcomb']) && (preg_match("/^\d{1,10}-\d{1,10}(,\d{1,10}-\d{1,10})*$/",$HTTP_POST_VARS['attrcomb']))) { $attrlist=explode(',',$HTTP_POST_VARS['attrcomb']); foreach ($attrlist as $attr) { list($oid, $oval)=explode('-',$attr); if (is_numeric($oid) && $oid==(int)$oid && is_numeric($oval) && $oval==(int)$oval) $attributes[$oid]=$oval; } } if (isset($HTTP_POST_VARS['id']) && is_array($HTTP_POST_VARS['id'])) { foreach ($HTTP_POST_VARS['id'] as $key=>$val) { if (is_numeric($key) && $key==(int)$key && is_numeric($val) && $val==(int)$val) $attributes=$attributes + $HTTP_POST_VARS['id']; } } $cart->add_cart($HTTP_POST_VARS['products_id'], $cart->get_quantity(tep_get_uprid($HTTP_POST_VARS['products_id'], $attributes))+1, $attributes); //++++ QT Pro: End Changed Code } tep_redirect(tep_href_link($goto, tep_get_all_get_params($parameters))); break; I have no idea how to accomodate the two pieces of code... can anyone help on this one ? Thanks !!!
  8. Hi guys ! I really need your help on this one, as it is blocking me from opening my shop. I have installed QTPro v4.51b by Olof Larsson (26 Oct 2008). The module itself works fine. That's when the shipping cost are involved that everything goes wrong : instead of calculating the shipping based on the total weight of the items in the cart, it calculates it based on the number of items in the cart. I have tried different shpping modules and they all behave the same (except the flat rate one, of course...). I strongly suspect QTpro to be involved in this, any idea where to start with ? thanks a lot ! Florence
  9. augustinparis

    [support]?MultiGeoZone MultiTable Shipping Module

    Hi guys ! just installed MZMT on my shop. I have set up the zones nicely in the configuration, and here is my set up in the modules (the weight in counted in grams) : Multiple geo zone shipping with multiple tables to each geo zone. Enable MultiRegion MultiTable Method True Tax Class --none-- Sort Order 0 Geo Zone 1 SHP-ZONE_A Geo Zone 1 Table Method weight Geo Zone 1 Handling Fee 0 Geo Zone 1 Shipping Table 1 500:15.30,1000:22.60 Geo Zone 2 SHP-ZONE_B Geo Zone 2 Table Method weight Geo Zone 2 Handling Fee 0 Geo Zone 2 Shipping Table 1 500:23.60,1000:34.50 Geo Zone 3 SHP-ZONE_C Geo Zone 3 Table Method weight Geo Zone 3 Handling Fee 0 Geo Zone 3 Shipping Table 1 500:30.60,1000:48.10 :ph34r: When I test it with a fake account coming based in Zone_A, however, I get ... "Shipping Method This is currently the only shipping method available to use on this order. Speedpost Express (22 g) 2 to 3 working days S$0.00" So it pulls out the shipping method required, but it fails to show the correct shipping fee (in this case that would be 15.30 SGD). Any idea what I got wrong here ? :blush: thanks ! Flo
  10. augustinparis

    Help ! Shipping prices add up with the number of items

    I am still stuck... anyone encountered the problem ?
  11. Hello all ! I have spent the last hour searching the web and specifically this forum to find a solution, without result :blink: ... Hope you can help. The core of the problem is : when a customer buys several products, the total shipping cost is based on the individual shipping cost of each product. This is not what I expected : I want the shipping cost based on the total weight of the products the customers buys. like : lets say 0 to 500 g products are shipped for a 5 dollars fee. A costumer buys 2 items each weighing 200g. At the moment my OsCommerce will calculate the shipping cost at 10 dollars (5+5), instead of 5 dollars which would be for 400g parcel. I use the built in shipping modules to calculate shipping, that is : - Shipping table rate, to enable 2 delivery fees within Singapore (registered mail and speedpost), I have set up a zone for this. - Zone rates for deliveries outside Singapore, setting up 3 zones for this. I have not found contributions that could help, and I can't believe OsCommerce doesn't have the built in capability to calculate the total weight of an order and show the corresponding shipping rate. Maybe I have missed something somewhere ? thanks a lot for your help ! Flo
  12. Many thanks for your reply ! the mistake was in product info, when I updated the file. It's all working well now, and I am now proficient (or as best as I can be) on winmerge. thanks folks.... and promise, next time, I read the FAQ ;)
  13. Hello ! first of all, a big thanks to the author of this contribution, and anyone involved in improving it and helping newbie users like me :) I installed multiple image on my website, free from templates and with only easypopulate and paypal add ons at the moment. On the admin side, it looks Okay, ... but then switching on the shop the products are there and displayed in the list of each category or per manufacturer but when clicking to have the full detail for one product, the product is not displayed. I get "Product not found' and these error messages : Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/(xxx)/public_html/shop/includes/functions/database.php on line 99 (on top of the page) and Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/(xxx)/public_html/shop/includes/functions/database.php on line 103 I suspect it has to do with the way I installed it... but I don't see where and how... :( . I would greatly appreciate if you could point me in the right direction : in which part of the code is the problem likely to be ? which file ? for info, here is the section of code of the database.php mentioned in the warning messages : From line 99 to 103 function tep_db_fetch_array($db_query) { return mysql_fetch_array($db_query, MYSQL_ASSOC); } function tep_db_num_rows($db_query) { return mysql_num_rows($db_query); Many thanks for your help ! Flo
×