Skip to main content
Skip table of contents

Excel und JSON Vergleich

Excel Begriff

JSON Begriff

ExtProdID

"EXT_PRODUCT_ID":"4484d3956f267dcdc196e099797f8c55098682c6"

SupplierID

"VENDOR":"317105234"

SupplierName

"VENDOR_NAME":"Mobile Supplier",

SupplierAID

"VENDOR_MAT":"BENTEST-3649144"

ManufacturerID

"MANUFACTCODE":"#Belkin"

ManufacturerName

"MANUFACTNAME":"Belkin"

ManufacturerAID

"MANUFACTMAT":"F8M134EBC01"

DesctiptionShort.de

"DESCRIPTION":[
               {
                  "languageCode":"DE",
                  "description":"Belkin Grip Vue"
               }
            ]

DescriptionLong.de

"LONGTEXT":[
               {
                  "languageCode":"DE",
                  "longtext":"Belkin Grip Vue - Schutzhülle für Mobiltelefon - thermoplastisches \nPolyurethan - klar - für Samsung GALAXY S II\n\nWeitere Informationen:\n\nAllgemein\nFarbe\nKlar\nMaterial\nThermoplastisches Polyurethan\nTragetasche\nTyp\nSchutzhülle\nFunktionen\nKratzfest\nEmpfohlene Verwendung\nFür Mobiltelefon\nInformationen zur Kompatibilität\nEntwickelt für\nSamsung GALAXY S II\nAllgemein\nFarbe\nKlar\nMaterial\nThermoplastisches Polyurethan\nTragetasche\nTyp\nSchutzhülle\nFunktionen\nKratzfest\nEmpfohlene Verwendung\nFür Mobiltelefon\nInformationen zur Kompatibilität\nEntwickelt für\nSamsung GALAXY S II"
               }
            ]

DeliveryTime

LEADTIME:7.0

Keywords.de

"SEARCH_TERM":[
               {
                  "languageCode":"DE",
                  "keyword":"Handheld"
               },
               {
                  "languageCode":"DE",
                  "keyword":"Tasche"
               },
               {
                  "languageCode":"DE",
                  "keyword":"Handy"
               },
               {
                  "languageCode":"DE",
                  "keyword":"Tasche"
               },
               {
                  "languageCode":"DE",
                  "keyword":"Handytasche"
               },
               {
                  "languageCode":"DE",
                  "keyword":"Handytragetasche"
               },
               {
                  "languageCode":"DE",
                  "keyword":"BENTEST"
               }
            ]

BoostingWords

EAN

BuyerAID

"MATNR":"24360105"

Contract

"CONTRACT":"1000000391"

Contract Item

"CONTRACT_ITEM":"001"

Catalog

"CATALOG_NAME":"DE Mobiletelefon"

CoreArticle

nicht gefunden

HazardousGood

"fieldName":"HAZARDOUS_GOOD",
          "fieldValue":"N",
          "languageCode":"EN"

HazardousSubstance

"fieldName":"HAZARDOUS_SUBSTANCE",
  "fieldValue":"N",
  "languageCode":"EN"

ArticleOrderDetails.OrderUnit

"UNIT":"PCE"

ArticleOrderDetails.ContentUnit

CONTENT_UNIT:"PK"

ArticleOrderDetails.NoCuPerOu

"PACKAGING_QTY":100.0

ArticleOrderDetails.PriceQuantity

"PRICE_QUANTITY":1.0

ArticleOrderDetails.QuantityMin

MINORDER_QTY:1

ArticleOrderDetails.QuantityInterval

"LOTSIZE":1

ArticlePriceDetails.ValidStartDate

"PRICE_VALID_FROM":"20141211010000"

ArticlePriceDetails.ValidEndDate

"PRICE_VALID_TO":"20151231010000"

ArticlePriceDetails.ArticlePrice.1.PriceType

ArticlePriceDetails.ArticlePrice.1.PriceAmount

"PRICE":12.61

ArticlePriceDetails.ArticlePrice.1.PriceCurrency

CURRENCY:"EUR",

ArticlePriceDetails.ArticlePrice.1.PriceFactor
ArticlePriceDetails.ArticlePrice.1.LowerBound
ArticlePriceDetails.ArticlePrice.1.PriceAmount

"PRICE_SCALES":[
               {
                  "scaleType":"01",
                  "low":5.0,
                  "price":12.61

Target.ClassificationSystem

"EXT_SCHEMA_TYPE:"ECLASS-5.1.2"

Target.ClassificationID

"EXT_CATEGORY_ID":"24360105"

Beispiel für ein Mime

"ATTACHMENTS":[
               {
                  "fileName":"https://kaffeewiki.de/images/b/bd/Test.jpg",
                  "mimeType":"jpg",
                  "type":"02",
                  "descriptions":[
                     {
                        "languageCode":"EN",
                        "description":"Belkin Grip Vue"
                     }
                  ]
               },

Mime.1.MimeType

"mimeType":"jpg"

Mime.1.MimeSource

"fileName:"https://kaffeewiki.de/images/b/bd/Test.jpg"

Mime.1.MimeDescr

"description:"Belkin Grip Vue"

Mime.1.MimePurpose

"type":"02"     (info: 01 = normal, 02 = thumbnail)

Mime.2.MimeType

"mimeType":"jpg"

Mime.2.MimeSource

"fileName:"https://kaffeewiki.de/images/b/bd/Test.jpg"

Mime.2.MimeDescr

"description:"Belkin Grip Vue"

Mime.2.MimePurpose

"type":"02"     (info: 01 = normal, 02 = thumbnail)

DocField.1.Name
DocField.1.Value
DocField.2.Name
DocField.2.Value

CUSTOMER_FIELDS":[
               {
                  "fieldName":"MAXORDER",
                  "fieldValue":"13332",
                  "languageCode":"EN"
               },

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.