7 Feedchecker for Partners


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.


INSTALLATION

  1. Download Feedchecker by clicking on the "Download Feedchecker" button

  2. Extract the zip file into the desired folder (right click and "Extract all") see Screenshot

  3. 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.

  4. 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


INSTRUCTIONS

  1. 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

  2. Select file/feed for verification (supported types are CSV or XLSX (Excel))

  3. 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.

  4. 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.

  5. 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.

  6. You can select the language of the feedcheck report.

  7. 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.

  8. 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.

  9. 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

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:

  • Description of the problem incl. all steps leading to the occurrence of the problem.

  • File that was checked attached

  • Screenshot of the error


VERSION

  • 1.0.3 - Nov 21, 2022

    • Improved structural checks for CSV files

  • 1.0.2 - Aug 1, 2022

    • various improvements on the Image Checker

  • 1.0.1 - May 10, 2022

    • various bugfixes and optimizations

  • 1.0.0 - Mar 16, 2022

 


Â