Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

NEW! Complete Order Editing Tool!


jhilgeman

Recommended Posts

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.

sum1.gif

 

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)

sum2.gif

 

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...

sum3.gif

 

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 ;)

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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.

Do, or do not. There is no try.

 

Order Editor 5.0.6 "Ultra Violet" is now available!

For support or to post comments, suggestions, etc, please visit the Order Editor support thread.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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?

Do, or do not. There is no try.

 

Order Editor 5.0.6 "Ultra Violet" is now available!

For support or to post comments, suggestions, etc, please visit the Order Editor support thread.

Link to comment
Share on other sites

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".

Do, or do not. There is no try.

 

Order Editor 5.0.6 "Ultra Violet" is now available!

For support or to post comments, suggestions, etc, please visit the Order Editor support thread.

Link to comment
Share on other sites

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?

Do, or do not. There is no try.

 

Order Editor 5.0.6 "Ultra Violet" is now available!

For support or to post comments, suggestions, etc, please visit the Order Editor support thread.

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

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. :)

Do, or do not. There is no try.

 

Order Editor 5.0.6 "Ultra Violet" is now available!

For support or to post comments, suggestions, etc, please visit the Order Editor support thread.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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.

Do, or do not. There is no try.

 

Order Editor 5.0.6 "Ultra Violet" is now available!

For support or to post comments, suggestions, etc, please visit the Order Editor support thread.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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.

Do, or do not. There is no try.

 

Order Editor 5.0.6 "Ultra Violet" is now available!

For support or to post comments, suggestions, etc, please visit the Order Editor support thread.

Link to comment
Share on other sites

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 by djmonkey1

Do, or do not. There is no try.

 

Order Editor 5.0.6 "Ultra Violet" is now available!

For support or to post comments, suggestions, etc, please visit the Order Editor support thread.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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?

Do, or do not. There is no try.

 

Order Editor 5.0.6 "Ultra Violet" is now available!

For support or to post comments, suggestions, etc, please visit the Order Editor support thread.

Link to comment
Share on other sites

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:

 

added-download.jpg

 

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.

Link to comment
Share on other sites

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?

Do, or do not. There is no try.

 

Order Editor 5.0.6 "Ultra Violet" is now available!

For support or to post comments, suggestions, etc, please visit the Order Editor support thread.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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?

Best regards,

Koh Kho King

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...