JR43409: CMVC 223676 - ALLOW REPARENT SKU USING ONE CSV ROW THROUGH DATA LOAD

7.0.0.9 for Developer Express
7.0.0.9 for Developer Professional
7.0.0.9 for Developer Enterprise
7.0.0-WS-WCServer-FP009
WebSphere Commerce Version 7.0.0.7 Fix Pack
WebSphere Commerce Version 7.0.0.9 Fix Pack

APAR status

• Closed as program error.

Error description

• Currently, a SKU can be moved from one parent product to another
  parent product through Data Load.  However, it needs two rows in
  the CSV. The first row detaches (removes association from) the
  existing parent product, while the second row attaches (adds
  association to) the new parent product.  This requires looking
  up the original parent product's id before constructing the row
  to remove the relationship to the parent product.
  

Local fix

• A SKU can be moved from one parent product to another parent
  product through Data Load using two rows in CSV.  The first row
  detaches (removes association from) the existing parent product,
  while the second row attaches (adds association to) the new
  parent product.
  

Problem summary

• USERS AFFECTED:
  WebSphere Commerce 7.0.0.5 customers who use Data Load to
  re-parent (move from one product to another) a SKU.
  
  PROBLEM ABSTRACT:
  Re-parenting a SKU using Data Load requires two CSV rows.  This
  is time consuming because the original parent must first be
  looked up in order to enter the relationship deletion record.
  
  BUSINESS IMPACT:
  Allow customers to move a SKU to a new parent product using one
  CSV row, without the need to know what the old parent product
  is.
  
  RECOMMENDATION:
  

Problem conclusion

• This new feature enables moving a SKU to the new parent product
  using just one row in CSV. In this row, the user only needs to
  specify the part number of the new parent product. The old
  parent product will be detached automatically. The CSV file
  looks like the following:
  
  CatalogEntryParentProductRelationship,,,
  PartNumber,ParentPartNumber,Sequence,Delete
  SKU1,ProductC,2,0
  
  This CSV will move SKU1 to the new parent ProductC and also
  detach SKU1 from the old parent.
  
  With this ifix, this feature is turned on by default. To turn it
  off, a property called
  "deleteSKUFromExistingParentProductWhenNewParentIsDifferent"
  needs to be set to "false" in the data load configuration file
  (e.g.wc-loader-catalog-entry-parent-product.xml), similar to the
  following:
  
        <_config:BusinessObjectMediator
  className="com.ibm.commerce.catalog.dataload.mediator.CatalogEnt
  ryParentProductMediator"
         componentId="com.ibm.commerce.catalog" >
         <_config:property name="validateCatalog" value="true" />
         <_config:property name="validateAttribute" value="true"
  />
         <_config:property name="syncSalesCatalogs" value="true"
  />
         <_config:property
  name="deleteSKUFromExistingParentProductWhenNewParentIsDifferent
  " value="false" />
        </_config:BusinessObjectMediator>
  
  If validateAttribute is set to "true" or not specified (default
  value is "true"), the mediator will also check if the SKU and
  its new parent product have the same defining attributes. If the
  defining attributes are not the same, an exception will be
  returned back to the dataload utility.
  -------------------------------------------------------------
  The latest available maintenance information can be obtained
  from the Recommended Fixes for WebSphere Commerce technote:
  http://www.ibm.com/support/docview.wss?rs=3046&uid=swg21261296
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  WC BUS EDITION

• Fixed component ID

  5724I3800

Applicable component levels

• R700 PSY

     UP