NEW! Complete Order Editing Tool!

chameleon · August 3, 2006

thx its working great you are a hearo

stefanlindvald · August 3, 2006

Hi djmonkey!

Thanx for a really useful contribution :)

I have a small(?) problem with the taxes, eg how the taxes are shown.

At first, when displaying the order, it shows the way I like it. 'Varav moms' is tax included and 'R?rlig fraktkostnad' is shipping cost.

When starting editing order all parts looks nice, except the tax that don't sum up the right way. It sum the total instead of 25% tax of total. The end row should be as in picture above, 22,20kr. (...and not 111kr)

After just an update the total component change. The taxes are correct but devided into shipping tax and "normal" tax - I just want one summarized tax. ...and I would prefer the tax to be shown on the end row - as same as the first picture ...if possible...

Is it possible to make some changes to the code in edit_orders.php to accomplish this? I tried for two days without any luck :'(

Help is very much appreciated!

Best regards

Stefan

PS Excuse my english - not my main language ;)

stefanlindvald · August 3, 2006

missed some info:

I have just updated from 2.6.1 to 2.6.2. It did not help :(

I use prices with tax (25%) included, and thats why I want the separate row in the end showing how much tax is included in total sum.

Hope someone can help or have an idea how to solve it.

Best regards

Stefan

djmonkey1 · August 4, 2006

I have just updated from 2.6.1 to 2.6.2. It did not help :(

What is the ot_class value of 'Varav moms' as stored in the orders_total table in the database? For instance total is ot_subtotal, subtotal is ot_subtotal, etc.

GoTTi · August 4, 2006

does this work when adding digital downloading to orders?

ive tried and it wont add the download link to the order.

kbking · August 4, 2006

What is the ot_class value of 'Varav moms' as stored in the orders_total table in the database? For instance total is ot_subtotal, subtotal is ot_subtotal, etc.

I have the same issue as Stefan has. In my orders_total table the ot_class value of "Varav moms" is ot_tax.

stefanlindvald · August 4, 2006

What is the ot_class value of 'Varav moms' as stored in the orders_total table in the database? For instance total is ot_subtotal, subtotal is ot_subtotal, etc.

The class of the tax 'Varav moms' is called ot_total_moms

Best regards

Stefan

djmonkey1 · August 4, 2006

does this work when adding digital downloading to orders?

ive tried and it wont add the download link to the order.

On what page exactly is the download link supposed to appear?

djmonkey1 · August 4, 2006

The class of the tax 'Varav moms' is called ot_total_moms

Best regards

Stefan

Try this: do a find and replace on your admin/edit_orders.php file and change every instance of "ot_tax" to "ot_total_moms".

djmonkey1 · August 4, 2006

I have the same issue as Stefan has. In my orders_total table the ot_class value of "Varav moms" is ot_tax.

That's very strange. I wouldn't expect you to have the exact same problem in that case.

I take it you've fixed the problems you mentioned earlier, or are at least not experiencing them anymore?

kbking · August 4, 2006

That's very strange. I wouldn't expect you to have the exact same problem in that case.

I take it you've fixed the problems you mentioned earlier, or are at least not experiencing them anymore?

It seems like the problem fixed itself, sort of. Anyway the whole page shows up now.

Maybe I was too fast to reply above. When I recieve the order, the whole order seems to have been calculated correct, as far as I can tell. Then if I only hit the update button in edit_orders.php the fields Moms (=VAT) and Total changes with the same amount.

Sorry! Right now - as I'm typing - I discovered that I have to enter the Shipping Tax myself. I did that and all of the figures stays the same as when I first recieved the order. I take it that's how it all works, right?

djmonkey1 · August 4, 2006

It seems like the problem fixed itself, sort of. Anyway the whole page shows up now.

Maybe I was too fast to reply above. When I recieve the order, the whole order seems to have been calculated correct, as far as I can tell. Then if I only hit the update button in edit_orders.php the fields Moms (=VAT) and Total changes with the same amount.

Sorry! Right now - as I'm typing - I discovered that I have to enter the Shipping Tax myself. I did that and all of the figures stays the same as when I first recieved the order. I take it that's how it all works, right?

Yes- osCommerce, for some reason, does not store the shipping tax rate amount when an order is processed. The shipping_tax field for Order Editor was added to try to compensate for that, but without additional modifications it only works when you update it manually via Order Editor. If you always or almost always charge the same rate for shipping tax you can change the default value of that field in the database to save some time when editing future orders.

If you want to get really creative you can modify the checkout process to store the shipping tax rate along with all the other order information. :)

August 5, 2006

Hi djmonkey1,

I'm hoping Order Editor will help me. But I would like to get your input before I use this contribution.

I combine shipping at a flat rate, I have figured out how to do this through the shipping table tool. I would rather not use the table, as I offer various items and the table could lock the buyer into excess fees.

Will Order Editor allow me to adjust total shipping costs to reflect total quantity ordered? I also need to be able to change shipping costs because of location of buyers (domestic vs international).

Thanks, Kathy

djmonkey1 · August 5, 2006

Hi djmonkey1,

I'm hoping Order Editor will help me. But I would like to get your input before I use this contribution.

I combine shipping at a flat rate, I have figured out how to do this through the shipping table tool. I would rather not use the table, as I offer various items and the table could lock the buyer into excess fees.

Will Order Editor allow me to adjust total shipping costs to reflect total quantity ordered? I also need to be able to change shipping costs because of location of buyers (domestic vs international).

Thanks, Kathy

With Order Editor you can change the shipping fee to be whatever you want, add/subtract products, change prices, tax rates, and/or quantities of items, add/subtract custom fees, etc.

August 5, 2006

With Order Editor you can change the shipping fee to be whatever you want, add/subtract products, change prices, tax rates, and/or quantities of items, add/subtract custom fees, etc.

Thank you for your response. I will be giving it a try.

Kathy

GoTTi · August 5, 2006

On what page exactly is the download link supposed to appear?

the download link is shown:

account_history_info.php?order_id=XXXX

at the bottom of that page, it shows up below "Download Links"

djmonkey1 · August 6, 2006

the download link is shown:

account_history_info.php?order_id=XXXX

at the bottom of that page, it shows up below "Download Links"

After looking at this more there are three things that I've identified Order Editor should be able to do as far as downloads are concerned: delete the download info from the database if the associated product is deleted; show the download options that may exist for a given product with the ability to edit those options (filename, expiry days, and max downloads); and, when adding a product, properly identify downloadable products and write the applicable data to the database.

The first step, deleting, is easy. In admin/edit_orders.php find at about line 209:

				$Query = "DELETE FROM " . TABLE_ORDERS_PRODUCTS_ATTRIBUTES . " 
			WHERE orders_id = '" . (int)$oID . "' 
			AND orders_products_id = '$orders_products_id';";
			tep_db_query($Query);

and add directly below it

				$Query2 = "DELETE FROM " . TABLE_ORDERS_PRODUCTS_DOWNLOAD . "
			WHERE orders_id = '" . (int)$oID . "'
			AND orders_products_id = '$orders_products_id';";
			tep_db_query($Query2);

The second step, displaying download info per product, I think I've got down also. At about line 367 find:

// 1.4 UPDATE SHIPPING, CUSTOM FEES, DISOUNTS, TAXES, AND TOTALS #####

and add above it

//1.3.5
	//update any downloads that may exist
  if (is_array($_POST['update_downloads'])) {
  foreach($_POST['update_downloads'] as $orders_products_download_id => $download_details) {
	$Query = "UPDATE " . TABLE_ORDERS_PRODUCTS_DOWNLOAD . " SET
				orders_products_filename = '" . $download_details["filename"] . "',
				download_maxdays = '" . $download_details["maxdays"] . "',
				download_count = '" . $download_details["maxcount"] . "'
				WHERE orders_id = '" . (int)$oID . "'
				AND orders_products_download_id = '$orders_products_download_id';";
				tep_db_query($Query);
			}
			}

Then at about line 1435 find

				echo '</small></nobr>';
		}
	}

	echo '		</td>' . "\n" .

and change it to

echo '</small></nobr>';
		}  //end for ($j=0; $j<sizeof($order->products[$i]['attributes']); $j++) {

		 //Has downloads?
	if (DOWNLOAD_ENABLED == 'true') {
  $downloads_count = 1;
  $d_index = 0;
  $download_query_raw ="SELECT *
					 FROM " . TABLE_ORDERS_PRODUCTS_DOWNLOAD . "							   
					 WHERE orders_products_id='" . $orders_products_id . "'
					 AND orders_id='" . (int)$oID . "'
					 ORDER BY orders_products_download_id";

	$download_query = tep_db_query($download_query_raw);

	//
	if (isset($downloads->products)) unset($downloads->products);
	//

	if (tep_db_num_rows($download_query) > 0) {
	while ($download = tep_db_fetch_array($download_query)) {

	 $downloads->products[$d_index] = array(
				'id' => $download['orders_products_download_id'],
				'filename' => $download['orders_products_filename'],
				'maxdays' => $download['download_maxdays'],
				'maxcount' => $download['download_count']);

	$d_index++; 

	} 
   } 

 for ($mm=0; $mm<sizeof($downloads->products); $mm++) {  
 $id =  $downloads->products[$mm]['id'];
 echo '<br /><small>';
 echo '<nobr>' . "Download #" . $downloads_count . "";
 echo ' </nobr><br />' . "\n";
 echo '<nobr>' . " - Filename: <input name='update_downloads[$id][filename]' size='12' value='" . $downloads->products[$mm]['filename'] . "'>";
 echo ' </nobr><br />' . "\n";
 echo '<nobr>' . " - Expiry days: <input name='update_downloads[$id][maxdays]' size='6' value='" . $downloads->products[$mm]['maxdays'] . "'>";
 echo ' </nobr><br />' . "\n";
 echo '<nobr>' . " - Downloads remaining: <input name='update_downloads[$id][maxcount]' size='6' value='" . $downloads->products[$mm]['maxcount'] . "'>";
 echo ' </nobr>' . "\n";
 echo '<hr /></small>';
 $downloads_count++;
} //end  for ($mm=0; $mm<sizeof($download_query); $mm++) {
} //end download

	} //end if (sizeof($order->products[$i]['attributes']) > 0) {

	echo '		</td>' . "\n" .

The third step, adding a downloadable product, I'm still working on. But if you could test these changes out and see how they work that would be much appreciated. Also, if you know of anything else that can or should be changed for Order Editor to work with downloads please post that as well.

djmonkey1 · August 6, 2006

the download link is shown:

account_history_info.php?order_id=XXXX

at the bottom of that page, it shows up below "Download Links"

It looks like the changes for "add a product" may have been easier than I thought.

Find somewhere in the neighborhood of line 500:

"options_values_price" => $opt_options_values_price,
				"price_prefix" => $opt_price_prefix);
				$option_names[$option_id] = $opt_products_options_name;
				$option_values_names[$option_value_id] = $opt_products_options_values_name;

and add below it

//add on for downloads
	if (DOWNLOAD_ENABLED == 'true') {
	$download_query_raw ="select products_attributes_filename, products_attributes_maxdays, products_attributes_maxcount 
	from " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD . " 
	where products_attributes_id='" . $opt_products_attributes_id . "'";

	$download_query = tep_db_query($download_query_raw);
	if (tep_db_num_rows($download_query) > 0) {
	  $download = tep_db_fetch_array($download_query);
	  $filename[$option_id] = $download['products_attributes_filename'];
	  $maxdays[$option_id]  = $download['products_attributes_maxdays'];
	  $maxcount[$option_id] = $download['products_attributes_maxcount'];
	} //end if (tep_db_num_rows($download_query) > 0) {
	} //end if (DOWNLOAD_ENABLED == 'true') {
	//end downloads

Then find what might be near line 584:

options_values_price = '" . 
	$option_value_details[$option_id][$option_value_id]['options_values_price'] . "',

					price_prefix = '" . 
					$option_value_details[$option_id][$option_value_id]['price_prefix'] . "'";

				tep_db_query($Query);

and add below it

//add on for downloads
	if (DOWNLOAD_ENABLED == 'true' && isset($filename[$option_id])) {

	$Query2 = "INSERT INTO " . TABLE_ORDERS_PRODUCTS_DOWNLOAD . " SET
			orders_id = '" . (int)$oID . "',
			orders_products_id = '" . $new_product_id . "',
			orders_products_filename = '" . $filename[$option_id] . "',
			download_maxdays = '" . $maxdays[$option_id] . "',
			download_count = '" . $maxcount[$option_id] . "'";

				tep_db_query($Query2);

	   } //end if (DOWNLOAD_ENABLED == 'true') {
	//end downloads

And that should be it. Apply all those changes (make sure you read the previous post) and see how things work then. Once we get this all worked out I'll include the changes in the next release.

Edited August 6, 2006 by djmonkey1

DarrenWu · August 7, 2006

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

I tried above changes, it doesn't work on my. mine is clean installation store + QTP 4.25 + order editor 2.62

my item is Rings, Ring has different size. each size has different quantities.

when i try to delete a product from a order with order editor. the quantity of that order only restock to the item inventory. but we really need that quantity also restock to that attributes.

djmonkey1 · August 7, 2006

I tried above changes, it doesn't work on my. mine is clean installation store + QTP 4.25 + order editor 2.62

my item is Rings, Ring has different size. each size has different quantities.

when i try to delete a product from a order with order editor. the quantity of that order only restock to the item inventory. but we really need that quantity also restock to that attributes.

These changes only affect the "add a product" function and hence do not change how Order Editor behaves when changing quantities and/or deleting a product. That's what Lenny was referring to when he said "Maybe someone else can check the regular Stock check and fill this in". Sorry I can't be of more help but QTPro is outside my realm of knowledge. Maybe the developer(s) of that contribution can help out?

GoTTi · August 8, 2006

After looking at this more there are three things that I've identified Order Editor should be able to do as far as downloads are concerned: delete the download info from the database if the associated product is deleted; show the download options that may exist for a given product with the ability to edit those options (filename, expiry days, and max downloads); and, when adding a product, properly identify downloadable products and write the applicable data to the database.

The first step, deleting, is easy. In admin/edit_orders.php find at about line 209:

				$Query = "DELETE FROM " . TABLE_ORDERS_PRODUCTS_ATTRIBUTES . " 
			WHERE orders_id = '" . (int)$oID . "' 
			AND orders_products_id = '$orders_products_id';";
			tep_db_query($Query);

and add directly below it

				$Query2 = "DELETE FROM " . TABLE_ORDERS_PRODUCTS_DOWNLOAD . "
			WHERE orders_id = '" . (int)$oID . "'
			AND orders_products_id = '$orders_products_id';";
			tep_db_query($Query2);

The second step, displaying download info per product, I think I've got down also. At about line 367 find:

// 1.4 UPDATE SHIPPING, CUSTOM FEES, DISOUNTS, TAXES, AND TOTALS #####

and add above it

//1.3.5
	//update any downloads that may exist
  if (is_array($_POST['update_downloads'])) {
  foreach($_POST['update_downloads'] as $orders_products_download_id => $download_details) {
	$Query = "UPDATE " . TABLE_ORDERS_PRODUCTS_DOWNLOAD . " SET
				orders_products_filename = '" . $download_details["filename"] . "',
				download_maxdays = '" . $download_details["maxdays"] . "',
				download_count = '" . $download_details["maxcount"] . "'
				WHERE orders_id = '" . (int)$oID . "'
				AND orders_products_download_id = '$orders_products_download_id';";
				tep_db_query($Query);
			}
			}

Then at about line 1435 find

				echo '</small></nobr>';
		}
	}

	echo '		</td>' . "\n" .

and change it to

echo '</small></nobr>';
		}  //end for ($j=0; $j<sizeof($order->products[$i]['attributes']); $j++) {

		 //Has downloads?
	if (DOWNLOAD_ENABLED == 'true') {
  $downloads_count = 1;
  $d_index = 0;
  $download_query_raw ="SELECT *
					 FROM " . TABLE_ORDERS_PRODUCTS_DOWNLOAD . "							   
					 WHERE orders_products_id='" . $orders_products_id . "'
					 AND orders_id='" . (int)$oID . "'
					 ORDER BY orders_products_download_id";

	$download_query = tep_db_query($download_query_raw);

	//
	if (isset($downloads->products)) unset($downloads->products);
	//

	if (tep_db_num_rows($download_query) > 0) {
	while ($download = tep_db_fetch_array($download_query)) {

	 $downloads->products[$d_index] = array(
				'id' => $download['orders_products_download_id'],
				'filename' => $download['orders_products_filename'],
				'maxdays' => $download['download_maxdays'],
				'maxcount' => $download['download_count']);

	$d_index++; 

	} 
   } 

 for ($mm=0; $mm<sizeof($downloads->products); $mm++) {  
 $id =  $downloads->products[$mm]['id'];
 echo '<br /><small>';
 echo '<nobr>' . "Download #" . $downloads_count . "";
 echo ' </nobr><br />' . "\n";
 echo '<nobr>' . " - Filename: <input name='update_downloads[$id][filename]' size='12' value='" . $downloads->products[$mm]['filename'] . "'>";
 echo ' </nobr><br />' . "\n";
 echo '<nobr>' . " - Expiry days: <input name='update_downloads[$id][maxdays]' size='6' value='" . $downloads->products[$mm]['maxdays'] . "'>";
 echo ' </nobr><br />' . "\n";
 echo '<nobr>' . " - Downloads remaining: <input name='update_downloads[$id][maxcount]' size='6' value='" . $downloads->products[$mm]['maxcount'] . "'>";
 echo ' </nobr>' . "\n";
 echo '<hr /></small>';
 $downloads_count++;
} //end  for ($mm=0; $mm<sizeof($download_query); $mm++) {
} //end download

	} //end if (sizeof($order->products[$i]['attributes']) > 0) {

	echo '		</td>' . "\n" .

The third step, adding a downloadable product, I'm still working on. But if you could test these changes out and see how they work that would be much appreciated. Also, if you know of anything else that can or should be changed for Order Editor to work with downloads please post that as well.

i added the code and it looks like everything is the same. im not quite sure what youve had me add.

i dont really understand how to mod this cart so i wont be much help with the enhancing it with you part, but i will be happy to test out the options as you give them to me.

ive taken a screen shot, with this mod youve told me to do, of the edit_order.php page after ive added a digital download to a users order. on the users site, under account_history_info.php, the digital download is NOT showing up still that ive added.

here is the screen shot:

you can also see in this image that the first item is the actual order that tookplace, the 2nd item line is the added item, and you can see its not inserting the file name, expiration, and downloads remaining.

good luck. let me know if you come up with some solutions.

djmonkey1 · August 8, 2006

i added the code and it looks like everything is the same. im not quite sure what youve had me add.

i dont really understand how to mod this cart so i wont be much help with the enhancing it with you part, but i will be happy to test out the options as you give them to me.

ive taken a screen shot, with this mod youve told me to do, of the edit_order.php page after ive added a digital download to a users order. on the users site, under account_history_info.php, the digital download is NOT showing up still that ive added.

here is the screen shot:

you can also see in this image that the first item is the actual order that tookplace, the 2nd item line is the added item, and you can see its not inserting the file name, expiration, and downloads remaining.

good luck. let me know if you come up with some solutions.

The first steps, in the post you replied to, only added the ability to display and modify download information that already existed. The code for 'add a product' was in the second message: http://www.oscommerce.com/forums/index.php?s=&...st&p=910496

Have you made all the changes from both posts?

GoTTi · August 9, 2006

The first steps, in the post you replied to, only added the ability to display and modify download information that already existed. The code for 'add a product' was in the second message: http://www.oscommerce.com/forums/index.php?s=&...st&p=910496

Have you made all the changes from both posts?

B E A UTIFUL!!!!

man u just saved me a LOT of time.....

i missed the 2nd post you had there, and did the insert of the digital download and this works perfect.

MUST add this to the next official release.

djmonkey1 · August 9, 2006

MUST add this to the next official release.

Done! Thanks for testing this out!

khoking · August 14, 2006

I am currently using an old version of order editor (v2.1 if I am not mistaken), and I would like to know if the following problem has been fixed in the new version before I upgrate it:

1. My default currencyis MYR (Malaysia Ringgit) (MYR1 = USD0.2857)

2. I have other currency in my store, eg. USD, Pound, S$...etc.

3. When a customer ordered in USD, if I edit the order using order editor by adding products or making changes to the price/shipping, then the whole order is messed up.

4. Order editor use the different value and figure in the total $...and the total $ becomes NOT CORRECT.

5. I have to go to PHPAdmin to edit that particular order number to change the shipping, total and item value to USD equivalent.

Is the order editor works for multiple currency store?

NEW! Complete Order Editing Tool!

Recommended Posts

Link to comment

Share on other sites

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Popular Posts

BrockleyJohn

piernas

BrockleyJohn

Posted Images

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Guest

Link to comment

Share on other sites

Link to comment

Share on other sites

Guest

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Join the conversation