Logged in as:
{SYSTEM/PORTAL.FLNAME}
Search
{SYSTEM/SIDEBAR.LINKS}
%menu%
DOWNLOADS
Files Updated Daily
File Updated Description
Onhand.txt This is an inventory file with ISBN, ISBN13 and Qty on Hand
The Onhand.txt file is having some additional columns added. These new columns will appear starting 8-24-2012. We are adding these columns per requests from our customers. The columns that will be added are, Stockid and UPC. The order of the columns will be Stockid, ISBN, ISBN13, UPC, Qty on Hand.
Files Updated Weekly
File UpdatedDescription
inv_tr3.zip The fields include ISBN, ISBN13, UPC, Long Title Description, Author, Retail price, New Leaf item code, CatNum, Category 1, Category 2, Category 3, Status, Publisher, and Material Type code.
The inv_tr3 file is having some additional columns added. These new columns will appear starting 8-24-2012. We are adding these columns per requests from our customers. The columns that will be added are, Stockid, Weight and WeightType. The Stockid will be added as the 1st column. The Weight and WeightType will be added to the end.
inv_comma.zip This transfer is just like INV_tr3 above, except the delimiter is comma instead of tab.
inv_tr4.zip The fields include ISBN, ISBN13, UPC, Long Title Description, Author, and Retail price.
inv_tr5.zip The fields include ISBN, ISBN13, UPC, Short Title Description, Author, Retail price, New Leaf item code, CatNum, Category 1, Category 2, Category 3, Status, Publisher, and code Material Type.
bisac1.zip This file lists all titles we carry in Bisac format.
inv_noexp.txt Titles with Export restrictions.
upc.zip ISBN, ISBN13, UPC, and barcode conversion data.
blurb.exe ISBN, ISBN13, UPC, and Blurb.
spanish.txt This file lists all titles we carry in spanish with ISBN, ISBN13 and Title in english (with title in spanish listed at the end).
clearance.txt This file lists all clearance products (most are 75% off Retail) with ISBN, ISBN13, UPC, SRP and Wholesale.
Files Updated Weekly - by product Category/Type
The files listed below that use the txt file extension will not be formatted properly if you open them in your Internet browser (IE, Firefox, and Opera). If you are intending on opening them within a spreadsheet, then you must first save the file to your local computer. To do that, right click on the file name and select the option within the menu for Save. You can then open your spreadsheet program and import the file.
File UpdatedDescription
books.txt The fields include Isbn13, LongTitle, Author, Retail, Publisher, Subject1, Subject2, Subject3, Binding, PageCnt.
recordedmedia.txt The fields include UPC, LongTitle, Artist/Author, Retail, Label/Publisher, Category1, Category2, Category3.
sidelines.txt The fields include UPC, Description, SuggestedRetail, Wholesale, Category1, Category2, Category3.
calendars.txt The fields include Isbn13, LongTitle, Author, Retail, Publisher, Subject1, Subject2, Subject3.
magazines.txt The fields include UPC, Title, Retail, Frequency, ReturnMethod.
demos.txt The fields include LongTitle, Artist/Author, Label/Publisher.
Inventory File Keys
File UpdatedDescription
mat_key.txt (Material type includes books, cassettes, videos, sidelines)  This file is case-sensitive.
publisher_list.txt This is list of publishers with our ID code.
key_to_sort_codes.htm Which catalog the category is in.
Subject Codes This is list of subject codes.