Kryptronic Software Support Forum

Design_Wholesale wrote:

It is so annoying the total disregard of CCP support for issues like yours - I often get the impression that they  their product to fail when they as good as tell people that something cannot be done, that CCP does not support whatever, etc.!

I'm sorry but there is anything BUT a "total disregard" for issues. What the poster did is more than a simple change and is one of those things that will likely get over written with an update. 

Design_Wholesale wrote:

My only question is how do I make orders actually appear under the newly created  namespace once I have marked them as ?

As he posted, he changed the SQL select statement associated with the namespace he copied so the select only looks for orders in a completed (which == shipped) status.

Design_Wholesale wrote:

I was referring to other users, too. - There have been numerous posts where the CCP staff seem to have adopted a "maybe addressed in next release" stock response

Nobody ever gets a "stock response" John unless it's a question that's been asked multiple times and I have a stock answer that I know will resolve the problem.  If you haven't noticed yet, CCP focuses on a robust and secure set of core features.  Some of the things that are asked for may make sense for a majority of our customers but not all of them do.  Adding features for the sake of adding features that a very small percentage of people might use is not going to happen.

Design_Wholesale wrote:

and have then completely disregarded the issue even when the poster has struggled valiantly on and come up with something that almost works and which would work with a very small amount of input from someone like yourself.

I don't believe that's the case at all.  People don't/won't learn unless they try things and I always try to give appropriate hints to get them headed in the right direction.  There are times when I'll post a complete solution for a minor tweak but there are also times when a custom modification request is the more appropriate route.

Design_Wholesale wrote:

This bothers me allot and leaves me wondering whether development of CCP is really up to meeting user requirements

I'm sorry that it bothers you but, as I mentioned above, not every requirement or desire makes sense to add to the core.  One thing that tends to happen is "feature creep" where everything but the kitchen sink is available.  While some view this as a "good thing" it can, and does, make it harder for a person new to e-commerce to get started.  They simply get overwhelmed, frustrated and give up.

Anything that makes it into CCP is gone over with a fine toothed comb and we debate its merits and whether or not it will benefit a significant majority of our customers.  If it makes it through that process it gets added. There are a number of things that have, or will be, making their way into CCP based on user requests and suggestions.

Design_Wholesale wrote:

... that CCP obviously could not care less about and which they seemingly have no intention of even looking at, never mind implementing.

I have to take exception to that comment John.  There isn't a feature or suggestion that's been made here or privately that we haven't at least looked at.  As I detailed in the previous paragraph, there are some that won't be implemented in the core but anything that falls into that category is always possible as a custom modification.  One size does not fit all and all sizes don't fit everyone.  It's a balancing act.

For the namespace I was modifying, the sql statement is in the table itself. Some have their functions out in another file.

For us, "Completed" was ok, but we prefer the term "Shipped". So I just changed the labels. The db table still uses "C" to denote that class of orders. Bear in mind, I didn't start another table - just adde another view.

I don't know if this will get overwritten in an update or not, but if it does it will be very easy to add back in. I'm working on a method to conolidate all the admin functions into one screen when updating and manipulating orders. I'll make sure to keep track of what I do so if I do upgrade, I'll be able to maintain the modded code.

I think Dave does a great job of support. As a programmer from way back, I can appreciate what he goes through. Thanks Dave!

Having all that data there on one page will be good if somebody needs that. What would be great would be to have that be configurable. For instance, all we are interested in updating is the order status and external comments and to have the ability to save the record and send the email from the same button click. Real simple. Real fast. A time stamp somewhere in the order to indicate it's last update would be great too. I think this is a mod I can write now, and I'll be looking at it in depth soon.

wyattea wrote:

...so v7 won't have batch order management built in?

No it will not.

wyattea wrote:

we'll have to pay for v7 AND the AOM?

If you want them both yes.

wyattea wrote:

I thought v7 was all about backend upgrades

There's quite a bit of change in the backend.

wyattea wrote:

and AOM is pretty much the main backend upgrade

Not the case at all.

wyattea wrote:

can we just buy the AOM xmod or will the xmod require v7?

ABOM will require version 7.

Design_Wholesale wrote:

Some of the modifications that look like being available in v7 are being attempted here and now by other members and it is all very well telling them that such and such will be covered by v7, but nobody is actually offering anything on what, precisely, will be available in the way of features and what we are going to have to buy as "addons",

When Nick has the details available I'm quite sure he will post them either here or on the web site.  I don't decide what does or does not become part of the core of CCP and what is made available as XMODs.  I can tell you that a couple of us have been arguing that things like AOM and BOM should be included in CCP but Nick has the final word.

Design_Wholesale wrote:

nor is information being made available on whether users could simply code their own versions of the "addons", to which I would say yes, most definitely they could because the "addons" are not going to require any major core code revisions because then you would be into new version territory and potentially creating all kinds of problems for future upgrades.

Since its inception CCP has always been able to be modified by anyone (a quick look at the things that have been done here in the forum is testament to that).  Coding something like AOM or BOM is a significant task and I know that first hand since I wrote both of them.  Right now the class for those is over 2400 lines of code and there is still some work to be done for BOM.  It's far far beyond a "simple" extension.

Design_Wholesale wrote:

So I would say to dskowron and wyattea yes, please  go ahead and create your own interfaces, AOM, ABOM, etc. - the core code is not going to need any major modifications and you would be saving us all a great deal of money!!

By all means, go for it.  But you won't be able to start until version 7 is released or you'll be doing it all over again.  I had AOM done and "in the can" a couple of months ago and I'm having to rework quite a bit of it because of the changes that are coming in version 7.

More than I can detail in a post James.  Suffice to say that the core and CCP have had extensive surgery and virtually everything that has caused confusion for people since V6 was released has been addressed with V7 (and then some).

So far, here's what I've done to my install to make it work better for our situation:

1). I disconnected the "Processing" orders from the "Completed" orders - they now have their own snapshot or "view" from the database that stores all the order records.

2). Gave my new snapshot view of shipped (completed) orders the same functionality as the other two views. i.e. the ability to view and modify (if necessary) the completed oders data just like you can with the "In Progress" orders.

3). I installed code written by Blitzen and modded by Dave which opens up the three funtions "Update Order Information", "Update Order Items (not particularly useful in my case)" and "Post Order Updates" in new windows so we don't lose our place when performing any of these tasks on a particular order.

Items 1 and 2 were accomplished in the KHXC application's "Database: Connections Backups and Raw Admin" section by cloning a namespace and adding a few new records to the dbguided table to give the required functionality to the new namespace.

Item 3 was accomplished by modding one file - ordersummary.php - as outlined in the post started by Blitzen which describes that mod. None of these mods were difficult, but figuring out how and where to do them was a bit tough. Thanks to Dave Martin for helping out there. You definitely need to think like a programmer if you are going to start looking at the core of the backend.

Next up is a single-page Order Management routine that will do what we want it to do for our particular situation. Once I get it figured out and done, I'll post it here if anyone is interested.

Dave Skowron
Red Bear Trading Company
wwwredbeartrading.com

This is a final version, of sorts, of what works with my webstore (thanks for posting this, , and for those who have helped answer those questions I needed answering in order to implement this in our webstore):



Clone  twice.


Change the  to  for one and  for the other.

Change the  values to correspond with the  values, only  the  prefix.

Change the  values to correspond with the  and  given to the namespace, so  for gbu0.manageordersc,  for gbu0.manageordersp, and  for gbu0.manageordersx.


Change the  values to correspond with the  and  given to the namespace, so

SELECT {COLS} FROM gbu0_orders WHERE status='C'

for  - gbu0.manageordersc,

SELECT {COLS} FROM gbu0_orders WHERE status='P'

for  - gbu0.manageordersp, and

SELECT {COLS} FROM gbu0_orders WHERE status='X'

for  - gbu0.manageordersx.

You should now have , , , and  under



Other fields, like , can be added too, should you require them.

Do  change ! - You should not need to modify the details for that namespace at all for the above changes. - Its  need to remain as:

SELECT {COLS} FROM gbu0_orders WHERE status<>'P' AND status<>'X'

...which simply tells the cart software to pull all oders from the namespace, but not where they are  (pending) or  (cancelled).


Lastly, those awful icons (especially the one with an exclaimation mark!) can be changed to something else! - .ico (icon) files (eg: favicon.ico) seem to work well as replacements.

Last edited by Design_Wholesale (08-14-2010 16:12:24)

Without access to your DB it's going to be really tough to try and figure out what might be going on John. As you know all of the links are built dynamically using information from the DB so it's quite likely there's a simple typo that's making things not work correctly.

Design_Wholesale wrote:

Hmm, - you are right - what would be the best way to handle this? - I could easily enough post a .csv of the namespaces in question, if that would help.

You're welcome to send me a SQL dump of the khxc_namespaces table if you'd like. You're using the UK version of V6 correct?

Design_Wholesale wrote:

I think that this may be related to the other problem I have been having, too, where all the namespace and lists in the database are in DESC order and are refusing to conform to the correct menuorder, even when deliberately reversed as a test to see if things have been put in DESC order somewhere.

I didn't read back through this thread so I'm not sure what ordering wrt namespaces you may be referring to John.

What table do you see a menudisplay column in John? Ordering of things in the back end menus is alphabetical for the most part.