4.4Import products from a CSV file

Steps

1. On the Products list, press Import. This opens the import page.
2. Press Download template. A file called shopgoti-products-template.csv downloads.
3. Open it in Excel or Google Sheets. It has 17 columns and two example rows: one simple product and one with two sizes.
4. Replace the example rows with your own. One row is one product. For a product with variants, repeat its name on one row per variant and write the option in variant_option, for example Size=M. For more than one option, separate them with |. Put photo links in image_urls, separated with |; up to 8 per product are used.

Steps

1. In CSV file, choose your CSV file. The file picker offers CSV and plain-text files only.
2. In Where the file is from, keep Detect automatically unless you know the source. The list offers ShopGoti template, Zatiq export, WooCommerce product CSV and Daraz seller-centre sheet. The choice only changes which column matches are suggested in the next step. A sheet from another source is handled by detection, and you can match its columns by hand.
3. Press Upload. The import opens at the matching step.

Steps

1. Under Match the columns, each product field has a list of the column headings in your file. Choose the heading that holds that field, or — not imported — to leave the field out.
2. Product name and Sell price (৳) are required and marked with an asterisk. The form does not go on until both have a column.
3. Under each list, the panel shows up to two values from that column, so you can check that you picked the right one.
4. Show imported products in the shop right away is ticked by default. Products whose status cell is blank are published straight away. Untick it, and they stay as drafts until you publish them yourself. A status cell in the file overrides this box for that row.
5. Press Check the file. Nothing is written yet.

Steps

1. Read the six figures: Rows, Products, Will be created, Will be updated, Will be skipped and Over plan limit. A product counts as updated when a product you already have has the same SKU — or the same name, for a row that has no SKU.
2. Read the meter, such as "12/50 products used on your plan". It counts the products you already have plus the ones this file would create. If your plan has no product limit, the meter says so.
3. Read Rows that will be skipped. Each entry gives the row's line number in your file and the reason. The report lists them all.
4. If Over plan limit is above zero, those products will not be imported. Press Upgrade plan to see the plans. After you upgrade, upload the same file again; only the products that were left out are added.
5. Press Start import to write the products, or Cancel to stop here.

Steps

1. While the import runs, the page shows "Importing… done/total products" and refreshes itself every two seconds. You can leave the page; the import keeps going. Press Cancel to stop it.
2. When it finishes, the heading reads Import finished, Import failed or Import cancelled. The counters show Created, Updated, Skipped, Over plan limit and Failed, with a line on photos stored and photos that failed.
3. Press Download report (CSV). You get one row per line of your file, with the columns line, key, status, reason, product_id, images_stored and images_failed.
4. Read Row results. Each product name links to its product page. When there are more rows than the screen shows, the rest are in the report.
5. Press Go to products to see the new products in the list.

Steps

1. On the import page, find Previous imports. It lists your most recent imports, newest first, up to 20. Older finished imports are removed when you upload a new file.
2. Press a file name to reopen that import. An import that has not started shows its matching step, a running one shows its progress, and a finished one shows its report.
3. Press All imports to return to the list, or Upload another file after a finished import.