Import, export and bulk edit

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.

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
• Prices and inventory