Follow

Sales History Downloads

Download your sales using a variety of parameters:

  • Number of Days: Select from the drop-down menu if you only want to download a file with a few days, weeks, or a month of Sales History.
  • Month: Select any specific month of Sales History the drop-down menu.
  • Between Specific Dates: Enter the date format as 'YYYY-MM-DD HH:MM:SS'
  • Specific Ship List: Your Ship pages create the drop-down menu, such as New, On Hold etc ...

The lower section allows you to refine the Sales History Download you requested in the top section.

  • Enter a pattern matching term using any of the following fields:
    • SKU
    • Location
    • Source
  • Or, specify according to:
    • Venue
    • Domestic, or International
    • Greater, or Less Than a specific dollar ($) amount
    • State 
    • Or select between Processed or Canceled orders.

Once you've made your selections and are ready to click the Get File button you will see a few remaining options...

Screen_Shot_2020-08-28_at_09.52.02.png

  • Format as an AZ OFR: will format your Sales History file to match an Amazon Order Fulfillment Report.
    • Note: The OFR format is greatly scaled-down as compared to the AoB Default format
    • Leave this unchecked to receive the AoB default which contains a great deal more data than the OFR format (such as the time an order arrived in AoB, your Tracking if entered, etc...)
  • Format for import to Stamps.com will format your Sales History file for use to import to your account with Stamps.com for your postage.
  • Galaxy Format will format the Sales History file to mimic Endicia's Galaxy file for your postage uses. 
  • Email me this file: will send an email to the address entered in Personal Settings containing a link to download your file.
    • If you have an FTP account with AOB this will also make the file available in the Downloads folder of your FTP.
    • Leaving this unchecked will allow your file to be downloaded directly from the download page.

A few sellers have asked what the difference is between the OFR formatted file and the AoB formatted files.  We thought showing the headers would give you a better idea.  Following are the headers for both files.

AoB formatted file:

qty, order_id, order_item_id, ship_method, purchase_date, buyer_email, buyer_phone, buyer_name, recipient_name, ship_address_1, ship_address_2, ship_address_3, ship_city, ship_state, ship_zip, ship_country, actual_shipping_cost, status, venue, sale_price, shipping_credit, title, sku, isbn, media, author, location, source, cost, weight, price, earnings, condition, aob_pull_time, dc, listed_date, shipped_date, commission, processing, tax, aob_comments, matched, p0, p1, p2, p3, p4, p5, p6, p7, p8, p9

OFR formatted file:

payments-status, order-id, order-item-id, payments-date, payments-transaction-id, item-name, listing-id, sku, price, shipping-fee, quantity-purchased, total-price, purchase-date, batch-id, buyer-email, buyer-name, recipient-name, ship-address-1, ship-address-2, ship-city, ship-state, ship-zip, ship-country, special-comments, upc, ship-method

 

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk