eBiss 3

Hilfe & Dokumentation

User Tools

Site Tools


Sidebar

en:howtos:supplierarticlepool:import_update:start

Article import/update

The specific job objects TradeItemManagerFillCache and TradeItemManagerBookCache are used to update any article information.

Update methods

The TradeItemManagerFillCache and the alternate TradeItemManagerDirectSql can populate four different manifestations of the pool and must be set accordingly. These provide the following options:

  1. Items1)
  2. Prices2)
  3. Texts3)
  4. Additional information4)

Depending on the settings made here, a suitable in-house file must be available, and mappings from the in-house format to the eBiss structures TradeItemDocument5), PriceListDocument6),TextDocument7) and AdditionalInfoDocument8) exist to post prices and item data. It is of course also conceivable to fill all or some of the eBiss structures with only one in-house type. Then it needs accordingly less selectors.

Conventional Integration via file

A standard procedure for the update of the article data looks in a supplier system as a rule as follows: The specific job objects TradeItemManagerFillCache and TradeItemManagerBookCache are used. Provided you have a database that supports the stored procedures used by eBiss for this purpose9)See )). Alternatively the slower TradeItemManagerDirectSql10) is used.

Update job

Note: Suitable for all database systems which are supported by eBiss.

Update job with DirectSQL

Note: Only for use with MSSQL as database system.

Integration via database connection and external procedure

Post article data directly from inventory management or from the ERP system. Data from the ERP system can be written directly into the eBiss database using existing views. From here the data can be transferred very quickly (see performance) into the ArticlePool. The corresponding views are:

  • ArticlePool_FillArticleCache_View, for the article data.
  • ArticlePool_FillPriceLineCache_View, for the price data.
  • ArticlePool_FillTextCache_View, for the texts.
  • ArticlePool_FillCustomItemsCache_View, for the article custom items.

Update Job

A corresponding job to transfer the data can look like this:

Here, the respective corresponding External “Fill” procedure must then be defined in the TradeItemManagerFillCache.

Expert Topics

1)
eBiss.Supplier.TradeItemDocument
2) , 6)
eBiss.Supplier.PriceListDocument
3) , 7)
eBiss.Supplier.TextDocument
4) , 8)
eBiss.Supplier.AdditionalInfoDocument
5)
eBiss.Supplier. TradeItemDocument
9)
Usable only for Microsoft SQL Server data base system.
10)
Usable for all eBiss supported data base systems.
en/howtos/supplierarticlepool/import_update/start.txt · Last modified: 2024/02/20 08:15 by 127.0.0.1