Automated Amazon Order Sync to Xero Invoices (Make.com)

1. **Create a New Scenario**: In Make.com, click 'Create a new scenario' and add the **Amazon Seller Central** module. 2. **Configure Amazon Trigger**: Select 'Watch Orders'. Create a connection using your Seller ID and AWS credentials. Set the 'Order Status' filter to 'Shipped' to ensure only finalized revenue is synced. 3. **Add a Router**: Add a Router module to check if the order has been processed previously to prevent double-entry. 4. **Handle Multi-Line Items (Iterator)**: Amazon orders often contain multiple products. Connect an **Iterator** module to the 'OrderItems' bundle. This breaks the order into individual units for granular mapping. 5. **Xero Contact Lookup**: Add a **Xero** 'Search Contacts' module. Search by 'Amazon Customer' or specific email. Follow this with a 'Create a Contact' module using an IF-ELSE filter (or 'Get or Create' logic) to ensure the invoice has a recipient. 6. **Transform Data (Array Aggregator)**: This is crucial for Xero. Connect an **Array Aggregator**. Set the Source Module as the Iterator and the Target structure as 'Xero: Create an Invoice - Line Items'. Map the SKU, Quantity, and Price here. 7. **Map to Xero Invoice**: Add the **Xero** 'Create an Invoice' module. Map the 'Total Amount' and 'Date'. Use the aggregated array from the previous step to populate the line items. 8. **Tax Logic**: Use Make.com's `if()` and `contains()` functions in the Tax Type field to map Amazon's 'ShipToState' to the corresponding Xero Tax Rate codes. 9. **Error Handling**: Right-click the Xero module and select 'Add error handler'. Use a 'Break' or 'Ignore' directive to manage API rate limits or invalid address formats without stopping the entire scenario. 10. **Save and Schedule**: Set the scenario to run every 15 minutes or hourly depending on your volume requirements.