Develop > Persistence layer > Data assets > Create catalog assets

Create a predefined configuration for a dynamic kit

Procedure

1. Create a predefined configuration for the dynamic kit in the database. Use an SQL statement similar to this example:

   INSERT INTO DKPREDEFCONF (DKPREDEFCONF_ID, CONFIGURATION_ID, COMPLETE) 
       VALUES (predefinedConfigurationId, configurationId, complete)
   

   Where:

   predefinedConfigurationId

   Is the ID to assign to the predefined configuration.

   configurationId

   Is the ID used by an external configurator to represent this predefined configuration (null if none exists).

   complete

   Is a flag which specifies whether the predefined configuration is a complete dynamic kit, and can be added directly to a shopping cart. If the value is 1, the predefined configuration is complete, and can be added to the cart directly. If the value is 0, it must pass through a configurator.

2. Enter a description for the predefined configuration. Use an SQL statement similar to this example:

   INSERT INTO DKPDCDESC (DKPREDEFCONF_ID, LANGUAGE_ID, NAME, SHORTDESCRIPTION, LONGDESCRIPTION) 
      VALUES (predefinedConfigurationId, languageId, name, shortdesc, longdesc)
   

   Where:

   predefinedConfigurationId

   Is the predefined configuration ID specified in step 1.

   languageId

   Is the ID of the language in which this description is written.

   name

   Is the name of the predefined configuration (for example, "Base Model PC").

   shortdesc

   Is a brief description of the predefined configuration.

   longdesc

   Is a complete description of the predefined configuration.

3. Create the components of the predefined configuration. Use an SQL statement similar to the following for each component:

   INSERT INTO DKPDCCOMPLIST (DKPDCCOMPLIST_ID, DKPREDEFCONF_ID, CATENTRY_ID, GROUPNAME, SEQUENCE, QUANTITY, QTYUNIT_ID) 
       VALUES (componentId,predefinedConfigurationId,componentCatentryId,groupName, sequence,quantity,qtyunit_id)
   

   Where:

   componentId

   Is the ID to use to refer to the component of the predefined configuration

   predefinedConfigurationId

   Is the predefined configuration ID specified in step 1.

   componentCatentryId

   Is the catalog entry ID of the component.

   groupName

   Is the header name used to group like components when displayed (for example, "harddrives" or "accessories").

   sequence

   Is the order in which to display the component, relative to any other components in the predefined configuration.

   quantity

   Is the number of units of the catalog entry in the component.

   qtyunit_id

   Is the ID of the unit of measure in which quantity is measured.

4. Create a relationship between the predefined configuration and the dynamic kit. Use an SQL statement similar to the following example:

   INSERT INTO DKPDCCATENTREL (DKPREDEFCONF_ID, CATENTRY_ID, SEQUENCE)
       VALUES (predefinedConfigurationId, dynamicKitCatentryId, sequence)
   

   Where:

   predefinedConfigurationId

   Is the predefined configuration ID specified in step 1.

   dynamicKitCatentryId

   Is catalog entry ID of the dynamic kit for which this predefined configuration is used.

   sequence

   Is the order in which to display the predefined configuration relative to any other predefined configurations defined for the dynamic kit.

5. Create an offer for the starting price of the predefined configuration. Use an SQL statement similar to the following example:

   INSERT INTO OFFER (OFFER_ID, TRADEPOSCN_ID, CATENTRY_ID, PUBLISHED)
       VALUES(offerId, priceListId, dynamicKitCatentryId, 1)
   

   Where:

   offerId

   Is the offer ID.

   priceListId

   Is the ID of the price list in which this predefined configuration's price is to be stored.

   dynamicKitCatentryId

   Is the catalog entry ID of the dynamic kit used in step 4.

6. Create an offer price for each currency to use in the store. Use an SQL statement similar to the following example:

   INSERT INTO OFFERPRICE (OFFER_ID, CURRENCY, PRICE) 
       VALUES(offerId, currency, price)
   

   Where:

   offerId

   Is the offer ID specified in step 5.

   currency

   Is the currency used (for example, USD).

   price

   Is the price of the predefined configuration (for example, 1499.99).

7. Create a relationship between the predefined configuration and the offer. Use an SQL statement similar to the following example:

   INSERT INTO DKPDCOFFERREL (DKPREDEFCONF_ID, OFFER_ID) 
       VALUES (predefinedConfigurationId, offerId)
   

   Where:

   predefinedConfigurationId

   Is the predefined configuration ID specified in step 1.

   offerId

   Is the offer ID specified in step 5.

Related concepts

Configurable products

Packages and bundles

Catalog entries

Catalog subsystem

Related tasks

Create a master catalog

Changing catalog information

+

Search Tips   |   Advanced Search