Hepsiburada → Trendyol
Rewrites your Hepsiburada product file into the Trendyol column layout, and fills the empty category template from your panel directly if you hand it over.
Excel (.xlsx, .xls) or CSV
Tips
- Download your product list as Excel from the Hepsiburada Seller Center under My Products
- Leave no barcode or stock-code cell empty; rows that miss one land in the warning list.
- Category names are not mapped automatically — check the category column in the file you download.
How to use it
- 1 Open the My Products screen in the Hepsiburada Seller Center, a large Turkish marketplace.
- 2 Download the product list as Excel; products with variants are grouped by variant group ID.
- 3 Drop the file on this page; the source format is detected and a mapping preview appears.
- 4 Check the warning list: missing barcodes, empty prices and duplicated variants are collected there.
- 5 Download the XLSX file for Trendyol.
- 6 In Trendyol Seller Center open Products › Bulk Product Operations and download the empty Excel template for your category.
- 7 Hand that empty template to the "Fill your own Trendyol template" section of the result card; the tool writes your products into the identically named columns. Then fill in the category-specific columns it leaves empty (material, gender and so on).
- 8 Upload the template; rejected rows show up in the Trendyol validation report.
What you should know
Reshaping a Hepsiburada, a major Turkish marketplace product list into the Trendyol format by hand costs hours: column names differ, prices switch between tax-inclusive and tax-exclusive, variants are grouped by a different rule, and a barcode’s leading zero disappears the moment a spreadsheet opens the file. This converter reads the file you exported from Hepsiburada, maps every field onto the Trendyol template, and reports the rows you should check before uploading.
The file never leaves your computer: reading, mapping and writing the new file all happen in the browser tab, with no account and no upload. The result downloads as Excel (.xlsx).
What to know about a Hepsiburada export: The merchant stock code is read as the SKU and the barcode column as the EAN. Images arrive in the Image1-5 columns and the first one is treated as the cover. A desi column, the Turkish volumetric weight unit, is carried over as weight information.
Trendyol asks for a separate Excel template per category and those template columns change from time to time. So the tool offers two routes: download a general table that uses Trendyol column names, or hand over the current empty template from your panel and have it filled directly. On the second route columns are recognized by their header names, so their order does not matter; category-specific mandatory attributes stay empty and are listed for you. If the upload fails, write to us and we will fix it.
Worked example: a Hepsiburada file turned into a Trendyol file
Our Hepsiburada sample file (hepsiburada.xlsx) holds 3 rows and 16 columns. The tool recognized 15 of those columns on its own. The other 1 are not product fields the tool carries, so they were left out: "Garanti Süresi". The rows were grouped into 2 products with 3 variants, and 4 image URLs were carried over. The Trendyol file that downloads has 3 rows and 24 columns; 17 of those columns arrive filled and the rest stay empty because the sample has no data for them.
First row of the output (under Trendyol column names)
| Trendyol column | Value written |
|---|---|
| Barkod | 8680002000011 |
| Model Kodu | TSH-1 |
| Marka | Nuve |
| Kategori | Tişört |
| Para Birimi | TRY |
| Ürün Adı | Erkek Basic Tişört |
| Ürün Açıklaması | Yüzde yüz pamuk |
| Piyasa Satış Fiyatı (KDV Dahil) | 249.9 |
| Trendyol'da Satılacak Fiyat (KDV Dahil) | 249.9 |
| Ürün Stok Adedi | 40 |
| Stok Kodu | TSH-1-SIY-L |
| KDV Oranı | 10 |
| Desi | 1 |
| Görsel Linki | https://cdn.example.com/img/tsh-siyah.jpg |
Notes the tool gave for this file
- Trendyol wants a separate Excel template per category. Hand the empty category template from your panel to the template section of the result card and the tool fills it directly; you can also copy the columns from this file into the template by hand.
- Category and brand names must match Trendyol's own names exactly; fix any mismatches in the template.
- Prices were written tax included. Where there was no list price, the sale price was repeated.
Field mapping: Hepsiburada → Trendyol
Which target column each source column is written to. You can fix unmatched fields in the preview before downloading.
| Field | Source column | Target column |
|---|---|---|
| Product name | Ürün Adı | Ürün Adı |
| Model / group code | Varyant Grup ID | Model Kodu |
| SKU | Satıcı Stok Kodu | Stok Kodu |
| Barcode | Barkod | Barkod |
| Sale price | Fiyat | Trendyol'da Satılacak Fiyat (KDV Dahil) |
| List / compare-at price | — | Piyasa Satış Fiyatı (KDV Dahil) Missing in the source; left empty |
| Stock | Stok | Ürün Stok Adedi |
| Tax rate | KDV Oranı | KDV Oranı |
| Volumetric weight (desi) | Desi | Desi |
| Weight (grams) | — | Desi Missing in the source; left empty |
| Image columns | Görsel1-5 | Görsel Linki / Görsel 1-8 |
| Option 1 | Renk | Renk |
| Option 2 | Beden | Beden |
| Description | Ürün Açıklaması | Ürün Açıklaması |
| Brand | Marka | Marka |
| Category | Kategori | Kategori |
Frequently asked questions
Which fields does Trendyol require?
Barcode, Model code, Brand, Category, Product name, Sale price (VAT included), Stock, VAT rate, Image URL. When one of them is empty the row lands in the warning list; fill it in the source file before uploading.
Are category and brand mapped automatically?
The brand is carried over untouched. Category names never match one to one across platforms, so you still have to fit them into the Trendyol category tree yourself; the tool writes the source category into the "Category" column.
Are prices carried over with or without tax?
The price in the Hepsiburada file is carried over exactly as it is; the Trendyol template expects a tax-inclusive price, so fill the tax rate column, which the panel treats as mandatory.
Are images transferred too?
Image URLs are carried over and Trendyol downloads the files from those addresses during import, so every URL has to stay publicly reachable. Marketplace CDN addresses usually stay open; if access is blocked, host the images yourself and update the URLs first.
How many products can I convert at once?
There is no cap. The conversion runs on a background thread, so the page stays responsive even with files of 10,000 to 20,000 rows; the time it takes depends on your machine.
Related tools
- Trendyol → Hepsiburada Converts your Trendyol product export into the Hepsiburada import template: columns are mapped, barcodes and variants stay intact. Free, no signup.
- Excel / CSV → Trendyol Converts your Excel / CSV product export into the Trendyol import template: columns are mapped, barcodes and variants stay intact. Free, no signup.
- Ikas → Trendyol Converts your Ikas product export into the Trendyol import template: columns are mapped, barcodes and variants stay intact. Free, no signup.
- CSV to Excel Converter Convert CSV and TSV files into formatted Excel XLSX spreadsheets. Automatically detects delimiters and encodings while keeping your data private in browser.
- Volumetric Weight Calculator Work out dimensional weight and the billable shipping weight from your box measurements, with a DIM factor of 3000, 4000, 5000 or 6000. Runs in your browser.
- n11 → Trendyol Converts your n11 product export into the Trendyol import template: columns are mapped, barcodes and variants stay intact. Free, no signup.
An independent tool. Not affiliated with Hepsiburada or Trendyol, and not an official product of either.