To define additional business channels, create an insert statement in the BUSCHN and BUSCHNDESC tables. For example, to track the number of items sold from a particular trade show, you can create a new business channel called "Trade Show". The following two insert statements define the new business channel that can then be applied to an order and tracked.
- Use the following insert statement for BUSCHN:
Define the following: (BUSCHN_ID, NAME, STATE) to be: (6, 'Trade Show', 'E')
- Use the following insert statement for BUSCHNDESC:
Define the following: (BUSCHNDESC_ID, LANGUAGE_ID, DESCRIPTION, DISPLAYNAME) to be: (6, -1, 'Order taken at a trade show', 'Trade Show')
This procedure will generate an additional menu item named Trade Show that can be selected when an order is submitted.
- In BUSCHN, BUSCHN_ID is a unique key that identifies the business channel.
The NAME is a set of characters that identify the name of the business channel.
The STATE of 'E' indicates that the business channel should be Enabled.
- For BUSCHNDESC, the BUSCHN_ID is a unique key that identifies the business channel. It must be exactly the same as the ID used in the BUSCHN insert statement.
The LANGUAGE_ID of -1 is maps to English. The Language table lists the full language mappings.
The DESCRIPTION is a description of the business channel that is being added.
The DISPLAYNAME is the name that will be displayed in the Multichannel Sales Center business channel menu.