Clover POS Import

Admin

Brother POS can import your product catalog directly from a Clover POS export. The importer reads the Items and Modifier Groups sheets from a Clover .xlsx export, maps modifier groups to product categories, and auto-creates weight presets with pricing from your Clover modifiers.

---

Before You Begin

You will need:

1. A Clover POS export file in .xlsx (Excel) format containing an Items sheet and a Modifier Groups sheet.
2. An understanding of which Clover modifier groups correspond to which product categories in your store.

Export from Clover

In Clover POS, navigate to your item inventory and export to Excel. Ensure both the Items and Modifier Groups sheets are included in the export file.

---

What Gets Imported

The importer reads the following data from your Clover export:

Clover Field	Brother POS Field	Notes
Item Name	Product Name	Duplicate names are disambiguated by appending the category name.
Price	Price	Fixed-price items. Variable-price and non-revenue items are excluded.
Cost	Cost	If provided.
Quantity	Current Stock	Imported as the starting stock level.
Categories	Categories	Mapped to Brother POS categories. New categories can be created during import.
Description	Description	Imported as-is.
(auto-generated)	SKU	Auto-generated in CLV-0001 format.

What Is Not Imported

• Images -- Clover images are not imported. Upload images after import via Images.
• Variable-price items -- Items without a fixed price are excluded.
• Non-revenue items -- Items flagged as non-revenue in Clover are excluded.

---

Import Process

Step 1: Upload the File

1. Navigate to Products in the top navigation bar.
2. Click the Import button.
3. Select or drag and drop your Clover .xlsx file.
4. Brother POS auto-detects the Clover format by checking for the Items and Modifier Groups sheets.

Step 2: Review the Preview

After upload, the system analyzes the file and shows a summary:

• Total items found in the Clover export.
• New products that will be created.
• Existing products that match by name (for updates).
• Excluded items (variable-price, non-revenue).
• Categories found with product counts per category.
• Modifier groups found with their modifiers and weight values.

Step 3: Map Modifier Groups

This is the key step unique to Clover imports. The Modifier Group Mapping UI lets you assign each Clover modifier group to a product category:

1. Each modifier group is listed with its modifiers (e.g., "Flower Weights: 1g, 3.5g, 7g, 14g, 28g").
2. For each modifier group, select the category it should be applied to.
3. Products in that category will receive weight presets based on the modifier group's weights and prices.

Modifier groups as weight presets

Clover modifier groups that contain weight-based modifiers (e.g., "1g", "3.5g", "1 oz") are parsed into weight presets automatically. The prices from each modifier become the custom prices for those weight presets on the associated products.

Step 4: Create New Categories (Optional)

During the mapping step, you can create new categories and subcategories inline:

1. If a Clover category does not match an existing Brother POS category, a Create New option appears.
2. Enter the new category name and optionally assign a parent category.
3. The category is created as part of the import process.

Step 5: Run the Import

1. Click Import Products.
2. The importer processes each item:
   • Creates or updates the product record.
   • Assigns categories.
   • Generates an SKU in CLV-0001 format (auto-incrementing).
   • Creates weight presets from modifier group weights.
   • Links weight presets to products with custom pricing from modifier prices.
3. A summary shows how many products were created, updated, and skipped.

---

Weight Preset Auto-Creation

The importer parses modifier names to extract weight values and automatically creates weight presets:

Modifier Name	Parsed Weight
1g	1.0g
3.5g	3.5g
3.5 grams	3.5g
7g	7.0g
14g	14.0g
28g	28.0g
1 oz	28.0g
half oz	14.0g
quarter oz	7.0g

Weight presets are created from the unique weights found across all modifier groups. Products receive ProductWeightPreset records linking them to the appropriate weights with custom prices from the Clover modifiers.

---

Duplicate Name Handling

If multiple Clover items share the same name:

• The importer disambiguates by appending the category name in parentheses.
• Example: "Blue Dream" in the "Flower" category becomes "Blue Dream" and "Blue Dream" in the "Pre-Rolls" category becomes "Blue Dream (Pre-Rolls)".

---

SKU Generation

SKUs are auto-generated in the format CLV-NNNN:

• CLV-0001, CLV-0002, CLV-0003, etc.
• The numbering auto-increments based on existing CLV-prefixed SKUs in your catalog.
• If you already have products with CLV SKUs, new imports continue the sequence.

---

After the Import

1. Navigate to Products to review the imported products.
2. Spot-check names, prices, stock levels, and category assignments.
3. Upload product images -- see Images.
4. Review weight presets on products and adjust pricing if needed.
5. Assign cannabis attributes (strain type, THC/CBD, terpenes) if applicable.
6. Configure pricing templates if your store uses tier-based pricing.

---

Troubleshooting

Issue	Solution
File not recognized as Clover format	Ensure the .xlsx file contains both an Items sheet and a Modifier Groups sheet.
Products missing after import	Check if they were variable-price or non-revenue items -- these are excluded.
Weight presets not created	Verify that modifier names contain recognizable weight formats (e.g., "3.5g", "1 oz").
Wrong category assignment	Re-run the import with corrected modifier group mappings, or edit products manually after import.

---

What's Next?

• CSV Import -- Import products using CSV files from other systems.
• Managing Products -- Browse and manage imported products.
• Images -- Upload product images after import.
• Weight Presets -- Manage weight presets created during import.