# Import, export and bulk edit

Catalog

Editing products one by one is fine for a small shop. For hundreds of products GrandNode offers two tools: **Excel import and export** for any field, and the **Bulk edit products** grid for the everyday numbers - price, old price, stock and whether a product is published.

### Export products

1. Open **Catalog → Products**.
2. To export everything that matches the current filters, choose **Export → Export to Excel (all found)**. To export only some products, tick them in the grid and choose **Export to Excel (selected)**.
3. Open the downloaded `.xlsx` file. Each row is a product; the first columns are its **Id** and **Sku**.

### Import products

1. Prepare an `.xlsx` file with the same columns as the export. The easiest start is an export of one product.
2. On the product list choose **Import from Excel** and pick the file.
3. GrandNode processes the rows and reports the result.

How a row is matched:

- If the **Id** matches an existing product, that product is updated.
- Otherwise, if the **Sku** matches an existing product, that product is updated.
- Otherwise a new product is created.

Only the columns present in the file are changed. Category and collection columns take lists of ids; the page name is generated from the name when it is empty and made unique. Missing references (a layout, tax category, warehouse or unit that does not exist) fall back to the defaults.

> Import into a copy of your store first, or export a backup before a large import. An import cannot be undone in one click.

### Bulk edit products

**Catalog → Bulk edit products** shows products in an editable grid: **Name**, **SKU**, **Price**, **Old price**, **Stock qty**, **Manage inventory** and **Published**.

![The Bulk edit products grid with name, SKU, price, old price, stock quantity, manage inventory and published columns, and Save changes and Cancel changes buttons](https://grandnode.com/Plugins/Theme.GrandNodeCom/Content/kb/catalog/bulk-edit.webp)

Catalog → Bulk edit products.

1. Narrow the list with the search box and **Filters** (category, brand, store, vendor, product type).
2. Click a cell and type the new value. Changed cells are marked.
3. Click **Save changes** to write all changes at once, or **Cancel changes** to discard them.

The icons at the end of each row open the full product editor or the product page, and **Delete** removes the product.

### Other lists

Categories, brands and collections have the same Excel export and import, and orders and customers can be exported the same way. The format is always the one the export produces.

### Tips and common mistakes

- Keep the **Id** column when you re-import an export; without it rows are matched by SKU, and rows with an empty SKU become new products.
- Excel changes long numbers such as GTINs into scientific notation. Format those columns as text before saving.
- The **Picture1**-**Picture3** columns take a file path on the server or an http(s) address; each picture is read and stored, so large imports with pictures take a while.

### Related

- [Products](https://grandnode.com/catalog-products)
- [Prices and inventory](https://grandnode.com/catalog-prices-inventory)

- [Web page](https://grandnode.com/catalog-import-export-bulk-edit)