Follow

Items & Inventory

Items are the things you sell in your Bookstore, everything from textbooks and college-branded sweatpants to marginally-edible granola bars and deeply-discounted acupuncture needles. Inventory refers to the nitty-gritty details of your items: How much did the textbooks cost you? How many colors of sweatpants do you sell? How long have the granola bars just been sitting there? What's the list price of those acupuncture needles?

This article covers how to add new items for sale as well as how to manage inventory for individual items.

Adding new items

You can add new Bookstore items...

  • In Bookstore > Admin, click Add Item in the left sidebar.
  • On any shopping/category page, including the Bookstore Home view, you'll find Add Item in the right column.
  • In the Term Book List, any books not in your inventory will show , which lets you add that book as a new item.

Adding the item

  1. Enter a Name and Description for the item. The item's name is the only required information (though you can't do much with an item bearing only a name, now can you?). (You can use text formatting in the Description.)
  2. Click the picture area to upload an item image.
  3. Do you want this item to be visible to (online) shoppers or hidden from them? Hidden items can still be sold via Point of Sale.
  4. Select the item's category.
  5. Is the item taxable? Bookstore automatically calculates sales tax for taxable items.
  6. Enter a 10- or 13-digit ISBN for books. If a book is included in a course reading list (using the ISBN), Bookstore uses the ISBN to:
  • Link directly from the course reading list to the item's page in Bookstore.
  • Populate the Term Book List report.
  • Enter the vendor's name. You can add new vendors here or select from existing vendors suggested by the text field.
  • Select the income account to be credited when this item is purchased.
  • Check if students can charge this item to their accounts.
  • Check if charges for this item should be reported on IRS 1098-T forms.
  • Is this item Featured In any of the shopping tabs? Select as many as you wish; when you're done, just leave the last one blank (--).

    At this point you can scroll to the bottom of the screen and click Save, but first you should probably add at least one inventory segment.

    Inventory segments

    Inventory segments are variations of the item. You might sell the same book in hardcover and softcover, or different colors and sizes of school-branded yoga pants. Each variation should have its own inventory segment.

    1. Use the segment name to summarize what's unique about this segment (XS red/XS blue, hardcover/softcover, DVD/Betamax, etc.).
    2. The SKU is the unique inventory identifier for each segment.
    3. List price is usually provided you by the vendor. This field is optional.
    4. Price is the amount at which your Bookstore will sell the item.
    5. Enter the weight in pounds. This field accepts decimals so you can enter, say, 1.25 to indicate 1 1⁄4 pounds.
    6. Enter the barcode; you can just scan this in with a USB barcode scanner. If you like to type long numbers, you can do that, too!
    7. Under initial inventory:
    • Quantity refers to the amount you received in a given order. As you receive new orders from your vendors, you'll add new inventory batches.
    • Our Cost refers to the per-item cost in that order. This amount can vary from one order to the next and is an important component of your inventory cost flow.
  • Click add inventory segment to show the fields for another segment. You can add as many segments as you need.
  • Delete an inventory segment by clicking .
  • When people are looking at this item, inventory segments will be shown in a drop-down. Use the symbols to change the segment drop-down order.

    Item pages

    After adding an item, you can find it...

    • By searching for it the Home view or one of the specific category/shopping views.
    • Via the Items report in Bookstore > Admin.
    • Anywhere you might see it linked—order pages, the Inventory report, etc.

    If there is more than one inventory segment for this item, select it using the drop-down right below the price. You can perform five actions on an item page:

    • Generate a "Buy Now" Link: Click this to generate a snippet of HTML code that you can incorporate into another website. When someone clicks the link, he'll be taken to Bookstore with the item added to his cart.
    • Add to Cart: If you want to buy the item, well, you can.
    • Edit Item: Click this to update or change item information.
    • Delete Item: Only do this if the item you're looking at was mistakenly added!
    • Update inventory: See below for how to add and adjust item inventory.

    Inventory

    The inventory panel shows you the entire inventory history for the inventory segment you're viewing. Change the segment by selecting one from the drop-down below the price.

    • The panel shows you when inventory was added or adjusted and when sales or returns affected the stock.
    • Hover over to see a quick summary of the order details affecting the inventory.
    • Click to see any notes that have been left on adjustments.

    Adding an inventory batch

    When you receive a new shipment from a vendor, you'll enter an inventory batch.

    1. First, if you're entering inventory for an item with multiple segments, make sure you're viewing the correct segment!
    2. Click Add batch.
    3. Change the date if necessary.
    4. Enter the quantity. This field autofills with the quantity from the last batch entered for this item/segment, but changing that ain't no big deal.
    5. Enter the cost per item. Likewise, this field autofills with the last cost. Cost per item is used in your inventory cost flow calculations.
    6. Click Save when you're finished.

    Now that you've added this batch, your inventory has increased and you have more stuff to sell!

    Adjusting inventory

    Inventory adjustments let you note loss or damage to stock or fix errors in an inventory batch (say, you counted wrong when unpacking the shipment).

    1. Click Add adjustment.
    2. Enter the amount of the adjustment. If it's a reduction of any kind, simply enter a negative number (e.g. -4).
    3. Check whether this adjustment is for loss or damage. If it is, the inventory reduction will be automatically accounted for based on your inventory cost flow method.
    4. If this is not for loss or damage, select the inventory batch this adjustment affects.
    5. Enter a note, especially if you're noting damage caused by spilling some hot, sweet coffee drink all over that new shipment of school-branded yoga pants.
    6. Click Save when you're finished.

    Now that you've adjusted the inventory, it is reflected in the stock total. If an adjustment for loss/damage, a corresponding entry has been created in the general ledger.

    Admin > Inventory

    There are two inventory views in Admin: Add Inventory and the Inventory report.

    Add Inventory

    Add Inventory lets you add inventory batches to any existing item/segment in your Bookstore. You can also view any recently-added inventory batch. If no items from a batch have been sold yet, you can delete the batch by clicking .

    1. Find the item/segment by scanning the item's barcode or using the item search.
    2. Follow the instructions for adding an inventory batch.

    Now that you've added this inventory batch, you'll see it under Recently Added; it will also appear on the item's page under Inventory.

    Inventory report

    The Inventory report lists all of your inventory segments. You can filter the report or export a spreadsheet of it.

    Was this article helpful?
    0 out of 0 found this helpful
    Submit a request

    8 Comments

    • 0
      Avatar
      Jonathon Beeke

      Is it possible when you add books from the Term Book list, that the picture of the book also appears in the Bookstore? It seems this took place under the Required textbooks for the students, but not in the Bookstore.

    • 0
      Avatar
      Mary Neel

      This would be very helpful for me, too.

      Question: are SKU and barcode the same numbers?

    • 0
      Avatar
      Brendan O'Donnell

      SKU and barcode could be the same number. They don't need to be; SKU can be whatever you want it to be.

    • 0
      Avatar
      Keith Heppner

      Does the program link to the Spring Arbor or Ingram data base so we can update when there are new books or price changes?

    • 0
      Avatar
      Keith Heppner

      Can you give different discounts to different customer categories?

    • 0
      Avatar
      Brendan O'Donnell

      Keith,

      Populi Bookstore doesn't link to those other databases—Ingram, in particular, charges exhorbitant rates for the privilege. As for discounts, not at this time, but there is a live feature request you can weigh in on: https://support.populiweb.com/entries/20250712-bookstore-internal-sales

    • 0
      Avatar
      Dr. Adam Biro

      Is it possible to make items always available, i.e. they don't have a specific inventory amount, they are just available on demand? We produce study guides and workbooks in house, so a specific inventory number is arbitrary. I wouldn't want students to think any of the materials we produce here are 'sold out' just because whatever initial inventory I might enter happens to get used up. Thanks. 

    • 0
      Avatar
      Keith Heppner

      Is it possible to upload from a csv file our starting inventory? 

    Article is closed for comments.