Forum: Inventory Control

Jamie, I created an "Out of Stock" icon similar to the one's that come with SC. (New) (Sale) etc. I know I had it working before, but cannot remember how to get that icon badge to appear when the inventory item is set to 0? Any ideas? John

Jamie, Can you tell me how to do a database query to show all inventory levels that are at zero? Or does the tables "show all" display this? Second, could a database query be written to show all inventory levels that are say 5 or less? I'm not very good at database query...

A look at the documentation seems to suggest that if I have rental products in my store, all I need to do is create a pair of Order Status Options, e.g. "Shipped (rental)" and "Returned (rental)," and configure the Inventory Control to do the right thing to the inventory numbers for the product...

I have a client on SC 3.1.3. One of their product is a tshirt that has multiple sizes and colors. They'd like to track the inventory by size and color. The product in question is here: https://www.beyondboobsinc.org/cart/store.php?crn=224&rn=437&action=show_detail Right now they have an...

I’m trying to display the number of items in stock in the item description and the item preview on regular pages. Like this store does (which I found in a thread here); http://yellowbellyfrog.com/store.php/products/suds-maker-soap-bag My issue is pretty much the same as the following thread...

OK I have a client that uses inventory control because they sell rare items and may only have 1 of any item in stock. If a client adds an item to their cart where only 1 exists it takes that item to 0 showing out of stock which makes sense. We do not want another person to come along at the same...

On our store, I plan on having multiple items that will be "special order" (ordered from the supplier at the time they are purchased by the customer) since they will require our supplier to apply embroidery work before shipping them to us for distribution to the customer. Can I show these items...

I understand (from reading one of the other posts) that when a cart times out the items in the cart will be returned to inventory. I also understand that this action does not take place upon the actual timeout, but rather the first time the storefront page is hit after the timeout. Question:...

I have a problem when a guest places an order in the cart and dosent fininsh it. The problem is the invtory goes down and down untill it reaches 0. The guest that are doing this are trying to kill my bussiness and it hurts as the stock items are not reseting for unfinished orders. Has any...

I know this wasn't possible before but are there directions on importing items via a spreadsheet? Thanks.

I have come across a problem where my inventory is not going down to 0 when a customer adds the max number of products in there cart. The inventory will go down to 1 which allows the user to add one more then they should be able to or allows another customer (or multiple customers) to add the item...

Is there a way to get a breakdown of the products sold in each month and their quantities in Squirrelcart?

Had a wierd order yesterday. I only stock one-of-a-kind items. All stock levels set to "1". A customer was able to place an order for two of the same item. The item was not marked for individual packaging but Squirrelcart put them in separate packages anyway. Cannot reproduce.Log track did not...

I've been trying to figure out how to manage my books. Is there some kind of software that connects all these thing i.e. database, bank account, and credit card processors? How do people manage this? Do you get a bookkeeping program and just enter everything by hand? If so what kind of...

Hi, Can we editing orders? Like if a customer ordered three items and calls in a cancels one item? Also, if we find out it's on back order with no known shipping date, so we have to cancel it? Can we edit the order say, and have the cart readjust the shipping cost, taxes, and totals,...

My store settings for session timeout remain at the default of 180. Yet I just got my cart emptied after only 3 minutes of being idle. The message even said, you have been idle for 3 minutes, your cart has been emptied. Anyone know why?

Jamie: I had an order for 5 items this morning. I sell one-of-a-kind items that each have an inventory level of "1". This mornings order DID NOT reduce the inventory and each item remained for sale until I checked and reduced inventory. Inventory control is enabled and so far, had been...

Hi, I've got a problem with inventory tracking: Create a product with options. Set stock levels for options. Set an overall stock level for the product. Add product (with an option selected) to basket, and allow session to expire (and hence replenish stock) Result: Overall stock level...