How Do I Import Products from Excel or CSV?
Download the template, add one row per product with sizes, stock and photos, check the preview, then import. Re-importing a file updates products by SKU.
You can add or update many products at once from one Excel (.xlsx) or CSV file, including their sizes, stock and photos. Open Admin → Products and choose "Import from Excel or CSV". Nothing is saved until you have seen a preview and pressed Import. Selling products needs a Pro, Business or Agency plan.
How do I start with the template?
In the import window, download the Excel template (English or Arabic) or the CSV template. The first row holds the column names, so keep them as they are. The first data row is a sample that starts with SAMPLE-: it is skipped when you import, so you can leave it or delete it. Only the product name is required.
What goes in each row?
One row is one product. The columns are Name, Price, Description, SKU, Photos, Sizes, Stock, Stock per size, Status, Type, Slug and Weight (g). Price is read in your store currency. If the price is empty or 0, the product is saved as a draft. Leave Status and Type empty to get an active physical product.
How do I add sizes and stock per size?
Write the sizes in the Sizes cell separated by commas, for example 0-3 months, 3-6 months, 6-9 months. In Stock per size, write one number for each size in the same order, for example 3, 5, 2. Every size gets the product price. If you give sizes, the single Stock cell is ignored. A product without sizes uses the Stock column: an empty cell means stock is not tracked, and 0 means sold out.
If the list in Stock per size has a different number of values than the list in Sizes, that row is marked as needing a fix. We never guess which size a number belongs to.
How do I add photos?
The easiest way is to put the picture in the file. In Excel, choose Insert, then Pictures, and place the picture over the Photos cell of that product's row. In Excel 365 you can instead choose "Place in Cell" so the picture sits inside the cell. You can put several pictures on one row, up to 12 per product. The first one becomes the main photo. Pictures can be JPEG, PNG, WebP or GIF, up to 10 MB each.
If your file has no pictures, write a web link (https) or a file name in the Photos cell, separated by commas. For a file name, the import asks you to choose those files from your computer and matches them by name. For links, the photos are downloaded when you press Import.
A file with many pictures can become large. If Excel says the file is too big, right-click a picture and use "Compress Pictures", then save again. The file limit is 100 MB and 500 products per file.
What do I see in the preview?
After you choose the file, you see a table with every product, its photos, price and sizes, and what will happen to it: create, update, no change, skip, or needs fixing. A row that needs fixing explains the problem next to the column that caused it, for example a price that is not a number. Fix the cell in your file and choose the file again. Rows that need fixing are not imported; the other rows are.
Which products are saved as drafts?
A new product is saved as a draft when it has no price, no photo, or a photo that could not be used, even if the Status cell says active. The preview gives the reason next to each draft, and the result screen counts them. Open the product in Admin → Products, fix it, and publish it.
Can I import the same file again to update my products?
Yes. Products are matched by SKU, or by the Slug when a row has no SKU. A match is updated and no duplicate is created. Keep the SKU unchanged in your file so it matches. Empty cells change nothing, and a column you remove changes nothing, so you cannot erase data by leaving a cell blank. Sizes you already have in your store but not in the file are kept, and existing photos are kept. If an import stops halfway, for example because the connection dropped, choose the same file again to continue; nothing is created twice.
If Excel removes the leading zeros of your SKUs (00123 becomes 123), set the SKU column to Text format before you type or paste them.