How To Keep Out Of Stock Item Status As Active?

[awarner20]

Hi folks,

 

I'm administering a collectable card games site and when a user buys the last available stock for a certain card, the item status is set to inactive and therfore does not show any longer in the store. We can simply go into the Admin and reset this to active, but it's becoming increasingly difficult to keep track of these products as we have over 1000 and our sales are increasing during our first month being "live".

 

These cards come in sets so even though a card may be Out of Stock, our customers would still like to view the descriptions and know which cards come in which sets.

 

I have done some searches and have found what I think may be close to a solution, but it's kind of unclear to me. It seems that I might be able to edit (or comment out) some code on the checkout_process.php page that updates the status of products based on if the quanity falls to zero. Please see the following post to see what I mean... http://www.oscommerce.com/forums/index.php?s=&...st&p=501906

 

So, my question is...is this the correct query to edit and if so, can someone please put it in clearer terms for me? As always, any assistance is GREATLY appreciated:)

[Avec]

That setting is in the Admin Console-configuration-product information.

[awarner20]

That setting is in the Admin Console-configuration-product information.

 

Thanks for your reply, but I'm afraid that maybe you mis-understood my question. There is no setting in Admin to accomplish what I need. The possible solutionias described in the forum link I posted. My question was regarding that solution. I was asking for clarification on how to edit the query listed in the solution, and whether or not someone could verify that this is the only way to accomplish what I need.

 

I am using osCommerce 2.2 Milestone 2 Update 060817.

 

Thanks in advance for any further assistance anyone can provide.

[Guest]

I also tried editing out that code. But the easiest way to do what I think your trying to do was as said before via your admin.

In admin goto Configuration>Stock

Subtract Stock - false

Allow Checkout - false

 

The file I edited was for check/money order orders, I wanted my stock working but I didnt want it to subract stock from check/money order orders until I got the cash and then I would manually adjust the stock. I did it that way because I was getting check/money order orders and they never sent payment, and if it removed the item when they placed the order then my inventory would be all screwed up.

[awarner20]

I also tried editing out that code. But the easiest way to do what I think your trying to do was as said before via your admin.

In admin goto Configuration>Stock

Subtract Stock - false

Allow Checkout - false

 

The file I edited was for check/money order orders, I wanted my stock working but I didnt want it to subract stock from check/money order orders until I got the cash and then I would manually adjust the stock. I did it that way because I was getting check/money order orders and they never sent payment, and if it removed the item when they placed the order then my inventory would be all screwed up.

 

 

Thanks for the reply, but I think my issue may be a bit more complicated because not only would I like the items to stay in "active" status, but I also need to set Subtract Stock - true. The store Admin is keeping track of their store stock this way and needs the "Out of Stock" to show when they no longer have inventory.

 

Hmmmm...maybe they'll just have to settle for manually setting the items as active after the go into the inactive status, or maybe they could keep their stock levels on a seperate spreadsheet. Does that make sense?

[awarner20]

Thanks for the reply, but I think my issue may be a bit more complicated because not only would I like the items to stay in "active" status, but I also need to set Subtract Stock - true. The store Admin is keeping track of their store stock this way and needs the "Out of Stock" to show when they no longer have inventory.

 

Hmmmm...maybe they'll just have to settle for manually setting the items as active after the go into the inactive status, or maybe they could keep their stock levels on a seperate spreadsheet. Does that make sense?

 

Does anyone else have any thoughts on how I might accomplish the goal here?

 

All in stock and out of stock items need to remain in "active" status (so they will show in store) while still setting "subtract stock" to true and permitting out of stock items to still show "out of stock" on store pages.

 

Thanks for any more thoughts on this...

[Jack_mcs]

Any of the Soldout contributions will do that.

 

Jack

[Guest]

Hey man... I've got EXACTLY what you need:

 

Open checkout_process.php and depending on what you're file contains, this will be around lines 151-153:

 

		if ( ($stock_left < 1) && (STOCK_ALLOW_CHECKOUT == 'false') ) {
	  tep_db_query("update " . TABLE_PRODUCTS . " set products_status = '0' where products_id = '" . tep_get_prid($order->products[$i]['id']) . "'");
	}

 

Comment out those three lines with "//" at the beginning of the lines, and sold out products will remain visible in the store, but a customer will not be able to actually checkout that item.

 

Let me know how it works for you!

[awarner20]

@ jack - Thank you for pointing me to those contribs. I will be installing the following as it seems to have some more in depth functions included.

http://www.oscommerce.com/community/contri.../search,soldout

 

@ john - Thanks also for your tip and clarifying that commenting out that code will work.

 

Have a good day guys!