Shopping Cart Software

**bkpie** · #1 11-06-2007, 03:32 PM

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.

**michael_s** · #2 11-06-2007, 04:32 PM

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...

**bkpie** · #3 11-13-2007, 05:29 PM

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>

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

**bkpie** · #4 11-14-2007, 11:14 AM

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.

**bkpie** · #5 11-14-2007, 06:20 PM

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?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Order Editor	michael_s	New osCommerce Contributions	0	04-28-2007 07:30 AM
Order Editor	michael_s	New osCommerce Contributions	0	04-28-2007 04:30 AM
Order Editor	michael_s	New osCommerce Contributions	0	04-27-2007 01:00 AM
Order Editor	michael_s	New osCommerce Contributions	0	04-20-2007 03:30 PM
Order Editor	michael_s	New osCommerce Contributions	0	02-25-2007 09:00 AM

Shopping Cart Software

Order editor help

Order editor help

Similar Threads

The Following User Says Thank You to michael_s For This Useful Post:
bkpie (11-07-2007)