Returns

Returns Bulk Processing

This extension to AMoP lets you bulk-process returns in the same way as orders. To bulk-process returns, create a return file with one return per row, following the format and providing the required data below. AbeBooks processes the file and creates a return for each row. A returns report file is then created, which you can download to view the results.

The format of the return file is:

  • The file must be in tab-delimited text format. (Note: pipe-delimited format is not supported for return files.)
  • If you include a header row, it will be ignored.
  • There are three columns in each row: ABEPOID, ABEPOITEMID, and RETURNREASON.
  • The RETURNREASON field must contain one of these values: DOESNOTWANT, ACCEPTEDINERROR, BUYERCANCELLED, or DIDNOTARRIVE.
  • Refund amounts are defined in the AbeBooks seller policies.

Uploading the Completed Returns File

After you enter all return information, upload the completed file to AbeBooks for processing.

  1. Upload the file to the returns folder.

Returns Error Reports

Open the returnsdone folder to view completed files and error logs.

Example return error report:

Successfully created refund with id 50880245 for abepoitemid 66704364
Successfully created refund with id 50880246 for abepoitemid 66704348
Successfully created refund with id 50880247 for abepoitemid 66704350

Success

Your Returns file was successfully processed if the error log contains the following message:

Successfully created refund with id (Return ID) for abepoitemid (Purchase Order Item Number)

Return File Errors

The Returns record should be fixed and re-uploaded if the logfile contains any of the following errors:

Error Description
Error in the line: line number - Missing abepoid ABEPOID is missing from this line in the returns file
Error in the line: line number - Missing abepoitemid ABEPOITEMID is missing from this line in the returns file
Error in the line: line number - Invalid abepoid ABEPO does not exist
Error in the line: line number - Abepoitemid abepoitemid not found for abepo abepoid ABEPOITEM doesn't exist in an ABEPO
Error in the line: line number - No valid return reason provided. No return reason or an invalid return reason code on this line in the returns file
Return for abepoitemid abepoitemid could not be completed at this time, please try again later. An error in sending the return to the return server. If this error persists after several minutes, please contact AbeBooks.
Return could not be completed for abepoitemid abepoitemid error code: return server error code and message An error being returned by the return server. Please contact AbeBooks and provide the error message.

Returns Reports

Returns reports show the current status of a return along with details of the original order. They are named "returnfrom_clientID_date_fileID.tab."

Viewing Returns Reports

Open the returnsreports folder to view completed files.

Returns reports are for your reference only. No further action is required. The columns contain the following information:

Column Name Notes
ORDERDATE The date the order was placed
RETURNDATE The date the return was processed
ABEPOID AbeBooks Order number
ABEPOITEMID AbeBooks Purchase Order Item Number
VENDORITEMID Your unique Book ID
ISBN Book details
AUTHOR Book details
TITLE Book details
DESCRIPTION Book details
CURRENCY You will be paid for the order in this currency
PRICE AbeBooks list price
BUYEREMAILADDRESS The buyer's email address. Questions or clarification about an order can be directed to the buyer.
RETURNID AbeBooks Return number
REASON The return reason indicated in the return file for the item