1. Home
  2. /
  3. User Guides
  4. /
  5. NetStore Backoffice and Administration
  6. /
  7. NetStore backoffice tasks
  8. /
  9. Publishing item information
  10. /
  11. Define and generate an...

Define and generate an item search database

Related topics

Item search databases are essentially an easy way of limiting the amount of information you want to be available for searching on your site.

IBS NetStore provides the following two ways to expose your products:

  • Item catalogues
  • Product search facility

Your company may choose to use both methods, or only one of the above.

With the Product search facility you can choose from one of the following:

  • Expose all products in the IBS Enterprise Item file, meaning all products will be available for searching.
    Note: The Default database definition has already been configured (see paragraph Default).
  • Create Item search database(s).

As you could have thousands of items registered in the IBS Enterprise Item file, it is more than likely that not everything is suitable for browsing (selling) on the Internet.

The creation of Item search databases lets you extract the information most relevant from the Item file.

IBS NetStore provides the following two preloaded Item search databases:

  • Default – This database references the following two Data restrictions:
    • Item restriction = DEFAULT which does not include any delete-marked or fictitious items.
    • Language restriction = DEFAULT which only includes the English and Swedish languages.
  • All – This database does not include any item restriction, but does include the same language restriction as mentioned above.

The creation of an Item search database is a several step process which is described here.

  1. You first create the database definition, where you point to any applicable data restrictions, (ultimately defining the selection criteria for the database, i.e., include/exclude the items applicable and applicable languages).
  2. You then generate the database (as a batch run or interactively), in the applicable languages desired (assuming the languages are supported and have been configured; see About setting up and managing your site). If the foreign descriptions have been entered for the items in the Item file, visitors and/or NetStore users will be able to search for the items in the applicable language.
  3. You can then connect the database on Application level, which will be the default database, (thereby allowing all visitors to your site access, via searching), to only those items available in the database.
  4. If you want to offer your NetStore users special search database versions, you can create and generate these databases and then connect them to the applicable User/User group.

Creating an item search database

  1. Click Item search database definition.
  2. Click New.
  3. You access the New item search database definition window:

    4. Panel image

    Complete the following information:

    Code
    Description
    Item restriction
    Select the applicable item restriction from the drop down list.
    Language restriction
    Select the applicable language restriction from the drop down list.

    The remaining fields are updated during the generation process. Click OK.

Generating/Synchronising the database

You can generate and/or synchronise a new/existing database. The synchronisation process allows any changes that have taken place in the IBS Enterprise Item file to be updated in an existing generated database. To generate/synchronise an item search database, do as follows:

  1. Click Item search database update.
  2. You access the Item search database generation window:

    3. Panel image

    Item search database
    Select the applicable item search database definition from the drop down list.
    Submit to batch
    Check this box if you want to submit the job in a batch run.

    Toggle the different functions by clicking the applicable button:

    • Generate to generate a new database.
    • Synchronization to update any changes from the Item file to an already existing item search database. If there is nothing to synchronise, you will receive a message.

You will receive a confirmation message on the bottom of the window after completion. One record will be created for each applicable item/language, which you can view by clicking Item search database.

Connect on Application level

  1. Click Application.
  2. Click the Settings button.
  3. Click the Edit button for the ItemSearchDatabase.
  4. On the Edit setting window, enter the applicable Item search database definition in the Value field and click OK.

Connect to a User group and/or User

The procedure is the same for User Group and User. The only difference is the access in.

  1. Click User Group or User.
  2. Click the Edit button for the applicable User group or User.
  3. Click the Settings button.
  4. On the Settings window, click New.
  5. On the New setting window, select the applicable preloaded setting type for catalogues (i.e. ItemSearchDatabase). Click OK.
  6. On the Edit setting window, enter the applicable value (i.e. the name of the Item search database) and click OK.

When the NetStore user runs a Product search, he/she will only retrieve a list of the applicable items.

Exit the routine.

Related topics