Inhaltsverzeichnis
TradeItemManagerDirectSql
This job step is obsolete, the TradeItemManager (Supplier) is to be used (From version 3.7.291 (4.11.23))
When using the MS-SQL server, the more performant TradeItemManagerFillCache and TradeItemManagerBookCache job steps can also be used.
| Name | Meaning |
|---|---|
| Type | Type of the job step. |
| Name | Name of the job step that will appear in the job designer |
| Description | Optional description for the job step. |
| BookingBatchSize : | Number of items to be posted at once (performance-dependent). |
| ItemsToBook : | Specifies the type of TradeItems you want to post. |
| OverwriteArticleDetail: | Allows you to override items in the database |
Posting items in the Supplier.ArticlePool
Items are posted as follows in the Supplier.ArticlePool:
- Article is not available in database:
- EAN is avaiable: Article from articlepool is not written to the database → Log entry: Double article.
- Ean is not avaiable: Article from articlepool is created in the database.
- Article is avaiable in the database:
- EAN is equal: Article from articlepool is compared with the field changed from the database, changed fields are stored in the database.
- EAN is not equal: Article from articlepool is not written to the database → Log entry: Double article.
Note: Articles are searched in the database for article number, color, size.
Option OverwriteArticleDetail
By using the OverwriteArticleDetail option, you can override an article in the database. This results in the following constellations:
- Article is not available in database:
- EAN is avaiable: Record to the ean is deleted in database, afterwards a new record is created for the article from the article catalog and stored in the database.
- Ean is not avaiable: Article from article catalog is created again in the database.
- Artikel is avaiable in the database:
- EAN is equal: Article from article catalog is compared with the field changed from the database, updated fields are updated in the database.
- EAN is not equal: Finding a record with Ean and deleting it from the database, create and save a new record for articles from the article catalog in the database.