1)Generally the price information is moved Core repository.So we need to remove those entries in CA module using remove attribute(xml-combine="remove"').And the price list is maintained at core repository.
2)But in Commerce module, the price properties(@SKU level) , need to refer the values of Core schema.
This we can achieve using following syntax.
<table name="dcs_price" type="multi" id-column-names="sku_id" multi-column-name="price_list">
<attribute name="tablePrefix" value="coreSchemaName."/>
<attribute name="metaDataSchemaPattern" value="coreSchemaName"/>
<property name="skuPrices" column-names="list_price" data-type="map" component-data-type="double" cache-mode="disabled">
....
</property>
</table>
Same is applicable for inventory also.
3) PriceList is also moved to core repository.Then we have to the following steps.
i)Need to change the component PriceLists.properties to refer online data source in commerce module
$class=atg.adapter.gsa.GSARepository
dataSource=/atg/dynamo/service/jdbc/DirectJTDataSource
ii)Need to create the component PriceLists.properties in CA module as follows.
$class=atg.adapter.gsa.GSARepository
dataSource=/atg/dynamo/service/jdbc/JTDataSource_production
iii)The competent JTDataSource_production will be as follows in CA module.
dataSource=/atg/dynamo/service/jdbc/DirectJTDataSource_production
iv)The compotent DirectJTDataSource_production will be as follows in CA module
JNDIName=ATGProductionDS
$class=atg.nucleus.JNDIReference
2)But in Commerce module, the price properties(@SKU level) , need to refer the values of Core schema.
This we can achieve using following syntax.
<table name="dcs_price" type="multi" id-column-names="sku_id" multi-column-name="price_list">
<attribute name="tablePrefix" value="coreSchemaName."/>
<attribute name="metaDataSchemaPattern" value="coreSchemaName"/>
<property name="skuPrices" column-names="list_price" data-type="map" component-data-type="double" cache-mode="disabled">
....
</property>
</table>
Same is applicable for inventory also.
3) PriceList is also moved to core repository.Then we have to the following steps.
i)Need to change the component PriceLists.properties to refer online data source in commerce module
$class=atg.adapter.gsa.GSARepository
dataSource=/atg/dynamo/service/jdbc/DirectJTDataSource
ii)Need to create the component PriceLists.properties in CA module as follows.
$class=atg.adapter.gsa.GSARepository
dataSource=/atg/dynamo/service/jdbc/JTDataSource_production
iii)The competent JTDataSource_production will be as follows in CA module.
dataSource=/atg/dynamo/service/jdbc/DirectJTDataSource_production
iv)The compotent DirectJTDataSource_production will be as follows in CA module
JNDIName=ATGProductionDS
$class=atg.nucleus.JNDIReference