Is there any inexpensive connector for Amazon? Reconciliation of payments is a pain.

Most of the main players have a prebuilt one (ie Celigo, Workato, Boomi, etc). I think NetSuite has one now too (used to be FarApp)

I developed a script that processes settlement files from Amazon. The settlement records contain data for both FBM and FBA orders, charges and fees as well as returns/refunds.

Thank you both. @Eric B, at a high level, are you able to share how records are processed? Do you use SOs? Or just standalone cash sales or standalone invoices? How do you record the fees? Via JE? How do you record the payment? Via cash sale? Customer payment? JE?

Using the example of FBA orders, the orders are brought into custom records and then processed with an MR script to generate SOs and then generate IFs and then Invoices and consequently Payments are generated to complete the loop. Charges and Fees are then reconciled from the Settlement records via JEs against the Amazon Order IDs.

Thank you. Any reason why you had to use custom records instead of SOs directly?

It’s basically a design philosophy/approach that allows for a little more robust testing of the data before creating the actual SO records. If the data import is messed up there is no need to delete SO records and when creating SOs, you can test incrementally.