Up-2-Shop Amazon interface

(Amazon Export Interface, Amazon Import Interface)

Software for the automated exchange of data with Amazon

© 2009 inbase gmbh

“With an estimated 16.7 million Internet buyers, Amazon had the most online buyers among web sites last year”
Source: enigma-gfk.de, 24.04.2009, http://www.enigma-gfk.de/download/pd-OSS-09-04-24-dfin.pdf

Your articles in the Amazon marketplace? No question!

The Up-2-Shop Amazon interface makes it possible to have automated data exchange with Amazon.

Your entire range of goods will be published at Amazon automatically by means of our Amazon Export interface.

As required, the Amazon Export interface also updates the data in various forms: Only new articles, articles with modified texts / prices or only the warehouse stockpiles.
All templates prepared by Amazon can be used; thus, for example, variants such as colours/sizes.

Amazon’s sales can be converted automatically into .CSV or .XML files through the integrated Amazon Import interface and thus imported into each merchandise management system such as microtech ERP-Complete, Mesonic or SAP Business One.

The subsequently generated shipping confirmations can once again be transmitted to Amazon:

              Workflow which is fun !

Img. 1: Registration data

The Up-2-Shop Amazon Interface permits the variable modification of Amazon’s parameters and is batch-compatible; that is to say, order imports or article updates can be conformed to timeframes via Command Line Parameter.

The data exchange to Amazon Seller Central comprises:

Amazon export interface:

Transfer of data to Amazon including

• Article data, among others texts, photos, prices, warehouse inventories, EAN codes
• Additional article data such as, for example, internal article numbers, manufacturer’s article number, supplier’s order numbers, additional descriptions
• Shipping confirmations
• Associated / similar articles (related items)

Amazon import interface

Transfer of order data from Amazon Seller Central incl.

• Order header data; among other things, addresses, supplier’s address, Amazon reference, etc.
• Order item data; among other things, article no. text, quantity, price
• Summary of shipping costs for the order items
• Preparation of order data in various .CSV files or .XML files for importing into ERP systems such as, for example, microtech ERP-Complete, Mesonic or SAP Business One

Retrieval of pending jobs (current jobs) at Amazon Seller Central incl.

• Tasks which are currently being handled at Amazon and that have not been completed, e.g., bulk update of 100,000 article data sets

Img. 2: Export of data:

Img. 3: Import of orders

The importing of Amazon’s orders ( Amazon import interface) can be started manually via GUI or in an automatic fashion.

The jobs that are currently being carried out at Amazon (uploading of article data, updating of warehouse inventories) are displayed on a “pending list”. When the jobs have been handled by Amazon, they are deleted from the list.
Thus, it is possible to control ongoing transmissions ...

Img. 4: Pending Jobs

Img. 5: Example of Automation using batch files

Example of implementation ERP-Complete using batch files

@echo off 
rem Importe amazon.de START 
cd E:\Daten\bpStarter 
SET TIM=%date:~0,2%.%date:~3,2%.%date:~6,4%, %time:~0,2%:%time:~3,2%:%time:~6,2% 
     
if exist E:\Daten\Amazon.de\Import\Address.csv goto fehler1 
if exist E:\Daten\Amazon.de\Import\Order.csv goto fehler2 
SET TIM=%date:~0,2%.%date:~3,2%.%date:~6,4%, %time:~0,2%:%time:~3,2%:%time:~6,2%
@echo %TIM%, Abfrage Amazon ... 
@echo %TIM%, Abfrage Amazon >>_importe.log 
     
java -jar E:\Daten\Amazon.de\up2shop.jar batch import path="E:\Daten\Amazon.de" 
IF ERRORLEVEL 1 GOTO fehler3 
if not exist E:\Daten\Amazon.de\Import\Address.csv goto NoNewDEOrders 
if not exist E:\Daten\Amazon.de\Import\Order.csv goto NoNewDEOrders 
     
SET TIM=%date:~0,2%.%date:~3,2%.%date:~6,4%, %time:~0,2%:%time:~3,2%:%time:~6,2% 
@echo %TIM%, Importiere Adressen ... 
@echo %TIM%, Importiere Adressen >>_importe.log 
E: 
cd E:\Daten\bpStarter 
START /WAIT E:\Daten\bpStarter\bpstarter.exe -once -layoutfile
E:\Daten\bpStarter\AmazonAdressImport.BPL -layoutgroup AdrImpListe -importonly 
IF ERRORLEVEL 1 GOTO fehler4 
SET TIM=%date:~0,2%.%date:~3,2%.%date:~6,4%, %time:~0,2%:%time:~3,2%:%time:~6,2%
@echo %TIM%, Importiere Bestellungen ...
@echo %TIM%, Importiere Bestellungen >>_importe.log 
     
START /WAIT E:\Daten\bpStarter\bpstarter.exe -once -layoutfile
E:\Daten\bpStarter\Amazon_Vorgaenge_ohne_Preise.BPL -layoutgroup VogImpMulti -importonly 
IF ERRORLEVEL 1 GOTO fehler5

(...)

:fehler1

(...)