Edit Orders v4.0 Support Thread

[lhungil]

...But, I still had the subtotal problem and then I messed something up and have tried to revert back and then re-do and now I am just stuck. ...

Re-install Edit Order's 4.1.1 (all steps to make sure your files are up to date) and make note of any messages. If you replaced "orders.php" with the one from "Super Orders" or any other module after the installation of "Edit Orders", the changes made during installation of "Edit Orders" will no longer be present in "orders.php". If you re-install "Edit Orders" the installer should automatically make the needed changes to "orders.php".

The "Edit Orders" installer changes all instances of FILENAME_ORDER_EDIT to FILENAME_EDIT_ORDERS if a version of "Super Order" <= "4.0.5" is installed.

...I am willing to let the order just be messed up due to the frustration it has caused me. ...

Once "Edit Orders" 4.1.1 is re-installed (and working), you have two options to fix the "messed up" order's subtotal:

1. Write down a list of products (including attributes and price) from the order. Remove all products from the order using "Edit Orders". Use phpMyAdmin or similiar to manually correct the "text" and "value" for subtotal and total (if nothing is in the order these should be "$0.00" and "0.0000" in the orders and orders_total database tables (for the specific order_id). This should fix the order to have correct subtotal and total data. You can then go back to "Edit Orders" and re-add the products.
2. Simply create a new order for the customer (see the "Admin New Order" plugin or "Encrypted Master Password" plugin). You can then use "Edit Orders" to re-create the order information in the "messed up" order. When done, you can delete the "messed up" order (so it does not show in invoices or the customer history).

[RyanEOD]

Re-install Edit Order's 4.1.1 (all steps to make sure your files are up to date) and make note of any messages. If you replaced "orders.php" with the one from "Super Orders" or any other module after the installation of "Edit Orders", the changes made during installation of "Edit Orders" will no longer be present in "orders.php". If you re-install "Edit Orders" the installer should automatically make the needed changes to "orders.php".

The "Edit Orders" installer changes all instances of FILENAME_ORDER_EDIT to FILENAME_EDIT_ORDERS if a version of "Super Order" <= "4.0.5" is installed.


Once "Edit Orders" 4.1.1 is re-installed (and working), you have two options to fix the "messed up" order's subtotal:

1. Write down a list of products (including attributes and price) from the order. Remove all products from the order using "Edit Orders". Use phpMyAdmin or similiar to manually correct the "text" and "value" for subtotal and total (if nothing is in the order these should be "$0.00" and "0.0000" in the orders and orders_total database tables (for the specific order_id). This should fix the order to have correct subtotal and total data. You can then go back to "Edit Orders" and re-add the products.
2. Simply create a new order for the customer (see the "Admin New Order" plugin or "Encrypted Master Password" plugin). You can then use "Edit Orders" to re-create the order information in the "messed up" order. When done, you can delete the "messed up" order (so it does not show in invoices or the customer history).

Thank you very much for the help! The steps worked, I wanted to keep that order as the same one due to the customer had already paid with Paypal so I didn't know how bad it would jack things up to cancel that order and redo a new one. So, I followed the steps for getting into SQL and after editing it there and then adding everything back in I am now good to go on that side!

I have one more problem but I think it is a Super Orders thing, when I go to bring up the Packaging Slip, and I have images on, it shows the same thumbnail for 2 different products. Any thoughts or should I move this over to the support thread for it?

Thanks again for all your help!

[lat9]

I've got Edit Orders 4.1.1 installed on a client's v1.5.1 site (running PHP 5.2.17). The store has products with a bunch of attributes and I'd asked the owner to perform a bit a verification of some of the issues he'd found with EO v4.1. He was editing a test order, adding a product that includes a checkbox attribute and indicated that the option didn't have a label in the "add product" screen. I didn't think much about it until I was checking the store's /logs folder and found:

[26-Jul-2013 15:50:46] PHP Warning:  array_shift(): The argument should be an array in <ADMIN/includes/functions/extra_functions/edit_orders_functions.php on line 486
[26-Jul-2013 15:50:46] PHP Warning:  Invalid argument supplied for foreach() in <ADMIN>/includes/functions/extra_functions/edit_orders_functions.php on line 487

I'm thinking that they're related ...

Any insight or additional tests I could perform are welcomed.

[lhungil]

... adding a product that includes a checkbox attribute and indicated that the option didn't have a label in the "add product" screen. ...

Not sure exactly what would cause the label to not show... Except maybe if no products_options_id existed for the admin language (the query would pull the products_attributes_id but would not be able to match a products_options / products_options_values)... Is the store by any chance a multilingual store?

...

[26-Jul-2013 15:50:46] PHP Warning:  array_shift(): The argument should be an array in <ADMIN/includes/functions/extra_functions/edit_orders_functions.php on line 486
[26-Jul-2013 15:50:46] PHP Warning:  Invalid argument supplied for foreach() in <ADMIN>/includes/functions/extra_functions/edit_orders_functions.php on line 487

...

Not related. The function containing those lines is not called when listing the options (attributes) on the "add product" page. Should not affect functionality (just does not add the attribute to the product as none were checked).

Thank You for reporting this debug message. It seems when I switched the test environments over to suphp I forget to change the php.ini settings from production to development (so they were not reporting warnings). I'll take care of the specific case generating that warning in the next release.

[bsonhome]

hi
i find a bug of the module,
the subtotal still not work 100% correctly
if only one product it working fine..
if more than one product and try to change the quantity or unit price the subtotal will go wrong
i am not sure how to fix it
if any help will be thankful

[DivaVocals]

hi
i find a bug of the module,
the subtotal still not work 100% correctly
if only one product it working fine..
if more than one product and try to change the quantity or unit price the subtotal will go wrong
i am not sure how to fix it
if any help will be thankful

Details will help.. Guessing is not a productive way to handle troubleshooting..

when you say "the subtotal will go wrong" some specifics of what you did, how your store is configure, etc would help..

does the product you added to the order have attributes?? are your products priced by attributes?? Are you using any order total modules?? if you are which ones?? what did the totals look like after editing?? what did you expect them to look like??

DETAILS my friend will help..

[bsonhome]

Hi
thanks i am not sure which module i should list so i list them all, sorry for my stupid.....
EasyPopulate-4.0
add_customers_from_admin
Edit Orders 4.1.1
Admin New Order 1.4
export_shipping_information_V1.3.2.1
Image_Handler4_v4_2
sitemapXML
recover_cart_sales v.4.00.00a
zen_lightbox-v1.6.4_1.5
ceon_uri_mapping_4.4.1_for_zc
Simple_Google_Analytics_1-2-5c
google_merchant_center_1.13.0

i will try to explain with step by step
firstly i go to customer, select one of the customer and click new order, then add one product which is 100usd now subtotal and total is 100 usd so they are correct.
then i add other product which is also 100 usd now the subtotal and total is 200 usd so they are correct.
then i change the quantity of one of the item to 3 and press enter key, and the subtotal is still 200 and total is also 200 it should be 400 for both,
if i go to quantity text box and click enter again, the total and subtotal will become 0, they are changing every time when i press enter

sorry my English is not very good.

Thanks for quick reply

[Amar619]

Details will help.. Guessing is not a productive way to handle troubleshooting..

when you say "the subtotal will go wrong" some specifics of what you did, how your store is configure, etc would help..

does the product you added to the order have attributes?? are your products priced by attributes?? Are you using any order total modules?? if you are which ones?? what did the totals look like after editing?? what did you expect them to look like??

DETAILS my friend will help..

Hi Zenners,

I am Facing the same issue here..

[twi]

Details will help.. Guessing is not a productive way to handle troubleshooting..

when you say "the subtotal will go wrong" some specifics of what you did, how your store is configure, etc would help..

does the product you added to the order have attributes?? are your products priced by attributes?? Are you using any order total modules?? if you are which ones?? what did the totals look like after editing?? what did you expect them to look like??

DETAILS my friend will help..

zc151
multisite
Super Orders
Edit orders RC1

hi HUNGL / dr byte:


I not sure if this is related or not. Since I was involved in testing EO RC1 and not got further than any other version other than RC .


I want to report to you before I proceed testing rc3 (if that is still necessary) that I discovered an error in the current EO RC1 I have put online use. I am not sure if this may be a problem with your EO RC3.

When editing an order by either deleting items and/or adding items, the subtotal before taxes comes out wrong (either the amount increased / decreased, after decreasing of deleting an item, or the amount). Upon further inspection in the database table "order_products" , the "orders_products_id" somehow skips, instead of following a sequential order. Is this supposed to be like this.

Reason I discovered this is because I notice the picking ticket in Super order is not displaying the correct picture. Could the wrongly display picture have something to do with the database being corrupted? Please let me know.

Products have no attributes.