Productstock [SOLVED]

[PrestaQvisten]

Hi,

i have a question about product stock for my prestashop. I use 8.2.0

I want all my products by default so that they can be ordered, even if they are out of stock.

But some products i have on my Outlet/Sale category i need to add quantity, so my customer only can order the quantity i have for those specific products and when they are sold out they can't be ordered anymore. 

Is there any way to do this setting?

Edited March 7 by PrestaQvisten (see edit history)

[Daresh]

Sure, you have settings to allow ordering out of stock products:

[Knowband Plugins]

Hi,

You can change the settings for all products using below queries-

1. Set all products to allow ordering when out of stock by default.
UPDATE stock_available
SET out_of_stock = 1;

2. Restrict Products in the "Outlet/Sale" Category
UPDATE stock_available AS sa
JOIN ps_category_product AS cp ON sa.id_product = cp.id_product
JOIN ps_category_lang AS cl ON cp.id_category = cl.id_category
SET sa.out_of_stock = 0
WHERE cl.name = 'Outlet' OR cl.name = 'Sale';

Kindly change the name of the categories as per your need.

Regards

[PrestaQvisten]

  On 1/22/2025 at 7:23 AM, Daresh said:

Sure, you have settings to allow ordering out of stock products:

Expand  

Hi,

do i need to have the stock management activated if i want to use this method? 

[Daresh]

Yes you do.

[PrestaQvisten]

  On 1/22/2025 at 1:17 PM, Knowband Plugins said:

Hi,

You can change the settings for all products using below queries-

1. Set all products to allow ordering when out of stock by default.
UPDATE stock_available
SET out_of_stock = 1;

2. Restrict Products in the "Outlet/Sale" Category
UPDATE stock_available AS sa
JOIN ps_category_product AS cp ON sa.id_product = cp.id_product
JOIN ps_category_lang AS cl ON cp.id_category = cl.id_category
SET sa.out_of_stock = 0
WHERE cl.name = 'Outlet' OR cl.name = 'Sale';

Kindly change the name of the categories as per your need.

Regards

Expand  

HI, where do i use the SQL queries. Where in admin can i use that?  do i need a module or do i go in to my CPanel for my homepage?

[Knowband Plugins]

Hi,

You can execute the SQL queries directly through the cPanel for your store.

However, please ensure you take a backup of your database before running the queries to avoid any data loss.

Regards.

[PrestaQvisten]

  On 1/28/2025 at 1:24 PM, Knowband Plugins said:

Hi,

You can execute the SQL queries directly through the cPanel for your store.

However, please ensure you take a backup of your database before running the queries to avoid any data loss.

Regards.

Expand  

Okay thanks!