Skip to main content

Merging multiple products

Merge identical or similar products from different sales channels under one primary product, so cost of goods sold (COGS) uses one cost and one history for all of them.

Written by Emily Burrows

About

Applies to: Finaloop Accounting, InventoryIQ, Margins

In Finaloop, you can merge products and group them together under one primary product, so identical or similar products coming from multiple sources, like Shopify and Amazon, are managed and costed as one product. Merging products improves your inventory accuracy and keeps your cost of goods sold (COGS), what the products you sold cost you, correct across platforms.

You can merge products whether you use sales-based COGS, where Finaloop records COGS when an order sells using the cost per unit you enter, or InventoryIQ, Finaloop's inventory management product, which tracks every unit and its cost:

  • If you're using the sales-based COGS method, merging products applies the primary product's cost updates to the merged products.

  • If you're using InventoryIQ, merging products treats the merged products as the same SKU for calculating first in, first out (FIFO) COGS.

Here's how to merge and unmerge products, how our Merge recommendations feature automates and optimizes this process, and how merging products affects your financials.

Note: In Margins, Finaloop's performance analytics product, the steps are the same: start from Products in the sidebar. Merging uses the primary product's cost per unit, as with sales-based COGS.


1. Merging products

You can merge products directly from your product list in Finaloop, on a computer. Merging products in Finaloop won't affect your sales channels: it's only for managing these products in Finaloop. A merge applies from the date your books start in Finaloop or the start of your first open year, whichever is later. Data from before that date still shows the products separately.

Important: Merging products combines their COGS and purchase history, which can change your COGS numbers. Other details, such as opening balances, recipes and physical counts, are kept only from the primary product to prevent double counting, and are erased from the other products. Review your products and COGS after you merge and make any necessary adjustments.

To merge multiple products:

  1. In Inventory → Products, click Actions and select Merge products.

    Products page Actions menu open with Merge products outlined, above Export file, Hide from product list and Add product.

  2. On the Merge products page, select the products you want to merge in the product list in the lower part of the page. They appear in the panel at the top.

  3. In the panel, click Make primary next to the product whose name, SKU, photo and cost you want to keep. It's then marked Primary.

  4. Click Save. If a Note! window tells you that some data from the merged products will be erased, click Save to confirm, or Go back to change your selection.

Merge products page with two selected products in the list, the Make primary button in the top panel and the Save button.

① Selected products, ② Make primary, ③ Save.

Once merged, you'll see Changes saved successfully on the screen and Saved successfully! next to the Continue button. The Products page now shows only the primary product, with the merged icon in its Attributes column.

Products list with the tooltip on the merged icon in the Attributes column: Merged. Indicates that this product has been merged with other product(s).

Click the product line to open it, then expand Product details to see the merged products under Merged products, with the primary product marked Primary and the date each product was merged in Merged since. If you open one of the other merged products, you'll see that it was merged into the primary product and that new costs can only be added through the primary product.

Product details section of a merged product listing its Shopify and Amazon versions, with Primary on the Shopify product and a Merged since date.

That's it, the products are merged!


2. Unmerging products

To unmerge products:

  1. In Inventory → Products, click the merged product to open it.

  2. Click Actions and select Edit merged products.

  3. Click the X next to each product you want to remove from the merge. To undo before saving, click the restore icon next to it.

  4. Click Save.

The removed products show again as separate products on the Products page. The primary product stays in the merge: to remove it, first click Make primary on another product.

Merges and unmerges apply to your open years. If a change would affect a year whose books are closed, you'll see Unable to save, because sales were recorded for one or more of the merged products during that closed year. Contact us and we'll help with changes that touch a closed year.


3. Merge recommendations

To save you time and reduce manual work, Finaloop automatically suggests product merges based on data from your connected platforms. Our Merge recommendations feature analyzes product data and suggests merges based on patterns we've learned, saving you time and improving inventory accuracy.

When you have merge recommendations, you'll see this at the top of your Products page and Inventory overview:

Banner reading You've got product merge recommendations! with a Tap to review link.

Click Tap to review to check them out. You can also open them from the Merge recommendations button on the Merge products page.

Our system groups potential matches into three categories, from most confident to least. If a product fits more than one, we place it in the most conservative category.

Perfect match: products with identical SKUs

These products have the same SKU but may have different product names.

Example: "Blue Hoodie" and "Hoodie - Blue" both have SKU BLH123. These would be included in the Perfect match category.


Flexible match: identical SKUs plus a known prefix or suffix

These products have the same SKUs with a known prefix or suffix from a marketplace (like FBA or FBM).

Example: BLH123-FBA and BLH123 would be included in the Flexible match category.


Smart match: potential product matches

These products are potential matches based on similarities in name, SKU, ASIN, or description, even though their SKUs aren't identical.

Example: BLH123 and BL124 are both called "Blue Hoodie." These would likely be included as a recommended Smart match. These should be carefully reviewed before merging.


Auto-merge or review manually

You can decide how to handle these merge suggestions:

  • Auto merge: Turn on this toggle for a category to let Finaloop automatically merge future matches. This is especially useful if you often add new products. Turning it on also merges all the groups shown in that category now, after you confirm in the Heads up! window.

  • Review and merge yourself: Keep the toggle off and review each suggestion before merging. In each group, you can click Make primary on a different product or remove a product that doesn't belong. Then click Merge products on the category to merge all its groups. This gives you more control when needed but requires more hands-on management.

The Auto merge toggle is available for Perfect match and Flexible match. Smart match suggestions need your review, so you can make sure your inventory matches are all accurate.

Merge recommendations page with Perfect match and Flexible match categories, their Auto merge toggles, Merge products buttons and the Merge log link.

① Auto merge, ② Merge products, ③ Merge log.


Merge log

Click Merge log in the upper right corner to review a detailed log of all merge activity over time, both auto-merges and manual merges. Each row shows the Date merged, Product, SKU, Source, the type of merge (Manual, By recommendation, Auto-merge or Multi) and Merged by. Merges made before April 2025 don't show an exact date.


4. How merging products affects your books

The steps to merge your products in Finaloop are the same whether you use the sales-based method or InventoryIQ to manage your COGS, but the impact the merge has on your books is different for each method.

Sales-based method

When you merge two or more products using the sales-based COGS method, Finaloop uses the cost per unit of the primary product for all merged products as well. If you change the cost of the primary product in Shopify or directly in Finaloop, this cost change also applies to all merged products, from the date the merge starts.


InventoryIQ

Merged products are tracked as one SKU in your warehouse. When you merge two or more products in InventoryIQ, those products are recorded in the relevant warehouses under the primary product.

For example, if you merge Ghost Ember Hot Sauce 5oz from Shopify with the same sauce listed on Amazon, units sold on either channel take their landed costs (the full cost of getting a product to your warehouse, including shipping, duties and fees) from the same batch of purchase orders (POs), and are treated the same for determining COGS. In other words, the PO cost layers are merged together for the FIFO COGS calculation.

Important: If you're using recipes or assemblies, only those linked to the primary product remain after merging. Recipes or assemblies for the other products disappear and need to be created again if you unmerge these products later. To save yourself unnecessary inputs, merge products before adding recipes or assemblies.


Related articles


Need help?

Not sure which products to merge or how recommendations apply to you? Reach out to [email protected] (Margins customers: [email protected]). We're here to help!

Did this answer your question?