====== TradeItemManagerDirectSql ======

{{:images:sign_warning.png?nolink|}} This job step is obsolete, the [[en:prozessdefinition:jobs:jobsteps:supplier:tradeitemmanager|]] 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.  

{{:images:sign_warning.png?nolink|}}**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.