3277 replies to this topic

[pcsadmin]

First let me say thank you for the contrib. Wonderful work.

I have ran into two issues though installing on v2.2 RC2. One is the shipping_quotes problem that seems to need commenting out. No problem but 5.0.7 says it fixes this issue and I installed 5.0.9b as it seemed to be the latest FULL update to the contrib. I expecteded it to have stayed fixed.

By commenting out code and reloading the page, I narrowed the problem to a line in admin/order_editor/shipping.php line 81 that states:

$quotes = $GLOBALS[$include_quotes[$i]]->quote($method);

Since I only have the flat rate shipping module active (No Fedex, etc.), I am unsure why this line causes problems.

Second, When I manually change the Shipping dollar value I get a "Working" overlay, I assume is javascript/ajax but it never completes. Refreshing the page clears the overlay but the value is unchanged. Disabling AJAX and using the Update button works fine.

There is a feature I would like/suggest.  Is it possible to place the order in a state such that if unpaid, the customer could then login and pay for the order or if the CC info is provided that the CC can be processed from the admin side. I understand the in ability to perform paypal transactions from the admin side.

All assistance is appreciated.

[OSC-Sevilla]

I am modding order editor to incoporate my lead time addon that shows if the product carries a lead time and how many days, during editing the order the operatoer can change these the specs:

this piece of code refers to a checkbox that shows which product(s) have lead times

<td class="dataTableContent" valign="top"><input type="checkbox" title="Lead time Active: <?php echo $order->products[$i]['lead_time_days']; ?> DAYS" name="<?php echo "update_products[" . $orders_products_id . "][lead_time]"; ?>" <?php if (ORDER_EDITOR_USE_AJAX == 'true') { ?>onclick="updateProductsField('update', '<?php echo $orders_products_id; ?>', 'products_lead_time', this.checked, this)"<?php } ?> <?php if($order->products[$i]['lead_time']=='1'){ echo "checked=\"true\""; }?>"></td>


The problem i am having is the data form the check box enters mySQL as " true " or " false" - is all well and good but i would like it to go in as "1" or "0"

If i deactivate AJAX, it goes in as "on"....


My db is currently VARCHAR (5).


I have googled searched high and low but not found a straight forward solution.


All this is carried out on edit_orders.php:

// Update orders_products Table
$Query = "UPDATE " . TABLE_ORDERS_PRODUCTS . " SET
products_model = '" . $products_details['model'] . "',
products_name = '" . oe_html_quotes($products_details['name']) . "',
products_price = '" . $products_details['price'] . "',
final_price = '" . $products_details['final_price'] . "',
products_tax = '" . $products_details['tax'] . "',
products_quantity = '" . $products_details['qty'] . "',
products_lead_time = '" . $products_details['lead_time'] . "',
products_lead_time_days = '" . $products_details['lead_time_days'] . "'
WHERE orders_id = '" . (int)$oID . "'
AND orders_products_id = '$orders_products_id';";
tep_db_query($Query);


Any ideas folks??

[pcsadmin]

Again let me say thanks to all who have worked on this contrib as I eat crow.

The problem with the shipping quotes was another contrib that modified the flat rate class.  This also seems to have fixed the AJAX update stalling problem.

I would still like to know if there is a way for the order to be placed in a state that the customer could login and pay for it.

Again all assistance is appreciated.

[chicoverde12]

edit: Nevermind, looks like it was a problem with the address and nothing was returned by FedEx.

I've just installed the FedEx Web Services contribution and the shipping methods from it are not showing up in Order Editor. Anyone have a similar problem?

Thanks,
Robert

Edited by chicoverde12, 01 August 2012 - 07:22 PM.

[nathanwheeler]

Hi! I am using http://www.oscommerce.com/community/contributions,1435/
this order editor.
I have only one language set in the dbase language table: German
BUT due to a autopilot catalog update we use from a central catalog backend dbase this dbase holds the product names et cet for 3 languages.

NOW
IF I add a product in this german shop believe it or not; I see german lang. categorie names and productnames but once I insert it/add it to the order -->
it shows the product name NOT in English but in my case Dutch. ( dutch is not activated or installed as languages it is just in the dbase products description and has a language id = 2, german = 2 and french = 3.

Anyone an idea how to solve this?

[nathanwheeler]

I meant: it shows the product name NOT in German but in my case Dutch. ( dutch is not activated or installed as languages it is just in the dbase products description and has a language id = 1, german = 2 and french = Happy to donate for a solution

[groston]

Problem with V2.3.3

Thank you to all who have contributed to this module - it looks quite useful!

My installation is a fairly vanilla V2.3.3. For the required mods to admin/orders.php, I was unable to find the appropriate lines in the original version. Can someone please help me figure out how to modify this file?

Thank you!

[thescalerstore]

Hello,
I have Order Edito 5.0.63 Insalled since 2008 and worked well. My ISP upgraded to php5 and now AJAX editing wont' work. I have to disable it.
I've searched the web with no luck.

Can you help me out ?
thank
Roby

[a.forever]

thescalerstore, on 04 September 2012 - 12:50 PM, said:

Hello,
I have Order Edito 5.0.63 Insalled since 2008 and worked well. My ISP upgraded to php5 and now AJAX editing wont' work. I have to disable it.
I've searched the web with no luck.

Can you help me out ?
thank
Roby

I'm using Order Editor 5.0.7, so I hope it's pretty much the same. Log onto your osCommerce Admin. Under Configuration -> Order Editor, set Allow the use of AJAX to update order information? to false.

[thescalerstore]

Thank, I know that option but I want to use AJAX

[Irin]

Hello. I need some help changing how the tax is being calculated in Order Editor. I'm using additional "Tax Exempt and Organization Discounts" and "COUNTY SALES TAX BY ZIPCODE" modules to handle taxes. Please advice what and where I need to change in order to handle the taxes correctly in Order Editor.

[pingpongrob]

I noticed that when order are edited, the are not in SSL mode, and sensitive customer data can be seen. Is there any way of changing it so the edits are all done whilst the page is in HTTPS mode.

[sunrise99]

demiati, on 29 January 2010 - 10:28 PM, said:

Hi Eveline,
I have to admit that I have virtually no knowledge of programming, but if it is of help you can edit the admin\includes\application_top.php and change the level of error reporting thus:

  error_reporting(E_NONE);

It's near the top of the file I think.

This surpresses the error, but doesn't cure the problem. I have the same problem with my site, so if you fin dout what the cause is, please let me know.

Good luck,
Carl

number_format($order->totals[$i]['value'], 2, '.', '')
(double) einfügen:

number_format((double)$order->totals[$i]['value'], 2, '.', '')

[sunrise99]

I get this error, do you have some suggestion how to fix it?



Warning: in_array() expects parameter 2 to be array, null given in/var/www/vhosts/catalog/admin/edit_orders.php on line 569

Warning: in_array() expects parameter 2 to be array, null given in/var/www/vhosts/catalog/admin/edit_orders.php on line 569

Edited by sunrise99, 19 February 2013 - 12:36 AM.

[mega01]

Hi!

great contribution!!

I have a question!!!

How do I add the email of the email order the phone and email adress of the customer?

[Snoopy10]

Hi,

I have installed order_editor_for2.3_v1.0 on my oscommerce 2.3.3 webshop. Further I'm using following modules:

ot_disocunt
ot_codfee
ot_loworderfee

I think due to this, the order total and taxes are calculated wrong, when I've modified the order. Mainly the ot_codfee is skipped after the calculation.

Can someone give me some hints, how can I add this modules to calculate the correct price. (I think ot_loworderfee should work)

Best wishes

Bernhard Bauer

[Snoopy10]

The discount-code module ot_discount from http://addons.oscommerce.com/info/7700/v,23 is also skipped after recalculation. What can I do?

[ffff]

Bug report
If I change the price of a product (brutto) to a negative value (refund), there will be shown no tax and the netto price is the same as brutto in the total view.