How do I merge my FBM and FBA SKUs?

Last updated about 7 years ago

Managing your FBM and FBA SKUs separately presents the following critical limitations:

  • You can't list duplicate SKUs that share the same UPC to channels like Jet and Walmart.
  • You can't have product ("variant") groups that contain duplicate SKUs -- no channels will allow the same unique product to be provided as 2 separate SKUs.
  • You need to manage each SKU separately which is inefficient.
  • Reporting is overly complicated as each SKU would be a separate line item.
For these reasons, we recommend merging your FBM and FBA SKUs together in Zentail. This process essentially adds your FBM inventory into your FBM warehouse in Zentail. It helps to standardize your catalog.

Merging SKUs only occurs on Zentail. It is only necessary when you have both an FBA and MF version of the same product. More specifically, you have an FBA SKU for one ASIN and a MF SKU for the same exact ASIN. Merging SKUs allows you to manage one "standardized" SKU for your inventory across different warehouses (in most cases- an FBA warehouse and your Main (or Merchant) warehouse). It also allows you to keep track of all of your sales data and analytics within one SKU.

After two SKUs are merged on Zentail, the FBA version survives as the standardized value, and the MF SKU gets archived on Zentail. The MF SKU will still be active on your Amazon account since Amazon requires different SKUs for FBA versus MF inventory.

How to merge your FBA and FBM SKUs

Merging SKUs automatically

We can now manage this function with a click of a button! Please contact us if you'd like to merge your SKUs.

If you need to specify which SKUs need to be merged, please send us a spreadsheet with your FBA sku in Column A and the FBM sku it will be merged with in column B.


Merging SKUs Manually

  1. In your Catalog => search for your FBA SKU
  2. Click the "EDIT" button => Click the Price & Availability menu option
  3. Enter the inventory quantity of the FBM SKU in the FBM warehouse (merchant fulfilled warehouse, often labeled "main" in the Warehouses section of your Account Settings page)
    merge-fbm-fba-zentail.png 25.96 KB
  4. Go to the FBM SKU
    • Zero-out the inventory that's in your FBM warehouse.
    • Click the 3-vertical-dot icon at the top of the page => Click "Archive".

Merging SKUs in Bulk

Currently the fastest way to do this is to use our Import / Export feature.

  1. Go to the Import Data page.
  2. Create a new template containing the following attribute columns (how to)
    • SKU (required)
    • ASIN
    • Condition
    • FBM Quantity
  3. Run an export of the custom template you just built. (how to)
  4. Sort the template by ASIN and Condition.
  5. Add the FBM quantity value into the FBM Quantity field for the FBA SKU.
  6. Change the FBM Quantity value of the FBM Quantity field to "0" for the FBM SKU.
  7. Run an import of the file you just edited. (how to)

Related reading:  Why do I have SKUs with "+MF+" in Seller Central?

powered by
SlimFAQ