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.
Table of content
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
INSTRUCTIONS
First, the provider type must be determined, depending on the provider type. You can choose between:
Marketplace - Merchant in CH
Marketplace EU-Hub (CH) - Merchant in CH from EU with CH fiscal representation
Marketplace EU-Hub (EU) - Merchant in CH from EU without CH fiscal representation
Retail (CH) - Swiss Supplier
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:
auto (automatic detection of separator)
semicolon (;)
comma (,)
tabulator (Tab ↹)
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).
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 |
|
|
headers |
|
|
ProviderKey |
| productkey, artikelnr, lieferant artikelnr., artikel-nr., lieferant-artikel-nr., artikelnr., lieferanten artikel-nr. |
Gtin |
| 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 |
| hersteller nummer, hersteller-nr, hersteller-nummer, herstellernr, herstellernummer, herstellernr., hersteller-nr., hersteller nr. |
BrandName |
| marke, brandname |
ProductCategory |
| kategorie, category, hauptkategorie, kategorisierung, produktkategorie, produkttyp |
Weight_g | only for EU hub
| weight, bruttogewicht, weightkg, weight_kg, gewicht, weightg |
TaresCode | only for EU hub
| tares |
TaricCode | only for EU hub
| taric |
CountryOfOrigin | only for EU hub
| ursprungsland |
ProductTitle_de |
| produktname, productname, produktname deutsch, producttitlede, artikelname, product name, produktname (de), name, producttitle |
LongDescription_de |
| productdescription, productdescription_de, beschreibung, marketing beschreibung |
MainImageUrl |
| imgeurl, , image_url, bild |
ImageUrl_1 |
| imageurl_2, imageurl_3, imageurl_4, imageurl_5, imageurl_6, imageurl_7, imageurl_8 |
VatRatePercentage | only for marketplace and Eu hub with fisc. Representation
| mwst., mwst-satz, vatrate, mwst |
PurchasePriceExclVatAndFee | only for Retail
| purchasepriceexcludingvatandfee, purchasepriceexcludingfee, purchasepriceexclfee |
PurchasePriceExclVat | only for Retail
| 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
| vk preis, vk, vk-preis, salespriceexcludingvat, verkaufspreis, salespriceexclvat_[currency], salespriceexclvat_chf, salespriceexclvat_eur |
QuantityOnStock |
| lagerbestand, bestand, stock |
RestockDate |
| deliverydate |
RestockTime |
|
|
MinimumOrderQuantity_dd |
| mindestbestellmenge (stück), mindestbestellmenge, bestellmengen, minimumorderquantity |
MinimumOrderQuantity_wd |
|
|
OrderQuantitySteps |
| bestellmengenschritt |
SpecificationKey |
| specificationkey_de |
SpecificationValue |
| specificationvalue_de |
IMAGE CHECKER Examination | ||
MainImageUrl |
| imgeurl, image_url, bild, bildurl, bild_url |
ImageUrl_1 |
| 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