GL
Asked
Hi, first sorry for my english nativa language Spanish
After update 3.4.14 to 3.4.18 the quantity Alerts show all the products with 0 quantity, before that only productos witch -1 was showing.
My site is now on 3.4.28 update
I tested 2 time same result.
I leave screenshots.
Also i notice a problem with update 3.4.14 to 3.4.15 that show table doent exist
"ERROR 1146 (42S02) at line 1: Table 'sma.sma_product_variants' doesn't exist"
tested also 2 times.
thx
After update 3.4.14 to 3.4.18 the quantity Alerts show all the products with 0 quantity, before that only productos witch -1 was showing.
My site is now on 3.4.28 update
I tested 2 time same result.
I leave screenshots.
Also i notice a problem with update 3.4.14 to 3.4.15 that show table doent exist
"ERROR 1146 (42S02) at line 1: Table 'sma.sma_product_variants' doesn't exist"
tested also 2 times.
thx
Attachments
- MSAnsweredHello,
Before it was display the products once they reached below quantity alter number. Now they will be in alter once the equal or less than quantity alert number.
For the SQL, Please replace the line with
```sql
ALTER TABLE `sma_product_variants` ADD UNIQUE `unique_product_id_name` (`product_id`, `name`);
```
If still for error, you can ignore this as it's just try to make the field unique but if there are already non-unique values, sql will produce error. - GLAnswered"Hello,
Before it was display the products once they reached below quantity alter number. Now they will be in alter once the equal or less than quantity alert number. "
I understand but there is a way to change this again the old way ? or a fix to change all alert quantitys at once, now i have 759 for alerts quantity, also will be nice an option to set a default alert quantity for all the products, - MSAnsweredThe import products can be used to update bulk products. System will check the product code and if found will update otherwise insert.
- Login to Reply