Last Step – Campus CEO
4. Updating Google Sheets
Now that you’ve sold and shipped the book, it’s time to update it in your school’s official inventory database operated by Google Sheets. We use Google sheets because it updates and saves in real-time, and gives us the ability to make changes as well.
You will receive an invite to edit this sheet after this training is complete, so please look for it in your email. If you have any complications, get with your supervisor. We understand that you may not have any experience using Excel or Google Sheets, but we can assure you that this is very simple.
Essentially, you’ll do 4 main things inside the Google sheet after shipping a book: (1) Enter in the condition of each book as you go through applying ID #’s. (2) After you ship a book, type in the shipping amount into the book’s corresponding cell. (3) Mark an ‘x’ in the “sold” column. (4) Change the color of the row to green, indicating that the book has been successfully shipped and completed.
Step 1: Update the condition of each book
As you’re going through and applying ID #’s for each book, check the condition as well. We mentioned the condition system on the last page, but we follow Amazon’s condition guidelines to a ‘T.’ You can view that here.
As you work through each book, update the condition by manually entering in the content for each book in it’s corresponding cell. This will be highlighted orange in your Google Sheets.
Step 2: Insert Shipping Amount
After shipping a book, find the book’s ID number inside the Google Sheet, or the corresponding ISBN #. Using the receipt you were given from USPS, enter the amount into the “Insert Shipping Cost” cell, which is a highlighted Salmon color. This includes the cost for shipping plus the cost for the mailer, if you had to buy one. Otherwise, if you were sent bubble mailers, simply key in the cost for shipping only. Please see below:
Step 3: Mark the Book as Sold Using an X
In the sold column, simply enter in the letter “x” to the corresponding cell. Click enter. Your sheet will look identical to this. See column ‘R’ in the picture below:
Step 4: Change Row Color to Green
The last step is to change the book’s row to green. To do so, click on the furthest left column of numbers. This will highlight the entire row. In this image, we have clicked the number “7,” which highlighted the entire row:
From there, go to the color dropdown button, and click on the green color. If this color is not available, you may need to find it by clicking inside the custom box. See below: