Skip to content
AREM Labs

EN TR

Shopify → n11

Rewrites your Shopify product file into the n11 column layout, and fills the empty category template from your panel directly if you hand it over.

1Drop your file here

Excel (.xlsx, .xls) or CSV

Tips

  • Shopify Admin › Products › Export, then pick "Plain CSV file"
  • 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. 1 In Shopify Admin open the Products page and click Export.
  2. 2 Choose "All products" and "Plain CSV file", then download.
  3. 3 Drop the file on this page; the source format is detected and a mapping preview appears.
  4. 4 Check the warning list: missing barcodes, empty prices and duplicated variants are collected there.
  5. 5 Download the XLSX file for n11.
  6. 6 In the n11 store panel open Products › Bulk Product Upload and download the category Excel template.
  7. 7 Hand that empty template to the "Fill your own n11 template" section of the result card; the tool writes your products into its columns. Then fill in the category code and mandatory attributes from the n11 list.
  8. 8 Upload the template; failed rows are listed in the panel.

What you should know

Reshaping a Shopify product list into the n11 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 Shopify, maps every field onto the n11 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 Shopify export: Every variant is its own row; Handle ties the rows of one product together. Extra images arrive on rows with an empty title through Image Src; the tool attaches them to the right product. Body (HTML) carries markup, which is stripped when the target expects plain text.

n11 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 n11 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 Shopify file turned into a n11 file

Our Shopify sample file (shopify.csv) holds 4 rows and 36 columns. The tool recognized 17 of those columns on its own. The other 19 are not product fields the tool carries, so they were left out: "Type", "Published", "Option1 Name", "Option2 Name", "Option3 Name", "Variant Inventory Tracker", "Variant Inventory Policy", "Variant Fulfillment Service" …. The rows were grouped into 2 products with 3 variants, and 4 image URLs were carried over. The n11 file that downloads has 3 rows and 22 columns; 15 of those columns arrive filled and the rest stay empty because the sample has no data for them. Going from 4 rows to 3 is not an error: Shopify and n11 write a product with variants using a different number of rows.

First row of the output (under n11 column names)

n11 columnValue written
Ürün Adı Linen Shirt
Ürün Açıklaması <p>Summer linen, <b>relaxed</b> fit</p>
Kategori Shirts
Marka Nuve
Stok Kodu LIN-BEJ-M
Barkod 8680004000011
Grup Kodu linen-shirt
Fiyat 49.9
Liste Fiyatı 59.9
Stok Miktarı 7
Resim 1 https://cdn.example.com/img/linen-1.jpg
Resim 2 https://cdn.example.com/img/linen-2.jpg
Resim 3 https://cdn.example.com/img/linen-3.jpg
Renk Beige

Notes the tool gave for this file

  • Draft layout: the n11 bulk upload template varies by category and expects images as files. Hand the empty template to the template section of the result card and the tool fills the text columns directly.

Field mapping: Shopify → n11

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 Title Ürün Adı
Model / group code Handle Grup Kodu
SKU Variant SKU Stok Kodu
Barcode Variant Barcode Barkod
Sale price Variant Price Fiyat
List / compare-at price Variant Compare At Price Liste Fiyatı
Stock Variant Inventory Qty Stok Miktarı
Tax rate — KDV Oranı Missing in the source; left empty
Weight (grams) Variant Grams — No counterpart in the target; skipped
Image columns Image Src + Image Position Resim 1-8
Option 1 Option1 Name / Value Renk
Option 2 Option2 Name / Value Beden
Description Body (HTML) Ürün Açıklaması
Brand Vendor Marka
Category Type Kategori

Frequently asked questions

Which fields does n11 require?

Product name, Category, Brand, Stock code, Barcode, Price, Stock quantity, VAT rate, Image 1. 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 n11 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 Shopify file is carried over exactly as it is; the n11 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 n11 downloads the files from those addresses during import, so every URL has to stay publicly reachable.

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.

Share

Guides

Articles and format references related to this tool.

Guides →

Related tools

An independent tool. Not affiliated with Shopify or n11, and not an official product of either.