Home
Documentation
HCL Commerce is a high-availability, highly scalable and customizable e-commerce platform. Able to support hundreds of thousands of transactions per day, HCL Commerce allows you to do business with consumers (B2C) or directly with businesses (B2B). HCL Commerce uses cloud friendly technology to make deployment and operation both easy and efficient. It provides easy-to-use tools for business users to centrally manage a cross-channel strategy. Business users can create and manage precision marketing campaigns, promotions, catalog, and merchandising across all sales channels. Business users can also use AI enabled content management capabilities.
Tutorials
HCL Commerce provides many tutorials to help you customize and understand your HCL Commerce instance and stores.
Web services
Web services tutorials introduce the various tasks that are related to creating and customizing web services for HCL Commerce applications.
Customizing the Transaction server using REST and JPA services
In this tutorial, you use REST services to create a JPA-based customization on the Transaction server.
Create a custom database table to store Facebook IDs
In this lesson, you create a sample database table to store Facebook IDs.

Documentation
HCL Commerce is a high-availability, highly scalable and customizable e-commerce platform. Able to support hundreds of thousands of transactions per day, HCL Commerce allows you to do business with consumers (B2C) or directly with businesses (B2B). HCL Commerce uses cloud friendly technology to make deployment and operation both easy and efficient. It provides easy-to-use tools for business users to centrally manage a cross-channel strategy. Business users can create and manage precision marketing campaigns, promotions, catalog, and merchandising across all sales channels. Business users can also use AI enabled content management capabilities.
- Getting started
  HCL Commerce has different advantages for business users, administrators and developers. HCL Commerce targets each of these roles with a tailored set of offerings so that each of your users can get maximum benefit.
- Installing and deploying
  Learn how to install and deploy HCL Commerce development environments and HCL Commerce production environments.
- Migrating
  Before you migrate to HCL Commerce Version 9, review this information to help plan and execute your migration.
- Operating
  Topics in the Operating category highlight tasks that are typically performed by business users, customer support representatives, to complete their day-to-day tasks in the operation of the HCL Commerce site.
- Integrating
  Topics in the Integrating category highlight the tasks that are commonly performed for using HCL Commerce in combination with other products.
- Administering
  Topics in the Administering category highlight tasks that are typically performed by the Site Administrator, to support daily operations of the HCL Commerce site.
- Customizing
  The topics in the Customizing section describe tasks performed by an application developer to customize HCL Commerce.
- Tutorials
  HCL Commerce provides many tutorials to help you customize and understand your HCL Commerce instance and stores.
  - Docker start-up logic
    HCL Commerce provides tutorials that are designed to introduce the various tasks that are related to the customizing Docker start-up logic. The following tutorials provide sample guides to defining the custom logic.
  - Programming model
    HCL Commerce provides tutorials that are designed to introduce the various tasks that are related to creating customized code to develop and enhance HCL Commerce applications. The following tutorials provide sample guides to customizing elements of the HCL Commerce programming model.
  - Web services
    Web services tutorials introduce the various tasks that are related to creating and customizing web services for HCL Commerce applications.
    - Customizing the Transaction server using REST and JPA services
      In this tutorial, you use REST services to create a JPA-based customization on the Transaction server.
      - Create a custom database table to store Facebook IDs
        In this lesson, you create a sample database table to store Facebook IDs.
      - Create JPA code to read and write Facebook information
        In this lesson, you write JPA code to access the new database XSOCIALACCOUNT table, and to read from and write to the table.
      - Test your Facebook integration
        In this lesson, you test your JPA code to ensure that you can access and work with Facebook user information.
    - Creating a BOD service module
      In this tutorial, you develop a project service module. The services that are provided by the module are Get and Change. As a part of creating the service module, you design the logical model (a noun) and physical model (a database schema) based on your business requirement.
  - Management Center
    HCL Commerce provides tutorials that are designed to introduce the various tasks that are related to customizing Management Center.
  - Migration
    HCL Commerce provides tutorials that are designed to introduce the various tasks that are related to migration from previous versions of WebSphere Commerce. The following tutorials provide sample guides to migrating your WebSphere Commerce sites to HCL Commerce Version 9.
  - Search
    HCL Commerce provides tutorials that are designed to describe how to customize HCL Commerce Search.
  - Starter stores
    HCL Commerce provides tutorials that are designed to introduce the various tasks that are related to customizing the storefront.
- Samples
  Topics in the Samples category highlight the various samples that are provided with HCL Commerce.
- Compliance
  The following section describes how you can leverage HCL Commerce features and functionality to help your site be compliant with different privacy and security standards.
- Securing
  These topics describe the security features of HCL Commerce and how to configure these features.
- Performance
  Topics in the Performance section describe the means by which to plan, implement, test, and re-visit the optimization of HCL Commerce site performance.
- Troubleshooting
  Topics in the Troubleshooting section highlight common issues that are encountered with HCL Commerce, and how they can be addressed or mitigated.
- Reference
  Topics in the Reference section contain all of the HCL Commerce reference documentation.

Create a custom database table to store Facebook IDs

In this lesson, you create a sample database table to store Facebook IDs.

Procedure

Connect to the development DB2 Docker container and execute the following SQL commands. You will use this command to create a customization table, XSOCIALACCOUNT, which will contain Facebook information for a user.

CREATE TABLE XSOCIALACCOUNT (XSOCIALACCOUNT_ID BIGINT NOT NULL, MEMBER_ID BIGINT NOT NULL, 
STORE_ID INTEGER NOT NULL, FACEBOOK_ID VARCHAR(254), NAME VARCHAR(254), OPTCOUNTER SMALLINT,
PRIMARY KEY (XSOCIALACCOUNT_ID));

INSERT INTO KEYS VALUES (10002,'xsocialaccount','xsocialaccount_id',10000,500,0,2147483647,0,1048576,1);

Where

MEMBER_ID: ID for the member, a unique primary key for this table.
STORE_ID: Generated unique key.
OPTCOUNTER: The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.