Delete order objects
To delete order objects:
- From the WC_installdir/bin directory, type the following:
- (DB2)
./dbclean.sh -object order -type typename -instancexml WC_installdir/instances/instance/xml/ instance.xml -db dbname -dbuser user -days daysold -loglevel loglevel
- Windows: dbclean -object order -type typename -instancexml WC_installdir/instances/instance/xml/ instance.xml -db dbname -days daysold -loglevel loglevel
- (Oracle)
./dbclean.sh -object order -type typename -instancexml WC_installdir/instances/instance/xml/ instance.xml -db dbname -days daysold -loglevel loglevel -dbtype oracle -dbuser user -dbpasswd password
- Windows: dbclean -object order -instancexml WC_installdir/instances/instance/xml/ instance.xml -type typename -db dbname -days daysold -loglevel loglevel -dbtype oracle -dbuser user -dbpasswd password
Use host:port:sid for the database name. For example, myhost:1521:mydb.
Notes:
- For the -type parameter, you can specify one of the following types:
- completed
- Indicates a completed order.
- canceled
- Indicates a canceled order.
- deposited
- Indicates an order that has been deposited.
- markfordelete
- Indicates an order that is cancelled or an order that is in the trashcan.
- shipped
- Indicates a shipped order.
- stale_guest
- Indicates stale orders from guest customers.
- stale_non_guest
- Indicates stale orders by customers who are not guests.
- quotation
- Indicates a quote that is in the trashcan.
- For details on the syntax and parameters for the dbclean script, see Database Cleanup utility script.
- Examine the WC_installdir/instances/instance/logs/DBClean/DBClean. timestamp.log file.
Related Concepts
Database Cleanup utility
Order and order item states