Home
User Guide
The information contained in this section applies to IBM WebSphere Commerce Version 7.0.0.9 and Feautre Pack 8. The documentation also applies to all subsequent releases and modifications until otherwise indicated in new editions.
Administering
Managing features
You can administer the features for your store and site, such as attribute, catalog, promotion, marketing, order management features, and more. The administration tasks that you can complete differ depending on the type of feature and the tool that you use to administer your store and site.
Order management
As a Site Administrator, you can manage various features of the order management subsystem.
WebSphere Commerce RVU Order Line Metrics
A Resource Value Unit (RVU) is a proof of entitlement based on the number of units of a specific resource that is used or managed. WebSphere Commerce RVU Order Line Metrics, is an order line resource, where you are able to produce a report of the count of any completed order lines for auditing purposes. For your specific RVU entitlement, refer to your license.
Check the number of order lines
You can run a SQL query to check how many order lines you have in your system.

Check the number of order lines

You can run a SQL query to check how many order lines you have in your system.

Pre-enablement of WebSphere Commerce RVU Order Line Metrics

To find out the number of lines you have before WebSphere Commerce RVU Order Line Metrics is enabled, run this SQL query:

select count(orderitems_id) from orderitems where orders_id in (select orders_id from orders
where status not in ('P', 'N', 'Q', 'T', 'W', 'Y', 'Z', 'NEW', 'RDY', 'CAN') and timeplaced is not null 
and timeplaced > startDateTime and timeplaced < endDateTime);

startDateTime and endDateTime represent the time range of interest.

Enablement of WebSphere Commerce RVU Order Line Metrics

To find out the number of lines you have after WebSphere Commerce RVU Order Line Metrics is enabled, run this SQL query:

select sum(linecount) from ordaudit where 
timeplaced > startTime and timeplaced < endDateTime;

startDateTime and endDateTime represent the time range of interest.