Reporting sales order status is only possible with FBM, and only open and unshipped sales orders are reported back to Amazon.
For FBA and FBM, it is possible to automatically upload invoices to Amazon starting with version 20.1. To enable the invoice upload service, check the Use invoice upload service checkbox. The time trigger for uploading the invoice is the arrival of the shipping information (tracking number) in Xentral. In addition, you can set a time difference to ensure that invoices are loaded to Amazon after a defined number of days at the latest, even if no tracking code has been received. Note that only invoices that have “sent” status are uploaded. You can also set this via the project settings or when creating invoices from the Transfer module.
With the help of the date in the field "Upload start date" you can also retroactively transfer already created invoices to Amazon.
The following explains how to create invoices and credits for Amazon in Xentral.
Amazon offers the possibility to have invoices and credit notes created directly by Amazon (VAT Service). This means that the data for the invoice (invoice number, VAT, amounts, etc.) comes from Amazon and not from Xentral. If you want to create the invoices and credit notes based on the VAT Service also in Xentral, up to version 20.2 our Amazon Seller App was necessary. From version 20.3 onwards you no longer need it for the use of the Amazon VAT Service. If you use the VAT Service you do not need a V2 report. If you use the VAT Service from Amazon, do not create invoices or credit notes for the corresponding sales orders in Xentral, as these are transferred from Amazon.
Note
In Xentral, you can only map the normal Amazon VAT service, but not the Amazon VAT service light. With the VAT service light, only the calculation of VAT is handled by Amazon, whereas the invoice must be created by the customer himself and uploaded to Amazon.
You have the option to create invoices and credit notes from the sales orders in Xentral.
You can also avoid generating invoices and credit notes for imported sales orders, for example if you use Amainvoice or Amazon VAT Service to create invoices.
The V2 billing report is required to create FBA credits, and if the V2 billing report does not exist in your Amazon account, you must have it activated through Amazon Customer Support.
Note
Credits are created by default with the payment date, not the import date.
In order to ensure a distinction between FBA and FBM products for Amazon, it is imperative that you maintain the external product numbers correctly. For Amazon FBA products, you must use the designation SKU_FBA and for FBM products, the designation SKU_FBM. In the tab External Product Number in the product master data, you must enter the corresponding Amazon SKU and select the Amazon interface as a shop. Instructions for importing external product numbers can be found here.
You can also offer an product as an FBA and FBM product by using the "Add another state" option on Amazon.
It's important that you don't switch back and forth between "Shipping by Seller" and "Shipping by Amazon" frequently with the offers and the associated item, but always add another state to it.
With Xentral, you can create products in Amazon. After linking to the marketplace, another Amazon Settings button will appear, where you can fill in various settings. Essentially, you can fill in "Basic Data" (or are passed on by Xentral). Additionally, you will need to select a category, whereupon other Amazon-specific mandatory fields will appear.
Minimal is supported by Xentral:
-
Product name
-
Bulletpoints
-
Weight
-
EAN
-
Product description
-
Product size
You can no longer create products directly in the product master data as before, but as follows:
-
You can access the Amazon Importer via Administration > Shop Interface > *Amazon*.
-
Then click on the tab Create product (BETA)
-
There you click on +New entry
-
Select the appropriate flat file (template) and click the Next button
-
Now enter the product number in the "Product" field in the overview that appears and wait for the result
-
Currently the product data is not yet loaded into the form, but must be entered manually (beta).
-
The displayed product is to be added via the Save button at the end of the field
There is a section in the System Health app that lets you monitor the status of your Amazon interface and Seller Central account, and you can find the System Health app as follows:
-
In Xentral NextGen: Administration menu > System messages
-
Classic Design: At the top of the page next to the search bar
The app displays the following for Amazon in the Online Stores section:
-
sellingPartnerApiRefreshToken
This message appears when one of your Amazon Shop interfaces has been disabled due to an empty token. The affected Shop ID is displayed in square brackets, e.g. Sales Channel [12].
-
Amazon_shopID_MarketplaceID
This message will give you information about the current state of your Amazon Seller Central account. Each Marketplace ID will have its own entry that looks something like this: Amazon_1_A1PA6795UKMFR9, where the values for the Shop ID and Marketplace ID may differ.
The message is structured as follows: [Marketplace ID] from sales channel [x] is [Status].
-
The [Marketplace ID] lets you see which of your marketplaces is affected. For example, the Marketplace ID for Germany is A1PA6795UKMFR9.
-
The [x] after sales channel shows the shop ID of the affected shop-importer in Xentral. All shop IDs are displayed on the far left of the overview table of the online shops app.
-
The [Status] field can have the following three statuses:
Status in Xentral
Status in Amazon API
ok
Normal
warning
At risk
error
Deactivated
If you receive a message other than "ok," please check your Amazon Seller Central account to identify the issue. Your account may be considered vulnerable if you fall under Amazon's performance guidelines due to a negative customer review, for example.
-
Shadow offers at Amazon occur when an FBM offer is converted to an FBA offer without the stock being set to zero beforehand.
Similarly, a shadow supply can arise if new stocks are transferred for an FBA supply.
Another possibility is that the wrong external product number designation was selected in the external product numbers tab, for example if the designation SKU_FBM is used for an FBA offer.
Valid values for the external product number designations are exclusively:
-
SKU_FBM
-
SKU_FBA
Follow these steps to delete shadow offers:
-
Navigate to Amazon Seller Central > Stock > Manage Stock.
-
In the upper search box, enter the appropriate ASIN and click Search.
-
On the right side you will see a small box next to Edit with an up arrow and a down arrow. Click on this small box.
-
Select the option Change to shipping by seller. This change may take a few minutes due to the system. Please be patient.
-
Cancel any open shipping through merchant sales orders (FBM) that you cannot or do not want to fulfill, otherwise this inventory will reappear in the system. This change may take a few minutes due to the system. Please be patient here as well.
-
Set the stock of the offer to 0.
-
Convert the offer back to Amazon (FBA) shipping by using the Change to shipping by Amazon option.
By removing the stock, as well as by back and forth conversion, the shadow supply in the system is removed.
If the import of sales orders does not work properly, please check the following:
-
Does the shop-import process launcher show an error? If so, restart the process launcher. The Amazon process launcher is not relevant for importing jobs.
-
Are there any corrupt or locked jobs in the intermediate table? You can check the intermediate table by clicking on Shopimport intermediate table in your Amazon interface.
-
Does the problem occur on a specific date? Change the import date to a newer date and set the import mode to Manual (with Import Center). If this works, set an earlier date and repeat the process until an error occurs in the import process.
Check that day's sales orders in your Amazon Seller Central.
If certain information is missing from the sales order, not all relevant information may be included in Amazon’s report, e.g. if the billing and shipping addresses are different.
Follow these steps to add more information to the report:
-
Log into your Amazon Seller Central.
-
Navigate to Sales Orders > Sales Order Reports .
-
Click Add or Remove Columns in the sales order report.
-
Activate the corresponding column. In case of missing billing address. activate billing in the Optional Columns area.
Note
Not all optional information can be transferred from Amazon to Xentral, as the information may not have an equivalent in the system.
The information is now added to all new jobs. It cannot be added to old jobs after the event.