IBM SG24-6320-00 manual Orders status, Changes are done by executing the following SQL commands

Draft Document for Review July 28, 2004 7:33 pm		6320ch_before_migration.fm
	Parameter	Value
	catalogcache_sz	4096

Important: Ensure that all connections to the database are terminated before continuing. Otherwise the changes performed by the script in this section may not take effect.

10.3.4 Orders status

Orders still in state C (Complete - Payment has been authorized) will be reallocated from the inventory when the WebSphere Commerce V5.6 system is brought online.

To avoid this, you should change the status of the orders according to their true status.

The Migration Guide for Windows 2000 and Windows 2003 - migrating from WebSphere Commerce Suite V5.1 recommends that these orders be changed to status S (Shipped) to prevent order items from being allocated again in WebSphere Commerce V5.6.

The changes are done by executing the following SQL commands:

update orders set status=’S’ where status=’C’ update orderitems set status=’S’ where status=’C’

Note: This is not recommended if you are using WebSphere Commerce Payments, or a similar system to automatically capture payments for orders in state S, unless you can be sure that all these orders have actually been shipped.

You must determine the best approach for your scenario. Some of the orders in state C may actually be abandoned orders, and if this is the case, these should be changed to state X - cancelled.

10.3.5 Catalog

This sections describes the changes which needs to be applied for the catalog subsystem.

Master catalog

A master catalog is a central location to manage your store’s merchandise. It is a single catalog containing everything your store has to offer. Master catalog was

Chapter 10. Pre-migration steps 193