In short

The Import Products wizard lets you bring products into the Hive from an Excel file in three steps. Upload your file, map its columns to your product template fields, then confirm how records are identified and stored.

Before you start

• You need a Product Template set up in Hive Control Center > Product Templates that matches the structure of the data you are importing. If you haven't created one yet, see the article on creating a Product Template.
• Your source file must be an Excel spreadsheet (.xlsx).
• At the end of the wizard, after it has run, it creates and saves a Flow for you. You DO NOT need to run the import wizard every time. It is a quick start method to creating a Flow.

Importing products

1. From the left-hand menu, click Products to expand the section.
2. Click My Products.
3. Click Import on the top menu bar. The Import Products wizard opens at a summary of the import process — How to Import. Read the overview and click Next to proceed to step two — Select the files for the import.
4. Drag your Excel file into the upload area, or click browse for them to select it from your computer. Once uploaded, the file appears under File(s) uploaded. Click Next to advance to step three.
5. On the Create the mappings for the data step, select your Target Product Template from the dropdown at the top. This tells the Hive which template structure to map your file columns into.
6. Review the mapping grid. Each row represents one column from your spreadsheet — the Source column shows the original column name, How to Map defaults to Pass Through Value, and Target is where you assign the matching field from your template.
7. For each source column, drag the matching field from the right-hand panel into the Target cell, or click Suggest Mappings to let the Hive auto-match fields by name. Use Refresh Mappings to reset the suggestions if needed.
8. To apply a transformation instead of a direct pass-through, change How to Map to Calculate Value and configure the calculation steps. See the article on using Calculate Value for details.
9. Once all required fields are mapped, click Next.
10. On the Store step, review the auto-generated Name for this Flow — it defaults to Import from Excel (date time). Edit it if you want something more descriptive.
11. Confirm Store Data As is set to Product.
12. In the Which fields together uniquely identify each record? field, select one or more fields that make each product unique — for example, your SKU or item number field. This controls whether the import creates new products or updates existing ones.
13. Click Done. The wizard creates a Flow, executes it immediately, and saves it to My Flows for future use.

The unique identifier field drives upsert logic — if a product matching that value already exists in the Hive, it will be updated. If no match is found, a new product is created. Choose a field that is genuinely unique across your product range, such as a SKU or item number.

What happens next

The import runs immediately when you click Done. You can check the result by going to Flows > History and clicking the run entry. The execution log shows how many records were added, updated and processed.

The wizard also saves the Flow to Flows > My Flows under the name you set in the Store step. You can re-run it at any time from the list — useful if you receive updated product files on a recurring basis.

*Keep Buzzing 🐝*Keep Buzzing 🐝