Aşağıdaki sql sorgusunu NebimV3Master veritabanında çalıştırın.
[php]USE NebimV3Master
GO
DECLARE @ReportFileName Char200 = SPACE(0)
DECLARE @IsDefault bit = 0
SELECT @ReportFileName = ReportFileName , @IsDefault = IsDefault FROM bsReportQuery WHERE ReportName = N'V3Integrator' AND QueryName = N'ASF_URUNFIYAT'
DELETE bsReportQuery WHERE ReportName = N'V3Integrator' AND QueryName = N'ASF_URUNFIYAT'
INSERT INTO bsReportQuery (ReportName, DefaultFilterCols, ParameteredFields, NotBeFilteredFields , IsPivotAvailable, IsDefault , ReportFileName , QueryName, QueryText)
SELECT ReportName = N'V3Integrator'
, DefaultFilterCols = N''
, ParameteredFields = N''
, NotBeFilteredFields = N''
, IsPivotAvailable = N'0'
, IsDefault = @IsDefault
, ReportFileName = N''
, QueryName = N'ASF_URUNFIYAT'
, QueryText =
N'
SELECT * FROM ASF_URUNFIYAT(''TR'',''EAN13'',999999)
'
GO [/php]
[size=small][font=Raleway, verdana, geneva, lucida,]Aşağıdaki sql sorgusunu şirket veritabanında çalıştırın[/font][/size]
[php]IF OBJECT_ID('ASF_URUNFIYAT') IS NOT NULL DROP FUNCTION ASF_URUNFIYAT
GO
CREATE FUNCTION ASF_URUNFIYAT (@LangCode Char5,@BarcodeTypeCode Char20,@PriceGroupCode Char20, @LastNHour int )
RETURNS TABLE
AS RETURN
(
SELECT Product.*
, ColorCode = prItemVariant.ColorCode
, ColorDescription = cdColorDesc.ColorDescription
, ItemDim1Code = prItemVariant.ItemDim1Code
, ItemDim2Code = prItemVariant.ItemDim2Code
, ItemDim3Code = prItemVariant.ItemDim3Code
, VatRate = ISNULL((SELECT VatRate FROM cdVat WITH(NOLOCK)
WHERE cdVat.VatCode = Product.ItemTaxGrCode),SPACE(0))
, Price1 = ISNULL((SELECT TOP 1 Price FROM ProductValidPrices(GETDATE(), GETDATE()) LastPrice
WHERE LastPrice.PaymentPlanCode=''
AND ItemTypeCode=Product.ProductTypeCode
AND ItemCode=Product.ProductCode
ORDER BY PriceListDate), SPACE(0))
, Price2 = ISNULL((SELECT TOP 1 Price FROM ProductValidPrices(GETDATE(), GETDATE()) LastPrice
WHERE LastPrice.PaymentPlanCode='001'
AND ItemTypeCode=Product.ProductTypeCode
AND ItemCode=Product.ProductCode
ORDER BY PriceListDate), SPACE(0))
, Warehouse1InventoryQty = ISNULL((SELECT SUM(AvailableInventoryQty1) FROM ItemInventory AS Warehouse1Inv WITH(NOLOCK)
WHERE
Warehouse1Inv.ItemTypeCode = prItemVariant.ItemTypeCode
AND Warehouse1Inv.ItemCode = prItemVariant.ItemCode
AND Warehouse1Inv.ColorCode = prItemVariant.ColorCode
AND Warehouse1Inv.ItemDim1Code = prItemVariant.ItemDim1Code
AND Warehouse1Inv.ItemDim2Code = prItemVariant.ItemDim2Code
AND Warehouse1Inv.ItemDim3Code = prItemVariant.ItemDim3Code) ,0)
, AttributeType01 = ISNULL((SELECT AttributeTypeDescription FROM ItemAttributeType(@LangCode) where ItemTypeCode = 1 AND AttributeTypeCode = 1 ), SPACE(0))
, AttributeType02 = ISNULL((SELECT AttributeTypeDescription FROM ItemAttributeType(@LangCode) where ItemTypeCode = 1 AND AttributeTypeCode = 2 ), SPACE(0))
, AttributeType03 = ISNULL((SELECT AttributeTypeDescription FROM ItemAttributeType(@LangCode) where ItemTypeCode = 1 AND AttributeTypeCode = 3 ), SPACE(0))
, AttributeType04 = ISNULL((SELECT AttributeTypeDescription FROM ItemAttributeType(@LangCode) where ItemTypeCode = 1 AND AttributeTypeCode = 4 ), SPACE(0))
, AttributeType05 = ISNULL((SELECT AttributeTypeDescription FROM ItemAttributeType(@LangCode) where ItemTypeCode = 1 AND AttributeTypeCode = 5 ), SPACE(0))
, AttributeType06 = ISNULL((SELECT AttributeTypeDescription FROM ItemAttributeType(@LangCode) where ItemTypeCode = 1 AND AttributeTypeCode = 6 ), SPACE(0))
, AttributeType07 = ISNULL((SELECT AttributeTypeDescription FROM ItemAttributeType(@LangCode) where ItemTypeCode = 1 AND AttributeTypeCode = 7 ), SPACE(0))
, AttributeType08 = ISNULL((SELECT AttributeTypeDescription FROM ItemAttributeType(@LangCode) where ItemTypeCode = 1 AND AttributeTypeCode = 8 ), SPACE(0))
, AttributeType09 = ISNULL((SELECT AttributeTypeDescription FROM ItemAttributeType(@LangCode) where ItemTypeCode = 1 AND AttributeTypeCode = 9 ), SPACE(0))
, AttributeType10 = ISNULL((SELECT AttributeTypeDescription FROM ItemAttributeType(@LangCode) where ItemTypeCode = 1 AND AttributeTypeCode = 10), SPACE(0))
, AttributeType11 = ISNULL((SELECT AttributeTypeDescription FROM ItemAttributeType(@LangCode) where ItemTypeCode = 1 AND AttributeTypeCode = 11), SPACE(0))
, AttributeType12 = ISNULL((SELECT AttributeTypeDescription FROM ItemAttributeType(@LangCode) where ItemTypeCode = 1 AND AttributeTypeCode = 12), SPACE(0))
, AttributeType13 = ISNULL((SELECT AttributeTypeDescription FROM ItemAttributeType(@LangCode) where ItemTypeCode = 1 AND AttributeTypeCode = 13), SPACE(0))
, AttributeType14 = ISNULL((SELECT AttributeTypeDescription FROM ItemAttributeType(@LangCode) where ItemTypeCode = 1 AND AttributeTypeCode = 14), SPACE(0))
, AttributeType15 = ISNULL((SELECT AttributeTypeDescription FROM ItemAttributeType(@LangCode) where ItemTypeCode = 1 AND AttributeTypeCode = 15), SPACE(0))
, AttributeType16 = ISNULL((SELECT AttributeTypeDescription FROM ItemAttributeType(@LangCode) where ItemTypeCode = 1 AND AttributeTypeCode = 16), SPACE(0))
, AttributeType17 = ISNULL((SELECT AttributeTypeDescription FROM ItemAttributeType(@LangCode) where ItemTypeCode = 1 AND AttributeTypeCode = 17), SPACE(0))
, AttributeType18 = ISNULL((SELECT AttributeTypeDescription FROM ItemAttributeType(@LangCode) where ItemTypeCode = 1 AND AttributeTypeCode = 18), SPACE(0))
, AttributeType19 = ISNULL((SELECT AttributeTypeDescription FROM ItemAttributeType(@LangCode) where ItemTypeCode = 1 AND AttributeTypeCode = 19), SPACE(0))
, AttributeType20 = ISNULL((SELECT AttributeTypeDescription FROM ItemAttributeType(@LangCode) where ItemTypeCode = 1 AND AttributeTypeCode = 20), SPACE(0))
--, ProductHierarchyLevel01Desc = ISNULL((SELECT ProductHierarchyLevel01Desc FROM dfProductHierarchyLevelNames where LangCode = @LangCode), SPACE(0))
--, ProductHierarchyLevel02Desc = ISNULL((SELECT ProductHierarchyLevel02Desc FROM dfProductHierarchyLevelNames where LangCode = @LangCode), SPACE(0))
--, ProductHierarchyLevel03Desc = ISNULL((SELECT ProductHierarchyLevel03Desc FROM dfProductHierarchyLevelNames where LangCode = @LangCode), SPACE(0))
--, ProductHierarchyLevel04Desc = ISNULL((SELECT ProductHierarchyLevel04Desc FROM dfProductHierarchyLevelNames where LangCode = @LangCode), SPACE(0))
--, ProductHierarchyLevel05Desc = ISNULL((SELECT ProductHierarchyLevel05Desc FROM dfProductHierarchyLevelNames where LangCode = @LangCode), SPACE(0))
--, ProductHierarchyLevel06Desc = ISNULL((SELECT ProductHierarchyLevel06Desc FROM dfProductHierarchyLevelNames where LangCode = @LangCode), SPACE(0))
--, ProductHierarchyLevel07Desc = ISNULL((SELECT ProductHierarchyLevel07Desc FROM dfProductHierarchyLevelNames where LangCode = @LangCode), SPACE(0))
--, ProductHierarchyLevel08Desc = ISNULL((SELECT ProductHierarchyLevel08Desc FROM dfProductHierarchyLevelNames where LangCode = @LangCode), SPACE(0))
--, ProductHierarchyLevel09Desc = ISNULL((SELECT ProductHierarchyLevel09Desc FROM dfProductHierarchyLevelNames where LangCode = @LangCode), SPACE(0))
--, ProductHierarchyLevel10Desc = ISNULL((SELECT ProductHierarchyLevel10Desc FROM dfProductHierarchyLevelNames where LangCode = @LangCode), SPACE(0))
, ItemPhotoPath = ISNULL((SELECT FolderPath FROM dfGlobalFolder WHERE GlobalDefaultCode = 1 AND FolderCode = N'ProductPhotoPath'),SPACE(0))
, Barcode = ISNULL((SELECT MAX(Barcode) FROM prItemBarcode WITH(NOLOCK)
WHERE prItemBarcode.BarcodeTypeCode = @BarcodeTypeCode
AND prItemBarcode.ItemTypeCode = prItemVariant.ItemTypeCode
AND prItemBarcode.ItemCode = prItemVariant.ItemCode
AND prItemBarcode.ColorCode = prItemVariant.ColorCode AND prItemBarcode.ItemDim1Code = prItemVariant.ItemDim1Code
AND prItemBarcode.ItemDim2Code = prItemVariant.ItemDim2Code AND prItemBarcode.ItemDim3Code = prItemVariant.ItemDim3Code) , SPACE(0))
, ItemDim1SortOrder = cdItemDim1.SortOrder
, ItemDim2SortOrder = cdItemDim2.SortOrder
, ItemDim3SortOrder = cdItemDim3.SortOrder
FROM ProductFilterWithDescription ('TR') AS Product
INNER JOIN prItemVariant WITH(NOLOCK)
ON prItemVariant.ItemCode = Product.ProductCode
AND prItemVariant.ItemTypeCode = Product.ProductTypeCode
INNER JOIN cdItemDim1 WITH(NOLOCK)
ON cdItemDim1.ItemDim1Code = prItemVariant.ItemDim1Code
INNER JOIN cdItemDim2 WITH(NOLOCK)
ON cdItemDim2.ItemDim2Code = prItemVariant.ItemDim2Code
INNER JOIN cdItemDim3 WITH(NOLOCK)
ON cdItemDim3.ItemDim3Code = prItemVariant.ItemDim3Code
INNER JOIN cdItem WITH(NOLOCK)
ON cdItem.ItemCode = Product.ProductCode
AND cdItem.ItemTypeCode = Product.ProductTypeCode
LEFT JOIN (
SELECT ItemCode,ItemTypeCode,ColorCode,ItemDim1Code,ItemDim2Code,ItemDim3Code,
SUM(AvailableInventoryQty1) AvailableInventory
FROM ItemInventory WITH (NOLOCK)
GROUP BY ItemCode,ItemTypeCode,ColorCode,ItemDim1Code,ItemDim2Code,ItemDim3Code
) AS WarehouseInv ON WarehouseInv.ItemTypeCode = prItemVariant.ItemTypeCode
AND WarehouseInv.ItemCode = prItemVariant.ItemCode
AND WarehouseInv.ColorCode = prItemVariant.ColorCode
AND WarehouseInv.ItemDim1Code = prItemVariant.ItemDim1Code
AND WarehouseInv.ItemDim2Code = prItemVariant.ItemDim2Code
AND WarehouseInv.ItemDim3Code = prItemVariant.ItemDim3Code
LEFT OUTER JOIN cdItemDesc WITH (NOLOCK) ON cdItemDesc.ItemTypeCode=Product.ProductTypeCode
AND cdItemDesc.ItemCode=Product.ProductCode
AND cdItemDesc.LangCode=@LangCode
LEFT OUTER JOIN cdColorDesc WITH (NOLOCK) ON cdColorDesc.ColorCode=prItemVariant.ColorCode
AND cdColorDesc.LangCode=@LangCode
WHERE Product.IsBlocked = 0
AND Product.UseInternet= 1
AND cdItem.IsBlocked = 0
AND Product.ProductTypeCode=1
AND (EXISTS (SELECT * FROM trStock WITH(NOLOCK)
WHERE trStock.ItemTypeCode = prItemVariant.ItemTypeCode
AND trStock.ItemCode = prItemVariant.ItemCode
AND trStock.ColorCode = prItemVariant.ColorCode
AND trStock.ItemDim1Code = prItemVariant.ItemDim1Code
AND trStock.ItemDim2Code = prItemVariant.ItemDim2Code
AND trStock.OperationDate BETWEEN DATEADD(HOUR , -1 * @LastNHour, GETDATE() ) AND GETDATE() )
OR (cdItem.LastUpdatedDate BETWEEN DATEADD(HOUR , -1 * @LastNHour, GETDATE() ) AND GETDATE() )
OR (cdItemDesc.LastUpdatedDate BETWEEN DATEADD(HOUR , -1 * @LastNHour, GETDATE() ) AND GETDATE())
OR (prItemVariant.LastUpdatedDate BETWEEN DATEADD(HOUR , -1 * @LastNHour, GETDATE() ) AND GETDATE())
)
)
GO [/php]
[size=small][font=Raleway, verdana, geneva, lucida,][size=small][font=Raleway, verdana, geneva, lucida,]Zip içerisinde bulunan dosyaları e-ticaret sitenizin ana dizininde entegrasyon adında bir klasöre upload ediniz. [/font][/size][/font][/size]
[size=small][font=Raleway, verdana, geneva, lucida,][size=small][font=Raleway, verdana, geneva, lucida,]functions.php dosyasındaki[/font][/size][/font][/size]
[php]$ip ='SERVER İPSİ';
$user_name ='NEBİM KULLANICISI';
$user_gruop ='KULLANICI GRUBU';
$password ='PAROLA';
$database ='V3_VERİTABANI';[/php]
[size=small][font=Raleway, verdana, geneva, lucida,][size=small][font=Raleway, verdana, geneva, lucida,]Alanlarını kendinize göre giriş yapıp kaydedin.[/font][/size][/font][/size]
[size=small][font=Raleway, verdana, geneva, lucida,][size=small][font=Raleway, verdana, geneva, lucida,]calistir.php içindeki
[/font][/size][/font][/size]
[php]$db = new ezSQL_mysql("USER","PASSWORD","DB","localhost");[/php]
[size=small][font=Raleway, verdana, geneva, lucida,][size=small][font=Raleway, verdana, geneva, lucida,]Alanına Opencart veritabanı bilgilerinizi girip kaydedin.[/font][/size][/font][/size]
[size=small][font=Raleway, verdana, geneva, lucida,][size=small][font=Raleway, verdana, geneva, lucida,]*Opencart MySQL veritabanında product_option_value tablosuna varchar 255 olarak stokID kolonunu en son kolon olacak şekilde ekleyin.[/font][/size][/font][/size]
[size=small][font=Raleway, verdana, geneva, lucida,][size=small][font=Raleway, verdana, geneva, lucida,]Tek Yönlü entegrasyondur. Sadece ürün / stok / barkod günceller siparişleri Nebim V3 3 göndermez.[/font][/size][/font][/size]
[size=small][font=Raleway, verdana, geneva, lucida,][size=small][font=Raleway, verdana, geneva, lucida,]Stoğunuzda tüm internete açık ürünleri opencarta atar. Bir kaç düzenleme ile isterseniz güncelleme işlemini parça parça yaptırabilirsiniz.[/font][/size][/font][/size]
[size=small][font=Raleway, verdana, geneva, lucida,][size=small][font=Raleway, verdana, geneva, lucida,]*Yukarıdaki fonksiyon satış fiyat listesinden ürünleri çeker. İsterseniz basit bir editleme ile temel fiyatlarla çalışmasını sağlayabilirsiniz.
[/font][/size][/font][/size]
[size=small][font=Raleway, verdana, geneva, lucida,][size=small][font=Raleway, verdana, geneva, lucida,]Not: " Warning: Invalid argument supplied for foreach() in " hatasını oc_product tablonuzda bulunan bir özelleştirmeden dolayı veya extra bir field varsa alırsınız. Insert sorgularınızdaki alanları kendi sitenize göre düzenlemeniz gerekmektedir.[/font][/size][/font][/size]
[size=small][font=Raleway, verdana, geneva, lucida,][size=small][font=Raleway, verdana, geneva, lucida,][Bağlantıyı görmek için giriş yapın]
Dosya: [Bağlantıyı görmek için giriş yapın]
[/font][/size][/font][/size]
