Whether you're setting up your textbook price rules for the first time or you're just curious, you'll want to know the List Price for the textbooks you sell and rent. We have an easy way to export that data into one Excel file, so you can sort, filter and manipulate the data to your heart's content.
Today, we'll highlight a nifty trick that Mike Clear, one of our Customer Success Managers, likes to use.
What does Sidewalk mean by "List Price"?
Conceptually? The List Price of a textbook is a bit like the Blue Book value of a car. Where the price of a textbook might fluctuate wildly over the course of the year (try selling the same book in March and August), the List Price value stays pretty fluid. It's a good benchmark for what the book's worth on any given day.
The textbook industry has several different ways to determine List Price. Sidewalk maintains a subscription to the Bowker Title Database, and Sidewalk Pro displays Bowker data when it calculates the List Price of a title.
Why do you need to export the List Price?
It's here if you want it. Our most common textbook price rules depend on list price to return a Sale or Rent price to your store. By analyzing that data, you can get a sense of what your most (and least) valuable inventory is, and adjust accordingly.
You can also see books that don't have a List Price because they're new, or custom titles, etc. Regardless, if you want to rent or sell them, you'll want to set a static Price Override for them.
For extra credit, you can also use an exported list of List Prices to determine where a book's local market value might differ from the national list value. From there, it's an easy step to enter a Price Override that more accurately reflects the local value of your book.
To do this right, then, you need way more than just an ISBN and a dollar amount. It's useful to know the adoption data for the book and any other price overrides that currently exist. You need everything, and you probably need it by Term, so that you can adjust your overrides or slice your data within the context of each adoption cycle at your institution.
So...that's what we created.
How to do it
1. Navigate to the Catalog Perspective in the Sidewalk Merchant. You can do this by clicking on the Catalog Menu and selecting "Catalog Perspective," by clicking the book icon on the far righthand side of your screen, or (if you're a hotkey whizz) by hitting F8.
2. Expand the catalog tree window on the lefthand side of your screen to find the term's catalog for which you'd like to see list prices.
3. Right-click the catalog that you'd like to export, and choose the option called "Export Adv Book List." It'll look like this:
Two thoughts on this step:
First, depending on how you click your way down to the term, the term might start loading before it lets you right click. That's fine; don't worry.
Second, you can totally click the "Export" button, rather than the "Export Adv Book List" button. A regular Export exports faster, but will only display the list prices that you've previously set overrides for.
4. Once you click "Export Adv Book List," you'll get a pop-up asking for an email address, and whether or not you'd like to use Amazon data. It will look like this:
The email address field will populate from whatever your Sidewalk Pro login is. If you don't use your actual email address for your login, you'll want to change this field.
Will "Use Amazon" Work?
Sure! Maybe. Depends. If you've linked Pro to your Amazon credentials, and you have price calls (more on this later), then yes.
First place to check is up in the Options menu. Click on Markets, then the Amazon tab. If you don't have Amazon set up, it will look pretty blank, like this:
Second place to check is over in Sidewalk Studio.
Log in to Studio and head to Textbooks, then Research. Search for a title, click on a result, and scroll to the bottom on a page. You'll see a great little button--you'll love this button!--that displays what we call the Qualified Amazon Low. A Qualified Amazon seller is one who has been in business online for quite a while, has great customer feedback, and isn't selling their inventory for a penny. Knowing what the Lowest qualified price is online today is very useful to you.
The button looks like this. If your Amazon credentials are up and working, it will return a price (without you going to Amazon yourself). If your Amazon credentials are not set up, the button will tell you:
Should I "Use Amazon"?
If you're in the middle of Buyback (and you use Amazon pricing for Buyback Price Rules), you might not want to use this option. It can really hurt your ability to calculate buyback prices dynamically in the buyback cart.
Amazon limits your ability to use their site to check prices through what they call "price calls." Your store gets a certain number of calls--chances--per hour. You might see where this is going: if you check "Use Amazon" and export your entire catalog, bet your bonnet that you're going to burn through your Amazon price calls, and out at the cash registers, books that you should be spec buying to sell on Amazon will start showing up with $0 prices.
So keep that in mind. Otherwise, check the box if you're interested in that pricing.
OK, let's get back to it!
How to do it: Continued
4. Check the box (or not), and click OK. Pro will begin exporting the advanced book list, and send it to the email address you picked.
5. Vigilantly watch your email. It makes the process run faster.
6. Once the file is complete, it will show up in your inbox with a subject that will look something like this: "Adv Book List Export -- Spring 2016."
7. Open the file. You might want to sort it by EAN first, so you can quickly select and delete the sections without books.
8. Once you've mastered Step 7, sort the resulting file by List Price. This will reveal a list of books that don't have a list price in Sidewalk Pro.
You're good to go! If you have any questions, you can comment on this article or send an email to firstname.lastname@example.org.