Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

NEW! Complete Order Editing Tool!


jhilgeman

Recommended Posts

I use oscommerce with joomla/mambo and all my variable are $_REQUEST in my store this is the way to my order.php

 

this is the way to my edit_orders.php

 

but when i will add a product in step 3 of the edit_orders.php, so i have this way and its wrong:

 

the error is here:

<form action=' . $_SERVER['PHP_SELF'] .'?oID=' .

 

Have you tried

 

<form action=' . $PHP_SELF .'?oID=' .

Edited by djmonkey1

Do, or do not. There is no try.

 

Order Editor 5.0.6 "Ultra Violet" is now available!

For support or to post comments, suggestions, etc, please visit the Order Editor support thread.

Link to comment
Share on other sites

is the same error :-(

 

How about

echo '<tr class="dataTableRow"><form action='&action=' . $_GET['action'] . ' method="POST">' . "\n";

Do, or do not. There is no try.

 

Order Editor 5.0.6 "Ultra Violet" is now available!

For support or to post comments, suggestions, etc, please visit the Order Editor support thread.

Link to comment
Share on other sites

Hi guys, love this contribution but I'm getting a small error on the details page. Under Payment Method it says authorize.net, which I'm using but under data I get :

 

Data: Error in encryption

 

What's causing this? I'm sure I probably didn't set something up right, can someone point me in the right direction?

Link to comment
Share on other sites

Hi guys, love this contribution but I'm getting a small error on the details page. Under Payment Method it says authorize.net, which I'm using but under data I get :

 

Data: Error in encryption

 

What's causing this? I'm sure I probably didn't set something up right, can someone point me in the right direction?

 

Could you be more specific?

Do, or do not. There is no try.

 

Order Editor 5.0.6 "Ultra Violet" is now available!

For support or to post comments, suggestions, etc, please visit the Order Editor support thread.

Link to comment
Share on other sites

I think it should work ok for you- could you describe your tax setup in more detail?

I've got one zone (The Netherlands) in which I vreated 2 taxgroups: One for 6% VAT, and one for 19%. Both of them are used in my shop (the lower tax is for medical instruments).

 

If a costumer orders articles from both taxgroups, and I want to edit this order, first the problem were that both taxes were calculated as 19% (the highets rate), now both taxgroups are calculated twice:

 

screenshot.jpg

Link to comment
Share on other sites

 

Gotcha- Order Editor doesn't use encryption, just straight data transfer. You would have to custom modify it to encrypt the data in whatever way the code for authorize.net is expecting.

Do, or do not. There is no try.

 

Order Editor 5.0.6 "Ultra Violet" is now available!

For support or to post comments, suggestions, etc, please visit the Order Editor support thread.

Link to comment
Share on other sites

I've got one zone (The Netherlands) in which I vreated 2 taxgroups: One for 6% VAT, and one for 19%. Both of them are used in my shop (the lower tax is for medical instruments).

 

If a costumer orders articles from both taxgroups, and I want to edit this order, first the problem were that both taxes were calculated as 19% (the highets rate), now both taxgroups are calculated twice:

 

Find this section of code at about line 341:

if (is_array ($_POST['update_totals'])){//1
		foreach($_POST['update_totals'] as $total_details)	{//2
			extract($total_details,EXTR_PREFIX_ALL,"ot");
			$ot_tax_found = 0;
			if (($ot_class == "ot_tax") && ($ot_title == $key))
				{//3
				$ot_tax_found = 1;
				break;
				}//end 3
			}//end 2

 

and change it to this:

if (is_array ($_POST['update_totals'])){//1
		foreach($_POST['update_totals'] as $total_details)	{//2
			extract($total_details,EXTR_PREFIX_ALL,"ot");
			$ot_tax_found = 0;
			if (($ot_class == "ot_tax") && (preg_replace("/:$/","",$ot_title) == $key))
				{//3
				$ot_tax_found = 1;
				break;
				}//end 3
			}//end 2

Do, or do not. There is no try.

 

Order Editor 5.0.6 "Ultra Violet" is now available!

For support or to post comments, suggestions, etc, please visit the Order Editor support thread.

Link to comment
Share on other sites

I also have the problem with the extra tax field appearing after an update.

I searched this thread but I couldn't find an answer.

Is there a solution for this problem? Or at least some kind of a solution to remove the extra tax field again, because now I can't get rid of it once it is there.

 

Thanks in advance!

Link to comment
Share on other sites

Also, when I want to give a discount of lets say 5 euro, the discount is substracted from the total, but the amount of tax is not changed. In my opinion the tax amount should also have to change, because it is a percentage of the order total.

Is it possible to also have the tax amount change when you apply a discount?

Link to comment
Share on other sites

I also have the problem with the extra tax field appearing after an update.

I searched this thread but I couldn't find an answer.

Is there a solution for this problem? Or at least some kind of a solution to remove the extra tax field again, because now I can't get rid of it once it is there.

 

Thanks in advance!

 

Delete the field from the database.

Do, or do not. There is no try.

 

Order Editor 5.0.6 "Ultra Violet" is now available!

For support or to post comments, suggestions, etc, please visit the Order Editor support thread.

Link to comment
Share on other sites

Also, when I want to give a discount of lets say 5 euro, the discount is substracted from the total, but the amount of tax is not changed. In my opinion the tax amount should also have to change, because it is a percentage of the order total.

Is it possible to also have the tax amount change when you apply a discount?

 

Read post #763 for an example of how to accomplish this.

Do, or do not. There is no try.

 

Order Editor 5.0.6 "Ultra Violet" is now available!

For support or to post comments, suggestions, etc, please visit the Order Editor support thread.

Link to comment
Share on other sites

Find this section of code at about line 341:

if (is_array ($_POST['update_totals'])){//1
		foreach($_POST['update_totals'] as $total_details)	{//2
			extract($total_details,EXTR_PREFIX_ALL,"ot");
			$ot_tax_found = 0;
			if (($ot_class == "ot_tax") && ($ot_title == $key))
				{//3
				$ot_tax_found = 1;
				break;
				}//end 3
			}//end 2

 

and change it to this:

if (is_array ($_POST['update_totals'])){//1
		foreach($_POST['update_totals'] as $total_details)	{//2
			extract($total_details,EXTR_PREFIX_ALL,"ot");
			$ot_tax_found = 0;
			if (($ot_class == "ot_tax") && (preg_replace("/:$/","",$ot_title) == $key))
				{//3
				$ot_tax_found = 1;
				break;
				}//end 3
			}//end 2

YES!!! It works!

 

Thank you very much, djmonkey! :thumbsup:

Link to comment
Share on other sites

Ive just installed v.2.4.1

 

Has anyone had this problem?

 

I added a product via the editor, then updated.

 

I now have 2 vat boxes?

 

Original

 

Any ideas?

 

Read the post directly above yours.

Do, or do not. There is no try.

 

Order Editor 5.0.6 "Ultra Violet" is now available!

For support or to post comments, suggestions, etc, please visit the Order Editor support thread.

Link to comment
Share on other sites

Is the latest version the one that is recommended to be installed on a heavily modified site?

 

Thanks.

 

It's the one that works the best.

Do, or do not. There is no try.

 

Order Editor 5.0.6 "Ultra Violet" is now available!

For support or to post comments, suggestions, etc, please visit the Order Editor support thread.

Link to comment
Share on other sites

Hello

 

I've been using version 1.72 up to now and decided to upgrade it to version 2.4 (deletion problems).

 

I'm now facing two problems :

 

1- After adding a product, the total is not calculated :

bug.jpg

 

 

 

2- If I click on update or delete, I get an error message :

Warning: Division by zero in /home/httpd/vhosts/clubfitting.net/httpdocs/admin/edit_orders.php on line 476

 

 

Could somebody help ?

 

Thanks in advance

Pat

Link to comment
Share on other sites

Hello

 

I've been using version 1.72 up to now and decided to upgrade it to version 2.4 (deletion problems).

 

I'm now facing two problems :

 

1- After adding a product, the total is not calculated :

 

 

2- If I click on update or delete, I get an error message :

Warning: Division by zero in /home/httpd/vhosts/clubfitting.net/httpdocs/admin/edit_orders.php on line 476

 

 

Could somebody help ?

 

Thanks in advance

Pat

 

Are you sure that you made all the changes as required by the installation instructions?

Do, or do not. There is no try.

 

Order Editor 5.0.6 "Ultra Violet" is now available!

For support or to post comments, suggestions, etc, please visit the Order Editor support thread.

Link to comment
Share on other sites

Are you sure that you made all the changes as required by the installation instructions?

 

I believe so, here is what I did :

- change edit_order.php (v2.4.1)

- run the sql

- amend admin/includes/functions/general.php

- partly amend catalog/admin/includes/classes/order.php (it's an upgrade for me) :

Find this starting at line 80:

$index = 0;

$orders_products_query = tep_db_query("select orders_products_id, products_name, products_model, products_price, products_tax, products_quantity, final_price from " . TABLE_ORDERS_PRODUCTS . " where orders_id = '" . (int)$order_id . "'");

while ($orders_products = tep_db_fetch_array($orders_products_query)) {

$this->products[$index] = array('qty' => $orders_products['products_quantity'],

'name' => $orders_products['products_name'],

'model' => $orders_products['products_model'],

'tax' => $orders_products['products_tax'],

'price' => $orders_products['products_price'],

'final_price' => $orders_products['final_price']);

 

$subindex = 0;

$attributes_query = tep_db_query("select products_options, products_options_values, options_values_price, price_prefix from " . TABLE_ORDERS_PRODUCTS_ATTRIBUTES . " where orders_id = '" . (int)$order_id . "' and orders_products_id = '" . (int)$orders_products['orders_products_id'] . "'");

if (tep_db_num_rows($attributes_query)) {

while ($attributes = tep_db_fetch_array($attributes_query)) {

$this->products[$index]['attributes'][$subindex] = array('option' => $attributes['products_options'],

'value' => $attributes['products_options_values'],

'prefix' => $attributes['price_prefix'],

'price' => $attributes['options_values_price']);

 

 

Replace it with this:

$index = 0;

$orders_products_query = tep_db_query("

select

op.orders_products_id,

op.products_name,

op.products_model,

op.products_price,

op.products_tax,

op.products_quantity,

op.final_price,

p.products_tax_class_id

from " . TABLE_ORDERS_PRODUCTS . " op

join " . TABLE_PRODUCTS . " p

on op.products_id = p.products_id

where orders_id = '" . (int)$order_id . "'");

 

while ($orders_products = tep_db_fetch_array($orders_products_query)) {

$this->products[$index] = array('qty' => $orders_products['products_quantity'],

'name' => $orders_products['products_name'],

'model' => $orders_products['products_model'],

'tax' => $orders_products['products_tax'],

'tax_description' => tep_get_tax_rates_description($orders_products['products_tax_class_id']),

'price' => $orders_products['products_price'],

'final_price' => $orders_products['final_price'],

'orders_products_id' => $orders_products['orders_products_id']);

 

$subindex = 0;

$attributes_query = tep_db_query("select * from " . TABLE_ORDERS_PRODUCTS_ATTRIBUTES . " where orders_id = '" . (int)$order_id . "' and orders_products_id = '" . (int)$orders_products['orders_products_id'] . "'");

if (tep_db_num_rows($attributes_query)) {

while ($attributes = tep_db_fetch_array($attributes_query)) {

$this->products[$index]['attributes'][$subindex] =

array('option' => $attributes['products_options'],

'value' => $attributes['products_options_values'],

'prefix' => $attributes['price_prefix'],

'price' => $attributes['options_values_price'],

'orders_products_attributes_id' => $attributes['orders_products_attributes_id']);

 

 

Di I forget shtg ? (I'm running Paypal Devosc)

Link to comment
Share on other sites

Any thanks for previous help. And it has worked.

 

 

I have another question if anyone could help or point me in the correct direction of what i should be doing.

 

 

1. I have an extra address line, how do i incorporate this?

 

 

2. Also I wish to add a tracking number after the order has been placed, any ideas on how this should be done? Ive looked at the contributions but none really fit....

 

 

Any thoughts?

Link to comment
Share on other sites

Any thanks for previous help. And it has worked.

 

I have another question if anyone could help or point me in the correct direction of what i should be doing.

 

1. I have an extra address line, how do i incorporate this?

 

2. Also I wish to add a tracking number after the order has been placed, any ideas on how this should be done? Ive looked at the contributions but none really fit....

 

Any thoughts?

 

Which second address line contribution are you running? There are two that I know of.

 

FedEx Automated Labels automatically generates a tracking number, writes it to the database, and includes it in the email sent to the customer. that it automatically sends when you generate a label. If you care at all for FedEx it's an excellent contribution.

 

UPS Order Tracking XML offers real-time tracking for your customers via your site. I use UPS and have found this contribution to be very helpful.

Do, or do not. There is no try.

 

Order Editor 5.0.6 "Ultra Violet" is now available!

For support or to post comments, suggestions, etc, please visit the Order Editor support thread.

Link to comment
Share on other sites

Using Extra Address Line v1.4.zip

http://www.oscommerce.com/community/contri...tra+address+1.4

 

 

Ill take a look at the tracking contribs... I dont use fedex or UPS will that make a difference, or can i customise it.

 

Also, Ive tried to make the "new Status / comments" area/table smaller in width but with no luck. It should be easy Im sure..

 

 

 

I am at this moment looking through the code to do this but ive also installed improved order number http://www.oscommerce.com/community/contri...,improved+order

 

I assume this would be easy to incorporate.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...