Adjusting inventory from FBA Orders with Flow

Shopify Plus
1

Hi,

Thanks for reading.

We have been selling through marketplace connector as well as our regular storefront. We just put products up to FBA.

I am not sure as to the best practice, but we made a second inventory location in Shopify called FBA. So, if we had 100 items in standard inventory in Shopify, we shipped 10 to Amazon and then put 10 into the “FBA” location in Shopify.
Is this the correct way? I didn’t see any other way to account for both types of fulfillment.
So, if this is right, can I use a flow to decrease the inventory in FBA? Also set up a low-inventory trigger for that item?
The other thing that’s messing up our system is it looks like we had to use a separate SKU for FBA vs FBM.
We are the manufacturer, so the SKU is very important to different aspects of the company, but FBA is a complication. I was thinking of having a conversion table to pass the “original” SKU back into our CRM and ignore the FBA-specific SKU.

Any thoughts or suggestions would be greatly appreciated.

Regards,

Pete

2

Hi,

Creating a separate inventory location in Shopify for FBA is a good practice, but manually managing inventory can be tedious. To simplify this, consider using Amazon MCF by WebBee:

  • Automatic Inventory Sync: Keeps FBA and Shopify inventory updated in real time.
  • SKU Management: Uses the same SKU for FBA and FBM, avoiding complications with your CRM.
  • Automation: Eliminates manual updates and supports low-inventory alerts for FBA stock.

This app streamlines your fulfillment process, saving time and ensuring accuracy. Let me know if you’d like more details or a demo!

3

@Uni-Trend I figured out how to do the adjustments using Flow if you’re interested. Here’s a link to my post on it: Automatically reconciling Shopify inventory for Amazon FBA orders using Shopify Flow - #3 by Gabe_Stillwater

4

@Uni-Trend ,

You’re thinking about this the right way, and yes what you did is broadly correct, with a few important best-practice tweaks.

  • Creating a separate FBA location in Shopify is the correct approach
  • Moving inventory from Warehouse → FBA location when you ship to Amazon is best practice
  • Shopify Flow can adjust FBA inventory and trigger low-stock alerts only if your Amazon connector syncs FBA sales back to Shopify
  • Using separate SKUs for FBA vs FBM is not ideal
  • Best practice is one internal/master SKU with different fulfillment locations
  • A SKU conversion table works only if the connector forces different SKUs, but treat it as a fallback, not the primary setup

Bottom line:
Locations = correct.
Flows = yes (with synced sales).
SKUs = keep one if you can.