PDA

View Full Version : Stock after upgrade


jster71
May 4th, 2005, 11:36 AM
We were able to see the number of items in stock in version 1.4 after upgrading to 1.6 the stock number is no longer in the products table. Is there any way to get the number of items in stock on the products table overview page?

pbxcom
May 4th, 2005, 01:51 PM
I was unsure if you were refering to the product addition or editing page or the main products table listing.

If you need it in the product addition or editing page you will need to enable "Inventory Control" in your "Store Setting".

If you want it in the products table listing, you will first need to enter this url just obviously replacing the domain name with yours http://www.YOURDOMAIN.com/squirrelcart/index.php?show_record_links=1&table=Table_Definition

Just as a site note were you see "Table_Definition" in that url you can replace that with any table name from the database and be able to perform various edits and modifcation that can be helpful.

Next, locate the Products record it's record number 6 it should be near the top. Click the edit and just check the field(s) you want displayed.

jster71
May 4th, 2005, 03:00 PM
That got me a lot closer but I see no option for Qty only warehouse.

Since the addition of warehouses(ver. 1.5 I think) qty is now stored in a relational table and not in the actual products table.