Jump to content

More than 25 listings in dashboard unsettled order


cqpbert

Recommended Posts

In dashboard unsettled orders, I want to list more than 25 orders on 1 page. Right now if I pick something else in the dropdown, the screen flashes like it reloaded but still only 25 listings.

Is this a bug or a setting I don't have set?

Link to comment
Share on other sites

looks like I am on 6.5.4

Let me upgrade and see if it goes away. I guess I was mistaken thinking the hosted option with maintenance took care of keeping my cart up to date.

Upgraded to 6.5.6.

Now when I set it to more than 25, I still have the action dropdown box. But still only 25 listings.

Link to comment
Share on other sites

In the Dashboard, the Unsettled Orders tab has a red circle with a number in it. Is this more than 25? I would assume so.

Please enable CubeCart's debug mode. (Be sure to have your IP address in the next text entry field -- www.showmyip.com.)

From the 'per page' dropdown, select 100. The page will auto reload.

The browser will want to display a popup window. Let it do so. You may need to reload the page if the popup has what looks like the same content as the main window.

Scroll to the database queries section. At about query number 41, look for:

SELECT * FROM `CubeCart_order_summary` WHERE `status` IN (1,2) OR `dashboard` = 1 ORDER BY `dashboard` DESC, `order_date` ASC LIMIT 100 OFFSET 0;

Is the LIMIT 100 present?

Link to comment
Share on other sites

It looks like the limit did not change to 100

Hack: 1728210645.55840 --- Duration: 1628 µs [NOT CACHED]
SELECT * FROM `CubeCart_order_summary` WHERE status IN (1,2,13,10,11,14) OR `dashboard` = 1 ORDER BY `dashboard` DESC, `order_date` ASC LIMIT 25 OFFSET 0;

And yes, right now the little red circle is at 73 in the unsettled orders tab.

 

Link to comment
Share on other sites

From this query, I see that there is a plugin (or hard code edits) that either makes a new query with custom order statuses, or creates an array with custom order statuses that is supplied to the existing $GLOBALS['db']->select() statement.

Please let us know what this plugin might be.

 

Link to comment
Share on other sites

The Custom Order Status plugin uses the admin.dashboard.unsettled_orders hook. (It's encoded, so I cannot determine what this hook code actually does. But the query shown suggests the hook code created that query.)

In the list of queries shown in CubeCart's debug window, was there a similar query just a few queries above the one you found? A query that has WHERE `status` IN (1,2) ?

Please contact Noodleman to determine if there is anything that would need to be done about the Github issue #3231 (implemented 19 Apr 2023 on CC652), versus the latest version of the plugin (v1.0.6 on 8 Feb 2018).

 

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