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.
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.
on OK to continue with order download.
The program keeps track
of your orders, and it never imports the same order twice. However,
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
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
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
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
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 Half.com FTP server. If you
select this option in Mail Extractor, it will import your Half.com 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
• 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 email@example.com
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 Half.com emails on my mail server".
Now you don't need (and cannot) enter your Half.com 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 Half.com 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 Half.com
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 Half.com account at least once, and check "Keep me
signed in" on the login page.
orders from eBay File Exchange – NEW!!!
As of October 2005, Half.com
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. Half.com is also included. The least
interval for which it can create reports for your items sold on Half.com
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
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 Half.com.
Please be aware that this selection also specifies how your items
will be uploaded to Half.com if you use Inventory Manager for that purpose.
If you have recently logged with your Internet Explorer to a different
Half.com/eBay 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
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.
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: http://k2b-bulk.ebay.com/ws/eBayISAPI.dll?SMDownloadScheduleSuccess&ssPageName=STRK:ME:LNLK
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
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.