Dedicated integrations
Other Case Studies
Dedicated integrations

Trefl - Amazon Vendor platform - connection to Impulse EVO system

Trefl manufactures and distributes toys and games. The company operates under the Amazon Vendor Central sales model. It involves trading only with Amazon. Trefl becomes a "first-hand" seller, a supplier of goods. Amazon handles retail sales, and Trefl supplies Amazon's warehouses with its goods.

konrad szatkowski

Adam Kadłuczka

automation specialist

What does a particular process solve?

Proces automatyzacji skupia się jedynie na obszarze wymiany danych <highlight>pomiędzy platformą Amazon Vendor a systemem ERP Impuls EVO<highlight>. Ze względu na wewnętrzne procedury bezpieczeństwa w firmie Trefl, integracja nie wprowadza ani nie pobiera danych bezpośrednio z systemu ERP, tylko ze specjalnie przygotowanego widoku bazy danych (DB View). W nim są umieszczane dane przesyłane przez integrator, a następnie automatyzacja wewnętrzna w firmie Trefl wprowadza je bezpośrednio do Impuls EVO. <frame>Tak samo proces wygląda gdy integrator ma umieścić dane na platformie Amazon Vendor, tj. integrator pobiera dane z widoku, a następnie przesyła je do platformy sprzedażowej.<frame>

Application of the process allowed the client to solve problems such as:

<highlight-white>Optymalizacja weryfikacji towaru.<highlight-white>

By increasing the number of orders issued in the system and automatically verifying all conditions given by the integration in the process, the company is able to ship more goods in a given shipping window

<highlight-white>Optymalizacja wysyłki towaru.<highlight-white>

Based on the documents issued by the company in the system and making them available in the view, the speed of generating ASN documents, necessary to support shipping to Amazon warehouses, will be significantly increased

<highlight-white>Praca na jednym systemie.<highlight-white>

The transfer of all data to and from the view allows you to operate in one place, without having to log into multiple systems, such as Amazon's platform or ERP system.

Who is this solution for?

For customers who operate under the Amazon Vendor Central sales model.

Documents occurring throughout the process

PO (Purchase Order)

An order placed by an Amazon Vendor. It contains, among other things, the goods to be delivered and the Shipping Window, which is the period during which the goods can be received at a particular warehouse.

ASN (Advanced Shipping Notice)

A document containing detailed information about the contents of a package. This is a document that is necessary to complete the order.

WZ (External Release)

It is on its basis that the ASN document is created. The data from this document is sent to the Amazon Vendor platform to issue a document on the platform using it.

FS (Sales Invoice)

It finalizes the entire process of exchanging goods. It is always issued to the same counterparty (Amazon). It must be on the Amazon platform in order to be paid.

Process flow:

  1. A PO document is issued
  2. It is inserted by integration into the shared view.
  3. There is some in-house process taking place, outside of the view provided, where sales and shipping people determine how much merchandise can be shipped. This value is completed in the view.
  4. The integrator retrieves the entered value and then completes the "Accepted Quantity" field next to each commodity on the indicated PO.
  5. The next step in the internal process is to create a WZ document. Once it is placed in the view, the integration creates an ASN on the Amazon platform, including the POs for which shipping lists are created.
  6. When calculating the number of cartons in which the goods will be placed, the integration uses an external tool, 3dbinpacking. The system, also via API, takes the dimensions of all the products included in the order, and then sends back the number of cartons or pallets, as well as an indication of which goods are to be placed in which carton.
  7. An ASN was created and printed as a PDF on the computer where the integrator is installed.
  8. Once the invoice entry appears in view, they will be uploaded to the Amazon platform, generating their internal invoice.

Important information:

<frame>Poziom automatyzacji zależy w znacznej części od bazy danych klienta, a dokładniej od informacji o produktach jak i o samych kartotekach produktów.<frame> Rodzaj towaru definiuje w jaki sposób tworzyć dokumenty ASN.  To czy należy przetrzymywać ich wymiary, korzystać z zewnętrznych narzędzi obliczających układ towarów w kartonach i na paletach, zależy od towaru jaki jest sprzedawany. Informacje na temat tych produktów, jak np. gabaryty bądź poszczególne wymiary, wpływają na kierunek, jaki należy obrać w procesie tworzenia warunków w automatyzacji.

<highlight>Klient musi posiadać wiedzę, ile czasu zajmie mu realizacja wybranej grupy towarów<highlight>, by zmieścić się w oknie dostawy, w którym Amazon jest w stanie przyjąć towar na swój magazyn. Integracja może wykonać pewne obliczenia bądź uwarunkować decyzje, lecz wszystkie te czynności muszą być poprzedzone pewnymi danymi znajdującymi się w bazie danych.

<highlight>API Amazon Vendor nie udostępnia dokumentu ASN<highlight> z jego platformy, dlatego jest tworzony z niego PDF lokalnie. Przycisk który umożliwia pobranie takiego dokumentu z platformy, w przypadku ASN stworzonego przez integrator, jest wyszarzony i nie można go użyć. Z takim samym wzorcem wydruku z jakim generował się przez Amazon, zostanie wygenerowany poza platformą i umieszczony we wskazanym miejscu na dysku.

Related case studies

About the author of the article:

Our content is created by people actively involved in the projects in question.

Adam Kadłuczka
Adam Kadłuczka

Automation Specialist

On a daily basis, he supports our clients by introducing automation in their companies. He specializes in the implementation of OMS systems and analysis of dedicated processes. He supports our developers in the implementation of dedicated integrations according to clients' business needs. Thanks to his knowledge of the most popular marketplaces, accounting programs and ordering systems, he knows how to combine them into one coherent system.

Let's do something amazing and unique together!

We don't sell PV, we won't pester you with unnecessary phone calls if you don't want us to. We always try to provide value to our potential customers.

Thank you, your message has been sent.
Unfortunately, something went wrong. We apologize for the glitches.
By clicking "Accept all cookies," you agree to store cookies on your device to improve site navigation, analyze site usage and assist in our marketing efforts. See our Privacy Policy for more information.

Get in touch

Do you need a similar solution in your company? Leave a contact. Our analyst will select a service according to your requirements.

Thank you, your message has been sent.
Unfortunately, something went wrong. We apologize for the glitches.