Amazon Connector FAQ

Review the questions and answers below to learn more about the Amazon connector.

How does NetSuite Connector handle Amazon settlement reimbursements?

NetSuite Connector posts reimbursements as cash sales. If Amazon owes you money for the settlement, NetSuite Connector posts it as a cash sale.

If I sync orders from multiple regions, do I need a different MWS token for each Amazon region?

In NetSuite Connector, you must have a separate Amazon connector for each region that you intend to sync. Also, each connector must have its own set of credentials.

However, if you have a unified account in Amazon, NetSuite Connector lets you sync orders for marketplaces in the same region using a single connector. For example, US, Canada, and Mexico for the North American region.

If you want to use product sync for any marketplace in the region other than the primary marketplace, you need a separate connector for that marketplace. You cannot use a unified connector for this case.

Does NetSuite Connector support LTL (Less Than Load, or relatively small) and small parcel?

Yes, FarApp does support LTL and small parcel type of shipments. You'll provide us with a field that indicates the shipment name/type during setup.

Does NetSuite Connector support syncing purchase orders in NetSuite, so that a vendor can ship stock to Amazon on behalf of the client?

Yes, this works similarly to the transfer order functionality except that purchase orders aren't fulfilled in NetSuite.

Which carriers does NetSuite Connector support for FBA Inbound Shipping?

NetSuite Connector supports Amazon's preferred carriers and well as using your own carrier.

Can you include kit items on transfer orders?

NetSuite does not allow you to include kit items on transfer orders. This does not work for kits because cannot inventory the master item. However, assembly items can work as assemblies and have an inventory value unless you disassemble them.

How will NetSuite Connector know where inventory is, what is in your warehouse, what has been already shipped to Amazon, and what is still on the way?

When you created the inventory transfer (either a transfer order or purchase order), the inventory was still in your warehouse. As soon as the inventory transfer is shipped, it takes the inventory out of the available quantity in your warehouse but does not add it to the Amazon warehouse yet. When the receipt is posted against the inventory transfer, the inventory is made available in your Amazon FBA warehouse location in NetSuite. When the transfer is shipped and the receipt is posted, NetSuite will show that inventory in In Transit status. It is still reflected on the books as an asset, but it will not be available at any location. When looking at a specific item you have shipped, NetSuite will show the quantity available at each location as well as that quantity that is in transit. You can view the open transfer or purchase order in the relevant orders screen. In-transit inventory should also be considered like your reorder-point, so NetSuite should not generate further purchase orders simply because the inventory is not in a particular location yet.

What happens when Amazon over- or under-receives inventory that you sent?

When Amazon under-receives inventory, NetSuite Connector posts an item receipt to NetSuite for the lower amount reported by Amazon. When Amazon over-receives, NetSuite Connector tries to sync the quantity that Amazon reported, which causes NetSuite to generate an error. In this scenario, the customer will get an error, which should be clarified with Amazon.

Can NetSuite Connector sync partial receipts?

If the useItemCostAsTransferCost field on your transfer order is set to false and there are multiple line items on the transfer order, NetSuite Connector can sync item receipts to partially receive the transfer order. However, you cannot partially receive a line item.

Why is pricing information not associated with pending Amazon orders?

Amazon pending orders do not contain complete order information when they are posted to NetSuite.

How are Merchant Fulfilled Network (MFN) and Fulfillment By Amazon (FBA) accounts handled differently?

Following are the differences between MFN and FBA account handling:

Listing items and/or inventory: NetSuite Connector can list MFN and FBA items under a single Amazon account or an account can be dedicated to merely MFN or merely FBA items. Listing FBA items is quite similar to listing MFN items, except that NetSuite Connector does not sync inventory or fulfillment latency, and toggles the fulfillment center ID to indicate it's an FBA item.
Importing orders:
- MFN orders are imported as sales orders as soon as they've been paid in Amazon.
- FBA orders are imported as soon as they have been shipped by Amazon. The orders are imported as cash sales since they don't require fulfillment. Cash sales also commit inventory immediately.
FBA Inventory:
- (NetSuite specific) You should create an Amazon location in NetSuite and let FarApp know the location. FarApp will import cash sales against this location so that the inventory in this location in NetSuite matches the inventory in Amazon's warehouse.
- NetSuite Connector can also perform inventory adjustments if necessary using inventory changes in Amazon. This is an additional sync for which additional charges may be apply. For more information, contact NetSuite Customer Support.
What happens when an order contains both MFN and FBA items?

In cases like this, Amazon will automatically split the order so that MFN items appear together on one order and FBA items will appear together on a second order. This occurs prior to syncing the order to NetSuite Connector. After Amazon splits the order, NetSuite Connector will then import both orders separately so that they are designated MFN and FBA accordingly.
Does NetSuite Connector handle my inbound shipments to Amazon for FBA?

Yes, NetSuite Connector provides support for this as an add-on feature for which additional charges may apply. By default, this feature will function as follows:
- You create a transfer order to replicate the shipping plan you create in Amazon.
- You place the shipment ID in a designated field on the transfer order.
- You create an item fulfillment for the transfer order to represent the shipment to Amazon.
- NetSuite Connector checks if Amazon has received the items. When Amazon reports received amounts, NetSuite Connector creates item receipt records for those items.

What happens when an order contains both MFN and FBA items?

In cases like this, Amazon will automatically split the order so that MFN items appear together on one order and FBA items will appear together on a second order. This occurs prior to syncing the order to NetSuite Connector. After Amazon splits the order, NetSuite Connector will then import both orders separately so that they are designated MFN and FBA accordingly.

Does NetSuite Connector handle inbound shipments to Amazon for FBA?

Yes, NetSuite Connector provides support for this as an add-on feature. By default, this will function as follows:

You will create a transfer order to indicate what items you'll be sending to Amazon. FarApp will let Amazon know what items are being shipped.
Amazon will indicate where to ship the items. NetSuite Connector will sync this information back so that you can create your shipping labels.
As soon as you ship your items, NetSuite Connector will sync the shipping details to Amazon.
When Amazon receives the items, NetSuite Connector will sync those details back to the transfer order in your system.

When an Amazon order has multiple tracking numbers, why is only a single tracking number sent to Amazon?

Sometimes, clients will create multiple shipments for a single item on an Amazon order in NetSuite. There are a few reasons for this, but the most common is when the item in question is a kit item that is actually composed of other items. In these cases, clients may have a fulfillment, shipment, and tracking number for each component item of the kit. However, Amazon will only accept a single tracking number for a single item in the order. This is not a NetSuite Connector restriction and any additional tracking numbers that are sent to Amazon are simply ignored.

Which field in the marketplace or cart does the field in NetSuite Connector product mappings correspond to?

Data fields will often have two names or identifications. One is used for low level processes like sending and receiving data through the API, and the other is used when displaying the data to the user. For example, a custom field in NetSuite will have an ID field and Description. When viewing that custom field on NetSuite forms, the description is a better identifier than the field ID.

The field name displayed in NetSuite Connector Product Mappings is the name of the field that the marketplace or cart accepts data in, but that name may not always be the same as the name displayed for products in your marketplace or cart. For example, the field Item Description in Shopify needs to be sent to a field named body_html through the API.

NetSuite Connector provides a tooltip for each field that will either give you the name of the field in the marketplace or cart or a short description. The tooltip displays when you hover the mouse on the marketplace or cart field name on the Product Mappings page.

Amazon Fulfilment By Amazon (FBA) FAQ

Review the questions and answers below to learn more about fulfillment by Amazon and NetSuite Connector.

Can NetSuite Connector map the shipping date on Amazon FBA orders?

No. The shipping date on Amazon orders is not available through API so NetSuite Connector cannot map the shipping date to NetSuite.

Can NetSuite Connector post FBA inventory to NetSuite

Yes. For more information, read Amazon Inventory Adjustment FAQ.

Can I post my Amazon FBA orders as sales orders?

No. Amazon fulfills Amazon FBA orders, so fulfillment is not necessary for such orders. Cash sales in NetSuite do not require fulfillment. Therefore, NetSuite Connector posts the Amazon FBA orders as cash sales instead of sales orders.

Why are names and addresses missing from FBA orders?

For security reasons, Amazon does not provide the buyer's name and address for FBA orders when those orders are retrieved through their API. If Amazon does not provide the data, NetSuite Connector cannot send that information to NetSuite. Since Amazon is fulfilling the orders on your behalf, complete customer information is not necessary for the order. The FBA orders should be posted to a fixed customer in NetSuite. For more information, see Managing Fulfillment by Amazon (FBA) Items in NetSuite Connector.

Why does NetSuite Connector post FBA orders as cash sales?

FBA orders are fulfilled by Amazon using inventory for the various products that you have already shipped to Amazon to store and fulfill orders on your behalf. Because FBA orders do not require you to directly fulfill them, they can be treated as already fulfilled. By default, NetSuite Connector will post these orders to NetSuite as cash sales, because unlike sales orders, cash sales do not require fulfillment.

I am using Amazon FBA as a 3PL to ship my non-Amazon, like ecommerce or other orders. Does NetSuite Connector handle this?

Yes, NetSuite Connector supports this feature but additional charges may apply. For more information, contact NetSuite Customer Support. Your non-Amazon orders will first sync to NetSuite. NetSuite Connector retrieves them from your system and syncs them to Amazon FBA for shipping. When they are shipped, NetSuite Connector syncs the shipping details back to your system. From there, if the orders originated in a marketplace or cart connected to your system through NetSuite Connector, the shipping details will sync to the marketplace or cart.

NetSuite Connector can filter which orders are synced to Amazon MCF (Multi-Channel Fulfillment) for fulfillment. Contact NetSuite Customer Support and send the criteria you want to use to filter the orders. For example, a location or a setting, and support will set it up.

Does inventory in a transfer state for FBA shows as available in NetSuite? Can we sync the quantity in reserve instead of the quantity available?

No. The in-transit NetSuite Connector inventory is not made available to NetSuite Connector by Amazon. Amazon does not consider the in-transit quantity as available FBA stock until that transfer has completed. NetSuite Connector is given the quantity value by Amazon, and the value passed is the available quantity. NetSuite Connector cannot map the reserved quantity because Amazon does not consider that amount available. That amount is usually in transit between Amazon warehouses and can take some time to become available. When Amazon considers that quantity as available and if using Amazon FBA inventory adjustment sync, NetSuite Connector can sync the quantity at that point. For more information, see this Amazon community help document where other sellers discuss the concept: https://sellercentral.amazon.com/forums/t/fba-inventory-quantity-available-vs-reserved/359398

Amazon Settlement Sync FAQ

The following are some frequently asked questions about Amazon settlement sync.

How do I set up Amazon Settlement Sync for NetSuite Connector?

For setup and charges for Amazon settlement sync, contact NetSuite Customer Support.

Where are the settings for settlement sync and what do they men?

For information about settlement sync settings, read Amazon Settlement Sync Settings in NetSuite Connector.

Can NetSuite Connector post FBA inventory adjustments to NetSuite?

Yes, you can use the Amazon Inventory Adjustment sync to update the FBA items inventory levels in NetSuite to reflect the availability in the Amazon warehouses.

What happens if I deposit an order in one NetSuite accounting period but it is not settled until a new NetSuite accounting period?

The leading practice is to wait to deposit payments on orders and hold cash sales in Undeposited Funds until Amazon settles or reconciles the period for the order. Alternatively, to deposit orders in the period they were placed and not when they were settled or reconciled, post the order modifications and refunds as summary transactions for an entire settlement report. You can then split those summary transactions and the non-order modifications summary transactions, across months.

To merge order modifications or refunds into a single summary transaction:

Go to Settings > Other Transactions, and click the Settlement tab.
Click Advanced Options.
Check the following boxes as required:
- Merge All Refunds on Report into a Single Summary Refund
- Merge All Order Fees into a Single Transaction
- When Posting Summary Transactions, Split them into Two Transactions if They Span Two Months
Click Save.

When recording refunds with Amazon Settlement sync, how does NetSuite Connector differentiate between a partial refund as a customer concession and a full refund for a returned product?

Amazon Settlement Reports may sometimes indicate that a refund was given for a specific SKU, when in fact it was a partial refund and the item was not returned to inventory. This is completely on Amazon's end. If Amazon is reporting a refund for a specific SKU, NetSuite Connector has no way of detecting if it should be a partial refund.

Does NetSuite Connector clear transactions when processing settlement reports, or do I need to reconcile them?

The transactions are posted as cash refunds or cash sales, which are already billed records in NetSuite. Therefore, you do not need to do any billing.

Amazon gives a financial concession to a customer or to us for an SKU on a settlement, and NetSuite Connector puts that as a cash refund using that SKU. Will NetSuite increase the quantity to incorrectly change the inventory totals?

A concession or similar entity is posted as an adjustment to the original transaction but does not affect the inventory for any SKU on the order. For more information, read Concession and Refund Handling in NetSuite Connector

If an order has been already invoiced, how does NetSuite Connector post modifications to that order?

Settlement fees and credits are synced to the billed record of the order, if available. If an order has not been invoiced yet, NetSuite Connector posts the changes to the original sales order. For more information, read Managing Amazon Settlement Sync on NetSuite Connector.

Why is the REVERSAL_REIMBURSEMENT SKU importing individually as a cash refund?

NetSuite Connector sometimes creates a new Cash Refund record with the settlement fee, instead of adding the fee as part of the original cash sale. For more information, read Why was a settlement fee added in a new cash refund instead of adding the fee as part of the original cash sale?.

How can I tell which fees will post as part of the order modifications and which will post as part of the non-order modifications?

NetSuite Connector includes any fee that has an order ID associated with it as an order modification. For more information, read Identifying Settlement Fees Posted As Order Modifications.

Why is NetSuite applying tax to my settlement items?

NetSuite is applying tax mostly because the item is not assigned to a nontaxable tax schedule.

Why do I see the same fee multiple times on one order?

There are some fee types that Amazon will charge multiple times per order. Commission is one example. If an order has five items, each will have a commission fee. You will not see a single line item that is the sum of all the item commissions; instead, there will be five different commission fees. Other fees work similarly.

Why was a settlement fee added in a new cash refund instead of adding the fee as part of the original cash sale?

NetSuite Connector sometimes creates a new Cash Refund record with the settlement fee, instead of adding the fee as part of the original cash sale. This new record is created if NetSuite Connector detects that the original cash sale has already been deposited. Another reason is that NetSuite would not allow it to add an item to the cash sale, because the order may already be refunded, or the order has a return authorization.

How do I view or download settlement reports in Amazon?

To view or download the settlement reports in Amazon, read the SuiteAnswers article View/Download Settlement Reports in Amazon.

Can NetSuite Connector combine all my settlement fees and credits from a settlement report into a single transaction line with the sum of the quantity and amount fields?

NetSuite Connector does not support combining different fees into a single line item whose quantity and total are the sum of the fee for the entire report. NetSuite Connector supports a single transaction for the entire report but fees or credits are not combined. For more information, read Importing Amazon Settlement Reports in NetSuite Connector.

How can I set NetSuite Connector to automatically create the other charge for sale items during settlement sync?

Read Importing Amazon Settlement Reports in NetSuite Connector.

How long does NetSuite Connector store Amazon settlement reports?

NetSuite Connector stores only the most recent three months of settlement reports.

Does NetSuite Connector sync settlement reports?

Yes. For more information, read Importing Amazon Settlement Reports in NetSuite Connector.

Can I summarize all fees in one transaction for each settlement or two transactions for those periods that span two months?

Yes. To enable summarizing fees into one transaction per settlement on your account, contact NetSuite Customer Support.

You can get the lump sum fees for each settlement period.

Note:

This feature does not combine each fee into a multiple quantity single line entry. For example, if two orders in the settlement have an FBAPerUnitFulfillmentFee SKU, you will see two line items with a quantity of one for each fee. You will also see the fee amount from each order. However, you will not see a single line item with two quantity and the sum of the fee from both orders.

Amazon Seller Fulfilled Prime (SFP) FAQ

Review the questions and answers below to learn more about Amazon seller fulfilled prime and NetSuite Connector.

Do SFP orders import as cash sales or sales orders?

NetSuite Connector imports SFP orders as sales orders because they need to be fulfilled in NetSuite.

Does NetSuite Connector automatically mark orders as shipped in NetSuite?

No, NetSuite Connector does not mark the orders as fulfilled because NetSuite Connector does not know if the order was shipped. NetSuite Connector only sends the labels to NetSuite. After the order is shipped, you should fulfill the order.

I have a ShipStation connector with NetSuite Connector. What does the flow look like with ShipStation involved?

The labels for SFP orders should be printed out directly from NetSuite and not from ShipStation. The SFP orders will be filtered out of the ShipStation connector.

Amazon Inventory Adjustment FAQ

Does NetSuite Connector sync quantity available or quantity on hand?

By default, NetSuite Connector compares the quantity on hand. However, if you want NetSuite Connector to compare quantity available, contact NetSuite Customer Support.

Does inventory adjustment work with custom record alias SKUs?

Inventory adjustments do not work with custom record alias SKUs. If you want to have both alias SKUs and inventory adjustment, you need to ensure that the FBA item is set up as the inventory item in NetSuite and the other item, which is most likely an MFN item, is set up as the custom record alias.

Are kits included in inventory adjustments?

Kits are included in inventory adjustments because they are treated as inventory items in Amazon.