NEW! Complete Order Editing Tool!
#3221
Posted 21 July 2011, 18:02
I have 2.3.1 installed with latest version of order editor and it seems that when i edit an order the colons go missing from the end of the order total titles.
It isnt a big issue, but annoying nonetheless.
If the customer places the order through the website they appear fine, but if I enter the order in the admin area they arent there. the only exception to this is the VAT line. The sub-total lines and total lines are missing the colon however.
The shipping line updates to include the colon if I click it on the left hand selection.
I cant seem to find where the colon comes from at the moment (still digging), can anyone help please?
Tony
#3222
Posted 21 July 2011, 20:25
fmosse, on 13 April 2011, 06:02, said:
I have installed Order Editor 5.0.9c and I have the following problem.
When I enter to the EDIT ORDER page, if the billin or shipping country address is the "default country address" of the shopping cart, it shows ok. But if the user has choosed other country, I always see "AFHGANISTAN"... Whan can I do?
Thanks!!!
Francisco
Hi,
I have the same problem.
Does anyone know the solution.
Yours
Plustm
#3223
Posted 09 September 2011, 19:27
1146 - Table 'chucho_osc1.eorder_text' doesn't exist
SELECT * FROM eorder_text where eorder_text_id = '1' and language_id = '2'
¿What i need to do to fix this and send mails with the correct orders to my customers?
#3224
Posted 09 September 2011, 21:07
I have installed the contrib "order_editor_5_0_9b". If i use the orders.php from this contrib, it will displayed this message
Fatal error: Call to undefined function tep_hide_session_id() in /home/www/web255/html/stempelgarten/shop/catalog/admin/orders.php on line 338
the line 338 is: <?php echo tep_hide_session_id(); ?></form></tr>
so, where is the bug? with the original orders.php, the shop will function normaly, but without the possibility of manual changes of orders.
greetz
Daniel
#3225
Posted 23 September 2011, 13:07
I tested my browser on an other site and ajax worked, so Iguess it is not comming from my browser.
If someone could give me an advice where to look, would be very nice.
Thank you
Regards
#3226
Posted 27 September 2011, 20:54
Am I missing something?
#3227
Posted 28 September 2011, 14:51
Has anyone an idea, for my problem in post 3224?
I have edit the line 1003 in "edit_orders_ajax.php"
if ( FILENAME_EMAIL_ORDER_TEXT !== FILENAME_EMAIL_ORDER_TEXT ){
But now, the problem is, that i add a product, the following error displays:
1054 - Unknown column 'products_stock_attributes' in 'field list'
SELECT products_id, products_quantity, products_stock_attributes FROM orders_products WHERE orders_id = '4340' AND orders_products_id = '38684'
[TEP STOP]
when i delete a product, the following error displays:
1054 - Unknown column 'products_stock_attributes' in 'field list'
SELECT products_id, products_quantity, products_stock_attributes FROM orders_products WHERE orders_id = '4340' AND orders_products_id = '38766'
[TEP STOP]
wurde aktualisiert
Where is the problem in the code? Or is there a problem with rights on the server?
greetz
Daniel
#3228
Posted 05 October 2011, 13:39
Been using this contribution successfully for some time but have an issue that I wonder if any one else has spotted and solved.
Basically if I create a negative value product (to create a refund for a customer), then the tax row dissappears from the order totals section. The tax is being calculated, my sub-total and total are different by the right amount, but the tax value is no longer separately shown. Make the value positive and it comes back.
I really want to use negative values so that other reporting tools in oscommerce don't perceive a refund as extra income, rather it is money lost and the maths on that should be straight forward enough so long as I can successfully post negative value order. I even have code that writes "Credit" instead of "Invoice" on the invoices if the total is detected as negative. Just need the tax to show on a separate line!
Thanks
J
#3229
Posted 12 October 2011, 20:01
I have server error when I add RusNNs' update for QT Pro which relates to his update for qtpro
This section causes a 500 server error
REPLACE WITH
if (ORDER_EDITOR_USE_QTPRO == 'true') {
if (isset($_POST['add_product_options'])) {
foreach($_POST['add_product_options'] as $option_id => $option_value_id) {
$products_stock_attributes[] = $option_id . '-'. $option_value_id;
} // for loop
sort($products_stock_attributes, SORT_NUMERIC); // Same sort as QT Pro stock
$products_stock_attributes = implode($products_stock_attributes, ',');
}
}
$sql_data_array = array('orders_id' => tep_db_prepare_input($oID),
'products_id' => tep_db_prepare_input($add_product_products_id),
'products_model' => tep_db_prepare_input($product['products_model']),
'products_name' => tep_db_prepare_input($product['products_name']),
'products_price' => tep_db_prepare_input($product['products_price']),
'final_price' => tep_db_prepare_input(($product['products_price'] + $AddedOptionsPrice)),
'products_tax' => tep_db_prepare_input($products_tax),
'products_quantity' => tep_db_prepare_input($_POST['add_product_quantity']),
'products_stock_attributes' => tep_db_prepare_input($products_stock_attributes));
tep_db_perform(TABLE_ORDERS_PRODUCTS, $sql_data_array);
The first section causes the issue.
Any ideas?
Thanks
Dave
Edited by stubbsy, 12 October 2011, 20:02.
#3230
Posted 19 October 2011, 10:56
Some bugs/areas of improvement I noticed.
I have installed version 5.09c + patch
- If I edit an order which has shipping but falls in the free shipping range the complete shipping entry is removed after an update and if I add it later it will appear after the total (so I manually have to set it straight in the database).
- If I want to remove a product from the order it takes very long to update (5min), if i refresh in the meanwhile the order is not updated. (same goes for altering the amount of ordered products, if I change the price it is updated instantly)
Edited by Sickboards, 19 October 2011, 10:58.
#3231
Posted 19 October 2011, 12:29
Edited by rdbello, 19 October 2011, 12:30.
#3232
Posted 01 November 2011, 17:03
Great contribution and works perfect for me... almost.
Does anyone know of a way of showing the number of items in stock when adding a product from the drop down. Would make my life easier rather than looking up my stock on the site?
Thanks.
#3233
Posted 07 November 2011, 09:10
Order editor and FCK works fine - but on http://pagan-magic.co.uk/shop/admin/email_order_text.php?selected_box=emailtext there is no email box for text - no idea what I've done wrong here, any help would be greatly appreciated.
#3234
Posted 07 November 2011, 09:37
#3235
Posted 15 November 2011, 04:57
We want to know:
after we create one new order from admin, payment is paypal.
Then how customer do this payment online?
Thanks & Best Regards,
Sunrise
#3236
Posted 15 November 2011, 09:04
#3237
Posted 02 December 2011, 20:14
I am trying to install this on v2.3 with the updated contrib. Everything installed fine, but as someone else has posted, all I get is a blank page with the left column and header.
My webhost forced me to update to 2.3, so I'm basically SOL until I get this fixed.
Any help is greatly appreciated. Thanks.
#3238
Posted 09 December 2011, 17:54
#3239
Posted 12 December 2011, 20:35
I got now the following.
subtotal : 10
shippingcosts: 5
credit points: 5
total: 10
When I add quantity of the product 2 and push the update button.
Then...
subtotal: 0
shippingcosts:5
creditpoints:5
total: 20
What I want:
subtotal: 20
shippingcosts:5
creditpoints: -5
total: 20
Where did order_editor calculate after update the subtotal? and where can I change credit points 5 to -5?
#3240
Posted 19 December 2011, 06:53
i'm using order editor Ahax for my website www.totomise.com
and some of the client need to edit her order so i'm using admin to login and change the order.
but i find it that the member discount price didn't update after i do adding/deletion the products. please advise.
[img]http://www.agushalim.com/demo/tmp/order1.jpg[/img]
After Edit the price of member discount still 19570
[img]http://www.agushalim.com/demo/tmp/order2.jpg[/img]














