|
|
Zeile 42: |
Zeile 42: |
| | | |
| | | |
- | Artikel
| + | [[BOB-SBOToWeb-Artikel-Stand-20130725]] |
- | | + | |
- | <PARM>
| + | |
- | <PATH>\\192.168.5.8\SAP\Datentransfer\ShopAbo-Transfer\WebOut\product</PATH>
| + | |
- | <GROUP>VOLL</GROUP>
| + | |
- | <ACTIVE>*YES</ACTIVE>
| + | |
- | <FILENRKOBJ></FILENRKOBJ>
| + | |
- | <FILE>01_{DATE}_{JobTime}_shop3_product.xml</FILE>
| + | |
- | <SQL>
| + | |
- | select
| + | |
- | OITM.ItemCode AS 'sku',
| + | |
- | OITM.SuppCatNum AS 'id',
| + | |
- | OITM.ItemName AS 'name',
| + | |
- | OITM.U_Internet AS 'itemtype',
| + | |
- | -- OITM.PicturName AS 'image',
| + | |
- | OITM.SWeight1 AS 'weight',
| + | |
- | OITM.SHeight1 AS 'hight',
| + | |
- | OITM.SWidth1 AS 'width',
| + | |
- | OITM.SLength1 AS 'length',
| + | |
- | ITM1.Price AS 'price',
| + | |
- | OITM.VatGourpSa AS 'taxcode',
| + | |
- | OITM.ValidFrom AS 'vdate',
| + | |
- | OITM.UpdateDate AS 'mdate',
| + | |
- | -- OITM.QryGroup11 AS 'abo_std',
| + | |
- | -- OITM.QryGroup12 AS 'abo_present',
| + | |
- | -- OITM.QryGroup13 AS 'rechnungsShop',
| + | |
- | -- OITM.QryGroup14 AS 'freundesShop',
| + | |
- | OITM.QryGroup15 AS 'limitedItem',
| + | |
- | -- OITM.QryGroup16 AS 'activeItem',
| + | |
- | isnull(OITM.U_BOB_KurzBesch,'') AS 'sdesc',
| + | |
- | -- isnull(OITM.U_BOB_Shop_Hinweis,'') AS 'info',
| + | |
- | [@SHOP_WARENGRUP].Name AS 'category_id_1',
| + | |
- | [@SHOP_UNTERGRUP].Name AS 'category_id_2',
| + | |
- | OITM.U_SMM_Sh_Verfueg AS 'product_availibility_flag'
| + | |
- | from OITM, ITM1, [@SHOP_WARENGRUP], [@SHOP_UNTERGRUP]
| + | |
- | where OITM.ItemCode = ITM1.ItemCode AND
| + | |
- | OITM.U_Warengrup = [@SHOP_WARENGRUP].code AND
| + | |
- | OITM.U_Untergrup = [@SHOP_UNTERGRUP].code AND
| + | |
- | ITM1.Pricelist = '1' AND
| + | |
- | OITM.U_Internet > '0' and
| + | |
- | OITM.FrozenFor = 'N'
| + | |
- | </SQL>
| + | |
- | <FMT>*XML</FMT>
| + | |
- | <OVERWRITE>*YES</OVERWRITE>
| + | |
- | <XMLROOT>shop3_product</XMLROOT>
| + | |
- | </PARM>
| + | |
| | | |
| =BOB-XMLToSBO Webshopdateien verarbeiten= | | =BOB-XMLToSBO Webshopdateien verarbeiten= |