Jump to content

lennypost

Members
  • Content count

    9
  • Joined

  • Last visited

  1. lennypost

    NEW! Complete Order Editing Tool!

    SOLUTION for QTPro atrributes support in Order Editor. I work with ordereditor v.2.5 and QTpro v.4.25 IMPORTANT NOTE: I do not have my shop set to default STOCK check ( i use an option that detracts stock when my orders hit the "delivered" status, so orders.php deals with stock check.) but i think that will not be a problem, since order editor already checks stock. The whole idea is to fill table collumn "products_stock_attributes" from TABLE_ORDERS_PRODUCTS with the correct value and stock should be correct. Maybe someone else can check the regular Stock check and fill this in. Ok. in edit_orders.php find this, about line 438: // 2.1.1 Get Product Attribute Info if(is_array ($_POST['add_product_options'])) { foreach($_POST['add_product_options'] as $option_id => $option_value_id) { $result = tep_db_query("SELECT * FROM " . TABLE_PRODUCTS_ATTRIBUTES . " pa LEFT JOIN " . TABLE_PRODUCTS_OPTIONS . " po ON po.products_options_id=pa.options_id LEFT JOIN " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov ON pov.products_options_values_id=pa.options_values_id WHERE products_id=" . $_POST['add_product_products_id'] . " and options_id=" . $option_id . " and options_values_id=" . $option_value_id . " and po.language_id = '" . (int)$languages_id . "' and pov.language_id = '" . (int)$languages_id . "'"); $row = tep_db_fetch_array($result); extract($row, EXTR_PREFIX_ALL, "opt"); $AddedOptionsPrice += $opt_options_values_price; $option_value_details[$option_id][$option_value_id] = array ("options_values_price" => $opt_options_values_price); $option_names[$option_id] = $opt_products_options_name; $option_values_names[$option_value_id] = $opt_products_options_values_name; } } change to: // 2.1.1 Get Product Attribute Info if(is_array ($_POST['add_product_options'])) { foreach($_POST['add_product_options'] as $option_id => $option_value_id) { $result = tep_db_query("SELECT * FROM " . TABLE_PRODUCTS_ATTRIBUTES . " pa LEFT JOIN " . TABLE_PRODUCTS_OPTIONS . " po ON po.products_options_id=pa.options_id LEFT JOIN " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov ON pov.products_options_values_id=pa.options_values_id WHERE products_id=" . $_POST['add_product_products_id'] . " and options_id=" . $option_id . " and options_values_id=" . $option_value_id . " and po.language_id = '" . (int)$languages_id . "' and pov.language_id = '" . (int)$languages_id . "'"); $row = tep_db_fetch_array($result); extract($row, EXTR_PREFIX_ALL, "opt"); $AddedOptionsPrice += $opt_options_values_price; $option_value_details[$option_id][$option_value_id] = array ("options_values_price" => $opt_options_values_price); $option_names[$option_id] = $opt_products_options_name; $option_values_names[$option_value_id] = $opt_products_options_values_name; $products_stock_attributes_array = array(); $products_stock_attributes_array[] = $option_id . "-" . $option_value_id; $products_stock_attributes = implode(",", $products_stock_attributes_array); } } row 508 // 2.2 UPDATE ORDER #### $Query = "INSERT INTO " . TABLE_ORDERS_PRODUCTS . " SET orders_id = '" . $oID . "', products_id = '" . $_POST['add_product_products_id'] . "', products_model = '" . $p_products_model . "', products_name = '" . tep_html_quotes($p_products_name) . "', products_price = '". $p_products_price . "', final_price = '" . ($p_products_price + $AddedOptionsPrice) . "', products_tax = '" . tep_get_tax_rate($p_products_tax_class_id, $countryid, $zoneid) . "', products_quantity = '" . $_POST['add_product_quantity'] . "'"; tep_db_query($Query); $new_product_id = tep_db_insert_id(); change to: // 2.2 UPDATE ORDER #### $Query = "INSERT INTO " . TABLE_ORDERS_PRODUCTS . " SET orders_id = '" . $oID . "', products_id = '" . $_POST['add_product_products_id'] . "', products_model = '" . $p_products_model . "', products_name = '" . tep_html_quotes($p_products_name) . "', products_price = '". $p_products_price . "', final_price = '" . ($p_products_price + $AddedOptionsPrice) . "', products_tax = '" . tep_get_tax_rate($p_products_tax_class_id, $countryid, $zoneid) . "', products_quantity = '" . $_POST['add_product_quantity'] . "', products_stock_attributes = '" . $products_stock_attributes . "'"; tep_db_query($Query); $new_product_id = tep_db_insert_id(); At least this works for me. Hope it helps you. Grtz Lenny
  2. lennypost

    [Contribution] STS v4

    Hi all, Thanks for thinking along! I have ssl configured correctly. When (in modules admin panel) sts is turned off, everything works perfectly. All images and everything, nice lock item and no errors. I have no third party images and no stylesheet images. I have also created a complety blank template, with just $content in it, so no additional image or stuff is loaded, and that doesn't even work. No lock icon, something has to still request a http item. But it i can't find it. It has to be something in default sts 4.... Hope anyone throws in another idea.
  3. lennypost

    [Contribution] STS v4

    I have this problem too. For my site it is very important to have ssl, for we sell condoms and related items, so customers really check if the site is secure or not. When sts is turned off, ssl works like a charm, but with sts on, not al items on the site are secure. I have tried several things and also searched for the bug. But i could not find anything. Right now i just assigned the http-server to be https://myserver to at least have ssl work, but this is no good. It is so much slower since every item has to be incrypted, also on index and products_info. Anyone have any clue? Please help! Thanks.
  4. lennypost

    Batch Printing without Frames or PDF

    Warning: Header may not contain more than a single header, new line detected. in /home/lenny/domains/l10.nl/public_html/admin/print_batch_process.php on line 39 Name,Company,StreetAddress,Suburb,City,State,Postcode,Country gsd dsdg,gdsgs,asfasf,asdf,dsfaf,,fffadf,Netherlands I have this problem also. Default install. Does anyone have a clue? Thanks!!
  5. lennypost

    Free Shipping over $99.00

    http://www.oscommerce.com/community/contri...rch,free+amount This contrib only gets to work when the minumum amount is reached. It then overrules the other shipping methodes. Good luck! :thumbsup: Regardz Lenny.
  6. Hello Everyone, I have a problem with the shipping. I can't find a contribution for this combined request. :'( I have the zones shipping installed. With 3 zones: NL, Europe, Rest of the world. That works fine. But i also need shipping to be free, but the minimum amount is different for each zone e.g. ?50 for NL, ?100 for Europe, ?250 for World. There is a sepparate contrib for free amount shipping, but that only works overall... :( Help anyone??? Any suggestions....?? :blush: Thanks anyway!!! Grtz Lenny
×