Clover POS Import

Admin

Use this page to move your product catalog from Clover into Brother POS using Clover's Excel export.

Quick steps

1. In Clover, export your item inventory to Excel (.xlsx). The file needs an Items sheet and a Modifier Groups sheet.
2. In Brother POS, go to Products > More Actions > Import from File.
3. Click Choose a file (or drag the file in). Check the Import Preview for new products, updates and errors.
4. Under Clover Modifier Group Mapping, for each weight group (like "1g, 3.5g, 7g"), tick the categories it applies to under Apply to categories:. Skip any group you don't need.
5. Click Import Products and wait for the summary. Don't close the page while it runs.
6. Spot-check a few products, then add images.

Items sold by weight are combined

Items like "Blue Dream 3.5g" and "Blue Dream 7g" in a mapped category become one product, Blue Dream, priced by weight. Existing products with those exact per-weight names are switched off (never deleted).

Common questions

Are my Clover images imported? No. Add them afterwards — see Product Images.

What if I run the import twice? Items are matched to existing products by SKU, then barcode, then exact name, and updated rather than duplicated.

A modifier group isn't in the mapping list. Only groups with a weight in their names (such as "3.5g" or "1 oz") are shown. Groups like "Gift Card Value" are left out.

My Clover items had no SKU. Brother POS makes one for each, like CLV-0001, CLV-0002.

---

More detail: before you begin and what gets imported

Brother POS can import your product catalog straight from a Clover POS export. It reads the Items and Modifier Groups sheets of a Clover .xlsx file. Weight-based modifier groups (such as "1g, 3.5g, 7g, 14g, 28g") become Pricing Templates for the categories you choose.

Before You Begin

You will need:

1. A Clover export in .xlsx (Excel) format that has a sheet named Items and a sheet named Modifier Groups.
2. An idea of which Clover modifier groups belong to which of your product categories.

Export from Clover

In Clover, export your item inventory to Excel. Make sure both the Items and Modifier Groups sheets are in the file.

What Gets Imported

Clover column	Brother POS field	Notes
Name	Product name	See Duplicate Names.
Price	Price
Cost	Cost	A negative cost is imported as 0.
Quantity	Stock	Imported as a whole number. Negative quantities become 0.
Categories	Categories	Categories that don't exist yet are created. An item with no category goes into Uncategorized.
Description	Description	If blank, the Clover Alternate Name is used instead.
SKU	SKU	If the Clover item has no SKU, one is generated (CLV-0001, CLV-0002…).
Product Code	Barcode
Hidden?	Active / inactive	Items marked Yes are imported as inactive.

Matching Existing Products

Each Clover item is matched to an existing product by its SKU first, then by its Product Code against your barcodes, then by exact name. A match is updated. Anything that doesn't match is created as a new product. An existing product keeps its categories unless it had none.

What Is Not Imported

• Images — Clover images are not imported. Add them afterwards — see Product Images.

Variable-price and non-revenue items

The import preview counts variable-price and non-revenue items as skipped, but the import itself brings them in too. Check those items after the import and deactivate any you don't want to sell.

More detail: the import step by step

Import Process

Step 1: Upload the File

1. Go to Products.
2. Open More Actions and choose Import from File.
3. Click Choose a file or drag and drop your Clover .xlsx file.
4. Brother POS recognises a Clover export by its Items and Modifier Groups sheets.

Step 2: Review the Preview

The Import Preview shows how many products are New and how many are Updates (matched by name for the preview), plus any errors.

Below it, the Clover Modifier Group Mapping section lists how many new products, categories and modifier groups were detected. Only modifier groups that contain at least one weight (such as "3.5g" or "1 oz") are shown. A group like "Gift Card Value" is left out.

Step 3: Map Modifier Groups to Categories

Each weight-based modifier group gets its own card:

1. The left side lists the group's modifiers with their Modifier, Weight and Price.
2. Under Apply to categories:, tick every category that group's pricing should apply to. Subcategories are listed under their parent.
3. To add a category that isn't listed, click + Add Category, type the name, optionally pick a parent category (or leave it as (Top-level category)), and click Add.

You don't have to map every group. A group with no categories ticked is ignored.

Step 4: Run the Import

Click Import Products. The import runs in the background and shows its progress. When it's done, a summary gives the number of products imported, weight variants combined, errors, pricing templates created and products assigned to a template. If any existing per-weight products were deactivated (see below), the summary also says how many and names the first 10.

More detail: what happens to weight products

What Happens to Weight Products

For each modifier group you mapped:

• A Pricing Template is created (or updated) with the same name as the group. Each modifier's weight and price becomes one row of the template, and it applies to the categories you ticked.
• Pricing templates are switched on for your store if they weren't already.

Clover items in a mapped category are then combined by name. Brother POS removes the weight from the end of the name, so "Blue Dream 3.5g" and "Blue Dream 7g" in the same category become one product called Blue Dream. That product:

• Is sold by weight using the matching pricing template, and gets its weight options from that template.
• Adds together the stock of all the Clover items it replaces.
• Uses the middle price of those items as its price, and the cost of the highest-priced one.

Brother POS also matches Clover categories to the groups you mapped by similar name, so a "Flower" category can pick up a "Flower Weights" group even if you didn't tick it. If you map no groups at all, your existing active pricing templates are used for this matching instead.

Re-importing deactivates per-weight products

If your catalog already has separate active products with exactly the same names as the Clover items ("Blue Dream 3.5g", "Blue Dream 7g"), they are deactivated when those items are combined into one "Blue Dream" product. They are never deleted, so their sales history is kept. The import summary lists them so you can review them afterwards.

How Weights Are Read

Modifier name	Weight
1g	1g
3.5g or 3.5 grams	3.5g
Quarter 8g	8g (a gram number always wins)
Gram	1g
1 oz or Oz	28g
half oz	14g
quarter oz	7g

A modifier whose name has no weight in it is ignored.

More detail: duplicate names, SKUs, and after the import

Duplicate Name Handling

If two or more non-weight Clover items have the same name, each one gets its first category added in parentheses. For example, "Rolling Papers" in Accessories and "Rolling Papers" in Merch become Rolling Papers (Accessories) and Rolling Papers (Merch). An item with no category keeps its name.

SKU Generation

When a Clover item has no SKU, Brother POS generates one in the format CLV-0001. Numbering carries on from the highest CLV- SKU already in your catalog, so a second import continues the sequence.

After the Import

1. Go to Products and spot-check names, prices, stock and categories.
2. Add product images — see Product Images.
3. Open a weight product and check its weight pricing on the Pricing tab.
4. If you sell cannabis, fill in strain type, THC/CBD and other details on the product's Cannabis tab.
5. Review the templates that were created under Pricing Templates.

More detail: troubleshooting

Troubleshooting

Issue	Solution
File not recognised as a Clover export	Make sure the .xlsx file has sheets named Items and Modifier Groups.
A modifier group doesn't appear in the mapping	None of its modifier names contain a weight (such as "3.5g" or "1 oz").
Weight items came in as separate products	Their category wasn't ticked for any modifier group. Re-run the import with that category mapped.
Unwanted items were imported	Variable-price, non-revenue and hidden items are all imported. Deactivate the ones you don't sell.
Wrong category or template	Re-run the import with corrected mappings, or edit the products afterwards.

---

What's Next?

• CSV Import — Import products from CSV files from other systems.
• Managing Products — Browse and manage imported products.
• Product Images — Add product images after import.
• Pricing Templates — Review the templates created from your modifier groups.
• Weight Presets — Manage your standard weight options.