pixi
Ask AI
What's an 'Ideas Portal'?
DE

Amazon Invoice Document Upload

Invoice Document Upload ("IDU") ensures that invoice documents created in pixi are uploaded to Amazon, verified and assigned to the appropriate order.

Credit documents will also be uploaded. An additional configuration is not necessary. It only has to be ensured that the PDF file associated with the credit is available on the document storage.

Notes:
- Invoices and credits must be available as a PDF file on the document storage before the planned upload starts.
It is important that the documents are uploaded as soon as possible after creation.
If the upload attempt to Amazon has already been made and there is no PDF file available, the invoice will not be uploaded and the upload attempt will fail. Currently, the upload to Amazon cannot be triggered again manually!
This is particularly important for credit notes that are created via the pixi Web, since in this case no automatic printing is triggered.

Info: If you do not dare to do the setup yourself, what to do first and / or how to do so, you can confidently turn to our account management and have the general setup or individual steps charged for a fee. Depending on the prerequisites already fulfilled, we offer you various packages.


Requirements

pixi Version

Your pixi database at least needs to be updated to pixi 19.12.
Please schedule an update appointment with the Support department (over-night or with a fixed date), if you don't fulfill this requirement.


Configuration

Shop Interface

The Amazon order no. (e.g. 028-6542021-8485122) has to be imported to pixi so that we can use it for the matching and the invoice upload. The matching also works if a prefix is used (e.g. Prefix_AmazonOrder No. - 12345_028-6542021-8485122).

Warning: If this is not currently handed over to pixi, the respective shop interface must first be adapted and expanded.


PDF Invoices

The PDF document storage is configured and the following settings are properly set:

  • pixi Control Center
    Save PDF Invoices/Reminders to Document Storage
    Delete PDF Invoice/Reminder Documents after X Days

  • pixi Invoices
    Save invoice as PDF to document storage

You can find additional information here: PDF Invoices


At least one PDF invoice template is available which is also used for Auto E-mail attachments.

  • If you only have one shop, you don't need the Printing Rule setup.
    You need to duplicate the main template, e.g. "noreport.rtm" -> "noreport_PDF.rtm" or "XYZ.rtm" -> "XYZ_PDF.rtm".

  • If all shops were set up to use the same template (e.g. "noreport.rtm"), the required template to upload documents to the document storage is "noreport_PDF.rtm". In this case, you don't need the Printing Rule setup.

  • If you have not activated any Printing Rules, but the templates are configured as follows, you don't need to set up the printing rules:

    • Client/shop ABC = ABC.rtm & ABC_PDF.rtm

    • Client/shop XYZ = XYZ.rtm & XYZ_PDF.rtm

  • If you want to use different templates for your shops or do this already and would like to use a separate template for each shop (or payment type) for which the Amazon invoice upload is to be used, you need to set up the printing rules.

You can find additional information here: Using PDF Invoice Templates


pixi Messaging

pixi Messaging as well as the event InvoiceCreated are enabled.
pixi Messaging will be enabled for all customers that already approached us. There will not be extra costs.

You can find additional information here: pixi Messaging


Channel Settings in pixi Control Center

The Amazon Seller Service was created as a separate channel in the Control Center. This represents the connection to the Seller Central via the SP-Api Authentication.

A new connection needs to be set up under Import and Export > Options... > Integrations & Import/Export > Configuration > Edit:

  1. Create a new channel by clicking New.

  2. Name the channel, e.g. „Amazon Seller Service“.

  3. Choose Amazon Seller Fulfilled Prime as Channel Type (will be renamed in future pixi versions).

  4. Click Next and Finish.

  5. Now Edit the newly created channel, click Next and fill in the settings:
    (all information not listed should not be changed by you and are already stored on the system side)


    • Amazon MWS Endpoint URL: Enter "0".

      • For Germany: https://mws-eu.amazonservices.com

    • Marketplace ID: Enter the ID which matches spApiBaseUrl (Amazon Marketplace). You can find the ID here: Marketplace IDs

      • For Germany: A1PA6795UKMFR9

    • Merchant ID/Token: Enter the ID assigned to your merchant account which you can find in Amazon Seller Central > Settings > Account Info > Business Information > Your Merchant Token.

    • MWS Auth Token: Leave empty.

The following settings are mandatory for the automatic invoice upload (IDU) and need to be configured: (from pixi 19.12 on)

  • Upload Documents: With this option, you can enable (1) or disable (0) the automated invoice document upload to Amazon. If enabled, the upload is done in defined intervals.
    If you enable the upload and leave all other settings empty, then the upload happens every 30 minutes between 8 p.m. and 5 a.m. Manual configuration is not needed.

    • Default: Empty = 0 = Upload is disabled

  • Next Document Upload Date: With this date you can manually force the document upload. If a date + time was entered, it has priority over the setting Document Upload Start (full Hour).

    • If the time is earlier than Document Upload Start (full Hour), upload is only done once.

    • If the time is between Document Upload Start (full Hour) and Document Upload End (full Hour), then Document Upload Start (full Hour) is ignored and documents are uploaded from Next Document Upload Date until Document Upload End (full Hour).

    • Format: "mm/dd/yyyy hh:mm:ss AM or PM"; e.g.: "11/25/2019 1:00:00 PM" or "11/25/2019 7:58:47 AM"

    • Default: Empty = The date is automatically set by the system.

  • Document Upload Start (full Hour): Enter the value for the starting time of the upload.

    • Format: "hh"; e.g.: "23" - In this case upload starts at 23 o'clock.

    • Default: Empty = 20 = 20 o'clock / 8 p.m.

  • Document Upload End (full Hour): Enter the value for the ending time of the upload.

    • Format: "hh"; e.g.: "4" - In this case upload ends at 4 o'clock.

    • Default: Empty = 5 = 5 o'clock / 5 a.m.

  • Document Upload Interval (Minutes): With this setting, you define the upload interval.

    • Format: "mm"; e.g.: "30" - We recommend an interval between "30" and "60".

    • Default: Empty = 30 = 30 minutes

  • Document Upload Result Verification: With this option, you can enable verification of the uploaded documents. Usually and during production, this setting should not be enabled. In case Amazon changes something in their verification response, then this setting might help resolving issues.

    • Default: 0 = Verification is disable

  • Archive Order: Archive orders in the document storage

    • Values: 0, 1

  • SP-API Resource: Do not change this value! It is used to connect to amazon api.

    • Default: /my/api/path

  • spApiBaseUrl: For EU marketplace, do not change this value! It is used to connect to amazon api.

  • SP-API Region URL: For EU marketplace, do not change this value! It is used to connect to amazon api.

    • Default: eu-west-1

    • North America (Canada, US, Mexico, and Brazil marketplaces): us-east-1

    • More information on other options: SP-API Endpoints (amazon.com)

  • spApiAuthorizationEndpoint: Do not change this value! This is the login to the Amazon (LWA) authorization server.

  • SP-API Enabled:

    • Values: 0, 1

    • Default: 1 (option must be enabled)

  • Prime Shipping Option Carrier Will PickUp

    • Values: 0, 1

    • When true, the carrier will pick up the package.

    • Default: 1

  • Prime Shipping Option Delivery Experience

    • Values: DeliveryConfirmationWithoutSignature, DeliveryConfirmationWithAdultSignature

    • Default: DeliveryConfirmationWithoutSignature

  • PrimeShippingOptionPrimeLabelFormat

    • Values: ZPL203 (pixi supports only this one!)

    • Default: ZPL203

    • Notes:

      • For DHL, the label was retrieved with PrimeShippingOptionCarrierWillPickUp, with both true and false. It depends on customer setup in the seller central. In this case, the DHL was selected on the Manage Shipping Services page of Seller Central in the marketplace that the orders are placed.

      • pixi will, if more providers are returned by Amazon, choose the cheapest provider.

  • SP-API Refresh token: When creating a new channel connection, this value must be empty. The token must be retrieved from pixi Web. Follow these steps to retrieve it:


  1. In pixi Web, go to Administration > Amazon IDU.

  2. In the upper menu bar, select Authorize Amazon (icon with the paper and check mark).


  3. A new pop-up window for Authorize Amazon is displayed. Select channel Amazon Prime Shipping Label.


  4. Click Authorize. You are redirected to the Marketplace on the Amazon Seller Central website. Login to your account.


  5. Select the account for authentication.


  6. Click Select Account.


  7. On the Authorise Descartes pixi page, read the terms and conditions. If you agree, click Confirm.


  8. You will be redirected to pixi Web.

  9. Check the URL in the address field of your browser. If it states "completeAuthResult=OK" in the last part, the authentication was successful. The Amazon Refresh Token was automatically added to the settings in Control Center.

  10. The authorization is done.


Back to top

Check Uploads and re-send them to Amazon

The Amazon IDU page in the pixi Web application under Administration gives you an overview of the upload attempts to Amazon.

  • The page is only displayed if the "pixi Control Center" permission is activated for the user.

  • The XMLs of the last 7 days are displayed.

  • A maximum of 1,000 entries are displayed in the list.

  • Filtering columns only affects the results narrowed down by the search.


Search Criteria

Using the search function, XMLs can be searched using various criteria:

  • Channel: Select a channel to filter on.

  • Invoice Number: Enter an invoice number if you want to filter for XMLs of a specific invoice.

  • Status: Filter by the status of the XML file (three-dots menu in the Status column). The following criteria are available:

    • XML IMPORTED - XML was created but not uploaded to Amazon yet

    • UPLOAD SUBMITTED - XML was submitted to Amazon

    • UPLOAD PROCESSING - XML is being processed by Amazon

    • UPLOAD PROCESSED - XML was successfully uploaded to Amazon

    • ERROR - XML upload to Amazon failed

  • External Order Nr.: Enter an external order number if you want to filter for XMLs of a specific order.

  • Create Date: You can filter by the creation date of the XML file.


View XML

You can display the content of the XML file. To do this, follow these steps:

  1. Select one row (multiselect is not supported).

  2. Click View .

  3. A pop-up window opens and the content of the XML file is displayed.
    It contains the data that Amazon needs to process the request.
    The Amazon request, as well as the response, can be copied on button click.


Resend to Amazon

In the event of an error, e.g. if there was no invoice document on the pixi document storage during the first upload attempt, the upload to Amazon can be triggered again. To do this, follow these steps:

  • Select one or multiple rows.

  • Click Resend to Amazon .

  • The upload attempt for all selected lines is now carried out again and a message is displayed.


Data Field Description

Column

Description

External Order Nr.

External order number of the customer order

Invoice Nr.

Invoice number belonging to the customer order

Status

Status of the XML file that is sent to Amazon:

  • ERROR

  • XML IMPORTED

  • UPLOAD SUBMITTED

  • UPLOAD PROCESSING

  • UPLOAD PROCESSED

Description

Contains additional information in the event of an error that can be helpful in solving the problem

Create Date

Creation date of the XML

Feed Submission Id

Unique ID to identify the upload process to Amazon


Back to top