Creating a predefined configuration for a dynamic kit

You can create a predefined configuration for a dynamic kit.

This topic does not apply if you are using the Sterling Configurator integration.

Procedure

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 you want 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.
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 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.
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 you want to use to refer to the component of the predefined configuration

predefinedConfigurationId

Is the predefined configuration ID specified in 1.

componentCatentryId

Is the catalog entry ID of the component.

groupName

Is the header name used to group like components when displayed (for example, "hard drives" 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.
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 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.
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 4.
Create an offer price for each currency you want 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 5.

currency

Is the currency used (for example, USD).

price

Is the price of the predefined configuration (for example, 1499.99).
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 1.

offerId

Is the offer ID specified in 5.