Amazon Integration - Information and Managed Availability Sign-up

Are you going to offer inventory management for FBA?

FBA Inventory + FBA Shipments + Replenishment 

These are things that Acumatica should support!

Really looking forward!

Its exciting to hear about the potential shipment connection. 

Regarding the order flow, I suggest you talk to members that have this functionality set up (through Celigo or other providers). If you don't account for damage, returns or other factors, the inventory in the Acumatica Amazon warehouse will be out of sync after a week or two. 

If you want to know more, reach out to any member that does Amazon or PM me.

@josh.fischer 

As far as I know, Amazon has this shipment process available via API already in place.

We do the entire shipment process + inventory sync entirely from within the system we currently use, and we don't do any touch in Seller Central.

I will put my offer here too (same as @Jeff96) that I'm more than willing to demo to you how we do it.

Anyway, can't wait to see it in Acumatica!!

@meir121218p  - terrific, thank you for the offer! Please be sure (if you haven’t already) to fill out the beta participation form above.

@CourtHagerDI  - yes, these fees are a very important need for all the merchants we speak with. The details about this are still being specified. Your approach of using non-stock items is a smart solution, especially when you need to “flex” the system into satisfying this. Our approach will be slightly different. What we are intending to do (still discussing internally) is adding fields which represent these Amazon fees within the financial system. Ultimately, the fees need to be represented within the invoice of the orders as a cost associated with the item(s) sale. However, there are challenges around this. For instance some fees are shared with the original order via the API and others are not. 

Long way of saying, we are determined to solve this, but details continue to be a wip. If you’re up for it @CourtHagerDI please fill out the form to be involved in the beta program. Even if  you don’t end up implementing this year, it would be great to engage with your team and learn from you guys. Appreciate it!

@josh

Most of my clients who use Amazon (AMZ) are lot controlled. I know Amazon doesn’t track lots, have you thought of anyway to allow these lot controlled customer to still use this connector? Right now we are exporting the inventory with lots from the AMZ warehouse inside of Acumatica (ACU). Running a vlookup and populating the orders pulled from AMZ with the lots available inside the AMZ warehouse in ACU. It would be nice to have this connector automatically select lots which are available, inside the specific warehouse &/or warehouse location containing the AMZ inventory.

@josh.fischer , @asmith50 - I broke down the RonnieMac account to be super simple in-terms of integration. Let’s discuss quickly because we are going to move forward regardless in the next 30 days. I would prefer this is an integration with Acumatica.  

Are there going to be grouping options, for example a daily import into a single Sales Order?  

We have a few hundred very small orders per day, there’s really not much value in having a sales order for every order since we fulfill using a different system in parallel.  Or at least not a value greater than the cost to upgrade the license to allow for more transactions.  Or will there be a pricing model that helps address that? We also use Shopify with an even greater order volume.  

Hi folks - sorry @meir121218p & @bryanb39 - just saw these two requests.

@meir121218p - when you send the PO to your vendor, the vendor could submit tracking information in the “ref” field which can then be pushed to Amazon. Another option is to set up a custom field, push your info into that field, then map that field to the tracking info in Amazon via the Entities window. Right now PO Receipts don’t 1) have a field for tracking information and 2) we don’t have standard connections between PO Receipts and Shipments. Internally have discussed establishing this relationship for drop ship merchants, but there are some complications we need to overcome.

@bryanb39 & @jamesh - This is a good question and a request we’ve heard from 2 or 3 merchants now. There are a few pieces to this.

1. In this initial phase we are pulling each FBA order in individually. At this time we don’t have it on the timeline/plan to pull FBA orders in via 1 group, but we are discussing if we could make this a configuration option for merchants. Essentially, give the merchant the option to either pull in 1 at a time, or pull in a large group. 
2. Our BA’s gave me feedback that technically (not guaranteed) it should be possible, but it will take some significant updates to the connector to make this possible.
   1. Also, we are now pulling Amazon Fees into Acumatica, and there would be some challenges we’d have to overcome for fee imports and for statement reconciliation. But, again, likely doable.
3. Right now our goals are to complete the remaining phases, take the first 2 dozen or so customers live, then revisit some of the requests which are not initial requirements. So, we could come back to this.
4. That said, we have discussed this with one of our VARs and they mentioned that a customization may be possible to solve this upfront. Again, not “easy” but possible.

FBA Vendor here.  From what im reading is that the Sales Orders will import, but what about all the deductions and fees that get taken out?  

Right now im using their flat file v2, and making a Pivot to create the invoice then, create a credit memo for the deductions. will this be able to handle this process?

@josh.fischer - Please add us to the testing for this connector. 

Thanks!

Hi @lauraj46 - we are intending to keep this in Managed Availability for a while longer, that said, we are happy to work with any Acumatica customer who is or wants to sell on Amazon. We are using managed availability for 2 primary reasons:

1. It’s mainly to ensure that VARs use implementation assist until they are 100% ready to serve customers without any complications. Amazon doesn’t offer test/dev environments, so implementation needs to be handled very carefully.
2. We are wrapping up development on an OAuth connector which will allow merchants to utilize Acumatica’s Amazon Developer Keys. In 2021 we were forced to require customers to get their own keys (which is less than easy) but we’ve overcome the hurdles that made that a requirement. Once customers can use our keys it’ll be much faster/easier for VARs and merchants. 

If you have a customer who is interested in implementing this solution, and they have their Amazon Keys, sign them up for Managed Availability. Won’t commit them to anything, but will give them access to our private forum, and we can work with you and your team to get them onto the calendar and implemented.

Hope that helps