royal38
Pioneers-
Posts
66 -
Joined
-
Last visited
Profile Information
-
Real Name
Jean D.
royal38's Achievements
-
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.
-
Hello, Now, 20% of IPN are received but 80% aren't. Can someone help me? Thanks
-
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.
-
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 ;)
-
Can you put the solution on this topic when you got it? Thanks a lot.
-
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
-
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.
-
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 ;)
-
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 ;)
-
Bundled Products : Max quantity is 127 !
royal38 replied to royal38's topic in General Add-Ons Support
No one? :huh: Thanks ^_^ -
Bundled Products : Max quantity is 127 !
royal38 replied to royal38's topic in General Add-Ons Support
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 :) -
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. ;)
-
Solved ;) In the new version, it's not in paypal_ipn.php but in ipn.php (which is in folder "ext") Bye
-
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 ;)
-
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 ;)