How to Import Amazon Orders into Acumatica
How to Import Amazon Orders into Acumatica
Importing Amazon orders into Acumatica starts by retrieving orders for a selected Amazon store and date range, reviewing the records, and importing selected orders as the document type configured for that store. The Amazon Connector can create either sales orders or invoices for Fulfillment by Merchant orders, while Fulfillment by Amazon orders are imported as invoices.
This guide follows the documented order-import workflow and focuses on the settings, document triggers, mapping rules, validation points, and exceptions that determine the result. The Biz-Tech Services Amazon Acumatica Connector keeps the work inside dedicated Amazon Store and processing screens so users can review an order before creating its Acumatica document.
Before You Start: What Must Be Configured
Before retrieving an order, the Amazon Connector package must be installed and published in Acumatica, and an Amazon Store record must identify the store. The Connection Settings tab must contain the credentials and marketplace information required for the connection through the Biz-Tech Services intermediate server. The Biz-Tech Services Acumatica Amazon Connector also relies on the import defaults and mappings described below.
1. Store Code identifies the corresponding Amazon store. A store marked Default Store appears automatically when users open processing and store screens.
2. Import Amazon Orders determines where Fulfillment by Merchant, or FBM, orders are imported in Acumatica.
3. Order Type supplies the default order type created by the integration.
4. Import Customer decides whether the connector creates a new customer from Amazon data or uses the default customer.
5. Import Item decides whether a missing Amazon product can create a new Acumatica inventory item. If this option is cleared and the item does not exist, the documentation says the integration produces an error.
6. Warehouse ID and Unit of Measure, or UOM, provide order-line defaults.
7. Taxable Category, Customer Tax Zone, and Tax ID provide the documented tax defaults.
8. Payment Method provides the default payment method for new customer records created from imported orders.
9. Cross-Reference Options determine which entities are matched between Amazon and Acumatica, including items, payments, and Ship Via values.
For a deeper explanation of the full inbound and outbound lifecycle, refer to the sibling article How Amazon FBA and FBM Data Flows into Acumatica ERP. The present guide stays centered on the operator steps and decisions that create the order document.
How to Import Amazon Orders into Acumatica, Step by Step
The Biz-Tech Services Amazon Acumatica Integration separates retrieval from import. That separation gives the user a review point before Acumatica creates a sales order or invoice.
Step 1: Retrieve orders for the correct store and dates
Open Import Amazon Orders, select the Store Code, and use Start Date and End Date to define the retrieval period. Click GET ORDERS. A timer reports elapsed time while the connector retrieves orders, and the loading icon next to the timer can cancel the retrieval. The resulting grid can contain every order found in the selected period, so confirm the dates before continuing.
Step 2: Review the retrieved Amazon orders
Inspect the grid and decide which orders should be imported. Click an Order Number to open the corresponding record in the Amazon Orders pop-up. This screen shows the important order information and is also where the documentation says an import error message can identify what must be corrected and in which system.
Step 3: Select individual orders or prepare a full batch
Select the checkbox for each required order when you want a controlled batch. Use IMPORT ALL only when every retrieved order in the grid is ready. Reviewing individual records first is especially important when item creation, customer creation, address overrides, or cross-references may produce different results across the batch.
Step 4: Run the import
Click IMPORT for the selected records, or click IMPORT ALL for the entire grid. After IMPORT is pressed, the screen filters out unselected orders. The process can be canceled by closing it, as described in the manual.
Step 5: Confirm the created Acumatica document
Open the created record and verify its type, customer, lines, warehouse, tax, payment, shipping, and address information. For FBM orders, the configured destination and Order Type decide whether the integration creates a sales order or an invoice. For Fulfillment by Amazon, or FBA, the FBA settings specify an Invoice Type, and the Import FBA Orders process creates an invoice displayed on the Sales Orders Invoice screen.
Document Triggers: What Each Action Creates
GET ORDERS retrieves Amazon records into the processing grid; it does not by itself create the final Acumatica order document. IMPORT or IMPORT ALL triggers creation for the selected retrieved records. The result depends on the store configuration and fulfillment channel.
1. FBM import can create a sales order or invoice, according to the Import Amazon Orders destination and configured Order Type.
2. FBA order import creates an invoice based on the configured FBA Invoice Type.
3. Import Customer can create a new customer when no matching customer exists; otherwise the default customer is used when that option is cleared.
4. Import Item can create a missing inventory item from the Amazon product SKU. When it is cleared, a missing item stops the import with an error.
5. An imported item uses the Amazon item price on the order rather than the mapped Acumatica item price.
6. Insert Item in Inventory Details Tab adds retrieved items to the Amazon Store Inventory Details tab during order import.
The import is only the first document event in the FBM lifecycle. After an imported sales order is acknowledged, users can create a shipment, confirm it with Ship Via, package, and tracking information, prepare an invoice, and release the invoice. Those later actions drive acknowledgement and fulfillment communication back to Amazon, but they are separate from the initial order import.
Mapping Rules That Decide What Appears on the Order
The Biz-Tech Services Acumatica Amazon Integration applies store defaults and cross-references while creating the Acumatica document. Review these rules before treating a successful import as complete.
Customer and address rules
When Import Customer is selected, customer information from Amazon can create a new Acumatica customer. When it is not selected, the connector uses the default customer. Override Ship Address Information from Amazon Order brings in the shipping destination from Amazon, and Override Bill Address Information from Amazon Order brings in the billing address. The manual does not provide a complete decision table for every combination, so test the chosen configuration with a controlled order before processing a large batch.
Item, price, warehouse, and UOM rules
The connector matches products through the configured item cross-reference and Inventory Details mappings. A missing product can be created from the SKU only when Import Item is selected. The order line uses the Amazon item title as its description even when an existing stock item description is not updated. The imported line uses the Amazon price, while Warehouse ID and UOM provide defaults.
Tax, payment, and shipping rules
The store settings provide Taxable Category, Customer Tax Zone, Tax ID, and Payment Method values for the import. Cross-reference selections control which Amazon values match Acumatica values. The manual specifically notes that the mapped Amazon Ship Via value should appear in Delivery Settings on the Shipping tab of the Sales Orders screen after import.
FBA-specific rules
FBA orders use a required default customer and the configured Invoice Type. If Import Amazon FBA Payment is selected, a payment-method field becomes available for the imported FBA order. The FBA status mapping table determines which Amazon order statuses are eligible for retrieval and import, and the Begin Order Date limits the retrieval window.
Validation and Common Exceptions
A completed process is not enough by itself; validate the generated document against the Amazon record and the store settings. The manual documents where errors appear but does not list all possible error messages.
1. If an order line shows an error in the import grid, hover over the red cross for additional information.
2. Open the Amazon Orders record to see the error message and the system in which the correction is required.
3. Use TOOLS > Trace for more detail when the grid message is not sufficient.
4. If a product does not exist and Import Item is cleared, correct the item mapping or configuration before retrying.
5. If Ship Via is wrong or blank, review Cross-Reference Options and the Amazon-to-Acumatica value mapping.
6. If the wrong customer appears, check Import Customer and the default customer setting.
7. If the wrong document type appears, review Import Amazon Orders, Order Type, and, for FBA, Invoice Type.
8. If an expected FBA order is missing, verify Begin Order Date and the selected Amazon status mappings.
The Send Email Notifications for Errors option can send notifications that identify Order IDs with errors. Because the source does not document a complete error-message catalog, use the order record, the grid indicator, and Trace rather than relying on guessed error text.
Where to Check Your Work
After the import, the Biz-Tech Services Amazon Acumatica Integrator exposes the most useful checks across the processing grid, Amazon order record, store configuration, and created Acumatica document.
1. Import Amazon Orders: confirm Store Code, Start Date, End Date, retrieved rows, and the import result.
2. Amazon Orders: open the Order Number and review the source details and any displayed error message.
3. Amazon Store - FBM Settings: verify Import Amazon Orders, Order Type, Last Imported Order Date, customer options, item options, warehouse, UOM, tax, and payment defaults.
4. Amazon Store - Cross-Reference: verify the Field, Amazon Value, and Acumatica Value pairs used by the order.
5. Amazon Store - Inventory Details: verify the Amazon SKU to Acumatica inventory mapping.
6. Sales Orders - Shipping tab: confirm the Ship Via result under Delivery Settings.
7. Created sales order or invoice: compare customer, addresses, lines, descriptions, quantities, prices, warehouse, taxes, and payment information with the Amazon order.
8. Import FBA Orders: confirm eligible statuses, retrieved FBA orders, and the resulting invoice.
9. FBM & FBA Orders: use the Fulfillment Channel field to distinguish how the order was fulfilled.
10. TOOLS > Trace: inspect technical details for a failed processing record.
How to Import Amazon Orders into Acumatica: Frequently Asked Questions
Can Amazon orders be imported as sales orders or invoices?
Yes. The documented FBM settings allow Amazon orders to be imported as a sales order or invoice document type, according to the configured destination and Order Type. FBA order import creates an invoice using the FBA Invoice Type.
What is the difference between GET ORDERS and IMPORT?
GET ORDERS retrieves records for the selected Store Code and date range into the grid. IMPORT creates Acumatica documents for selected records, while IMPORT ALL processes every retrieved record shown in the grid.
Why did an Amazon order fail because of an item?
A documented cause is a product that does not exist in Acumatica when Import Item is not selected. Review the Inventory Details mapping and the Import Item option, then use the red-cross details or TOOLS > Trace to confirm the actual cause before retrying.
Where can I see an Amazon order import error?
The error appears on the corresponding grid line, with more information available by hovering over the red cross. The Amazon Orders screen can also display the message, and TOOLS > Trace provides additional diagnostic detail.
Why did the imported order use the default customer?
When Import Customer is not selected, the connector imports the order with the default customer. The Biz-Tech Services Acumatica Amazon Integrator creates a new customer from Amazon information only when Import Customer is selected and the workflow requires a new customer record.
Why is the Ship Via value wrong after import?
Review the selected Cross-Reference Options and the Amazon-to-Acumatica carrier mapping. The mapped value should appear in Delivery Settings on the Shipping tab of the Sales Orders screen.
Why is an FBA order not available to import?
Check the FBA Begin Order Date and the status mapping table. The documentation states that the corresponding Order Status checkbox must be selected for the order to be retrieved and imported.
Does importing an Amazon order also send fulfillment?
No. Order import creates the configured Acumatica document. Fulfillment is a later FBM process involving shipment creation, shipment confirmation, invoice preparation, and either the automatic flow or the Export Amazon Fulfillments processing screen.
Work With the Biz-Tech Services Amazon Connector
A reliable Amazon order import begins with the store defaults and mappings, continues through separate retrieval and review steps, and ends with validation of the created Acumatica document. Use a controlled test order to confirm customer, item, address, tax, payment, warehouse, and document-type behavior before increasing batch size.
If your team needs help configuring or validating Amazon order imports, work with the Biz-Tech Services Acumatica Amazon Integration team. Visit https://biz-techservices.com to learn how the Biz-Tech Services Amazon Acumatica Integrator can support your Acumatica and Amazon workflow.
Check the video for more details - https://www.youtube.com/watch?v=N8bnQS5EKTw
