The purpose of the matching file is to link the item identifiers that a merchant uses for a particular product, with the item identifiers a supplier uses for that same product. Since sometimes these identifiers differ from partner to partner, Logicbroker uses this matching file to source products to the appropriate trading partner/supplier.
If your inventory will be transmitted as EDI to your trading partner, the matching file is used to specify which records from your inventory upload will be transmitted. (All records can be sent by setting up auto-matching)
Matching File Format
The matching file is a simple CSV file that requires only two columns. These columns are the first two columns on the Logicbroker standard feed: SupplierSKU, and MerchantSKU.
(The matching file may also be a CSV file with only two columns, but the column headers must be “SupplierSKU” and “MerchantSKU”)
These two columns should be populated with the supplier’s version of a SKU, along with the merchant’s corresponding version of that SKU.
(Attached is a matching file that may be used as a template for uploads)
Uploading a Matching File
To upload a matching file, make sure the correct partner is selected from the “Select Partner” drop down. Once selected, scroll down to the “Files” section, and press “choose file” for the Matching File option. This will open a prompt to upload a file from your computer. Select the matching file you would like to upload.
Once completed, an event will be created indicating a new matching file was uploaded. The details will show the name of the file you had uploaded.
Matching File upload can also be automated over FTP. For more information regarding this, or inventory management within the Logicbroker portal, please see the following sections: