Trendyol → Shopify
Turns your Trendyol product export into a Shopify bulk-upload file, column for column.
Excel (.xlsx, .xls) or CSV
Tips
- Download your product list as Excel from Trendyol Seller Center › Products › Product List
- 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 Products › Product List in Trendyol Seller Center. Trendyol is the largest marketplace in Turkey.
- 2 Use "Download as Excel" at the top right; the file arrives as .xlsx.
- 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 CSV file for Shopify.
- 6 Upload the downloaded CSV in Shopify Admin › Products › Import.
- 7 Tick "Overwrite products with matching handles" only when you are updating products that already exist.
- 8 Shopify emails you when the import finishes; failed rows are listed in that report.
What you should know
Reshaping a Trendyol, the largest marketplace in Turkey product list into the Shopify 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 Trendyol, maps every field onto the Shopify 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 UTF-8 CSV and can be handed straight to the Shopify import screen.
What to know about a Trendyol export: Price columns include VAT ("Trendyol sale price" and "market sale price"). Variants are separate rows under the same model code; the colour and size columns are read as options. Images arrive as URLs in the "Image 1-8" columns.
Worked example: a Trendyol file turned into a Shopify file
Our Trendyol sample file (trendyol.xlsx) holds 4 rows and 19 columns. The tool recognized 19 of those columns on its own. No column was left out. The rows were grouped into 2 products with 4 variants, and 4 image URLs were carried over. The Shopify file that downloads has 4 rows and 36 columns; 28 of those columns arrive filled and the rest stay empty because the sample has no data for them.
First row of the output (under Shopify column names)
| Shopify column | Value written |
|---|---|
| Handle | cicekli-yazlik-elbise |
| Title | Çiçekli Yazlık Elbise |
| Body (HTML) | <p>Pamuklu, rahat kesim.</p> |
| Vendor | Nuve |
| Type | Elbise |
| Published | TRUE |
| Option1 Name | Color |
| Option1 Value | Kırmızı |
| Option2 Name | Size |
| Option2 Value | S |
| Variant SKU | ELB-001-KIR-S |
| Variant Grams | 2000 |
| Variant Inventory Tracker | shopify |
| Variant Inventory Qty | 12 |
Notes the tool gave for this file
- In your Shopify admin, upload this CSV from Products > Import.
- The source category was written to Shopify's "Type" field; pick the standard Shopify category after importing.
- Prices were carried over in the source currency, tax included. Check them before importing if your store currency differs.
- Where weight was missing, volumetric weight was converted to grams assuming 1 desi = 1 kg.
Field mapping: Trendyol → Shopify
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ı | Title |
| Model / group code | Model Kodu | Handle |
| SKU | Stok Kodu | Variant SKU |
| Barcode | Barkod | Variant Barcode |
| Sale price | Trendyol'da Satılacak Fiyat (KDV Dahil) | Variant Price |
| List / compare-at price | Piyasa Satış Fiyatı (KDV Dahil) | Variant Compare At Price |
| Stock | Ürün Stok Adedi | Variant Inventory Qty |
| Tax rate | KDV Oranı | — No counterpart in the target; skipped |
| Volumetric weight (desi) | Desi | Variant Grams |
| Weight (grams) | — | Variant Grams Missing in the source; left empty |
| Image columns | Görsel Linki / Görsel 1-8 | Image Src + Image Position |
| Option 1 | Renk | Option1 Name / Value |
| Option 2 | Beden | Option2 Name / Value |
| Description | Ürün Açıklaması | Body (HTML) |
| Brand | Marka | Vendor |
| Category | Kategori | Type |
Frequently asked questions
Which fields does Shopify require?
Handle, Title, Variant Price, Variant SKU or Barcode, Image Src (the URL has to be publicly reachable). 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 Shopify category tree yourself; the tool writes the source category into the "Type" column.
Are prices carried over with or without tax?
The price in the Trendyol file is carried over exactly as it is; Shopify shows the price as you entered it, so decide whether "all prices include tax" fits your market.
Are images transferred too?
Image URLs are carried over and Shopify 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.
Guides
Articles and format references related to this tool.
Related tools
- Shopify → Trendyol Converts your Shopify product export into the Trendyol import template: columns are mapped, barcodes and variants stay intact. Free, no signup.
- Excel / CSV → Shopify Converts your Excel / CSV product export into the Shopify import template: columns are mapped, barcodes and variants stay intact. Free, no signup.
- n11 → Shopify Converts your n11 product export into the Shopify 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.
An independent tool. Not affiliated with Trendyol or Shopify, and not an official product of either.