Operators can export and import products (adverts) in the Operator portal by selecting ADVERTS > Search Adverts or Central Product Database. This article focuses on importing and exporting via the Search Adverts page.
How to export products
- In the Operator portal, go to ADVERTS > Search Adverts.
Apply any filters you need, then click Search.
- To export all adverts across all sellers, click Search without applying filters.
- To narrow down the results, select filters such as the seller name, category, created at or updated at timestamps, or more specific filters such as the Ad ID.
Note: The number of rows you can export is limited to 200,000. If the search results include more than 200,000 rows, you will be prompted to refine the search further.
- Select Export Results. The button appears at the bottom of the filter panel, next to Reset Filters and Search. The Exported Spreadsheet File Configuration modal opens.
Configure your export:
- Export products: Choose the file format from the dropdown. The default is Separated by category (xlsx).
- Search for a field: Enter a keyword to find specific fields, or use the checkboxes to select individual columns. You can also select Select all required fields or Select All to include all available fields. Your selections are saved and applied to future exports.
Note: Ad ID, Variant ID, and Errors are always included.
- Select Download. Your export is generated in the platform and downloads automatically when ready.
Tip: Every export is also saved to Reporting > Imports & Exports, so you can return and re-download it at any time.
Importing products
Importing products lets you update the existing products from multiple sellers in bulk. In the Operator portal, go to ADVERTS > Search Adverts > Manage Data > Bulk import.
- Create a CSV or XLSX file with the appropriate columns or bulk export from the Manage Data dropdown in the Search Adverts page. Update the file and re-upload.
- Create or export a spreadsheet of the adverts.
- Admins can bulk upload spreadsheets containing adverts from multiple retailers, but all adverts must already exist in the system and have valid Advert IDs.
To create new adverts, you must log in as the specific retailer and use the Spreadsheet Upload page in the Seller Portal.
Note: The Seller Name column is ignored during import, and adverts cannot be reassigned to a different seller through this process.
- Upload your spreadsheet. Choose your file (CSV or XLSX only), then click Import adverts.
- Check the results. A link to the results page will appear. Click it to confirm that your import was successful.
Related articles