Jump to content


Corporate Sponsors


Latest News: (loading..)

* * * * * 6 votes

NEW! Complete Order Editing Tool!


3252 replies to this topic

#3221 style123

  • Community Member
  • 3 posts
  • Real Name:Tony

Posted 21 July 2011, 18:02

Wonder if someone can help with this.

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 plustm

  • Community Member
  • 4 posts
  • Real Name:Bartek

Posted 21 July 2011, 20:25

View Postfmosse, on 13 April 2011, 06:02, said:

Hi!

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 JuanOnnet

  • Community Member
  • 7 posts
  • Real Name:Juan David Calle Duque

Posted 09 September 2011, 19:27

Hi, when I modify the order and try to send the new order clicking the button "new order mail", nothing happens and appear this message:

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 Dani25

  • Community Member
  • 2 posts
  • Real Name:Daniel

Posted 09 September 2011, 21:07

Hi

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 bad3000

  • Community Member
  • 13 posts
  • Real Name:badou

Posted 23 September 2011, 13:07

Hello I installed "Order Editor 5.0.9c". I can't update my order when ajax is activated (the order is showing up but nothing is happening when I change something). When it is off it works.
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 Op999

  • Community Member
  • 44 posts
  • Real Name:Omar Perez

Posted 27 September 2011, 20:54

I've installed it in the past and have updated as well, but I am not able to change discount codes. If, for example, I have a 20 percent discount on the total purchase, and I edit an order and add a few more items, the discount stays the same as the original. Nor do I have the option of deleting a coupon/discount used.

Am I missing something?

#3227 Dani25

  • Community Member
  • 2 posts
  • Real Name:Daniel

Posted 28 September 2011, 14:51

Hi

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 midijay

  • Community Member
  • 16 posts
  • Real Name:jay

Posted 05 October 2011, 13:39

Hi
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 stubbsy

  • Community Member
  • 539 posts
  • Real Name:dave stubbs
  • Gender:Male
  • Location:Lyme Regis

Posted 12 October 2011, 20:01

Hi,

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 Sickboards

  • Community Member
  • 13 posts
  • Real Name:Martijn
  • Gender:Male
  • Location:The Hague, The Netherlands

Posted 19 October 2011, 10:56

First of great tool,

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 rdbello

  • Community Member
  • 148 posts
  • Real Name:Renato

Posted 19 October 2011, 12:29

I'm having problem with downloadable products. When I add this kind of product, the system include only one item referring to the group name and nothing else. Also the link does not work. Could anyone help me? Thank you.

Edited by rdbello, 19 October 2011, 12:30.


#3232 kartdemon

  • Community Member
  • 41 posts
  • Real Name:Kartdemon

Posted 01 November 2011, 17:03

Hi,

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 DawnG

  • Community Member
  • 178 posts
  • Real Name:Dawn Gribble

Posted 07 November 2011, 09:10

I have Order Editor 5.0.9 installed, and FCK Editor and Order Confirmation Emails.

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 DawnG

  • Community Member
  • 178 posts
  • Real Name:Dawn Gribble

Posted 07 November 2011, 09:37

I say the Editor works fine, but it's no longer notifying the customers of the order update - despite the box being ticked

#3235 sunrise99

  • Community Member
  • 139 posts
  • Real Name:David

Posted 15 November 2011, 04:57

Hi,
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 trent1133

  • Community Member
  • 1 posts
  • Real Name:Trent Smith

Posted 15 November 2011, 09:04

hi, how can i make a order page like this one?

http://penta.com.au/...oducts_id=53830

#3237 teknorc

  • Community Member
  • 4 posts
  • Real Name:Daniel Lewis

Posted 02 December 2011, 20:14

Hello,

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 Simpel

  • Community Member
  • 96 posts
  • Real Name:de wit

Posted 09 December 2011, 17:54

After update with the update-button. In the order, the sub_total get to zero. Also when update the sum total does not update. In which file should I have to look?

#3239 Simpel

  • Community Member
  • 96 posts
  • Real Name:de wit

Posted 12 December 2011, 20:35

Test again.

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 m0b1us

  • Community Member
  • 13 posts
  • Real Name:Agus Halim

Posted 19 December 2011, 06:53

hi,
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]