Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

jhilgeman

NEW! Complete Order Editing Tool!

Recommended Posts

Can you tell me what is need to be done to upgrade from 2.6.5a to 2.7?

 

djmonkey1, thanks for all your hard work!

You're welcome- upgrade instructions are included with the package.

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.

Share this post


Link to post
Share on other sites
Hi DJmonk ;)

 

Some troubles with IE and onMouseover="ddrivetip..... function

It doesn't display them anymore.

But it's ok with firefox... :-"

 

message error:

'tipobj.style' has NULL value or isn't an objet...

 

And credit card fields are always displayed instead of not with 2.6.5 a version...

 

Any ideas? :rolleyes:

 

If you want I've translated in french the new edit_orders.php language file.

 

Thank you for the translation! If you could, please post it on the contribution download page for others to use.

 

For the problem you mentioned, that's strange- I tested it out in Firefox, Opera, and IE and everything worked fine. The only problem I've had with the tooltips is that in IE they'll show up underneath the state/country dropdowns in certain situations. I've compared my working file to the one in the 2.7 package and they are identical.

 

What version of IE are you running?


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.

Share this post


Link to post
Share on other sites

Hi djmonkey1,

 

I'm very eager to try the updated and improved contribution release, however, I have extensive modifications and some additional contributions combined in my admin/edit_orders.php and even my current code differs in some degree from your coding provided by contribution. It'll be very hard even with the comparing tool to modify the file to keep my site working properly. I don't want just to change my working code to match yours, so, please, if there is any chance you can help with updating my edit_orders.php to the latest revision, I would greatly appreciate that. What exactly needs to be changed in regards to adding new features and removing previous functions? All other files I can modify according to your upgrade instructions provided in the package.

 

Thanks in advance.

Share this post


Link to post
Share on other sites

Hello again djmonkey.

 

I've just realised that my customers aren't getting the "Thanks for order" emails when the first place an order.

 

They get everything else i send them such as when i change the status to dispatched.

 

Any ideas? I've had revert back to my original files :(

Share this post


Link to post
Share on other sites

Hello again djmonkey.

 

I've just realised that my customers aren't getting the "Thanks for order" emails when the first place an order.

 

They get everything else i send them such as when i change the status to dispatched.

 

Any ideas? I've had revert back to my original files :(

Share this post


Link to post
Share on other sites

Hello again djmonkey.

 

I've just realised that my customers aren't getting the "Thanks for order" emails when the first place an order.

 

They get everything else i send them such as when i change the status to dispatched.

 

Any ideas? I've had revert back to my original files :(

Share this post


Link to post
Share on other sites
Hello again djmonkey.

 

I've just realised that my customers aren't getting the "Thanks for order" emails when the first place an order.

 

They get everything else i send them such as when i change the status to dispatched.

 

Any ideas? I've had revert back to my original files :(

 

Ignore me, i think my webmail was just tkaing ages :blush:

Share this post


Link to post
Share on other sites
Hi djmonkey1,

 

I'm very eager to try the updated and improved contribution release, however, I have extensive modifications and some additional contributions combined in my admin/edit_orders.php and even my current code differs in some degree from your coding provided by contribution. It'll be very hard even with the comparing tool to modify the file to keep my site working properly. I don't want just to change my working code to match yours, so, please, if there is any chance you can help with updating my edit_orders.php to the latest revision, I would greatly appreciate that. What exactly needs to be changed in regards to adding new features and removing previous functions? All other files I can modify according to your upgrade instructions provided in the package.

 

Thanks in advance.

 

There were a huge number of changes, subtractions, and additions made to the code. I can, if you want, email you a file difference report in HTML that is for all intents and purposes the same as line-by-line revision instructions, but from what you've written it doesn't sound like it would help you very much. It may be easier for you to install the new version and then edit it to incorporate the changes necessary for your site.


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.

Share this post


Link to post
Share on other sites
That's not too hard- you just have to edit the HTML to display the elements as you would like.

 

I have try, but the checkbox will not work, when i take one, the both boxe get away.

Share this post


Link to post
Share on other sites
I have try, but the checkbox will not work, when i take one, the both boxe get away.

 

There are two table rows to watch out for:

<tr id="shippingAddressEntry">

and

<tr id="billingAddressEntry">

 

You have to be careful that both of those cells stay intact and do not overlap.


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.

Share this post


Link to post
Share on other sites

This seems like just what I was looking for, but it isn't working for me.

 

If I open edit_orders.php without any ?page=1&oID=1814&action=edit&osCAdminID=34f25c... added, it shows me:

 

E-Commerce Engine Copyright ? 2005 osCommerce

osCommerce provides no warranty and is redistributable under the GNU General Public License

Powered by osCommerce

 

but if I leave all that stuff on the end of the URL, I get a completely blank page.

 

I have SEO URLs and a few other things added, but which is conflicting, I have no idea.

 

Any suggestions?

Share this post


Link to post
Share on other sites
This seems like just what I was looking for, but it isn't working for me.

 

How about a url that ends like this:

edit_orders.php?oID=2

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.

Share this post


Link to post
Share on other sites
How about a url that ends like this:

edit_orders.php?oID=2 gives me the OSCommerce info, but the first order number is 100.

?oID=100 give me a blank screen

Share this post


Link to post
Share on other sites
edit_orders.php?oID=2 gives me the OSCommerce info, but the first order number is 100.

?oID=100 give me a blank screen

 

This sounds like a problem with the order class file admin/includes/classes/oe_order.php (assuming you're using v2.7). Blank screens can be hard to troubleshoot.

 

Try uploading these files again:

admin/edit_orders.php

admin/includes/classes/oe_order.php

 

Wait- if you use an order number that doesn't exist it doesn't give you an error?

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.

Share this post


Link to post
Share on other sites
edit_orders.php?oID=2 gives me the OSCommerce info, but the first order number is 100.

?oID=100 give me a blank screen

 

Here are some changes to make:

 

At about line 740 find

  //oh, and by the way....
 if (($action == 'edit') && ($order_exists == true)) { $order = new oe_order($oID);

 //and, we're off....

and change it to

  //oh, and by the way....
 if (($action == 'edit') && ($order_exists == true)) $order = new oe_order($oID);

 //and, we're off....

 

Then find at about line 1351

<!-- body_text //-->
<td width="100%" valign="top">
  <table border="0" width="100%" cellspacing="0" cellpadding="2">

and change it to

<!-- body_text //-->
<td width="100%" valign="top">
 <table border="0" width="100%" cellspacing="0" cellpadding="2">
 <?php if (($action == 'edit') && ($order_exists == true)) { ?>

 

And see how things work then.


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.

Share this post


Link to post
Share on other sites
There were a huge number of changes, subtractions, and additions made to the code. I can, if you want, email you a file difference report in HTML that is for all intents and purposes the same as line-by-line revision instructions, but from what you've written it doesn't sound like it would help you very much. It may be easier for you to install the new version and then edit it to incorporate the changes necessary for your site.

That would be very nice of you, djmonkey1, if you could email me the html comparison file you mentioned above. At least something to begin with. May be your comparison report will be more accurate and detailed than mine. Unfortunately, I can't just rewrite my current files because I'll loose all my additions that were so hard to implement, and they're too numerous to remember them all. And, the worst thing is that I don't keep track of all the updates and modifications I made to my files once everything is functioning properly. The problem is when it's not, so I need to go back and try to remember what exactly I changed and where. I'll appreciate any help you may kindly provide.

 

Thanks in advance.

Share this post


Link to post
Share on other sites
Here are some changes to make:

 

At about line 740 find

  //oh, and by the way....
 if (($action == 'edit') && ($order_exists == true)) { $order = new oe_order($oID);

 //and, we're off....

and change it to

  //oh, and by the way....
 if (($action == 'edit') && ($order_exists == true)) $order = new oe_order($oID);

 

When you mate this update remember to delete this in line 2086

 

}

 

Or you get a error.

Share this post


Link to post
Share on other sites

hi,

 

 

I use the contrib Order at glance in the files orders.php and this contrib use html_noquote from the general.php here is the code from the orders.php

<?php // ====> BOF: ORDERS AND COMMENTS AT-A-GLANCE <==== ?>
			<td class="dataTableContent" align="left"><?php echo '<b>' . $orders['orders_id'] . '</b>'; 

$products = "";
$products_query = tep_db_query("SELECT orders_products_id, products_name, products_quantity FROM " . TABLE_ORDERS_PRODUCTS . " WHERE orders_id = '" . tep_db_input($orders['orders_id']) . "' ");
while($products_rows = tep_db_fetch_array($products_query))
{
$products .= ($products_rows["products_quantity"]) . "x " . (tep_html_noquote($products_rows["products_name"])) . "<br>";
$result_attributes = tep_db_query("SELECT products_options, products_options_values FROM " . TABLE_ORDERS_PRODUCTS_ATTRIBUTES . " WHERE orders_id = '" . tep_db_input($orders['orders_id']). "' AND orders_products_id = '" . $products_rows["orders_products_id"] . "' ORDER BY products_options");
while($row_attributes = tep_db_fetch_array($result_attributes))
{
$products .=" - " . (tep_html_noquote($row_attributes["products_options"])) . ": " 
. (tep_html_noquote($row_attributes["products_options_values"])) . "<br>";
}
}
  ?>	
	<img src="images/icons/comment2.gif" onMouseOver="ddrivetip('<?php echo '' . $products . ''; ?>', 'silver', 350);" onMouseOut="hideddrivetip();" align="top" border="0">
</td>
 <?php  // ====> EOF: ORDERS AT-A-GLANCE <==== ?>

 

 

Then i i cancel the function tep_html_noquote form the generalhp

  function tep_html_noquote($string) {
 $string=str_replace(''', '', $string);
 $string=str_replace("'", "", $string);
 $string=str_replace('"', '', $string);
 $string=preg_replace("/\\r\\n|\\n|\\r/", "<BR>", $string); 
 return $string;

 }

 

i can not open the orders in the admin

 

Do you have an idee how to modify the code :

<?php // ====> BOF: ORDERS AND COMMENTS AT-A-GLANCE <==== ?>
			<td class="dataTableContent" align="left"><?php echo '<b>' . $orders['orders_id'] . '</b>'; 

$products = "";
$products_query = tep_db_query("SELECT orders_products_id, products_name, products_quantity FROM " . TABLE_ORDERS_PRODUCTS . " WHERE orders_id = '" . tep_db_input($orders['orders_id']) . "' ");
while($products_rows = tep_db_fetch_array($products_query))
{
$products .= ($products_rows["products_quantity"]) . "x " . (tep_html_noquote($products_rows["products_name"])) . "<br>";
$result_attributes = tep_db_query("SELECT products_options, products_options_values FROM " . TABLE_ORDERS_PRODUCTS_ATTRIBUTES . " WHERE orders_id = '" . tep_db_input($orders['orders_id']). "' AND orders_products_id = '" . $products_rows["orders_products_id"] . "' ORDER BY products_options");
while($row_attributes = tep_db_fetch_array($result_attributes))
{
$products .=" - " . (tep_html_noquote($row_attributes["products_options"])) . ": " 
. (tep_html_noquote($row_attributes["products_options_values"])) . "<br>";
}
}
  ?>	
	<img src="images/icons/comment2.gif" onMouseOver="ddrivetip('<?php echo '' . $products . ''; ?>', 'silver', 350);" onMouseOut="hideddrivetip();" align="top" border="0">
</td>
 <?php  // ====> EOF: ORDERS AT-A-GLANCE <==== ?>

Share this post


Link to post
Share on other sites
When you mate this update remember to delete this in line 2086

 

}

 

Or you get a error.

 

No- you're supposed to make both the changes I posted, not just one.


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.

Share this post


Link to post
Share on other sites
I use the contrib Order at glance in the files orders.php and this contrib use html_noquote from the general.php here is the code from the orders.php

i can not open the orders in the admin

 

Do you have an idee how to modify the code :

 

That's what happens when I work on too many contributions at the same time. :)

 

Just delete the function tep_html_noquote from admin/includes/functions/oe_functions.php and everything should be ok. That function isn't used by Order Editor.


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.

Share this post


Link to post
Share on other sites
IE Version 6.0.2900.2180

 

I will post the french package this week

 

;)

You're not using any characters such as ' or " in the tips themselves are you?

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.

Share this post


Link to post
Share on other sites
That's what happens when I work on too many contributions at the same time. :)

 

Just delete the function tep_html_noquote from admin/includes/functions/oe_functions.php and everything should be ok. That function isn't used by Order Editor.

 

 

cool :thumbsup:

 

many thanks

 

xav :-"

Share this post


Link to post
Share on other sites
No- you're supposed to make both the changes I posted, not just one.

 

I have make both updates, but get the error in line, but after i delete the } all is okay.

Share this post


Link to post
Share on other sites

Hello Friends,

 

this module is great !!!

i already use it without any errors (Vers.2.7)...

very cool :)

 

but there's one thing i want to ad to it:

 

i wanna use it in a shop where i installed SPPC (Separate Prices per Customer)

and Price_Breaks for SPPC (both latest versions)...

 

does someone know how to change the edit_orders.php to make it work with it ?

 

because the edit orders module works neither with price breaks nor with SPPC...

i wanna make it work with Price Breaks for Separate Prices Per Customers...

 

would be very cool if someone knows the situation and can help... :thumbsup:

 

sorry for my bad english...

 

thank u very much...

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×