Reporting to Indie Bestsellers only:
To report only online sales, follow steps 1 and 6.
To report online sales and in-store sales, follow steps 1 through 4 and 6.
Reporting to the New York Times only:
To report only online sales, follow steps 1 and 5.
To report online sales and in-store sales, follow steps 1 through 5.
Reporting to the New York Times and Indie Bestsellers:
To report only online sales, follow steps 1, 5, and 6.
To report online sales and in-store sales, follow steps 1 through 6.
If you are an IndieCommerce/IndieLite user:
Sign in to your site and visit store -> reports -> NYT Bestseller Report *
In the Order status field, select your completed sales statuses (generally both Completed by warehouse and Completed)
Select the start and end dates and times for the week (generally 12:00AM Sunday to 11:59PM Saturday)
After the report is generated, click CSV below the displayed records to download the report as a CSV file and save the file to a convenient, known location on your computer
If you use another eCommerce system:
Export a CSV file from your system composed of one line for each title sold during the Sunday through Saturday of the reporting period detailing, for each book, the ISBN and total quantity sold for that ISBN, headed, respectively with “SKU” and “Quantity”
If you are only reporting online sales, skip to step 5, Log in to NYTimes.com and report following instructions provided by NYT.
Follow the directions at the following address to export in-store sales figures from your POS.
Append your in-store sales to your online sales to create a single file using Google Sheets or Excel
Copy your ISBN and Quantity data from your Online Sales report
Create a new Google Sheets spreadsheet or Excel file and select cell A1
Paste your ISBN and Quantity data
Copy the ISBN and Quantity data from your In-Store Sales report
Select the first blank cell in column A in your Google Sheets spreadsheet
Paste your ISBN and Quantity data
Aggregate the sales using the directions below (“Aggregating Sales”) to ensure each ISBN only appears once and represents all sales for that ISBN.
The New York Times limits stores to one sales report submission per week and requires that each ISBN appears only once in that report representing the total sales for that book. To provide sales figures from two different sources, the sales reports must be combined and the quantities per ISBN totaled. The following method for accomplishing this uses Google Sheets to total the ISBNs (requires a Google account).
Create a new Google Sheets spreadsheet
Select cell A1 then copy/paste your sales data into the sheet, starting at cell A1 (the result should be two columns of data, the ISBNs in column A and the quantities in column B)
Select cell D1 then copy/paste the following formula into cell D1
= QUERY(A:B,"select A, sum(B) group by A",-1)
The aggregated figures should be automatically displayed in columns D and E.
Select columns D and E.
In the Edit menu, select Copy.
At the lower left of the browser window, click the plus symbol to add a new sheet
Select cell A1 in the newly created sheet
In the Edit menu, select Paste special, then Paste values only
Change the text in cell A1 to ISBN
Change the text in cell B1 to Quantity
In the File menu, select Download, then Comma-separated values (.csv, current sheet) to download a CSV of the aggregated data of just the second sheet
If you report in-store sales directly to BookScan via your POS, you can only submit online sales via BookWeb (and can continue to report in-store sales to BookScan)
If you report sales via a file upload to BookWeb, use the following method
Log in to BookWeb.org from 3pm ET Saturday, to 3am ET Tuesday
Click “File Upload” in the menu at the left of the page
On the resulting page, leave “Point of Sale System” set to “Other”
Click “Browse” and select your sales file from your local file
Select the number of outlets the report represents
Check “Yes” if you wish to provide your sales reports to BookScan (Your store will receive BookScan's weekly DMA Book Sales and other national reports if you participate)
Click “Submit Query”