NEW! Complete Order Editing Tool!

[djmonkey1]

I don't know where

TEXT_SUBTOTAL

TEXT_DISCOUNT

TEXT_DELIVERY

TEXT_TAX

TEXT_TOTAL

are coming from, those aren't used in this contribution. From the looks of it that's actually what's written for those entries in your database.

[olsonsp4c]

Hello... I just installed version 2.3 of the order editing tool and get the following error message when I try to edit an order:

 

Fatal error: Call to a member function on a non-object in /home/xxxxxxx/includes/modules/payment/freeofcharge.php on line 42

 

This is the line in the freeofcharge module that dynamically turnes this contrib off if the sum total of the order is <.01:

 

if ($cart->show_total() >= 0.01) {

$this->enabled = false;

 

Why would this cause it to be incompatible with the order editor?

 

Any thoughts?

 

Thanks!

 

Scott

[julbukki]

Here is screencapture about how taxes get handled. Some how it puts the whole total into this tax 22% at first time. I dont know what should i place into this single emptybox (percent or total). And then if i go ahean it adds this tax 22% into total so it douples the total.

I did updated into this latest 2_2_1 version. Any ideas how to correct this?

 

<bluenotemkvi - removed link to image>

Edited April 8, 2006 by BlueNoteMKVI

[Guest]

I am looking for a contribution that will allow me to enter an order through admin, edit the price and then enter the customers card details.

 

I've looked over this and dont quite get it. Whats the point?

 

If a customer adds items to there basket and then goes through the checkout. Then makes there payment. Whats the point in then editiing there order if they have already paid?

[djmonkey1]

Here is screencapture about how taxes get handled. Some how it puts the whole total into this tax 22% at first time. I dont know what should i place into this single emptybox (percent or total). And then if i go ahean it adds this tax 22% into total so it douples the total.

 

Please don't hotlink to images in password protected directories.

 

For your problem, post your shop setting of Display Prices with Tax as well as how many tax classes you use, with the number of tax rates in each class.

Edited April 7, 2006 by djmonkey1

[djmonkey1]

I am looking for a contribution that will allow me to enter an order through admin, edit the price and then enter the customers card details.

 

I've looked over this and dont quite get it. Whats the point?

 

If a customer adds items to there basket and then goes through the checkout. Then makes there payment. Whats the point in then editiing there order if they have already paid?

 

What's the point of you asking the same question that someone asks in this thread every few days?

[djmonkey1]

Hello... I just installed version 2.3 of the order editing tool and get the following error message when I try to edit an order:

 

Fatal error: Call to a member function on a non-object in /home/xxxxxxx/includes/modules/payment/freeofcharge.php on line 42

 

This is the line in the freeofcharge module that dynamically turnes this contrib off if the sum total of the order is <.01:

 

if ($cart->show_total() >= 0.01) {

$this->enabled = false;

 

Why would this cause it to be incompatible with the order editor?

 

Any thoughts?

 

Thanks!

 

Scott

 

That's a new one to me. Post a link to the download page for the contribution in question.

[Patty]

Hello.

 

I've installed OE for a client who's been using it for about one year with no problems (v1.61b). A couple of days ago I updated to the latest version and now OE is rounding prices down for products and shipping. Down here we don't use tax so I'm not concerned about that, which seems to be a big problem for most people.

 

ie:

Product 1 = $ 0.50 -> OE will change it to 0.00

Product 2 = $ 1.00

Shipping = 4.35 -> OE will change it to 4.00

 

The client didn't change anything in the order, she just updated the status and sent a note to her client, like she always does. The funny thing is, OE zeroed all products priced $0.50 but did not change the order total (luckly for her...). Unless shipping includes cents.

 

So how can I fix this so OE won't mess with the prices?

 

Thanks in advance for any help.

[djmonkey1]

Hello.

 

I've installed OE for a client who's been using it for about one year with no problems (v1.61b). A couple of days ago I updated to the latest version and now OE is rounding prices down for products and shipping. Down here we don't use tax so I'm not concerned about that, which seems to be a big problem for most people.

 

ie:

Product 1 = $ 0.50 -> OE will change it to 0.00

Product 2 = $ 1.00

Shipping = 4.35 -> OE will change it to 4.00

 

The client didn't change anything in the order, she just updated the status and sent a note to her client, like she always does. The funny thing is, OE zeroed all products priced $0.50 but did not change the order total (luckly for her...). Unless shipping includes cents.

 

So how can I fix this so OE won't mess with the prices?

 

Thanks in advance for any help.

 

What version are you using? A new one comes out every few days :). Have you tried a different version?

 

What version of osC is your client running? Does her shop feature any changes to the way product prices, etc, are calculated?

[Patty]

Tks for your quick reply. :)

 

I was using v1.61b. Now I updated to the last 2.2.1

I realized though that this problem started to happen on Mar 29. I installed some sales report contributions on that day. I looked into them but it doesn't seem that any of them changes the way prices are handled.

 

Another order just came in and a product priced 0.70 was rounded to 0.00!

 

When I edit the wrong prices for products and shipping on OE they stand corrected.

 

Any idea of what could be causing the store to round the prices down? I'm clueless.

[Patty]

I just noticed another thing: upon fixing the prices on the new order, OE accepts the new values but doesn't add them up on the subtotal. So I have:

 

Product 1 = 0.70 (fixed from 0.00)

Product 2 = 3.00

Product 3 = 5.00

Subtotal = 8.70

Shipping = 4.05 (fixed from 4.00)

Total = 12.75

 

But OE shows total = 12.00

 

On the order Details, all prices and total show fine. But if I go to OE from there the individual prices are corrected but the sum stays rounded down. Shouldn't all values look the same as in the order details? Now this looks like an OE bug, right? Any clues on how to fix it?

 

I'm confused. Now I don't know if the rounding problem has to do with OE or not. I just can tell it start happening on orders from 03/29 that I look up with OE. Before that the prices are not rounded down when looking with OE. >_<

Edited April 8, 2006 by Patty

[djmonkey1]

I just noticed another thing: upon fixing the prices on the new order, OE accepts the new values but doesn't add them up on the subtotal. So I have:

 

Product 1 = 0.70 (fixed from 0.00)

Product 2 = 3.00

Product 3 = 5.00

Subtotal = 8.70

Shipping = 4.05 (fixed from 4.00)

Total = 12.75

 

But OE shows total = 12.00

 

On the order Details, all prices and total show fine. But if I go to OE from there the individual prices are corrected but the sum stays rounded down. Shouldn't all values look the same as in the order details? Now this looks like an OE bug, right? Any clues on how to fix it?

 

I'm confused. Now I don't know if the rounding problem has to do with OE or not. I just can tell it start happening on orders from 03/29 that I look up with OE. Before that the prices are not rounded down when looking with OE. >_<

 

That sounds super bizarre to me.

 

Did your sales report contribution edit any of the following files:

admin/includes/application_top.php

admin/includes/classes/currencies.php

admin/includes/classes/order.php

admin/includes/functions/general.php (if so please specify which function(s))

 

Did you modify Order Editor in any way?

 

Have you made any changes to your database? For instance, in the table 'orders_products', if somehow the type setting of the field 'products_price' was changed to Decimal (15,0) the database would automatically round the products price to the nearest dollar (the correct setting is Decimal (15,4)). For the total being rounded, check the type setting of the 'value' field of the table 'order_totals'- that should also be Decimal (15, 4).

 

Also, after you've edited an order using Order Editor and you see that the total is being rounded compare the entries for 'value' and 'text' in the database for that line item. Are they both rounded, or just one of them?

[Patty]

It's more than bizarre and it's driving me nuts! :wacko:

 

I checked the DB and all values you mentioned are 15, 4, except product_tax, which is 7,4. But we don't use tax down here, so taxes values and problems are of no concern.

 

The only change I made to the orders table was the one instructed in your installation notes. And no, I didn't modify OE, just the language file to translate to Portuguese (the one included is incomplete). No change has been made to the way the store does its calculations or shows prices.

 

As for the new orders with rounded prices, on the DB just the final price is rounded. The product price shows the correct price.

 

Another weird thing: the confirmation email shows all orders and products with the right values. But when we check admin, Details shows the correct total and shipping, but the individual prices are rounded down. And OE, like I mentionet before, shows all fields as 0 if less than 1.00 and shipping rounded down and calculates the total showed on its page, which is different from the real total showed on Details.

Edited April 8, 2006 by Patty

[Patty]

Can't edit my post after a couple of minutes. :angry:

 

admin/includes/application_top.php has been modified on 03/28. I'll check on that now.

admin/includes/classes/order.php have been changed as per your installation instructions.

[Patty]

I checked admin/includes/application_top.php and there were only two things added for a couple fo reports:

 

Line 13

//Orderlist
define('FILENAME_ORDERLIST', 'orderlist.php');

 

Last lines

  // Sales report add on
define('FILENAME_STATS_SALES_REPORT', 'stats_sales_report.php');
?>

 

 

 

As for admin/order.php, here are the changes:

 

Old one

			<td class="pageHeading" align="right"><?php echo '<a href="' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('action'))) . '">' . tep_image_button('button_back.gif', IMAGE_BACK) . '</a>'; ?></td>

Changed for OE 2.2.1

			<!-- Changed for order editor -->
		<td class="pageHeading" align="right"><?php echo '<a href="' . tep_href_link(FILENAME_ORDERS_EDIT, 'oID=' . $_GET['oID']) . '">' . tep_image_button('button_edit.gif', IMAGE_EDIT) . '</a> <a href="' . tep_href_link(FILENAME_ORDERS_INVOICE, 'oID=' . $_GET['oID']) . '" TARGET="_blank">' . tep_image_button('button_invoice.gif', IMAGE_ORDERS_INVOICE) . '</a> <a href="' . tep_href_link(FILENAME_ORDERS_PACKINGSLIP, 'oID=' . $_GET['oID']) . '" TARGET="_blank">' . tep_image_button('button_packingslip.gif', IMAGE_ORDERS_PACKINGSLIP) . '</a> <a href="' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('action'))) . '">' . tep_image_button('button_back.gif', IMAGE_BACK) . '</a> '; ?></td>
		<!-- Changed for order editor -->

 

Old one

		<td colspan="2" align="right"><?php echo '<a href="' . tep_href_link(FILENAME_ORDERS_EDIT, 'oID=' . $HTTP_GET_VARS['oID']) . '">' . tep_image_button('button_edit.gif', IMAGE_EDIT) . '</a> <a href="' . tep_href_link(FILENAME_ORDERS_INVOICE, 'oID=' . $HTTP_GET_VARS['oID']) . '" TARGET="_blank">' . tep_image_button('button_invoice.gif', IMAGE_ORDERS_INVOICE) . '</a> <a href="' . tep_href_link(FILENAME_ORDERS_PACKINGSLIP, 'oID=' . $HTTP_GET_VARS['oID']) . '" TARGET="_blank">' . tep_image_button('button_packingslip.gif', IMAGE_ORDERS_PACKINGSLIP) . '</a> <a href="' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('action'))) . '">' . tep_image_button('button_back.gif', IMAGE_BACK) . '</a> '; ?></td>

Changed for OE 2.2.1

	  <!-- Changed for order editor -->
<td colspan="2" align="right"><?php echo '<a href="' . tep_href_link(FILENAME_ORDERS_EDIT, 'oID=' . $_GET['oID']) . '">' . tep_image_button('button_edit.gif', IMAGE_EDIT) . '</a> <a href="' . tep_href_link(FILENAME_ORDERS_INVOICE, 'oID=' . $_GET['oID']) . '" TARGET="_blank">' . tep_image_button('button_invoice.gif', IMAGE_ORDERS_INVOICE) . '</a> <a href="' . tep_href_link(FILENAME_ORDERS_PACKINGSLIP, 'oID=' . $_GET['oID']) . '" TARGET="_blank">' . tep_image_button('button_packingslip.gif', IMAGE_ORDERS_PACKINGSLIP) . '</a> <a href="' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('action'))) . '">' . tep_image_button('button_back.gif', IMAGE_BACK) . '</a> '; ?></td>
<!-- Changed for order editor -->

 

 

I also had two contributions added to that file: IP Addy and Column Sort that added the following:

 

Line 37

		$check_status_query = tep_db_query("select customers_name, customers_email_address, orders_status, ipaddy, date_purchased from " . TABLE_ORDERS . " where orders_id = '" . (int)$oID . "'");

 

Line 153

			  <!-- BOF IP addy -->
		  <tr>
			<td class="main">?</td>
		   </tr>
		   <tr>
			<td class="main"><b><?php echo ENTRY_IPADDRESS; ?></b></td>
			<td class="main"><?php echo $order->customer['ipaddy']; ?></td>
		   </tr>
		   <!-- EOF IP addy -->

Line 334 (right after the change for OE)

 <?php

// Admin Order Sort Mod Applied

  } else {
  if (isset($HTTP_GET_VARS['viewedSortOrder']))
  {
 $viewedSortOrder = $HTTP_GET_VARS['viewedSortOrder'];
 tep_session_register('viewedSortOrder');
  }
  if (isset($HTTP_GET_VARS['page']))
  {
 $page = $HTTP_GET_VARS['page'];
 tep_session_register('page');
  }
  if(!isset($page)) $page = 1;

  switch ($viewedSortOrder) {
   case "customer-asc":
	 $order .= "customers_name";
   break;
   case "customer-desc":
	 $order .= "customers_name DESC";
   break;
   case "date-asc":
	 $order .= "date_purchased";
   break;
   case "date-desc":
	 $order .= "date_purchased DESC";
   break;
   case "status-asc":
	 $order .= "orders_status_id";
   break;
   case "status-desc":
	 $order .= "orders_status_id DESC";
   break;
	default:
	$order .= "orders_id DESC";
  }
  ?>

 

Line 396

				 <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_CUSTOMERS; ?>?<a href="<?php echo "$PHP_SELF?viewedSortOrder=customer-asc"; ?>"><img src="images/icon_down.gif" border="0" width="11" height="12" alt="Descendente"></a><a href="<?php echo "$PHP_SELF?viewedSortOrder=customer-desc"; ?>"><img src="images/icon_up.gif" border="0" width="11" height="12" alt="Ascendente"></a></td>
			 <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ORDER_TOTAL; ?></td>
			 <td class="dataTableHeadingContent" align="center"><?php echo TABLE_HEADING_DATE_PURCHASED; ?><br><a href="<?php echo "$PHP_SELF?viewedSortOrder=date-asc"; ?>"><img src="images/icon_down.gif" border="0" width="11" height="12" alt="Descendente"></a><a href="<?php echo "$PHP_SELF?viewedSortOrder=date-desc"; ?>"><img src="images/icon_up.gif" border="0" width="11" height="12" alt="Ascendente"></a></td>
			 <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_STATUS; ?><br><a href="<?php echo "$PHP_SELF?viewedSortOrder=status-desc"; ?>"><img src="images/icon_down.gif" border="0" width="11" height="12" alt="Descendente"></a><a href="<?php echo "$PHP_SELF?viewedSortOrder=status-asc"; ?>"><img src="images/icon_up.gif" border="0" width="11" height="12" alt="Ascendente"></a></td>
			 <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ACTION; ?>?</td>
		   </tr>
<?php
 if (isset($HTTP_GET_VARS['cID'])) {
   $cID = tep_db_prepare_input($HTTP_GET_VARS['cID']);
   $orders_query_raw = "select o.orders_id, o.customers_name, o.customers_id, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.customers_id = '" . (int)$cID . "' and o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and ot.class = 'ot_total' order by $order";
	 } elseif (isset($HTTP_GET_VARS['status']) && is_numeric($HTTP_GET_VARS['status']) && ($HTTP_GET_VARS['status'] > 0)) {
   $status = tep_db_prepare_input($HTTP_GET_VARS['status']);
   $orders_query_raw = "select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and s.orders_status_id = '" . (int)$status . "' and ot.class = 'ot_total' order by o.orders_id DESC";
 } else {
   $orders_query_raw = "select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and ot.class = 'ot_total' order by $order";
 }

 

I hope this helps in solving the mistery, for I have no clue! :blink:

[djmonkey1]

Note: works with register_globals ON or OFF

 

4/8/2006

v2.4

-fixed bug in Payment Method dropdown where cc fields were not automatically displayed upon

selecting the Credit Card option from the list

 

-integrated multiple tax class patch by Hartmut Holzgraefe. Modified various portions of the patch,

such as the function tep_get_tax_rates_description and the expanded $orders_query, to allow for

having multiple tax rates per class.

 

-included modification of the $orders_products query in admin/includes/classes/order.php as part of

the fix for multiple tax classes and did away with duplicate query within edit_orders.php

 

-placed the function tep_get_tax_rates_description in admin/includes/functions/general.php so it

would be available to the order class

 

-included new input field, Price(base), to allow for on-the-fly calcs to include any product

attributes that may exist, and also to allow for editing of both price fields for each product in

an order to keep them in line with each other. Please see the README for more on this.

 

-Slightly modified the display text of the configuration input for Payment Method selector

 

-Changed javascript calculator to always format price calcs to four decimal places (as recommended

by Irin)

[Patty]

Hello again.

 

Just updated to v2.4. It didn't fix the problem I'm having with the rounded values, but now it shows the correct price for product in the product_price, but all other values are rounded down.

 

I had to correct all subtotals and totals manually on phpMyAdmin because OE is not updating the calculations, although it does corrects the prices. Is this a known bug?

 

I was searching the forums and found a thread about a PHP bug related to rounding numbers, maybe it has something to do with my problem? http://www.oscommerce.com/forums/index.php?showtopic=173656&st=0

 

Another thing I noticed in the new version is that nothing happens when I click on the help buttons. There's a javascript error on the page.

Edited April 9, 2006 by Patty

[Irin]

Hello,

 

I've just updated to the latest v2.4. When I click Update or add a new product to the order, the following warnings appear:

Warning: Cannot use a scalar value as an array in ...\osCommerce\admin\edit_orders.php on line 309

 

Warning: Cannot use a scalar value as an array in ...\osCommerce\admin\edit_orders.php on line 344

 

Warning: array_sum(): The argument should be an array in ...\osCommerce\admin\edit_orders.php on line 355

 

Warning: Cannot modify header information - headers already sent by (output started at ...\osCommerce\admin\edit_orders.php:309) in ...\osCommerce\admin\includes\functions\general.php on line 108

What's wrong? Any help appreciated.

 

Thanks,

Irina.

[djmonkey1]

Hello again.

 

Just updated to v2.4. It didn't fix the problem I'm having with the rounded values, but now it shows the correct price for product in the product_price, but all other values are rounded down.

 

I had to correct all subtotals and totals manually on phpMyAdmin because OE is not updating the calculations, although it does corrects the prices. Is this a known bug?

 

I was searching the forums and found a thread about a PHP bug related to rounding numbers, maybe it has something to do with my problem? http://www.oscommerce.com/forums/index.php?showtopic=173656&st=0

 

Another thing I noticed in the new version is that nothing happens when I click on the help buttons. There's a javascript error on the page.

 

Gack- there aren't supposed to be any help buttons....

[djmonkey1]

Hello,

 

I've just updated to the latest v2.4. When I click Update or add a new product to the order, the following warnings appear:

 

What's wrong? Any help appreciated.

 

Thanks,

Irina.

 

That's a very specific error and is probably referring to $RunningTax. That variable was scalar in the past and is now an array.

 

$RunningTax is declared as an array at line 197 for the update process and line 623 for the add a product process as shown here:

 

$RunningTax = array($default_tax_name => 0);

 

and should always be referred to as an array as in

 

$RunningTax[$default_tax_name]

 

What's inside the brackets varies depending on the case but the brackets should contain something.

 

Now that I've written all that, I have some ideas as to how this could happen. Did you do make sure you have all the steps in the install.txt completed? The file doesn't come with upgrade instructions (my fault), but if you look through the install.txt you may see things that you haven't done yet, like install a new function in functions/general.php and modify some queries in classes/order.php, etc.

[olsonsp4c]

That's a new one to me. Post a link to the download page for the contribution in question.

 

Here's the contribution in question:

 

http://www.oscommerce.com/community/contri...,free+of+charge

 

Free of charge payment module

 

thanks!

 

Scott

[lildog]

I am having a problem with some overlapping code. DJmonkey can probably help me as he worked on both contributions I am installing. Order Editor and Purchase without account. Busy guy. And two great contributions.

To install purchase without account I need to change line 27 in catalog/admin/includes/classes/order.php from:

$order_query = tep_db_query("select customers_name, customers_company.....

to:

$order_query = tep_db_query("select customers_id, customers_name, .....

BUT, order editor has already altered that line to:

$order_query = tep_db_query("select * from " . TABLE_ORDERS . " where orders_id = '" . (int)$order_id . "'");

Can someone help me fix this? I am relatively new to php and OSC. I would also like to know what the "*" stands for in the order editor line.

Thank you very much,

Todd

[Irin]

That's a very specific error and is probably referring to $RunningTax. That variable was scalar in the past and is now an array.

 

$RunningTax is declared as an array at line 197 for the update process and line 623 for the add a product process as shown here:

 

$RunningTax = array($default_tax_name => 0);

 

and should always be referred to as an array as in

 

$RunningTax[$default_tax_name]

 

What's inside the brackets varies depending on the case but the brackets should contain something.

 

Now that I've written all that, I have some ideas as to how this could happen. Did you do make sure you have all the steps in the install.txt completed? The file doesn't come with upgrade instructions (my fault), but if you look through the install.txt you may see things that you haven't done yet, like install a new function in functions/general.php and modify some queries in classes/order.php, etc.

You were right, djmonkey1. I'm missing some code in my admin/includes/classes/order.php. I have PayPal conrib and Product Description added to the $orders_products_query string, so this is how I modified my query. Please let me know if I'm missing anything.

$index = 0;

//begin PayPal_Shopping_Cart_IPN

$orders_products_query = tep_db_query("select op.orders_products_id, op.products_name, p.products_description, op.products_model, op.products_price, op.products_tax, op.products_quantity, op.final_price, op.products_id, p.products_tax_class_id from " . TABLE_ORDERS_PRODUCTS . " as op, ". TABLE_PRODUCTS_DESCRIPTION. " as p on op.products_id = p.products_id where orders_id = '" . (int)$order_id . "' and p.language_id= '" . (int)$languages_id . "' and p.products_id=op.products_id");

//end PayPal_Shopping_Cart_IPN

while ($orders_products = tep_db_fetch_array($orders_products_query)) {

$this->products[$index] = array('qty' => $orders_products['products_quantity'],

//begin PayPal_Shopping_Cart_IPN

'id' => $orders_products['products_id'],

'orders_products_id' => $orders_products['orders_products_id'],

//end PayPal_Shopping_Cart_IPN

'name' => $orders_products['products_name'],

'model' => $orders_products['products_model'],

'description' => $orders_products['products_description'],

'tax' => $orders_products['products_tax'],

'tax_description' => tep_get_tax_rates_description($orders_products['products_tax_class_id']),

'price' => $orders_products['products_price'],

'final_price' => $orders_products['final_price'],

'orders_products_id' => $orders_products['orders_products_id']);

 

$subindex = 0;

//begin PayPal_Shopping_Cart_IPN

$attributes_query = tep_db_query("select products_options, products_options_values, options_values_price, price_prefix, products_options_id, products_options_values_id from " . TABLE_ORDERS_PRODUCTS_ATTRIBUTES . " where orders_id = '" . (int)$order_id . "' and orders_products_id = '" . (int)$orders_products['orders_products_id'] . "'");

//end PayPal_Shopping_Cart_IPN

if (tep_db_num_rows($attributes_query)) {

while ($attributes = tep_db_fetch_array($attributes_query)) {

$this->products[$index]['attributes'][$subindex] = array('option' => $attributes['products_options'],

//begin PayPal_Shopping_Cart_IPN

'option_id' => $attributes['products_options_id'],

'value_id' => $attributes['products_options_values_id'],

//end PayPal_Shopping_Cart_IPN

'value' => $attributes['products_options_values'],

'prefix' => $attributes['price_prefix'],

'price' => $attributes['options_values_price'],

'orders_products_attributes_id' => $attributes['orders_products_attributes_id']);

Thanks,

Irina.

Edited April 9, 2006 by Irin

[Patty]

Gack- there aren't supposed to be any help buttons....

 

Well.... there are! :blink:

And I didn't change anything, except the language file to Portuguese.

Check it out:

 

There must be some kind of poltergeist around here, for I couldn't figure out the rounding problem yet and I found out that my test store on my local server is having the same problem! :o

[Patty]

Damn! The edit feature vanishes too fast!! :angry:

 

What about OE not recalculating the corrected values and keeping the same order total from before the correction?? Isn't OE supposed to recalculate the new values?