Download   Help  

Getting Orders

In order to import your orders from Amazon, you first need to enter your amazon seller nickname, amazon username and password in the Account Settings/Order Imports window. Set the number of days for which you want the report. (we recommend 4 days-considering the gap between Friday and Monday). Simply click on Get Orders buttons.

Whenever you press Get Orders, a window will show up in which you can select an 'ad-hoc' combination of parameters as to what type of orders you want to import. The only parameter that will be memorized as if changed in the Account Settings window, is the number of days for which Amazon Order Fulfillment Report is generated.

Click on OK to continue with order download.

The program keeps track of your orders, and it never imports the same order twice. However,

If you have installed the new version over any of the previous versions of Mail Extractor, please notice that the program does not keep track of your Marketplace orders imported from emails! The program will initially (only the first time) import some orders you have most likely already imported in the previous version. Just delete the duplicates.

The imported orders have different background colors, depending on the shipping method. Standard mail orders have white background, while expedited orders have green background. International orders have red background.
Previous versions of Mail Extractor have been able to import some additional item info from Amazon details web page. However, this is no longer possible because Amazon Order Fulfillment Report do not contain any link that would enable the program to access the unique web page for your listing on Amazon.
However, this is now possible by importing Amazon Open Listing Report to Inventory Manager. Therefore, to have the additional details imported together with your orders, you will first need to import the Amazon Open Listings Report into your Inventory Manager and later import all Add/Modify/Delete files through Inventory Manager. To do so, just click the Inventory Manager button, click Import/Export, select the IMPORT tab, select "Amazon Open Listings Report (purge and replace AOLR)", and hit "Close & Perform". Later, whenever you Add/Modify/Delete items to Amazon, use the "Inventory Loader File" option to add the items to your local inventory as well.
If importing any item with a SKU that already exists in the local inventory, it will be updated with the new price and quantity. The rest of the fields for that record will remain unchanged. If you want to replace the entire record of an item, you actually need to delete it and then import new items. Use the Search option in the Inventory Manager to easily locate items. Also, note that the Quantity field is editable, and you can change its content as you like.
The program automatically updates the Quantity field in your local database, according to the Quantity in your orders and upon request uploads/generates Add/Modify/Delete file.
Select the "Order fields" tab in the main window to browse some of the most important fields of your orders. Or you can select other tabs to see the address fields.

If Power Seller, you have access to the FTP server. If you select this option in Mail Extractor, it will import your order files from the FTP server.

A seller can determine the frequency at which order files are received by selecting one of the following queues:

Once per day delivered at 8 AM EST
Once per day delivered at 10 AM EST
Three times a day delivered at 5 AM, 1 PM and 10 PM EST
Once per hour

Please notify with your choice for a queue. You may also need to request Automated Order Processing (Order folder will be created on your FTP account).


Non-Power Sellers can import ordes only by downloading the notification emails, like in the previous versions of the program. Make sure to select "Import my orders from my emails on my mail server". Now you don't need (and cannot) enter your login parameters anywhere in the program, but you do need to enter your email account parameters in the "E-mail Accounts" tab. Please refer to the "E-mail Acccounts" section for more details on how to set up your email account, and configure your mail client.
The importing process goes like this: when you press the Get Orders button, the program tries to connect to your mail server, and begins to download your notification emails. It downloads messages starting from the latest, and finishes at the first message found on the mail server. This way of downloading enables you to perform the download as fast as possible, because you can cancel it anytime, as soon as you download the newest orders. So you don't have to wait until ME scrolls through all the messages.

Since non-Power Sellers have no SKU for their items, there is no way for this type of orders to integrate in any way with data in the local database. Therefore any additional data nout found in the email must be retrieved from the order details page on web. To turn this opton on, check "Download extra details from Web (only non-Power Sellers)". Also, in order for this to work, you must allow Internet Explorer to accept cookies, and you should have logged with it in your web account at least once, and check "Keep me signed in" on the login page.


Importing orders from eBay File Exchange NEW!!!

As of October 2005, has introduced a new option File Exchange, which completely replaces the old Bulk Catalog Lister. File Exchange makes possible for mid- and high-volume sellers to manipulate their online inventory by uploading file to eBay through the File Exchange web interface. Also, File Exchange allows for creating custom schedules to generate various order reports. is also included. The least interval for which it can create reports for your items sold on is one hour. You must create such a schedule, and File Exchange will start filling your eBay database with links to the generated reports. Mail Extractor now can pick up these reports, and import your orders from them.
This is the link where you create and edit your eBay File Exchange schedules:
Make sure to provide your eBay login paramters in the Account Settings window! Also, in the same window, you need to select "Import orders from my eBay File Exchange account", under setting for Please be aware that this selection also specifies how your items will be uploaded to if you use Inventory Manager for that purpose.
If you have recently logged with your Internet Explorer to a different account than the one you want to import your orders from, make sure to sign out before using Mail Extractor to import the orders. Otherwise, it may connect to the other account and import the orders you didn't want to import.

At this point, the program enables eBay sellers to import their orders only from PayPal notification emails (you must have PayPal account), or from their eBay File Exchange accounts. File Exchange is a new feature on eBay, that completely replaces the abandoned Bulk Catalog Lister. It allows for manipulating your online eBay inventory by sending files through File Exchange web interface. Also, you can import your orders from File Exchange reports, which are automatically generated according to customs schedule, defined by you. Unfortunately, the least possible interval eBay has provided at this point is 24 hours. In other words, you have to wait until the next day at the same time to import your new orders.
Mail Extractor should work fine for sellers who sell on eBay Store's.

If you want to import your eBay orders from your paypay notification emails, first make sure to properly configure your email account in the Setting Accounts window (see the "E-mail Accounts" section), and to enter your eBay login parameters in the same window. Don't forget to turn on the option (checkbox). The login parameters are mandatory, otherwise the program won't be able to get additional details from your local database. You must follow a specific procedure in order to successfully work with eBay orders in Mail Extractor. In order to learn how to properly upload your inventory items to eBay and your local database, please refer to "INVENTORY MANAGER" section.

Sellers who upload inventory to eBay through the eBay website, cannot put more than one shipping option for each item, and allow your buyers to choose between stadard and expedited shipping methods. In order for MailExtractor to recognize standard verses expedited mail, you will need to specify shipping price in the Shipping Method Defaults Window.



Importing eBay orders from eBay File Exchange NEW!!!

Please read the first previous paragraph, about File Exchange. We will here go in some details on importing from File Exchange.
First, the scheduled report that Mail Extractor imports orders from is of the "Paid & Awaiting To Ship" type. This is the link where you create and edit your eBay File Exchange schedules:
Secondly, and naturally, you must provide yor eBay login parameters in the Account Settings window, and make sure to logout with your Internet Explorer from any other eBay account you may have recently logged on to. If you don't do this, Mail Extractor may import orders from that other account, and you may know be aware of it. The whole issue is related to system cookies. This may be overcome in the future versions of the program.
Third, in the Account Settings window, select "Import orders from my eBay File Exchange account", under eBay options. Please be aware that this selection also specifies how your items will be uploaded to eBay if you use Inventory Manager for that purpose.
Also, in the Shipping Method Defaults window, make sure to provide correct value for "shipping cost for each additional item", because Mail Extractor's ability to correctly detect the shipping method of the order is based on that value, since no shipping method information is provided in eBay File Exchange the reports.


WWW: E-MAIL:   FAX: (336) 297-9847   

Copyright 2002. All Rights Reserved.