Content Comparison

INTRODUCTION

In order to make the preparation of the product data more efficient, we provide our partners with the Feedchecker tool from Galaxus. The Feedchecker examine the individual files for structural and content-related correctness. The output of the check is an excel file with suggestions for improvement. In addition to the overview, it is also possible to see on a product basis which attributes still need to be adapted or supplemented.

If any question derives regarding the content, the responsible Portfolio Development Manager is at your disposal. If you have any problems with the tool itself, you can also contact our Product Data Integration Team directly. Please find the according Mail below.

Table of content

Table of Contents

minLevel	2
maxLevel	2
exclude	EINLEITUNG\|pdi@digitecgalaxus.ch

INSTALLATION

Download Feedchecker by clicking on the "Download Feedchecker" button
Extract the zip file into the desired folder (right click and "Extract all") see Screenshot
Start the application by double-clicking on the shortcut with the red tick symbol in the "DG Feedchecker" directory. see Screenshot
Attention! The shortcut must not be moved from the directory. If you want to create your own shortcut, please see the following point.
If you want to create your own shortcut (e.g. on the desktop or on the taskbar), this must be done with the target file "src/Feedchecker.exe" (Ctrl+C on the file, then right-click in the desired target folder and "Insert shortcut"). see Screenshot

Download Feedchecker 💾

Attachmentspatterns*.zip

INSTRUCTIONS

First, the provider type must be determined, depending on the provider type. You can choose between:
1. Marketplace - Merchant in CH
2. Marketplace EU-Hub (CH) - Merchant in CH from EU with CH fiscal representation
3. Marketplace EU-Hub (EU) - Merchant in CH from EU without CH fiscal representation
4. Retail (CH) - Swiss Supplier
5. Retail (Non-CH) - Supplier worldwide
Select file/feed for verification (supported types are CSV or XLSX (Excel))
For CSV files, the separator should also be determined. Possible options are:
1. auto (automatic detection of separator)
2. semicolon (;)
3. comma (,)
4. tabulator (Tab ↹)
5. hyphen (|)
  Note: If the auto option detects the separator incorrectly, it is recommended to directly select the separator used.
Click on "Import Feed". This will import the selected file and the result will be shown in the "Status" field (8). If successful, a preview of the file is displayed in the "Preview" field (9).
1. The "Preview" field shows the first 10 lines from the file that were read in for checking.
You can specify the directory where the feedcheck report can be exported. If nothing is entered, the report will be exported to the same directory as the checked file.
You can select the language of the feedcheck report.
Start Feedcheck by clicking on "Start Feed Checker". A pop-up message informs the user that the check has been completed and the report exported.
Start the image link check by clicking on "Start Image Checker". A pop-up message informs the user that the check has been completed and the report exported.
On the "Status" interface, the user is informed about the progress of the checks. The error messages that prevent the file from being read in for the check are also displayed here (E.g. text parsing issues)

VALIDATION

The following is the list of all validations performed by the Feedchecker.

Note: The "Alias" column contains all alternative column names (case-insensitive) that are recognised in addition to the column names prescribed in this User Guide. If the file has neither the default nor the alternative column names, the file cannot be checked.

Columns	Validation	Alias
FEEDCHECKER EXAMINATION
whole file	Does a row contain more or less columns than the header? Are the values correctly parsed?
headers	Does it contain mandatory columns (depending on provider and feed type)? does it contain duplicates? does it contain empty headers? does it contain line breaks?
ProviderKey	is empty? are there duplicates? is > 100 characters? does it contain characters outside ASCII 32-126? is sorted? (only relevant for SpecificationData variant 1)	productkey, artikelnr, lieferant artikelnr., artikel-nr., lieferant-artikel-nr., artikelnr., lieferanten artikel-nr.
Gtin	is empty? are there duplicates? is valid (length 8, 12, 13, 14)? is check digit correct? is internal? is voucher?	ean-nummer, ean-code, eancode, ean code, barcode, upc, ean nummer, gtin / ean, upc-code, produkt gtin, ean/upc-code, ean-nr., ean, gtin/ean, ean/gtin, eannummer
ManufacturerKey	are there duplicates? is > 4 and < 50 characters?	hersteller nummer, hersteller-nr, hersteller-nummer, herstellernr, herstellernummer, herstellernr., hersteller-nr., hersteller nr.
BrandName	is empty?	marke, brandname
ProductCategory	is empty? is > 200 characters?	kategorie, category, hauptkategorie, kategorisierung, produktkategorie, produkttyp
Weight_g	only for EU hub is empty? is 0? does it contain thousand separators?	weight, bruttogewicht, weightkg, weight_kg, gewicht, weightg
TaresCode	only for EU hub is empty? is valid (formats "12345678" or "1234.5678")	tares
TaricCode	only for EU hub is empty? is 6-11 digits (without spaces)?	taric
CountryOfOrigin	only for EU hub is empty? is 2-digit?	ursprungsland
ProductTitle_de	is empty? is < 100 characters? does it contain the mark at the end?	produktname, productname, produktname deutsch, producttitlede, artikelname, product name, produktname (de), name, producttitle
LongDescription_de	is < 4000 characters?	productdescription, productdescription_de, beschreibung, marketing beschreibung
MainImageUrl	is empty? is < 300 characters? is the URL text valid?	imgeurl, , image_url, bild
ImageUrl_1	is < 300 characters? is the URL text valid?	imageurl_2, imageurl_3, imageurl_4, imageurl_5, imageurl_6, imageurl_7, imageurl_8
VatRatePercentage	only for marketplace and Eu hub with fisc. Representation is empty? is CH (8.1 or 2.6)?	mwst., mwst-satz, vatrate, mwst
PurchasePriceExclVatAndFee	only for Retail is empty? is 0? does it contain thousand separators?	purchasepriceexcludingvatandfee, purchasepriceexcludingfee, purchasepriceexclfee
PurchasePriceExclVat	only for Retail is empty? is 0? does it contain thousand separators?	einkaufspreis (exkl.), purchasepriceexclvat_[currency], purchasepriceexclvat_chf, purchasepriceexclvat_eur, ek, ep netto, ek netto, einkaufspreis, price, ep, purchasepriceexcludingvat, ek chf, preis
SalesPriceExclVat	only for Marketplace and Eu-Hub is empty? is 0? does it contain thousand separators?	vk preis, vk, vk-preis, salespriceexcludingvat, verkaufspreis, salespriceexclvat_[currency], salespriceexclvat_chf, salespriceexclvat_eur
QuantityOnStock	is empty? does it contain thousand separators?	lagerbestand, bestand, stock
RestockDate	is the format valid ("YYYY-MM-DD" or "DD.MM.YYYY")? is it in the past?	deliverydate
RestockTime	is< 365?
MinimumOrderQuantity_dd	is < OrderQuantitySteps? is integer?	mindestbestellmenge (stück), mindestbestellmenge, bestellmengen, minimumorderquantity
MinimumOrderQuantity_wd	is < OrderQuantitySteps? is integer?
OrderQuantitySteps	is empty?	bestellmengenschritt
SpecificationKey	is < 200 characters? does it contain HTML tags?	specificationkey_de
SpecificationValue	is < 200 characters? does it contain HTML tags?	specificationvalue_de
IMAGE CHECKER Examination
MainImageUrl	is the URL text valid? Is the URL valid? Does the URL redirect to another URL? Is the image size < 14 MB Is the larger dimension of the image > 400px?	imgeurl, image_url, bild, bildurl, bild_url
ImageUrl_1	is the URL text valid? Is the URL valid? Does the URL redirect to another URL? Is the image size < 14 MB Is the larger dimension of the image > 400px?	imageurl_2, imageurl_3, imageurl_4, imageurl_5, imageurl_6, imageurl_7, imageurl_8

SUPPORT

If you have technical problems with the Feedchecker, our Product Data Integration Managers will be happy to help. You are welcome to send an email to the email address on the right, which should contain the following information to enable the fastest possible solution: