This is a discussion on Order editor help within the osCMax v2 Features Discussion forums, part of the osCmax v2.0 Forums category; The order editor works great except with larger orders. Today we had a 12 page order and any change I ...
Order editor help The order editor works great except with larger orders. Today we had a 12 page order and any change I made took 5 min to process per change It happens with most orders of 3 pages or more.
Over an hour to make changes on that order. It seems to lock up or crawl. Is there a fix or workaround? Any help appreciated.
Re: Order editor help Look at the queries as they are happening. It has to look up a lot of data for a 12 page order.
Make sure that all the tables that are being accessed are properly indexed and you may need to actually hack the queries to be more efficient.
I don't think the maker of that mod anticipated such large orders. Most applications would be single page orders...
Michael Sasek
osCMax Developer
osCmax installation service - Have our professionals install osCmax on your server - same day service!
osCmax 2.0 User Manual - the must have beginners guide to osCmax v2.0
Stay Up To Date with everything osCMax:
Free osCMax Newsletters - Security notices, New Releases, osCMax News
osCMax on Twitter - Up to the minute info as it happens. Know it first.
osCmax Documentation
Re: Order editor help I think I found a contribution that will make things work faster but have been trying to get to work for a few days now. It is called ajax order editor where you can edit on the detail page everything pretty quickly. I am so close I can taste it.The items are clickable on the details page and the box comes up to edit but then I get an error window from explorer. Anyone install this contrib. or can tell me what is causing the following to pop up in an explorer box
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html dir="ltr" lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>QSI</title>
<link rel="stylesheet" type="text/css" href="includes/stylesheet.css">
<script language="javascript" src="includes/general.js"></script>
<script language="javascript" src="includes/ajax.js"></script>
</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF">
<div id="add-Product" class="addProduct">
<div>Add a product</div>
<div id="add-product-product" class="addProductContents">Name or model of product:</div>
<div id="addProductSearch" class="addProductContentsSearch"><table border="0" width="100%" cellspacing="0" cellpadding="2">
</table>
<table border="0" width="100%" cellspacing="0" cellpadding="2">
<tr>
<td class="infoBoxContent"><input type="text" name="keywords" id="keywords" onKeyUp="loadXMLDoc(this.value);" autocomplete="off" style="width: 100%"></td>
</tr>
<tr>
<td class="infoBoxContent"><div style="display: block; margin-left: 0%; width:100%; float: left; border:solid 1px; background-color:#CCCCCC;" id="quicksearch">Search Results: </div></td>
</tr>
</table>
</div>
<div id="addProductFind"> </div>
<div id="ProdAttr"> </div>
<a href="javascript: hideAddProducts();"><img src="includes/languages/english/images/buttons/button_cancel.gif" border="0" alt=""></a>
</div>
<!-- header //-->
<table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td><a href="http://aabox.com/?oscmax"><img src="images/oscmax.gif" border="0" alt="osCMax v2.0 from AABox Web Hosting" title=" osCMax v2.0 from AABox Web Hosting " width="169" height="56"></a></td>
<td align="right"><a href="http://www.osCDox.com" target="_blank"><img src="images/header_support.gif" border="0" alt="osCDox" title=" osCDox " width="50" height="50"></a> <a href="http://localhost/"><img src="images/header_checkout.gif" border="0" alt="Catalog" title=" Catalog " width="53" height="50"></a> <a href="http://localhost/admin/index.php"><img src="images/header_administration.gif" border="0" alt="Admin" title=" Admin " width="50" height="50"></a> </td>
</tr>
<tr class="headerBar">
<td class="headerBarContent"> <a href="http://localhost/admin/admin_account.php" class="headerLink">My Account/Password</a> | <a href="http://localhost/admin/logoff.php" class="headerLink">Logoff</a></td>
<td class="headerBarContent" align="right"> <a href="https://aabox.com/?oscmax" target="_blank" class="headerLink">AABox Web Hosting</a> | <a href="http://oscdox.com" class="headerLink">osCDox.com</a> | <a href="http://localhost/" class="headerLink">Catalog</a> | <a href="http://localhost/admin/index.php" class="headerLink">Admin</a> </td>
</tr>
</table><!-- header_eof //-->
Re: Order editor help Nevermind, I have that figured out. It was not in the instructions to allow access to a new file the contribution added. I have it all working except the add products which I believe is a sppc problem. Once I figure it out I will try and add it to contributions updated for oscmax and sppc.
Re: Order editor help Alright...I know I am talking to myself alot here but am requesting some help now. I got the ajax order editor contribution working with oscmax and it is great for editing large orders with no slow sql like the order editor included, however the order editor included has some nice features being able to use text in different areas etc. The problem is ajax which works on the details page(directly on orders.php)breaks order editor . If you use order editor and hit update it doubles everything. Anyone here willing to take a crack at this? It would be great to have both. Install was actually fairly easy once my slow mind got working just a couple syntax errors that were easy to find and a fix listed on the ajax order editor contribution page for adding products. I can send the fixes if needed. Need a better coder than I to finish this up. ANY TAKERS?
Posting Permissions
LinkBack URL
About LinkBacks
Bookmarks