Editing Product Matching
If marketplace listings did not automatically connect to your inventory items, you can manually set up the connections in two ways:
-
Row by row — directly in the product list or in the parameter card.
-
In bulk — by uploading a list of connections via an Excel file (XLS).
Important: After making any changes, be sure to click the «Save» button. Once the data is saved, problematic «yellow rows» in the list will turn white, and the name of the linked product will appear next to the marketplace listing.
Method 1. Item-by-item product linking
- You can link products directly from the table or by accessing the product card properties.
Option A (Direct from the list):
- Go to the Products tab and find the desired row.
- Click on the Accounting Product column by the name or the Not Found label.
- In the field that appears, select the search mode (by name, code, or SKU) and enter the value.
- Choose the appropriate product from the dropdown list and click the Save button.
Option B (Through product card properties):
- Click on the product row to open the card parameters.
- Click Search Product, select the criterion (name, code, or SKU), and find the desired position.
- Select the product from the list and click the binding button — the linking row will update.
- Click the general Save button.
Method 2. Bulk Upload via Excel (XLS)
- Convenient for linking multiple SKUs. Go to the Products tab and follow these 5 simple steps:
- Download the template: Click the green button to download the XLS file.
- Clear old data: Click the red button to remove current temporary links in the form before uploading a new file.
- Fill in the file: Open the downloaded Excel file. Do not change or delete the first (header) row! Fill in the empty rows with data and save the file.
- Upload the file: Click the gray button and select your saved XLS file. Product rows will appear on the screen.
- Save the result: Click the blue button “Save” to fix the new links.
Important rule: Under no circumstances should you change, delete, or move the first (header) row of the template table. It contains technical column names. If you change it, the system will not recognize the file structure, and the matching will not load.
Which template to use?
The file format depends on your marketplace:
-
Basic template (For Ozon, Yandex.Market, Megamarket, Lemanapro, Hoff)
In the first row, in order, the columns should be:- SKU/product name on the marketplace.
- Code or SKU of the product in the accounting system.
-
Advanced template (For Wildberries, Avito, AliExpress)
In the first row, in order, the columns should be:
- Code or SKU of the product in the accounting system.
- Product ID/nomenclature ID on the marketplace.
- Size code on the marketplace.