# Import and export products with a CSV file > Add or update many products at once from a CSV file made in Excel or Google Sheets, and download your whole product list as a CSV. Instead of adding products one by one, make a list in Excel or Google Sheets, save it as a CSV file and **Import** it into Tukri. New products in the file are added and the ones you already have are updated. The other way round, **Export** downloads your shop's whole product list as a CSV file. ## Before you begin - Importing and exporting need the **Bulk product tools** permission. It starts with the **Owner** and **Admin** roles, not **Staff**; the owner can give it to other roles under **Settings** › **Roles**. Without it, the two buttons do not appear. - Every unit named in the file (such as Pieces or Kilogram) must already exist in your shop. For a new unit, first add it with the **+** beside **Unit** on the product form. Categories that do not exist yet are created for you. - Save the file as a UTF-8 CSV so Bangla names stay readable. It must be a .csv file of at most 5 MB. - Every column is explained in Tukri's [CSV import guide](https://tukri.bd/products/import-guide), where you can also download an empty template. ## Import a file 1. Open **Products** in the menu on the left and click **Import** at the top. (On a phone it is the upload icon above the list.) ![The top of the product list on a computer: the Export and Import buttons with the other buttons](https://tukri.bd/help-center/en/import-products-csv/products-computer.webp) 2. If you need a starting point, click **Download template**; for what each column means, **Read the CSV guide**. 3. Under **CSV file**, choose your file. ![Import products from CSV: the Read the CSV guide and Download template links, and demo-products.csv chosen below](https://tukri.bd/help-center/en/import-products-csv/choose-file-computer.webp) 4. Click **Start import**. The message "Import queued. We will tell you when it finishes." appears. 5. The import runs in the background, so you can close the window and keep working. When it finishes, a "Product import finished" notification arrives under the bell at the top. 6. Open **Import** again. **Last import** shows how many products were added, updated and rejected. ![Last import: 2 added, 0 updated, 1 rejected out of 3 products, with the Download the rejected rows link](https://tukri.bd/help-center/en/import-products-csv/last-import-computer.webp) ## What an import does and does not do - A product is matched by its SKU; when the SKU cell is empty or matches nothing, by its barcode. A match is updated; anything else is added as a new product. So importing the same file twice with both SKU and barcode empty adds those products twice. - The file's stock is used only as the [opening stock](https://tukri.bd/help/opening-stock) of a new product or variant. A file never changes the stock of a product you already have; use a purchase or a stock adjustment for that. - An import never deletes products, variants or packs. - A file cannot turn a plain product into one with variants or back, or switch batch and expiry tracking on or off; do those on the product screen. It also cannot change the unit of a product whose stock has already been bought or sold. - Photos are not part of the CSV. - Each product is imported on its own: if one is wrong, the others still go in. ## Fix rejected rows If any product was rejected, **Last import** shows **Download the rejected rows**. That file lists each rejected row with its number, the column and what is wrong, for example that the shop has no unit by that name. Fix the rows in that file and upload it again. The products that imported are not touched. Only the person who uploaded the file can download its report. ## Export your whole list On **Products**, click **Export** at the top (on a phone, the download icon). A CSV of every product in the shop downloads: active and inactive, everything except deleted products. It has exactly the columns the import reads, so you can change prices or names in it and import it back to update many products at once. ## Let an AI build the file The [CSV import guide](https://tukri.bd/products/import-guide) has a section called **Ask an AI to build your file** with a ready-made prompt. Copy it into ChatGPT, Claude, Gemini or another assistant, then send your product list (typed, a supplier's price list or a photo of your notebook). Import the CSV it gives back. Check the prices and stock once before importing. ![The top of the CSV import guide: the Download template button and the Ask an AI to build your file section](https://tukri.bd/help-center/en/import-products-csv/guide-computer.webp) ## If something goes wrong **The import seems stuck.** If the spinner under **Last import** keeps turning, wait a few minutes and open the window again. If it never moves, contact Tukri support. **It says "The uploaded file could not be read." or "The file is empty."** Save the file again as a UTF-8 CSV and retry. If the first line (the header) is missing a required column, the whole file is refused; start from the template's header. **A row says "Your plan's product limit is full, so this product was not added."** Your plan's number of products is full. For more, choose a bigger plan: [Your plan](https://tukri.bd/help/plan-and-subscription). **A row says its SKU belongs to a deleted product.** Restore that product ([Edit, deactivate, delete or restore a product](https://tukri.bd/help/edit-a-product)), or use a different SKU in the file. **There is no Import or Export button.** Your role does not have the **Bulk product tools** permission. Ask the shop owner. --- - Source: https://tukri.bd/help/import-products-csv - Language: English - In বাংলা: https://tukri.bd/bn/help/import-products-csv - Last reviewed: 2026-10-22 - Site index for language models: https://tukri.bd/llms.txt