Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Out of stock, but in store?


Guest

Recommended Posts

I've got a lot of products in my store, and therefore its hard to have all the products in at the same time. And there are products I never have in stock, that must be ordered. Is there any way I can show all the products, other than going in to Administration - Products - and enable them? That would kill me if I had to do that for the 5000 products not showing up :'(

 

I've tried searching for my problem but I haven't found an answer, sorry if its allready widely covered and researched.

Link to comment
Share on other sites

assuming you have pictures for all of these, and entered all the necessary information (prices, weight, description etc). You activate all of them through a sql update query, and quantity showing 0 which then will indicate in the shopping cart that the product is not in shop, but needs to be ordered.

 

Alternatively, like I did for keukenlust, I'll be loading essentially pricelists data (no pict, no weight, no description). I list these under the categories similar to the upcoming products functionality.

 

HTH

Carine

KEEP CALM AND CARRY ON

I do not use the responsive bootstrap version since i coded my responsive version earlier, but i have bought every 28d of code package to support burts effort and keep this forum alive (albeit more like on life support).

So if you are still here ? What are you waiting for ?!

 

Find the most frequent unique errors to fix:

grep "PHP" php_error_log.txt | sed "s/^.* PHP/PHP/g" |grep "line" |sort | uniq -c | sort -r > counterrors.txt

Link to comment
Share on other sites

I've got a lot of products in my store, and therefore its hard to have all the products in at the same time. And there are products I never have in stock, that must be ordered. Is there any way I can show all the products, other than going in to Administration - Products - and enable them? That would kill me if I had to do that for the 5000 products not showing up  :'(

 

I've tried searching for my problem but I haven't found an answer, sorry if its allready widely covered and researched.

 

I have added a feature to my site where I mark my products as to whether they can be backordered or not. If marked as backorderable, the customer is told, payment is taken. If not marked as backorderable, they get a sold out icon so they cannot place the product in their shopping cart.

 

I was working on this as a contribution but got sidetracked. Please let me know if you would like what I have.

 

Regards,

 

Donna gordon

UKGoods.com

Link to comment
Share on other sites

I have added a feature to my site where I mark my products as to whether they can be backordered or not.  If marked as backorderable, the customer is told, payment is taken.  If not marked as backorderable, they get a sold out icon so they cannot place the product in their shopping cart.

 

I was working on this as a contribution but got sidetracked.  Please let me know if you would like what I have.

 

Regards,

 

Donna gordon

UKGoods.com

Hi Donna!

Sounds like a good plan! I would love to try your sollution!

Then I would have covered the products I have to backorder, do you know of any contribution that covers the other problem? If the product is out of stock, I want it to be accessible.

Some products are so popular that they are almost never in stock.

 

Regards

Tor

Dafiks.no

Link to comment
Share on other sites

assuming you have pictures for all of these, and entered all the necessary information (prices, weight, description etc). You activate all of them through a sql update query, and quantity showing 0 which then will indicate in the shopping cart that the product is not in shop, but needs to be ordered.

 

Alternatively, like I did for keukenlust, I'll be loading essentially pricelists data (no pict, no weight, no description). I list these under the categories similar to the upcoming products functionality.

 

HTH

Carine

 

Hi Carine!

 

Can I ask what query you run to make the products visible in the store? Will this affect the other products <b>in</b> stock?

 

Regards

Tor

Link to comment
Share on other sites

I just added the source code in my blog, (see last comment under quick & dirty uploading pricelists)

KEEP CALM AND CARRY ON

I do not use the responsive bootstrap version since i coded my responsive version earlier, but i have bought every 28d of code package to support burts effort and keep this forum alive (albeit more like on life support).

So if you are still here ? What are you waiting for ?!

 

Find the most frequent unique errors to fix:

grep "PHP" php_error_log.txt | sed "s/^.* PHP/PHP/g" |grep "line" |sort | uniq -c | sort -r > counterrors.txt

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...