Question

Why is the eCommerce option missing in the Address Register?

Answer

Issue Summary:
The missing eCommerce option in the Address Register is typically due to a configuration issue in the database. This is often linked to the type of license the customer has purchased. If the configuration for the eCommerce adaptor is not correctly set up or if the appropriate license is not applied, the option will not be available in the system.

Verification Script:
To check if the configuration for the eCommerce adaptor exists, run the following SQL query:

sql

-- Sample script to verify GTWY_Type settings
SELECT GTWY_TYPE ,GTWY_ID,* 
FROM BP.BASS_GATEWAY_CONFIG 
WHERE GTWY_TYPE = '31' 
AND REC_DELETED = '0';

GTWY_Type Reference:
GTWY_Type = 1 → Refers to Shipserv Adaptor (used in BASSnet versions before 2.11).

Note: This adaptor may still be in use in newer versions in some environments.

GTWY_Type = 31 → Refers to eCommerce Adaptor (introduced in BASSnet version 2.11 and later).

In some setups, the original GTWY_ID used for Shipserv may not have been updated to reflect the eCommerce adaptor.

Important Note:
If the relevant data exists in the BP.BASS_GATEWAY_CONFIG table with GTWY_TYPE = 31, then the eCommerce option should appear in the Address Register.

The setup is visible in the system, and the configuration can be deleted directly through the UI by end-user with the license of the eCommerce Adaptor only.