Thursday, 23 February 2017

Price Properties and PriceList reference Info

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