Technote

(FAQ)

How to set up per product and per category shipping using CALCODE combinations

This technote details how to set up calculation codes (CALCODE) for your categories and helps understand the behavior of associating CALCODEs to categories.

Cause This is useful if you have specific CALCODE association for certain catentries as well as categories.
A sample setup is as follows:

1. Setup the CATENCALCD table to have per item shipping calcodes

2. Setup the CATGPCALCD table to have per category shipping calcodes, these are top categories

3. Order an item that has a record in CATENCALCD and is part of a sub category that has en entry in CATGPCALCD. Note that your category needs to be a direct parent of the product/item.

Answer

The goal is to achieve a decomposed shipping like below:
Ground shipping: $2.00 (Order cover charge= 0.00 + item specific charge=2.00)
2nd Day shipping: $25.99 (Order cover charge= 23.99 + item specific charge=2.00)
Next Day Shipping: $57.99 (Order cover charge=55.99 + item specific charge=2.00)

To achieve the above, configure order cover charges at category level and item specific charges are configured at product level.

For instance:
CALCODE_00 for Order Cover Charge 1
CALCODE_01 for Order Cover Charge 2
CALCODE_02 for Order Cover Charge 3

CALCODE_10 for Item Specific Charge 1
CALCODE_11 for Item Specific Charge 2
CALCODE_12 for Item Specific Charge 3

This document assumes that you already have your calcodes defined properly.
Two database tables are used: CATENCALCD and CATGPCALCD
Specific entries need to be made to both tables to setup the above configuration.

1. CALCODES only apply to direct parent categories of the products.
First, make sure that your the entries you make in CATGPCALCD are the direct parent categories of the products you are applying this category filter to.

For instance, if you have the following tree:

You will be able to achieve the setup above by setting up your CATENCALCD and CATGPCALCD as follows:
- Make CATENCALCD entry associating the product (Product_A for instance) to a calcode
- Making an entry in CATGPCALCD for TopCat would NOT cascade to Product_A and Product_B if they are added to cart.

- You will only be able to achieve the proper setup by using the entry in CATENCALCD along with an entry in CATGPCALCD with the proper direct parent category of the product,

So have:
CATENCALCD --> associate Product A to CALCODE_10
CATGPCALCD --> associate subCat_11 to CALCODE_00

2. Apply multiple calcodes associated with different categories to a single product.
You can also have multiple Calcodes applied to a product if it is available under multiple categories.

2.a Single Calcode combined to different categories
For instance, assume the following catalog tree.

If there is only 1 calcode which is combined with both subCat_11 and subCat_21, for Product_B, this calcode will take effect only one time.


For this setup, have
CATGPCALCD --> associate subCat_11 to CALCODE_02
CATGPCALCD --> associate subCat_21 to CALCODE_02

Remember:
CALCODE_02 for Order Cover Charge 3 --> 55.99

After all calculations, the final shipping charge for Product_B will be 55.99.
If you have a specific entry in CATENCALCD for Product_B, that will also be added.

2.b Different Calcodes associated to different categories:
Assume the following tree.

If CALCODE_01 is combined with subCat_11, and CALCODE_02 is combined with subCat_21, for Product_B, both calcodes will take effect for Product_B.

This setup would give you the following table data;
CATGPCALCD --> associate subCat_11 to CALCODE_01
CATGPCALCD --> associate subCat_21 to CALCODE_02

Remember:
CALCODE_01 for Order Cover Charge 2 --> 23.99
CALCODE_02 for Order Cover Charge 3 --> 55.99

After all calculations, the final shipping charge for Product_B will be 23.99+55.99.
If you have a specific entry in CATENCALCD for Product_B, that will also be added.  

Document Information

Current web document: http://www.ibm.com/support/docview.wss?uid=swg21287743