HCL Commerce Version 9.1.11.0 or later

Synchronizing environments using the Stagingprop utility

When the data loading and search indexing are successful in the Auth environment, the database and Search environments are synchronized from the Auth to the Live environments. This is known as the staging propagation. This propagation transfers the data uploaded in the Auth environment to the Live environment.

Procedure

  1. Run the stagingprop utility. 
    root@comlnx13 ~]# docker exec -it <util container> bash
[root@utils bin]# ./stagingprop.sh -scope _all_ -dbtype DB2 -sourcedb db:50000/mall -sourcedb_user wcs -sourcedb_passwd wcs1 -destdb <live IP>:50000/mall -destdb_user wcs -destdb_passwd wcs1
  2. Run a full index build on the Auth environment. 
    curl --user spiuser:QxV7uCk6RRiwvPVaa4wdD78jaHi2za8ssjneNMdu3vgqi --insecure -X POST "https://<Auth IP>:5443/wcs/resources/admin/index/dataImport/build?connectorId=auth.reindex&storeId=<store ID>"
  3. To copy the search indices from the Auth to Live environment, use the following push to live command. 
    curl --user spiuser:QxV7uCk6RRiwvPVaa4wdD78jaHi2za8ssjneNMdu3vgqi --insecure -X POST "https://<Auth IP>:5443/wcs/resources/admin/index/dataImport/build?connectorId=push-to-live&storeId=<store ID>"

Results

All the data available in the Auth environment is successfully propagated to the Live environment.

See stagingprop utility for more information.