WebSphere Commerce Enterprise

Disabling tax sharing in an extended site model

When tax sharing has been enabled for the extended site model, the extended site store always uses the tax assets in the extended site asset store for tax calculation. An extended site store may need to disable tax sharing.

Procedure

  1. Stop the tax sharing from the extended site asset store by Removing the store relationship of type com.ibm.commerce.tax by running the following SQL statement:
    UPDATE STOREREL SET STATE=0 WHERE STORE_ID=EXTENDED_SITE_STORE_ID AND 
              RELATED_STORE_ID = EXTENDED_SITE_ASSET_STORE_ID AND STRELTYPE_ID=-2
    Where
    EXTENDED_SITE_ASSET_STORE_ID
    The extended site asset store ID.
    EXTENDED_SITE_STORE_ID
    The extended site store ID.

    Tax sharing is stopped either for sales tax or for the shipping tax.

  2. Define a new tax code for the extended site store and make sure that the sequence of this tax code is bigger than the one in extended site asset store. For more information on defining tax codes, see Defining sales tax codes and Defining shipping tax codes.
    1. Update the sequence with the following SQL statement:
      UPDATE CALCODE SET SEQUENCE=XXX WHERE CALCODE_ID_id=XXX
    2. Assign this tax code to the catalog entries for extended site store. The tax categories defined in the extended site asset store will no longer work in the extended site store. All the tax jurisdictions can still be shared in the extended site asset store.