HomeGuideProduct data import
Go-live Est. read 5 min

Product data import

Bulk-import thousands of products via Excel — with field-by-field notes

Prepare your product file

Format data to match the official template before importing.

1

Download the template

Back office → Products → Bulk import → Download template.

2

Required fields

Name and sell price are required. If barcode is empty, an internal SKU is generated.

3

Fill product rows

Map your existing catalog to the template; start with core fields and enrich later.

Field reference

1

Product name

Required. Use a clear searchable name.

2

Barcode / SKU

Optional. EAN-13, EAN-8, Code128, and similar formats are supported.

3

Sell price

Required. Two decimal places (e.g. 12.50).

4

Cost price

Optional. Used for margin; never shown to customers.

5

Category

Optional. Create categories first; use “/” for nested paths (e.g. Food/Snacks).

6

Opening stock

Optional. Can set initial quantity during import.

Tips
  • Multiple barcodes on one row can be separated with “;”.
  • Images are not imported via Excel — upload them after import.

Run the import

1

Upload the Excel file

Choose the file on the bulk import page; validation starts automatically.

2

Review validation

Fix any errored rows from the report, then re-upload if needed.

3

Confirm import

Start import and watch progress; you get a notice when finished.

4

Spot-check results

Open the product list and verify a sample of items.