CyberStore Documentation
Order History Archiving
In This Topic

The Order History feature has allowed Console users to view transaction information. With version 2.13, we have expanded that functionality in several ways.

With two new Console Order screens, you can monitor shopper activity in real-time. You have access to information on all active user sessions, in-progress orders, as well as access to an improved Order History screen.

Create Archive Order History Database Schema (#7591)

We have added new tables to the CyberStore database in which completed Order History is archived.

Upgrade Installer Script Conversion of Order Tables to New Archived Order History Tables (#7592) 

When you upgrade to version 2.13, the CyberStore installer uses creation scripts to create six new Order History archive tables in the database if they do not already exist. It migrates all pre-existing data for completed orders to these new tables.

The presence of an order with linked data no longer prevents you from deleting Items, Customers, or other related data from CyberStore when using the Management Console.

New "Active Sessions" Console Screen (#7594)

The "Active Sessions" grid displays the contents of the session and Shopping Cart tables. It shows information about all active sessions within your web store, including the length of time since the shopper requested a page from the server and whether the shopper has begun the checkout process.

The Live Update feature automatically refreshes the information within the grid every ten seconds, provided the edit window is not open.



To learn more about the functions of this grid, see the Active Sessions section in the User's Guide.

New "In Progress Order Review" Console Screen (#7593)

You can view orders that are still in the process of checking out. The "In Progress Order Review" grid is similar to the "Order History Review" grid, minus the Order Receipts tab contained within the pop-up. Any blanks within the grid indicate that the shopper has not yet filled out those respective fields.

If an order is highlighted in purple, the order is complete but has not been archived. 


Please see the In Progress Orders section in the User's Guide for the outlined features of this grid. 

Improved Order History Review Console screen (#7647)

The existing "Order History Review" grid has been modified to contain information about orders that have been completed. The grid has been expanded with additional columns, allowing for easier data filtering.



You can see details about orders placed across all sites in the instance of CyberStore. You can also sort the grid and rearrange columns as you wish, provided you do not refresh the window. The "Live Update" feature refreshes the data every ten seconds.

For complete information about the Order History Review grid, see the Order History topic in the User's Guide.

Front-End Business Logic to Archive Processed Orders (#7595)

We have created new business logic so that when the user completes the checkout process, CyberStore archives the order and subsequently deletes the ORD_OrderHeader record. There are no noticeable changes to the shopper's front-end experience.

The order confirmation page appears as below:


To learn more about the functions of this grid, see the Order History section in the User's Guide.

Front-End Changes to Order History Review to Source from Order Archives (#7596)

The front-end CustomerOrderStatus control now uses data from the Order History tables instead of the Active Sessions table.

Otherwise, the control has the same functions as in previous versions of CyberStore. 



Change Credit Card System Utilities to Point to New Archived Order Tables (#7622)

The "System Utilities" window now points to Order History archive tables.

Otherwise, there are no noticeable changes to this control or its features.



Dashboard Adjustments for Archived Orders (#7639)

The Sales Order Dashboard now points to the Order History archive tables.

Otherwise, there are no noticeable changes.



See Also


Release Notes