Neu Amazon Angebote mit Bestand anzeigen

[chx_de]

Im Bereich Artikel kann man sich die aktuellen Amazon Listings anzeigen lassen.
So muss man nicht die SKU kopieren und erst in den Bereich Marktplätze wechseln.

Declare @key1 varchar(50);
SET @key1 = (select cArtNr from tArtikel where kArtikel =@key)

select
   pf_amazon_angebot.cSellerSKU as SKU,
   pf_amazon_angebot.cItemName AS Angebots_Name,
   tplattform.cName AS Market,
   FORMAT(pf_amazon_angebot.fPrice, 'C', 'de-de') AS Preis,
   pf_amazon_angebot.nQuantity AS BestandMFN,
   pf_amazon_angebot_fba.nQuantity AS BestandFBA,
   pf_amazon_angebot_fba.nQtyReserved AS Reserved,
   pf_amazon_angebot_fba.nQtyUnsellable AS Unsellable,
   pf_amazon_angebot_fba.nQtyInboundShipped AS Shipped,
   pf_amazon_angebot_fba.nQtyInboundWorking AS Working,
   pf_amazon_angebot_fba.nQtyReceiving AS Receiving,
   cFulfillmentChannel as AFN_MFN
  
from pf_amazon_angebot
   join tPlattform on pf_amazon_angebot.nPlattform = tPlattform.nPlattform
   left join pf_amazon_angebot_fba on pf_amazon_angebot.cSellerSKU = pf_amazon_angebot_fba.cSellerSKU
   where pf_amazon_angebot.cSellerSKU like @key1 + '%'

 

[Manuel Pietzsch]

Hi,

ein Artikel kann jetzt auf mehrere SKUs laufen, dafür haben wir Mappings. Wenn ich das richtig sehe müsste es so korrekt sein:

SELECT    pf_amazon_angebot.cSellerSKU as SKU,
        pf_amazon_angebot.cItemName AS Angebots_Name,
        tplattform.cName AS Market,
        FORMAT(pf_amazon_angebot.fPrice, 'C', 'de-de') AS Preis,
        ISNULL(pf_amazon_angebot.nQuantity, 0.0) AS BestandMFN,
        ISNULL(pf_amazon_angebot_fba.nQuantity, 0.0) AS BestandFBA,
        ISNULL(pf_amazon_angebot_fba.nQtyReserved, 0.0) AS Reserved,
        ISNULL(pf_amazon_angebot_fba.nQtyUnsellable, 0.0) AS Unsellable,
        ISNULL(pf_amazon_angebot_fba.nQtyInboundShipped, 0.0) AS Shipped,
        ISNULL(pf_amazon_angebot_fba.nQtyInboundWorking, 0.0) AS Working,
        ISNULL(pf_amazon_angebot_fba.nQtyReceiving, 0.0) AS Receiving,
        cFulfillmentChannel AS AFN_MFN
FROM dbo.pf_amazon_angebot
JOIN dbo.pf_amazon_angebot_mapping    ON pf_amazon_angebot.cSellerSKU = pf_amazon_angebot_mapping.cSellerSKU
    AND pf_amazon_angebot.kUser = pf_amazon_angebot_mapping.kUser
JOIN dbo.tPlattform ON pf_amazon_angebot.nPlattform = tPlattform.nPlattform
LEFT JOIN dbo.pf_amazon_angebot_fba on pf_amazon_angebot.cSellerSKU = pf_amazon_angebot_fba.cSellerSKU
WHERE pf_amazon_angebot_mapping.kArtikel = @Key

Gerne mal ausprobieren