-
Order Editor 1.3.7 Issues
Hi I recently upgraded to 1.3.7 and now the order editor is giving me nothing but issues.
1. When I try to update a status under edit order I get the following
Fatal error: Cannot use object of type queryFactoryResult as array in /home2/xxxx/public_html/wholesale_ordering/admin/edit_orders.php on line 185
I then refresh the page and nothing has changed not even my notes. Can anyone help?
2. When I try to delete a product by adding a 0 in quantity I get the following error
Fatal error: Cannot use object of type order as array in /home2/xxxx/public_html/wholesale_ordering/admin/edit_orders.php on line 271
but when I go back a page the product is gone? Can anyone help here?
3. Also when I add an item with attributes it is not showing in my order editor but it does show in invoice and normal edit page. I need to be able to change a size or colour if required can anyone help here?
I hope someone can help with one or all issues I have come across so far.
-
Re: Order Editor 1.3.7 Issues
I think I have a similar issue. When trying to update the status of an order I get:
Fatal error: Cannot use object of type queryFactoryResult as array in .../public_html/warehowse/edit_orders.php on line 185
Anyone have any ideas?
-
Re: Order Editor 1.3.7 Issues
Quote:
Originally Posted by
erotique
...2. When I try to delete a product by adding a 0 in quantity I get the following error
Fatal error: Cannot use object of type order as array in /home2/xxxx/public_html/wholesale_ordering/admin/edit_orders.php on line 271
but when I go back a page the product is gone? Can anyone help here?
I also get this bug ... :(
-
Re: Order Editor 1.3.7 Issues
I just tried the EDIT ORDERS mod, and i think i found a bug: I can't notify my cusotmers anymore about their orders updates. Got an error:
"Fatal error: Cannot use object of type queryFactoryResult as array in /home/mydomain/public_html/admin/edit_orders.php on line 185". I can change the status of an order, but I can't check the box "notify user" because I will get that error.
{Later edit}
I think I found something (beginner here!). I have changed this:
PHP Code:
$email = STORE_NAME . "\n" . EMAIL_SEPARATOR . "\n" . EMAIL_TEXT_ORDER_NUMBER . ' ' . $oID . "\n" . EMAIL_TEXT_INVOICE_URL . ' ' . zen_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL') . "\n" . EMAIL_TEXT_DATE_ORDERED . ' ' . zen_date_long($check_status['date_purchased']) . "\n\n" . $notify_comments . sprintf(EMAIL_TEXT_STATUS_UPDATE, $orders_status_array[$status]);
zen_mail($check_status['customers_name'], $check_status['customers_email_address'], EMAIL_TEXT_SUBJECT, $email, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS);
with this:
PHP Code:
$email = STORE_NAME . "\n" . EMAIL_SEPARATOR . "\n" . EMAIL_TEXT_ORDER_NUMBER . ' ' . $oID . "\n" . EMAIL_TEXT_INVOICE_URL . ' ' . zen_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL') . "\n" . EMAIL_TEXT_DATE_ORDERED . ' ' . zen_date_long($check_status->fields['date_purchased']) . "\n\n" . $notify_comments . sprintf(EMAIL_TEXT_STATUS_UPDATE, $orders_status_array[$status]);
zen_mail($check_status['customers_name'], $check_status->fields['customers_email_address'], EMAIL_TEXT_SUBJECT, $email, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS);
But now emails get to the destination in the following form:
Code:
Order Update
$EMAIL_MESSAGE_HTML
Now we have another big "?"... Anybody?...
-
Re: Order Editor 1.3.7 Issues
Quote:
Originally Posted by
Florin
I also get this bug ... :(
I think I solve your problem:
LA mine imi dadea eroare la linia 281, dar s-ar putea sa am eu ceva in plus in fisierul ala, asa ca incearca urmatoarele:
In admin/edit_orders.php I have changed this lines:
PHP Code:
if ($products_details["qty"] != $order['products_quantity']){
$differenza_quantita = ($products_details["qty"] - $order['products_quantity']);
$db -> Execute("update " . TABLE_PRODUCTS . " set products_quantity = products_quantity - " . $differenza_quantita . ", products_ordered = products_ordered + " . $differenza_quantita . " where products_id = '" . (int)$order['products_id'] . "'");
}
with this:
PHP Code:
if ($products_details->fields["qty"] != $order->fields['products_quantity']){
$differenza_quantita = ($products_details->fields["qty"] - $order->fields['products_quantity']);
$db -> Execute("update " . TABLE_PRODUCTS . " set products_quantity = products_quantity - " . $differenza_quantita . ", products_ordered = products_ordered + " . $differenza_quantita . " where products_id = '" . (int)$order->fields['products_id'] . "'");
}
Still have that problem with emails, which ain't lookin' as I want...
-
Re: Order Editor 1.3.7 Issues
Un-professional solution for "notify customer" issue when upgrading the orders' status:
In ADMIN pannel, under CUSTOMERS/ORDERS, after the change of order's status, click directly the order line instead of DETAILS or EDIT buttons.
This trick allows you to use the orders.php properties instead of edit_orders.php ones.:smartass:
-
Re: Order Editor 1.3.7 Issues
I just update Edit orders to the latest version when i click the update button this is the errors i get
Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/user/public_html/catolog/admin/edit_orders.php:4) in /home/user/public_html/catolog/includes/functions/sessions.php on line 108
Warning: Cannot modify header information - headers already sent by (output started at /home/user/public_html/catolog/folgers/edit_orders.php:4) in /home/user/public_html/catolog/admin/includes/init_includes/init_templates.php on line 36
Warning: Cannot modify header information - headers already sent by (output started at /home/user/public_html/catolog/admin/edit_orders.php:4) in /home/user/public_html/catolog/admin /includes/functions/general.php on line 34
Any ideas
-
1 Attachment(s)
Re: Order Editor 1.3.7 Issues
Hi, I am trying to utilize the Edit Orders Mod. to add/remove items from customers' orders. When adding item, at Step 2, how can I list items in the dropdown box base on Model No. rather than Product Name?
When removing items, I noticed that those without attributes are correctly re-stocked but for those with attributes, the re-stocking is done at the total rather than the appropriate attribute.
Any advice/patch is greatly appreciated.
lextechs, I had a similar error. You may want to try using this attachment. It seems to be working at my site (please test it at your local copy file). Extract the file into your admin folder.
-
Re: Order Editor 1.3.7 Issues
Quote:
Originally Posted by
lextechs
Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/user/public_html/catolog/admin/edit_orders.php:4) in /home/user/public_html/catolog/includes/functions/sessions.php on line 108
FAQ: https://www.zen-cart.com/tutorials/index.php?article=87
-
Re: Order Editor 1.3.7 Issues
instead I've always 500 error when I try to update order.. why?
-
Re: Order Editor 1.3.7 Issues
I see in the edit_orders.php some of the code have <? and some of it has <?php shouldn't all open tags for php have <?php and clsoe tag ?> ?
-
Re: Order Editor 1.3.7 Issues
Stenrique and DrByte thanks for your help
I have another problem when i up Zencart says message "Success Success: Order has been successfully updated." But the e-mails are been bouced back because it's not putting the users e-mail address in tot he send to field, so the update is happening but the customer doesn't receive the update
-
Re: Order Editor 1.3.7 Issues
Quote:
Originally Posted by
L3D_Z3PP
Un-professional solution for "notify customer" issue when upgrading the orders' status:
In ADMIN pannel, under CUSTOMERS/ORDERS, after the change of order's status, click directly the order line instead of DETAILS or EDIT buttons.
This trick allows you to use the orders.php properties instead of edit_orders.php ones.:smartass:
Thanks!
-
Re: Order Editor 1.3.7 Issues
Hi, I am getting this error when clicking the edit button:
Parse error: syntax error, unexpected $end in ...\admin\edit_orders.php on line 1338
Any idea or fix please?
MG
-
Re: Order Editor 1.3.7 Issues
I think I have just fixed this problem by allowing short <? tags on my testing server. I have spotted some thing else though.
If I add a value into the tax field when I edit and order. It does not change the inc price or excl price they are still held as the same value as the product originally had.
Should this not apply a tax rate entered (eg. 17.5% for VAT)
MG
-
Re: Order Editor 1.3.7 Issues
I am also getting the following error when taking a product off the order either by setting qty to 0 or when just deleting the qty and or deleting the decription and all other fields:
Fatal error: Cannot use object of type order as array in ....\admin\edit_orders.php on line 271
don't know if this has been spotted. any fix? if I hit the back button it goes back to the order with out the line on it (so correct result) and stock is put back on the product qry ( also a correct result).
Look forward to a fix.
Thanks
MG
-
Re: Order Editor 1.3.7 Issues
Sorry this is my 4th post in a row but I have also spotted a couple of other things.
After adding a product with attributes, the attribute does not appear on the order. eg I have a t-shirt blue 0-6 - I get the product name -T-shirt but 0-6 and blue not showing. Also if you have the product stock by attributes module installed it does not take the stock down off this module
The last one would be a great nice to have as this is crucial to stock control for me.
Look forward to comments and solutions - Sorry I am not a programmer and so would not know where to start to fix but I hope this helps in terms of feed back on the module.
Best regards
MG
-
Re: Order Editor 1.3.7 Issues
Quote:
Originally Posted by
DrByte
FAQ:
https://www.zen-cart.com/tutorials/index.php?article=87
Quote:
Originally Posted by
lextechs
I just update Edit orders to the latest version when i click the update button this is the errors i get
Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/user/public_html/catolog/admin/edit_orders.php:4) in /home/user/public_html/catolog/includes/functions/sessions.php on line 108
Warning: Cannot modify header information - headers already sent by (output started at /home/user/public_html/catolog/folgers/edit_orders.php:4) in /home/user/public_html/catolog/admin/includes/init_includes/init_templates.php on line 36
Warning: Cannot modify header information - headers already sent by (output started at /home/user/public_html/catolog/admin/edit_orders.php:4) in /home/user/public_html/catolog/admin /includes/functions/general.php on line 34
The strange thing is that the top of the file has been made wrong in this version - if you cut the top bit:
Code:
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
<title><?php echo TITLE; ?></title>
<link rel="stylesheet" type="text/css" href="includes/stylesheet.css">
<script language="javascript" src="includes/general.js"></script>
</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF">
from the top so that <?php is the start, and paste that top bit under the line that says
Code:
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
(which will now be around line 519)
then it works.
-
Re: Order Editor 1.3.7 Issues
Quote:
Originally Posted by
MikeyG
I am also getting the following error when taking a product off the order either by setting qty to 0 or when just deleting the qty and or deleting the decription and all other fields:
Fatal error: Cannot use object of type order as array in ....\admin\edit_orders.php on line 271
don't know if this has been spotted. any fix? if I hit the back button it goes back to the order with out the line on it (so correct result) and stock is put back on the product qry ( also a correct result).
Look forward to a fix.
Thanks
MG
Need a small fix in admin/edit_orders.php, replace lines 267 - 274 with following:
PHP Code:
$db -> Execute($Query);
$row = $db->fields;
//UPDATE_INVENTORY_QUANTITY_START##############################################################################################################
#$order = zen_db_fetch_array($order_query);
if ($products_details["qty"] != $row->fields['products_quantity']){
$differenza_quantita = ($products_details["qty"] - $row->fields['products_quantity']);
$db -> Execute("update " . TABLE_PRODUCTS . " set products_quantity = products_quantity - " . $differenza_quantita . ", products_ordered = products_ordered + " . $differenza_quantita . " where products_id = '" . (int)$row->fields['products_id'] . "'");
}
-
Re: Order Editor 1.3.7 Issues
I use currency € as default. After updating prices, some values now turn up as $
Sub-Totaal: $28.04
Tariefzones (Verzenden naar: NL): €3.95
FL TAX 7.0%: $1.96
Kosten Betaalwijze: €0.35
Totaal: $34.30
-
Re: Order Editor 1.3.7 Issues
zc_tester, Thank you for your fix that has got rid of the bug when deleting
Is there any fix to this question regarding attributes not appearing.
After adding a product with attributes, the attribute does not appear on the order. eg I have a t-shirt blue 0-6 - I get the product name -T-shirt but 0-6 and blue not showing. Also if you have the product stock by attributes module installed it does not take the stock down off this module
Many thanks
MG
-
Re: Order Editor 1.3.7 Issues
I just uploaded an new ver of this module.
it includes the following changes. sorry my text editor does not have a spell checker. so the read me file is a bit bungled.
admin/edit_orders.php
Removed redundant function definitions that were breaking the program. if you want to see the functions try greping in the admin/includes/functions dir)
Changed print functions to echo functions for performance reasons.
Restructured head:
To include page function in <title> tags.
T to conform to current zen cart admin page format.
added zc_tester's delete item fix.
readme.txt
Made huge restructuring changes, and added table of contents.
I will repost when it has been approved and added to the downloads section.
JOsh
-
Re: Order Editor 1.3.7 Issues
Hi JOsh (and all others), thanks for your availability :cool:
Thanks to all this present thread, I fixed all my problems... One of them was <?... Now the SW runs.
But I still have a 1/2 problem.
When I update/add/delete items the shipping field doesn't update.
I solve that by editing the value by hand.
It's an item to put on 'to do list' :hug:
-
Re: Order Editor 1.3.7 Issues
I installed the latest version (1.2.5) on my 1.3.7 zencart, but nothing seems to have changed. Is there supposed to be a new menu button somewhere in admin? Where is it?
I have taken a look at the order list and clicked on the normal "edit" button for a specific order, but nothing has changed inside. Everything is still non-editable.
I also have installed Admin Permissions module, which may be why the Order Editor mod menu is not appearing. But when I attempted to add the Order Editor to the permissions, I found that the Order Editor does not have an admin/includes/boxes/extra_boxes box to modify....so I am stuck.
How do I access this Mod after installing it? :(
-
Re: Order Editor 1.3.7 Issues
JOsh,
After updating:
Fatal error: Call to undefined function: zen_field_exists() in /home/web/public_html/loja/admin/edit_orders.php on line 82
This function is where?
-
Re: Order Editor 1.3.7 Issues
Concerning to ths 'not visible' button...
I suppose you have edited admin/orders.php
Check if you have two edit buttons.
http://pm-si.com/pub/edit.jpg
Search admin/orders.php for:
PHP Code:
$contents[] = array('align' => 'center', 'text' => '<a href="' . zen_href_link(FILENAME_ORDER_EDIT, zen_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=edit', 'NONSSL') . '">' . zen_image_button('button_edit.gif', IMAGE_EDIT) . '</a>');
You have here 'button_edit.gif.
Just create a new gif button and replace this filename with the new one, like I did:
PHP Code:
$contents[] = array('align' => 'center', 'text' => '<a href="' . zen_href_link(FILENAME_ORDER_EDIT, zen_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=edit', 'NONSSL') . '">' . zen_image_button('button_edit_alter.gif', IMAGE_EDIT) . '</a>');
Did this helped?
-
Re: Order Editor 1.3.7 Issues
Quote:
Originally Posted by
Pedro Martins
JOsh,
After updating:
Fatal error: Call to undefined function: zen_field_exists() in /home/web/public_html/loja/admin/edit_orders.php on line 82
This function is where?
There is code missing from edit_orders. Insert this above the line requiring application_bottom.php.
Code:
<?php
////////////////////////////////////////////////////////////////////////////////////////////////
//
// Function : zen_field_exists
//
// Arguments : table table name
// field field name
//
// Return : true/false
//
// Description : Function to check the existence of a database field
//
////////////////////////////////////////////////////////////////////////////////////////////////
function zen_field_exists($table,$field) {
global $db;
$describe_query = $db -> Execute("describe $table");
while (!$describe_query -> EOF)
{
if ($d_row["Field"] == "$field") {
return true;
}
$describe_query -> MoveNext();
}
return false;
}
////////////////////////////////////////////////////////////////////////////////////////////////
//
// Function : zen_get_country_id
//
// Arguments : country_name country name string
//
// Return : country_id
//
// Description : Function to retrieve the country_id based on the country's name
//
////////////////////////////////////////////////////////////////////////////////////////////////
function zen_get_country_id($country_name) {
global $db;
$country_id_query = $db -> Execute("select * from " . TABLE_COUNTRIES . " where countries_name = '" . $country_name . "'");
if (!$country_id_query->RecordCount()) {
return 0;
}
else {
return $country_id_query->fields['countries_id'];
}
}
////////////////////////////////////////////////////////////////////////////////////////////////
//
// Function : zen_get_country_iso_code_2
//
// Arguments : country_id country id number
//
// Return : country_iso_code_2
//
// Description : Function to retrieve the country_iso_code_2 based on the country's id
//
////////////////////////////////////////////////////////////////////////////////////////////////
function zen_get_country_iso_code_2($country_id) {
global $db;
$country_iso_query = $db -> Execute("select * from " . TABLE_COUNTRIES . " where countries_id = '" . $country_id . "'");
if (!zen_db_num_rows($country_iso_query)) {
return 0;
}
else {
$country_iso_row = zen_db_fetch_array($country_iso_query);
return $country_iso_row['countries_iso_code_2'];
}
}
////////////////////////////////////////////////////////////////////////////////////////////////
//
// Function : zen_get_zone_id
//
// Arguments : country_id country id string
// zone_name state/province name
//
// Return : zone_id
//
// Description : Function to retrieve the zone_id based on the zone's name
//
////////////////////////////////////////////////////////////////////////////////////////////////
function zen_get_zone_id($country_id, $zone_name) {
global $db;
$zone_id_query = $db -> Execute("select * from " . TABLE_ZONES . " where zone_country_id = '" . $country_id . "' and zone_name = '" . $zone_name . "'");
if (!$zone_id_query->RecordCount()) {
return 0;
}
else {
return $zone_id_query->fields['zone_id'];
}
}
////////////////////////////////////////////////////////////////////////////////////////////////
//
// Function : zen_html_quotes
//
// Arguments : string any string
//
// Return : string with single quotes converted to html equivalent
//
// Description : Function to change quotes to HTML equivalents for form inputs.
//
////////////////////////////////////////////////////////////////////////////////////////////////
function zen_html_quotes($string) {
return str_replace("'", "'", $string);
}
////////////////////////////////////////////////////////////////////////////////////////////////
//
// Function : zen_html_unquote
//
// Arguments : string any string
//
// Return : string with html equivalent converted back to single quotes
//
// Description : Function to change HTML equivalents back to quotes
//
////////////////////////////////////////////////////////////////////////////////////////////////
function zen_html_unquote($string) {
return str_replace("'", "'", $string);
}
?>
But I am still getting an error when trying to update the staus and emailing the customer. The error is:
Code:
Fatal error: Cannot use object of type queryFactoryResult as array in C:\Program Files\xampp\htdocs\drumshop\admin\edit_orders.php on line 185
Was there ever a fix for this?
Matt
-
Re: Order Editor 1.3.7 Issues
OI vey why was I getting the redundant functions errors?!!!!
I will be working on this form 10-12 today and for trhe rest of the week
if every one want to take a chuck of the work and add their chages here I would not mind or I could set up a SVN repo and pm people details.
Better yet I will make a source forge project for this mod. yeah yeah, that way we can all commit our changes.
Sound good?
JOsh
-
Re: Order Editor 1.3.7 Issues
Quote:
Originally Posted by
thomasw98
I installed the latest version (1.2.5) on my 1.3.7 zencart, but nothing seems to have changed. Is there supposed to be a new menu button somewhere in admin? Where is it?
I have taken a look at the order list and clicked on the normal "edit" button for a specific order, but nothing has changed inside. Everything is still non-editable.
I also have installed Admin Permissions module, which may be why the Order Editor mod menu is not appearing. But when I attempted to add the Order Editor to the permissions, I found that the Order Editor does not have an admin/includes/boxes/extra_boxes box to modify....so I am stuck.
How do I access this Mod after installing it? :(
Ahh this was in older documentation then I had to update.
let me quote form an older read me
Quote:
DITED FILES
-----------------------------------------
only 1 file to edit:
admin/orders.php
1) This add the "Details" button - see explanations below:
FIND
$contents[] = array('align' => 'center', 'text' => '<a href="' . zen_href_link(FILENAME_ORDERS, zen_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=edit', 'NONSSL') . '">' . zen_image_button('button_edit.gif', IMAGE_EDIT) . '</a> <a href="' . zen_href_link(FILENAME_ORDERS, zen_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=delete', 'NONSSL') . '">' . zen_image_button('button_delete.gif', IMAGE_DELETE) . '</a>');
REPLACE WITH:
$contents[] = array('align' => 'center', 'text' => '<a href="' . zen_href_link(FILENAME_ORDER_EDIT, zen_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=edit', 'NONSSL') . '">' . zen_image_button('button_details.gif', IMAGE_DETAILS) . '</a> <a href="' . zen_href_link(FILENAME_ORDERS, zen_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=delete', 'NONSSL') . '">' . zen_image_button('button_delete.gif', IMAGE_DELETE) . '</a>');
2) This will add the "Edit" button - see explanation below:
FIND:
$contents[] = array('align' => 'center', 'text' => '<a href="' . zen_href_link(FILENAME_ORDERS, zen_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=edit', 'NONSSL') . '">' . zen_image_button('button_edit.gif', IMAGE_EDIT) . '</a>');
REPLACE WITH:
$contents[] = array('align' => 'center', 'text' => '<a href="' . zen_href_link(FILENAME_ORDER_EDIT, zen_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=edit', 'NONSSL') . '">' . zen_image_button('button_edit.gif', IMAGE_EDIT) . '</a>');
-----------------------------------------
VIEWING & EDITING ORDERS
-----------------------------------------
In ADMIN PANEL -> CUSTOMERS -> ORDERS, once an order is selected from the list, you will see at the bottom of its description a button called "Edit". Click on it to access the Edit Order page, and make alterations to the Order. To delete an item, just use Quantity = 0.
In ADMIN PANEL -> CUSTOMERS -> ORDERS, once an order is selected you will also see a button called "Details". Clicking it will take you to the old order description screen, where all details about the order and payment methods can be seen.
-
Re: Order Editor 1.3.7 Issues
Quote:
Originally Posted by
##########################
OI vey why was I getting the redundant functions errors?!!!!
I will be working on this form 10-12 today and for trhe rest of the week
if every one want to take a chuck of the work and add their chages here I would not mind or I could set up a SVN repo and pm people details.
Better yet I will make a source forge project for this mod. yeah yeah, that way we can all commit our changes.
Sound good?
JOsh
I would help you if I could but I am still in the very early stages of learning php. I can help test any revisions if that would help.
Matt
-
Re: Order Editor 1.3.7 Issues
sounds good.
hey I applied for a source forge project for this.
-
Re: Order Editor 1.3.7 Issues
Here come the fix to be able to edit (sort of) orders attributes:
In edit_orders.php line 815 replace
PHP Code:
$attributes_query_string = "select * from " . TABLE_ORDERS_PRODUCTS_ATTRIBUTES . " where orders_id = '" . (int)$oID . "' and orders_products_id = '" . (int)$orders_products['orders_products_id'] . "'";
with
PHP Code:
$attributes_query_string = "select * from " . TABLE_ORDERS_PRODUCTS_ATTRIBUTES . " where orders_id = '" . (int)$oID . "' and orders_products_id = '" . (int)$orders_products_query->fields['orders_products_id'] . "'";
You may also want to edit line 846 and replace size="6" and size="10" with something bigger (I put 60).
On the other hand, this is not quite what I was expecting, I hoped I'll have in edit orders pulldowns for each option, and the product price to be calculated as in shop, base price + options price. Right now, if the user choose option X instead of option Y, I have to open another instance of the admin to be able to copy-paste both the option name and option value, then I'll have to recalculate manually the final price for the product.
-
Re: Order Editor 1.3.7 Issues
zc_tester
Thank you for the attribute edit bit.
I am not sure if you saw my question from earlier. If I add a product having attributes the attributes are not being added into the order I just get the product name no attribute saved.
Can this be fixed. And can it deduct stock from the product stock by attributes module. This would be agreat result.
Thanks
MG
-
Re: Order Editor 1.3.7 Issues
is it possible to integrate this into super orders 2.0?
-
Re: Order Editor 1.3.7 Issues
Quote:
Originally Posted by
##########################
Ahh this was in older documentation then I had to update.
let me quote form an older read me
I tried that but I got this error:
Code:
PHP Fatal error: Call to undefined function: zen_field_exists() in /home/smm/public_html/cart/smadmin/edit_orders.php on line 163
-
Re: Order Editor 1.3.7 Issues
I am getting this error when I use this
Fatal error: Call to undefined function: zen_field_exists() in /var/virtual/web/w0713/html/store/admin/edit_orders.php on line 82
Anyone had this before?
Cheers,
Neil
-
Re: Order Editor 1.3.7 Issues
I have the same error: Call to undefined function: zen_field_exists()
-
Re: Order Editor 1.3.7 Issues
Quote:
I am getting this error when I use this
Fatal error: Call to undefined function: zen_field_exists() in /var/virtual/web/w0713/html/store/admin/edit_orders.php on line 82
I seem to recall I fixed this by opening and closing all the php tags properly eg <?php .... ?>
Hope this helps.
MG
-
Re: Order Editor 1.3.7 Issues
I have the mod going for everything except delete. I added the change from zc_tester
as follows (first line is line 267
// $Query = "delete from " . TABLE_ORDERS_PRODUCTS . " where orders_products_id = '$orders_products_id';";
// $db -> Execute($Query);
// //UPDATE_INVENTORY_QUANTITY_START################################################# #############################################################
// #$order = zen_db_fetch_array($order_query);
// if ($products_details["qty"] != $order['products_quantity']){
// $differenza_quantita = ($products_details["qty"] - $order['products_quantity']);
// $db -> Execute("update " . TABLE_PRODUCTS . " set products_quantity = products_quantity - " . $differenza_quantita . ", products_ordered = products_ordered + " . $differenza_quantita . " where products_id = '" . (int)$order['products_id'] . "'");
// }
// //UPDATE_INVENTORY_QUANTITY_END################################################### ###########################################################
// Edit Begin
$db -> Execute($Query);
$row = $db->fields;
//UPDATE_INVENTORY_QUANTITY_START################################################# #############################################################
#$order = zen_db_fetch_array($order_query);
if ($products_details["qty"] != $row->fields['products_quantity']){
$differenza_quantita = ($products_details["qty"] - $row->fields['products_quantity']);
$db -> Execute("update " . TABLE_PRODUCTS . " set products_quantity = products_quantity - " . $differenza_quantita . ", products_ordered = products_ordered + " . $differenza_quantita . " where products_id = '" . (int)$row->fields['products_id'] . "'");
}
//UPDATE_INVENTORY_QUANTITY_END################################################### ###########################################################
// Edit End
however when I set the quantity to zero and click Update, the item still is there. Any thoughts?? This is a really important mod for us. Many TIA
bob
-
Re: Order Editor 1.3.7 Issues
never mind. I had commented out the line that defines the delete statement. DUH.
bob
-
Re: Order Editor 1.3.7 Issues
If you type "zen_field_exists" in the developper toolkit , this function is nowhere to be found in the entire set of file. How can you make this work, I'm curious?
-
Re: Order Editor 1.3.7 Issues
Whoever last edited this module removed the functions... :lamo:
Download the version before it and copy the functions over from the bottom of the admin/edit_orders.php
-
Re: Order Editor 1.3.7 Issues
I've rewrote the readme.txt yet again. The latest version did not have any installation instructions, nor was it in an easily readable layout.
The functions were clearly needed and shouldn't have been removed in that manner. I've re-added them as extra_functions.
Changed "sechof" back to "sprintf" (all echo's remain).
v1.2.6 should be available soon in the downloads section, enjoy!
-
Re: Order Editor 1.3.7 Issues
After an edit , shipping tax does not calculate properly.
It seems to use the subtotal to calculate the shipping tax rather than the shipping fee.
was using edit_order 1.1 and now just updated to 1.2.6.
made all changes in readme file, no issues during installation.
help is appreciated please,
-
Re: Order Editor 1.3.7 Issues
I thought I would give more info,
Everytime I edit an order it changes the shipping tax totals based on total order rather than just the shippiing cost.
I also have split tax module installed, and super orders installed.
current zen cart installation is 1.3.7.1
any ideas?
-
Re: Order Editor 1.3.7 Issues
:no:I have been tring to install the edit orders mod and i get this error.
Parse error: syntax error, unexpected T_REQUIRE in /home2/mysitecom/public_html/myadminfolder/orders.php on line 1
I think it has something to do when i cut and paste the new code in the orders.php file. i have looked and looked but i can't find a problem.
can someone help me? I would like this mod to edit orders.
-
Re: Order Editor 1.3.7 Issues
Quote:
Originally Posted by
numinix
v1.2.6 should be available soon in the downloads section, enjoy!
Hi
may i ask if this version or the version earlier compatible with zencart v.1.3.8a?
i upgraded my zencart yesterday and encountered this error when i tried to click Edit order in the admin view
Parse error: parse error, unexpected $end in C:\Program Files\EasyPHP\www\zencart\admin\edit_orders.php on line 1312
i have no idea how to correct this, any advice?
thanks,
natalia
-
Re: Order Editor 1.3.7 Issues
Quote:
Originally Posted by
nataliajoe
Hi
may i ask if this version or the version earlier compatible with zencart v.1.3.8a?
i upgraded my zencart yesterday and encountered this error when i tried to click Edit order in the admin view
Parse error: parse error, unexpected $end in C:\Program Files\EasyPHP\www\zencart\admin\edit_orders.php on line 1312
i have no idea how to correct this, any advice?
thanks,
natalia
Our update to this module was very minor and you are directing your question to the wrong person. As said in my post above, I simply rewrote the installation instructions as they didn't really exist and were confusing for more users. Then I just re-added functions that were mistakenly removed by someone else is a previous version.
-
Re: Order Editor 1.3.7 Issues
Quote:
Originally Posted by
numinix
Our update to this module was very minor and you are directing your question to the wrong person. As said in my post above, I simply rewrote the installation instructions as they didn't really exist and were confusing for more users. Then I just re-added functions that were mistakenly removed by someone else is a previous version.
HI
sorry abt that, cos I only found this thread in the forum, so I thought you maybe able to help with my question.
thanks for replying my message...
natalia
-
Order Edit on Version 1.8.3a
I am noticing a number of issues that make the module unusable. When reducing the shipping, the tax change properly.
I am using 5% GST for this item.
Price 76.50
Shipping 10.00
GST 4.33
Total 90.83
After I correct my shipping to 7.50, the order changes to this...
Price 76.50
Shipping 7.50
GST 3.83
Total 87.83
The tax should be 4.20.
As well, I did another transaction where there was a coupon code. After adjusting the shipping, the following lines showed up in addition to the GST...
Shipping Tax
Sales Tax
The same number that was in GST was duplicated on the other lines, completely throwing the total off.
-
Re: Order Editor 1.3.7 Issues
Quote:
Originally Posted by
numinix
Our update to this module was very minor and you are directing your question to the wrong person. As said in my post above, I simply rewrote the installation instructions as they didn't really exist and were confusing for more users. Then I just re-added functions that were mistakenly removed by someone else is a previous version.
btw, another question, anyone knows whether is this contribution compatible with v1.3.8a or not?
thanks,
natalia
-
Re: Order Editor 1.3.7 Issues
Yes, I'm useing it on 1.3.8a
-
Re: Order Editor 1.3.7 Issues
Quote:
Originally Posted by
gothstone
Yes, I'm useing it on 1.3.8a
hi, may I know how do you manage to do that? cos when i do a clean install of v1.38a on my pc, without doing anything, i installed this edit order module, it gave me errors when i click the "edit order" button in the admin view...
thanks
natalia
-
Re: Order Editor 1.3.7 Issues
It would be helpfull to know what error it gives you. I would suggest checking the code changes you made to /admin/orders.php to make sure there is no typo. I will try on a clean install tomorrow if needed, as my site may not be a compleatly fair test. I have "Info at a Glance", and "USPS.com Click-N-Ship" installed as well, and they also edit orders.php. I also made a few code changes to the code suggested in the readme to modify the way the buttons work. I wanted to be able to click on the origional button and just view the details, but have an edit button at the bottom that used the mod to edit the order. Here are my notes on installing the mod:
Code:
edit orders 1.2.6 Nov 12th 2007
unzip
copy and upload admin directory
edit admin/orders.php Note first change is not the same as in readme, but what we want instead; to just rename the button
Replace line:
$contents[] = array('align' => 'center', 'text' => '<a href="' . zen_href_link(FILENAME_ORDERS, zen_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=edit', 'NONSSL') . '">' . zen_image_button('button_edit.gif', IMAGE_EDIT) . '</a> <a href="' . zen_href_link(FILENAME_ORDERS, zen_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=delete', 'NONSSL') . '">' . zen_image_button('button_delete.gif', IMAGE_DELETE) . '</a>');
With the code:
// ====> BOF: Edit Orders 1.2.6 <====
// $contents[] = array('align' => 'center', 'text' => '<a href="' . zen_href_link(FILENAME_ORDERS, zen_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=edit', 'NONSSL') . '">' . zen_image_button('button_edit.gif', IMAGE_EDIT) . '</a> <a href="' . zen_href_link(FILENAME_ORDERS, zen_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=delete', 'NONSSL') . '">' . zen_image_button('button_delete.gif', IMAGE_DELETE) . '</a>');
$contents[] = array('align' => 'center', 'text' => '<a href="' . zen_href_link(FILENAME_ORDERS, zen_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=edit', 'NONSSL') . '">' . zen_image_button('button_details.gif', IMAGE_EDIT) . '</a> <a href="' . zen_href_link(FILENAME_ORDERS, zen_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=delete', 'NONSSL') . '">' . zen_image_button('button_delete.gif', IMAGE_DELETE) . '</a>');
// ====> EOF: Edit Orders 1.2.6 <====
Replace line:
$contents[] = array('align' => 'center', 'text' => '<a href="' . zen_href_link(FILENAME_ORDERS, zen_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=edit', 'NONSSL') . '">' . zen_image_button('button_edit.gif', IMAGE_EDIT) . '</a>');
With the code:
// ====> BOF: Edit Orders 1.2.6 <====
// $contents[] = array('align' => 'center', 'text' => '<a href="' . zen_href_link(FILENAME_ORDERS, zen_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=edit', 'NONSSL') . '">' . zen_image_button('button_edit.gif', IMAGE_EDIT) . '</a>');
$contents[] = array('align' => 'center', 'text' => '<a href="' . zen_href_link(FILENAME_ORDER_EDIT, zen_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=edit', 'NONSSL') . '">' . zen_image_button('button_edit.gif', IMAGE_EDIT) . '</a>');
// ====> EOF: Edit Orders 1.2.6 <====
-
Re: Order Editor 1.3.7 Issues
Ok, I went back and saw your previous post. A parse error, unexpected $end is usualy caused by a missing } somewhere in your code. I would pull a clean copy of /admin/orders.php and try editing it again. Its usualy faster to redo the mod then actualy try to find the typo burried in 1000+ lines of code.
-
Re: Order Editor 1.3.7 Issues
I just installed the new version of this mod since the old version I had was giving me nothing but errors when I upgraded to zen v1.3.8, BUT, both the Details page and the Edit page look exactly the same and no attributes are showing. I have no way of knowing what sizes people are ordering...
Are these two pages supposed to be exactly the same?
-
Re: Order Editor 1.3.7 Issues
That is how the mod works by default, and I didn't like it either. Look back a few posts for the code I use to change that.
-
Re: Order Editor 1.3.7 Issues
Quote:
Originally Posted by
gothstone
That is how the mod works by default, and I didn't like it either. Look back a few posts for the code I use to change that.
just looked at the code and used it, but now I get this error when hitting the Details button:
Fatal error: Call to undefined function zen_address_format() in xxxx/store/admin/orders.php on line 389
EDIT: Actually I am getting that error for every button (Invoive, Details, Packing Slip) except the EDIT button, which has nothing to do with the mod I don't think.
-
Re: Order Editor 1.3.7 Issues
So, I managed to figure out my issues with the tax not calculating properly. There is a hard coded variable in the edit_orders.php file that specifies the shipping tax. I put in the right number here. This really should be read out of the database though, so I may change this later on.
As for discounts, it was not subtracting them from the total, nor was tax being calculated as a negative. Once again, the tax on this discount should be read from the database.
Now the issue I have is that the email does not work when updating the status or comments. I tried looking at the orders.php file to see what was different. The call to zen_mail was different. I fixed this up, but still have the same problem....
Email Error: Could not instantiate mail function. Please check Admin->Configuration->Email Options->Email Transport
Anyone else have this problem? I can't see how the edit_orders.php version is any different than the orders.php version.
-
Re: Order Editor 1.3.7 Issues
So never did figure out my above problem with Admin being funky, so I re-uploaded the Admin folder from v1.3.8, re-installed the Edit Order mod with the changes in post #54...everything seemed to work correctly, I could get to my invoice, packin slip, etc...BUT now when I want to EDIT an order I get the following error:
Quote:
Fatal error: Cannot redeclare zen_get_country_id() (previously declared in ../public_html/store/admin/edit_orders.php:1242) in ../public_html/store/admin/includes/functions/extra_functions/edit_orders.php on line 45
Anyone know what this is about? I'm going crazy over here...
-
Re: Order Editor 1.3.7 Issues
Quote:
Originally Posted by
gothstone
Ok, I went back and saw your previous post. A parse error, unexpected $end is usualy caused by a missing } somewhere in your code. I would pull a clean copy of /admin/orders.php and try editing it again. Its usualy faster to redo the mod then actualy try to find the typo burried in 1000+ lines of code.
I found the parse error in orders.php occurs at the end of the second replacement around line 917.
Quote:
if (sizeof($order->products) > 0) {
// ====> BOF: Edit Orders 1.2.6 <====
// $contents[] = array('align' => 'center', 'text' => '<a href="' . zen_href_link(FILENAME_ORDERS, zen_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=edit', 'NONSSL') . '">' . zen_image_button('button_edit.gif', IMAGE_EDIT) . '</a>');
$contents[] = array('align' => 'center', 'text' => '<a href="' . zen_href_link(FILENAME_ORDER_EDIT, zen_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=edit', 'NONSSL') . '">' . zen_image_button('button_edit.gif', IMAGE_EDIT) . '</a>');
// ====> EOF: Edit Orders 1.2.6 <====
}
break;
If you are not careful, the closing "}" just before the "break;" winds up on the commented EOF line above it and so is also commented out.
BUT once I cleared that up I get a parse error in admin/edit_orders.php at the last line. So I'm off on another hunt. :frusty:
-
Re: Order Editor 1.3.7 Issues
Quote:
Originally Posted by
ScrapHutInc
So, I managed to figure out my issues with the tax not calculating properly. There is a hard coded variable in the edit_orders.php file that specifies the shipping tax. I put in the right number here. This really should be read out of the database though, so I may change this later on.
As for discounts, it was not subtracting them from the total, nor was tax being calculated as a negative. Once again, the tax on this discount should be read from the database.
Now the issue I have is that the email does not work when updating the status or comments. I tried looking at the orders.php file to see what was different. The call to zen_mail was different. I fixed this up, but still have the same problem....
Email Error: Could not instantiate mail function. Please check Admin->Configuration->Email Options->Email Transport
Anyone else have this problem? I can't see how the edit_orders.php version is any different than the orders.php version.
just curious, how did you fix the tax problem, can you be more specific to what change you made please.
-
1 Attachment(s)
Re: Edit Orders 1.2.6 Issues
Hi to all,
I have been trying to plug the leaks in the admin/edit_orders.php file and here is what I got:
1. Some of the parse errors are caused by use of short php tags "<?". Rather than setting my php to use short tags, I searched the file with Notepad++ and replaced 9 instances of <? " with <?php ". When you do the search/replace be sure to include a space after the tag. That cured the problem.
BTW, I also noted an extra '</form> around line 995. Didn't seem to do anything if I commented it out.
2. The "Add Products" text was :yuck: so I created a button. You put this button in admin/includes/language/english/images/buttons. Then you have to make some modifications as follows:
Quote:
a. In yourcart/includes/languages/english/YOURTEMPLATE/button_names.php ADD the following line (in alphabetical sequence is fine or anywhere):
define('BUTTON_IMAGE_ADD_PRODUCT','button_add_product.gif');
b. in yourcart/admin/includes/languages/english.php ADD
define('IMAGE_ADD_PRODUCT','Add Product');
c. Now here's the tricky one - in the 'Orders Total' block in admin/edit_orders.php (around line 860)
FIND:
<td align='center' valign='top'><br><a href="<?php echo $PHP_SELF . "?oID=$oID&action=add_product&step=1"; ?>"><u><b><font size='3'><?php echo TEXT_DATE_ORDER_ADDNEW; ?> </font></b></u></a></td>
and REPLACE IT WITH:
<td align='center' valign='top'><br><a href="<?php echo $PHP_SELF . "?oID=$oID&action=add_product&step=1"; ?>"><?php echo zen_image_button('button_add_product.gif',IMAGE_ADD_PRODUCT) ?></a></td>
(Actually I prefer to comment out the old one and add the new one just in case.)
Now you will have a matching "Add Products" button. I have included the button image in the zip file with an updated version of edit_orders.php (including the fix by zc_tester for the delete bug).
I am still seeing a number of problems with my 1.38a version cart.
1. When I attempt to add a product with attributes, I get the drop down list of attributes, but after I select one and click the OK button, it reverts to the first attribute in the list.
2. The attribute did not show on the Order page or the Details page.
3. The mod should get the unit price from the database and add it to the order.
4. Attempted to DELETE and item by setting Quantity=0. When I click on the Update button I get the following error:
Quote:
"Fatal error:Cannot use object of type order as array in .../admin/edit_orders.php, line 271."
When I use the browser BACK button to get back to the Orders page, the item is deleted, BUT the TAX is not corrected as required AND the ORDER TOTAL is NOT changed. This may be due to the fact that I did not remove the unit price manually.
This is a very useful mod. I just which we could get all the bugs out of it. :frusty:
-
Re: Edit Orders 1.2.6 Issues
Small update:
I was able to simply adjust the prices on the EDIT page and the tax and totals recalculated correctly. One more little annoyance out of the way. :clap:
Now if I can only fix the problem with the attributes...
-
Re: Edit Orders 1.2.6 Issues
I've made all the changes you have recommended, thank you for the files and instructions - very good. No errors and looks like everything but shipping tax recalculations are working. can you let me know what you did to correct this.
-
Re: Order Editor 1.3.7 Issues
Hi,
Take a look at this, I might be on to something here? :huh:
http://www.oscommerce.com/community/contributions,1435/
PHP gurus might want to have a look at that OSC package.
(..catalog/admin/edit_orders.php)
This part is rather interesting:
PHP Code:
// Get the shipping quotes- if we don't have shipping quotes shipping tax calculation can't happen
$shipping_modules = new shipping;
$shipping_quotes = $shipping_modules->quote();
if (DISPLAY_PRICE_WITH_TAX == 'true') {//extract the base shipping cost or the ot_shipping module will add tax to it again
$module = substr($GLOBALS['shipping']['id'], 0, strpos($GLOBALS['shipping']['id'], '_'));
$tax = tep_get_tax_rate($GLOBALS[$module]->tax_class, $order->delivery['country']['id'], $order->delivery['zone_id']);
$order->info['total'] -= ( $order->info['shipping_cost'] - ($order->info['shipping_cost'] / (1 + ($tax /100))) );
$order->info['shipping_cost'] = ($order->info['shipping_cost'] / (1 + ($tax /100)));
}
Could that somehow be ported to ZenCart / Edit Orders in order to get the shipping tax calculated correctly?
I really hope some PHP guru could make this work! Thanks in advance!
-
Re: Order Editor 1.3.7 Issues
Edit orders does not work correctly on my non profit website where there is no shipping or sales tax. When I alter a record, the total price goes to "Zero". Can you please tell me what I have to do to get this to work properly and to restore the total amounts to my site. Thank you.
www.buya.org
-
Re: Order Editor 1.3.7 Issues
Same here. Changing an item price resets everything at zero, and writes some <b> tags in the order total table...
-
Re: Order Editor 1.3.7 Issues
Hi, I installed this mod and am getting the following error when I try to add another product to an existing order:
1364 Field 'products_prid' doesn't have a default value
in:
[insert into orders_products set orders_id = 11133, products_id = 392, products_model = 'PD-0078', products_name = 'Siren', products_price = '155.0000', final_price = '155', products_tax = '0', products_quantity = 1;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
Where did I go wrong?
-
Re: Order Editor 1.3.7 Issues
I deleted the table 'products_prid' & now adding products works 100%.
What is that table there for, could I just leave it deleted or does something else indeed use it?
One other issue I have is when I try to remove products from a order I get the following error page:
Fatal error: Cannot use object of type order as array in C:\Domains\thesourceltd.com\wwwroot\admin\edit_orders.php on line 271
This is what I find at line 271:
// 0 Quantity = Delete
$Query = "delete from " . TABLE_ORDERS_PRODUCTS . " where orders_products_id = '$orders_products_id';";
$db -> Execute($Query);
//UPDATE_INVENTORY_QUANTITY_START################################################# #############################################################
#$order = zen_db_fetch_array($order_query);
if ($products_details["qty"] != $order['products_quantity']){
$differenza_quantita = ($products_details["qty"] - $order['products_quantity']);
$db -> Execute("update " . TABLE_PRODUCTS . " set products_quantity = products_quantity - " . $differenza_quantita . ", products_ordered = products_ordered + " . $differenza_quantita . " where products_id = '" . (int)$order['products_id'] . "'");
}
//UPDATE_INVENTORY_QUANTITY_END################################################### ###########################################################
$Query = "delete from " . TABLE_ORDERS_PRODUCTS_ATTRIBUTES . " where orders_products_id = '$orders_products_id';";
$db -> Execute($Query);
}
Is there anything wrong with this code?
-
Re: Order Editor 1.3.7 Issues
Well I just found out that ordering new products uses the table 'products_prid', therefore I had to re-create the table... now however my edit orders obviously fails to work when I try to add another product to an existing order.
Any help would be great :)
-
Re: Order Editor 1.3.7 Issues
I have installed the Edit Orders mod and tried to make it work because it provides functions not available any other way; namely, the ability to add a new product or change the quantity of a product. However, I still find the following problems:
1. Product attribute selection drop menu reverts to default value when OK is clicked.
2. Product attribute is not shown on details page after update.
3. Price for added product not added/adjusted automatically. Especially important when product is "priced by attribute".
4. Does not add/adjust shipping weight.
Does anyone have any thoughts on these points? I especially want to be able to process an order for a quantity of one product where I may have fewer than the number ordered in stock and need to backorder the rest. It seems my only choice is to delete the original order and create 2 new orders. Is there another way? :frusty:
-
Re: Order Editor 1.3.7 Issues
So i take it this is the mod to use to update/change orders, i have always told my customers to reorder, this will help if i can get it to work
Where can i get the latest version?
-
Re: Order Editor 1.3.7 Issues
Quote:
Originally Posted by
LloydR
So i take it this is the mod to use to update/change orders, i have always told my customers to reorder, this will help if i can get it to work
Where can i get the latest version?
It's in the downloads section:
http://www.zen-cart.com/index.php?ma...roducts_id=444
-
Re: Order Editor 1.3.7 Issues
Could someone please let me know if they got this MOD working without resetting the order total price to zero every time it's upldated? I really need this to get to work :-)
Thanks!
-
Re: Order Editor 1.3.7 Issues
Mine is working 100%, just used this forums topic for fixes
-
Re: Order Editor 1.3.7 Issues
Quote:
Originally Posted by
LloydR
Mine is working 100%, just used this forums topic for fixes
Just a quick question for my interest...
Are you using the Super Orders mod or just the standard Orders facility provided by ZenCart. I can not get Edit Orders to work reliably with Super Orders.
-
Re: Order Editor 1.3.7 Issues
I saw this in the beginning of the forum, but never saw a clear fix for it.
When going to save (using the edit button) I get this error:
Fatal error: Cannot use object of type queryFactoryResult as array in ../html/admin/edit_orders.php on line 185
And, yes, I saw the "Unprofessional Fix" but I want the button to work too.
-
Re: Order Editor 1.3.7 Issues
Not using the super orders mod
-
Re: Order Editor 1.3.7 Issues
[quote=Stenrique;440724]When adding item, at Step 2, how can I list items in the dropdown box base on Model No. rather than Product Name?quote]
Anyone know how to do the above?
-
Re: Order Editor 1.3.7 Issues
Ok, I have no idea what I did that fixed it last night - I played with several fixes I found in the forum. but apparently the edit orders in the initial site I was working in is now working EXCEPT the send notice to customer. This appears to not be working and has to be done seperately using the "Unprofessional Fix"
I will try copying these files over to the other sites I'm working on and cross my fingers that whatever I changed in my files fixes them also.
-
Re: Order Editor 1.3.7 Issues
When i click the detail button git takse me to the same page as does the eidt button. also when i click update after editing a order the mail bounce back and get this message: "A message that you sent contained no recipient addresses, and therefore no
delivery could be attempted." In the bouncein ge-mail i get
-
Re: Order Editor 1.3.7 Issues
Luckily I haven't had half the issues I saw in this thread (thanks to downloading late I assume...) but we do have the issue where if you edit a comment, you can't read it or any previous one. You can do the trick of clicking on the product line instead and that works to resurrect comments made through the original interface, but you can never see comments posted from the edit_orders interface.
Did anyone ever have a fix just for that that I'm missing on the board?
-
Re: Order Editor 1.3.7 Issues
I feel like I'm on the wrong planet sometimes. So I go to the download area, I click on this module: Edit Orders Last Updated by: Numinix Technology Nov 12 2007 zen v1.3.7 version 1.2.6 .
I download the file edit_orders_1-2-6.zip, unpack it, and look at the core file, admin\edit_orders.php
It says in the comments that this is from 11/04/04, version 1.3a and other than the zen-cart copyright the comments only refer to osCommerce.
This is the same version I was using called version 1.1 from last fall. Did something strange happen in the download area?
-
Re: Order Editor 1.3.7 Issues
Quote:
Originally Posted by
dhcernese
This is the same version I was using called version 1.1 from last fall. Did something strange happen in the download area?
If you look at the admin/includes/functions/extra_functions/edit_orders.php file you will see
Quote:
* @version $Id: edit_orders.php, v 1.0.0 12/11/2007 12:08:59 numinix $
People usually don't fix what ain't broke. I just wish someone would fix what IS broke in this mod, like the problem with product attributes not showing.
http://www.zen-cart.com/forum/showpo...0&postcount=63
Or as Yogi Berra said: "It's deja vu all over again" :cool:
-
Re: Order Editor 1.3.7 Issues
Quote:
Originally Posted by
mauryg
If you look at the admin/includes/functions/extra_functions/edit_orders.php file you will see
People usually don't fix what ain't broke. I just wish someone would fix what IS broke in this mod, like the problem with product attributes not showing.
http://www.zen-cart.com/forum/showpo...0&postcount=63
Or as Yogi Berra said: "It's deja vu all over again" :cool:
Ah. I see. So the only difference between 1.2.6 and 1.1 is that the functions were pulled out of the main module in admin and put in a separate file.
Yes, I agree, attributes would help. I can't use it without them.
-
Re: Order Editor 1.3.7 Issues
[FONT=Arial]Has anyone experienced this error and found a fix for it?[/FONT]
[FONT=Arial][/FONT]
[FONT=Arial]When I change the product quantity to 0 and hit update (to remove an item from an order) I get his error: [/FONT]
[FONT=Arial][/FONT]
[FONT=Arial]
Quote:
[FONT=Arial]Fatal error: Cannot use object of type order as array in edit_orders.php on line 271:[/FONT]
[FONT=Arial]
[/FONT]
[FONT=Arial][/FONT]
[FONT=Arial]Zen Cart 1.3.8a[/FONT]
[FONT=Arial]Edit Orders VERSION: 1.2.6 11/12/2007[/FONT]
[FONT=Arial][/FONT]
[FONT=Arial]Thanks.[/FONT]
-
Re: Order Editor 1.3.7 Issues
I get that error as well. Always have, but it used to be if you'd hit back everything still updated (sub total, products, etc...) Now, nothing updates. Never did figure this out...
-
Re: Order Editor 1.3.7 Issues
khopek,
Just found this fix -
Need a small fix in admin/edit_orders.php, replace lines 267 - 274 with following PHP Code:
$db -> Execute($Query);
$row = $db->fields;
//UPDATE_INVENTORY_QUANTITY_START################################################# #############################################################
#$order = zen_db_fetch_array($order_query);
if ($products_details["qty"] != $row->fields['products_quantity']){
$differenza_quantita = ($products_details["qty"] - $row->fields['products_quantity']);
$db -> Execute("update " . TABLE_PRODUCTS . " set products_quantity = products_quantity - " . $differenza_quantita . ", products_ordered = products_ordered + " . $differenza_quantita . " where products_id = '" . (int)$row->fields['products_id'] . "'");
}
I still have a problem adding items priced by attributes. It adds the item, but not the attribute or the price...
Any fixes???
Thanks.
-
Re: Order Editor 1.3.7 Issues
Can I throw in a different issue, same module? I installed the Edit Orders module.
I tried it out I got a 404 message that said can't find FILENAME_ORDER_EDIT on this server. I looked at the text file and it says to replace two sections of code, in admin/orders.php, which I did very carefully. However, I noticed that the only file that is close is EDIT_ORDERS, and it's inside the edit_orders/admin folder.
The instructions were to upload the files to my store, but it didn't say where, nor in which folder. Since the error FILENAME_ORDER_EDIT that can't be found is being sought in the admin folder, are all files to be dumped into admin? Or, should I install it in the Modules folder?
Thanks
-
Re: Order Editor 1.3.7 Issues
I have read through the threat but can't find the fix to fix the issue of emails not being sent to customers when you update the status or add comments.
How do I go about fixing the code?
-
Re: Order Editor 1.3.7 Issues
I get this seeing when updating an order
Fatal error: Cannot use object of type queryFactoryResult as array inFatal error: Cannot use object of type queryFactoryResult as array in XXXX/public_html/shop/admin/edit_orders.php on line 185
Plus it isnt updating the orders either.
-
Re: Order Editor 1.3.7 Issues
Quote:
Originally Posted by
infocom
a bit old this thread but I am getting this too when using this mod.
In edit_orders.php on lines 185 and 186 the fields for customer email address ( and name and date_purchased) are wrong.
Notice the $check_status['customers_email_address'] should be $check_status->fields['customers_email_address'].
Wrong code:-
Code:
$email = STORE_NAME . "\n" . EMAIL_SEPARATOR . "\n" . EMAIL_TEXT_ORDER_NUMBER . ' ' . $oID . "\n" . EMAIL_TEXT_INVOICE_URL . ' ' . zen_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL') . "\n" . EMAIL_TEXT_DATE_ORDERED . ' ' . zen_date_long($check_status['date_purchased']) . "\n\n" . $notify_comments . sprintf(EMAIL_TEXT_STATUS_UPDATE, $orders_status_array[$status]);
zen_mail($check_status['customers_name'], $check_status['customers_email_address'], EMAIL_TEXT_SUBJECT, $email, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS);
Correct Code:-
Code:
$email = STORE_NAME . "\n" . EMAIL_SEPARATOR . "\n" . EMAIL_TEXT_ORDER_NUMBER . ' ' . $oID . "\n" . EMAIL_TEXT_INVOICE_URL . ' ' . zen_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL') . "\n" . EMAIL_TEXT_DATE_ORDERED . ' ' . zen_date_long($check_status->fields['date_purchased']) . "\n\n" . $notify_comments . sprintf(EMAIL_TEXT_STATUS_UPDATE, $orders_status_array[$status]);
zen_mail($check_status->fields['customers_name'], $check_status->fields['customers_email_address'], EMAIL_TEXT_SUBJECT, $email, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS);
by infocom
http://www.zen-cart.com/forum/showth...otify+Customer
-
Re: Order Editor 1.3.7 Issues
edit orders
zen cart 1.3.8a
super orders also installed.
when i try to delete an item by entering 0, the cart says successfully updated and i don't get an error but it does not remove the product. i can change quantity from 2 to 1, but i cannot change from 1 to 0.
how do you delete items from an order?
thanks.
-
Re: Order Editor 1.3.7 Issues
follow up:
after entering 0 and updating to remove and item from an order. it seems to adjust the total but it does not remove the item. the item is still listed.
how do i fix that.
thanks.
-
Re: Order Editor 1.3.7 Issues
if no one else has encountered this (entering 0 to remove an item, but it does not get removed and does not give an error), does anyone at least have a guess as how to fix it???
-
Re: Order Editor 1.3.7 Issues
I used the add products part of this mod in another mod I worked on - Drop Shipping w/ PDF Packing Lists. So, I had to fix the attributes for that. I was able to integrate these fixes into Edit Orders, fix the Status/Comments problems, and integrate the other fixes that were detailed on this thread. I've uploaded a new version, 1.5, of this mod that seems to fix all problems that I can find. Please be aware--attributes are TRICKY! I've added a ton of information to the db that this mod wasn't processing before, but not every little detail gets updated when you are dealing with attributes. As far as I can tell, Zen Cart doesn't even use all the data in TABLE_ORDER_PRODUCTS_ATTRIBUTES, so I don't think this will be much of an issue, but you have all been warned! Use this at your own risk.
v 1.5 5/24/08 - Scott Turner
NOTE: 1.5 - Works With Zen Cart 1.3.8
1. Fixed Issues with Adding a Product With Attributes
2. Adding Products with Attributes Will Automatically Recalculate Price
3. Fixed Issue with Deleting a Product (Thanks zc_tester)
4. Fixed Issue with Editing a Product Attribute (Thanks zc_tester)
5. Added Ability to Edit Product Attributes Price Increases/Decreases
-- NOTE: This will not change the unit price - this must be edited manually.
6. Corrected PHP tags
7. Fixed Problems with Status/Comments Updates & Emails
LINK -- Just updated it, so it will probably take a day or two to show up.
Enjoy! :smile:
-
Re: Order Editor 1.3.7 Issues
Thanks for your work! I just installed 1.5 into my cart.
-
Re: Order Editor 1.3.7 Issues
brilliant update srturner47!!!!!
:cheers:
-
Re: Order Editor 1.3.7 Issues
I'm beginning to go bald in the spot where I keep pulling my hair out. I've tried this module several times, and was in hopes that this latest update would work properly, but it doesn't. I think I've figured out the reason, but don't know what to do about it.
I think that it is a config file issue, because I changed the name of my admin file for security reasons, and that's where it's looking. Since this module wouldn't know that, I'm pretty sure that there must be a config file that is telling it where to look. Can someone please point me in the right direction?
Thanks in advance for your consideration.
Shepherd
