Jump to content

royal38

Members
  • Content count

    66
  • Joined

  • Last visited

Profile Information

  • Real Name
    Jean D.
  1. royal38

    Official PayPal IPN Support Thread

    I've found the problem. The invoice parameter is missing in the ipn process for 80% of order. Where can I correct this problem of invoice parameter which is missing? Thanks and best regards.
  2. royal38

    Official PayPal IPN Support Thread

    Hello, Now, 20% of IPN are received but 80% aren't. Can someone help me? Thanks
  3. royal38

    Official PayPal IPN Support Thread

    Hello, I have some problems with paypal IPN 2.1.0.0 since we upgrade to PHP 5.3. When there is paypal payment, the status of order doesn't update to "Payment clear". We have to validate the order manually. Can someone help me? Thanks and best regards. Fabien.
  4. royal38

    Bundled Products

    Hi all, I use this contribution for more than 1 year and it is great. But does someone find how to choose the slave products depending on the color chosen (attribute)? Thanks a lot ;)
  5. royal38

    NEW! Complete Order Editing Tool!

    Can you put the solution on this topic when you got it? Thanks a lot.
  6. royal38

    NEW! Complete Order Editing Tool!

    It is not really solved. I try something but I have to update the order 3 times to have the godd subtotal. <_< In catalog/admin/order_editor/order.php , I've add : $custom_query = tep_db_query("select sum(value) as cusval from " . TABLE_ORDERS_TOTAL . " where orders_id = '" . (int)$order_id . "' and class like 'ot_custom%'"); $custom = tep_db_fetch_array($custom_query); $subval = $this->info['subtotal']; $sumcus = $custom['cusval']; $this->info['subtotal'] = $subval + $sumcus;// - $this->info['shipping_cost'];//$subval + $sumcus; Someone have a best solution? Thanks a lot
  7. royal38

    NEW! Complete Order Editing Tool!

    Hello, Can someone tell me how to add or substract the value of ot_custom_x to the subtotal? When I add a custom field, it's add the value to the total but not on the subtotal. Can someone help me to solve these? Thansk a lot.
  8. royal38

    NEW! Complete Order Editing Tool!

    Hello, I use the contrib order editor which is great but I have a little bug with it : Discount don't apply on subtotal, only on total. Because of that, tax and price excluding tax are wrong because there are based on the subtotal (in my version). As you can see, subtotal don't include the discount :angry: but is included in the total. :blink: I try all this afternoon to modify the file order.php which is in the file "order_editor", but I failed to apply "discount" which is a custom on the subtotal. I don't know how to apply discount on this code : Thanks a lot for your help. Bye ;)
  9. Hello, I use the contrib order editor which is great but I have a little bug with it : Discount don't apply on subtotal, only on total. Because of that, tax and price excluding tax are wrong because there are based on the subtotal. As you can see, subtotal don't include the discount :angry: but is included in the total. :blink: I try all this afternoon to modify the file order.php which is in the file "order_editor", but I failed to apply "discount" which is a custom on the subtotal. I don't know how to apply discount on this code : Thanks a lot for your help. Bye ;)
  10. No one? :huh: Thanks ^_^
  11. Hello, I want to go over 200 or 300... but not 32767... So can I get some errors if I change the type in the database? What means the (4) in "tinyint(4)"? Thanks a lot :)
  12. Hello, I use Bundled products contribution, and max quantity for bundled products is only 127. If I change the data type ( actually tinyint(4) ) to smallint(6), I will have some errors in your opinion? Thank a lot. ;)
  13. royal38

    Bundled products and paypal ipn

    Solved ;) In the new version, it's not in paypal_ipn.php but in ipn.php (which is in folder "ext") Bye
  14. royal38

    Bundled products

    Hello, I've a problem with paypal ipn. I try to include this code in my paypal_ipn.php but I can't find this code which must be replaced! : for ($i=0, $n=sizeof($order->products); $i<$n; $i++) { // Stock Update - Joao Correia if (STOCK_LIMITED == 'true') { if (DOWNLOAD_ENABLED == 'true') { $stock_query_raw = "SELECT products_quantity, pad.products_attributes_filename FROM " . TABLE_PRODUCTS . " p LEFT JOIN " . TABLE_PRODUCTS_ATTRIBUTES . " pa ON p.products_id=pa.products_id LEFT JOIN " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD . " pad ON pa.products_attributes_id=pad.products_attributes_id WHERE p.products_id = '" . tep_get_prid($order->products[$i]['id']) . "'"; // Will work with only one option for downloadable products // otherwise, we have to build the query dynamically with a loop $products_attributes = $order->products[$i]['attributes']; if (is_array($products_attributes)) { $stock_query_raw .= " AND pa.options_id = '" . $products_attributes[0]['option_id'] . "' AND pa.options_values_id = '" . $products_attributes[0]['value_id'] . "'"; } $stock_query = tep_db_query($stock_query_raw); } else { $stock_query = tep_db_query("select products_quantity from " . TABLE_PRODUCTS . " where products_id = '" . tep_get_prid($order->products[$i]['id']) . "'"); } if (tep_db_num_rows($stock_query) > 0) { $stock_values = tep_db_fetch_array($stock_query); // do not decrement quantities if products_attributes_filename exists if ((DOWNLOAD_ENABLED != 'true') || (!$stock_values['products_attributes_filename'])) { $stock_left = $stock_values['products_quantity'] - $order->products[$i]['qty']; } else { $stock_left = $stock_values['products_quantity']; } tep_db_query("update " . TABLE_PRODUCTS . " set products_quantity = '" . $stock_left . "' where products_id = '" . tep_get_prid($order->products[$i]['id']) . "'"); if ( ($stock_left < 1) && (STOCK_ALLOW_CHECKOUT == 'false') ) { tep_db_query("update " . TABLE_PRODUCTS . " set products_status = '0' where products_id = '" . tep_get_prid($order->products[$i]['id']) . "'"); } } } Does someone have the same problem. Thanks a lot ;)
  15. royal38

    Bundled products and paypal ipn

    Hello, I try to install the contrib Bundled products, and to install it, I need to edit paypal_ipn.php I have to search this code in paypal_ipn.php for ($i=0, $n=sizeof($order->products); $i<$n; $i++) { // Stock Update - Joao Correia if (STOCK_LIMITED == 'true') { if (DOWNLOAD_ENABLED == 'true') { $stock_query_raw = "SELECT products_quantity, pad.products_attributes_filename FROM " . TABLE_PRODUCTS . " p LEFT JOIN " . TABLE_PRODUCTS_ATTRIBUTES . " pa ON p.products_id=pa.products_id LEFT JOIN " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD . " pad ON pa.products_attributes_id=pad.products_attributes_id WHERE p.products_id = '" . tep_get_prid($order->products[$i]['id']) . "'"; // Will work with only one option for downloadable products // otherwise, we have to build the query dynamically with a loop $products_attributes = $order->products[$i]['attributes']; if (is_array($products_attributes)) { $stock_query_raw .= " AND pa.options_id = '" . $products_attributes[0]['option_id'] . "' AND pa.options_values_id = '" . $products_attributes[0]['value_id'] . "'"; } $stock_query = tep_db_query($stock_query_raw); } else { $stock_query = tep_db_query("select products_quantity from " . TABLE_PRODUCTS . " where products_id = '" . tep_get_prid($order->products[$i]['id']) . "'"); } if (tep_db_num_rows($stock_query) > 0) { $stock_values = tep_db_fetch_array($stock_query); // do not decrement quantities if products_attributes_filename exists if ((DOWNLOAD_ENABLED != 'true') || (!$stock_values['products_attributes_filename'])) { $stock_left = $stock_values['products_quantity'] - $order->products[$i]['qty']; } else { $stock_left = $stock_values['products_quantity']; } tep_db_query("update " . TABLE_PRODUCTS . " set products_quantity = '" . $stock_left . "' where products_id = '" . tep_get_prid($order->products[$i]['id']) . "'"); if ( ($stock_left < 1) && (STOCK_ALLOW_CHECKOUT == 'false') ) { tep_db_query("update " . TABLE_PRODUCTS . " set products_status = '0' where products_id = '" . tep_get_prid($order->products[$i]['id']) . "'"); } } } The problem is that I haven't this code in my paypal_ipn.php . Can someone tell me what's the problem?? Here is my paypal ipn version : osCommerce PayPal IPN Module v2.2 For 2.2MS2 (14 jan 2007) Thanks a lot for your help ;)
×