Filter
Top Products
Chapter 10. Pre-migration steps 193
Draft Document for Review July 28, 2004 7:33 pm 6320ch_before_migration.fm
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’
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
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.
Parameter Value
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.