Jump to content

Warehouse Decrease Issue


D20

Recommended Posts

Hello everybody,

 

when in Warehouse Management, if I make a search by name, decrease is impossible.

 

Also if I make a search by EAN decrease works fine.

 

Is it a strange issue?

 

Someone have the same issue?

 

Thank You

Alessandro

 

Link to comment
Share on other sites

Hi there,

 

I have the same issue. Problem is with the SQL query. When trying to decrease a product without searching, SQL query is:

SELECT SQL_CALC_FOUND_ROWS a.* , w.id_currency, a.id_product as id, (a.price_te * a.physical_quantity) as valuation, w.name as warehouse
FROM `wsps_stock` a INNER JOIN `wsps_product` p ON (p.id_product = a.id_product AND p.advanced_stock_management = 1)
LEFT JOIN `wsps_warehouse` AS w ON w.id_warehouse = a.id_warehouse WHERE 1 AND a.id_product = 162 AND a.id_product_attribute = 542
ORDER BY `name` ASC LIMIT 0, 50

But when the product is searched by name, the SQL query is:

SELECT SQL_CALC_FOUND_ROWS a.* , w.id_currency, a.id_product as id, (a.price_te * a.physical_quantity) as valuation, w.name as warehouse
FROM `wsps_stock` a INNER JOIN `wsps_product` p ON (p.id_product = a.id_product AND p.advanced_stock_management = 1)
LEFT JOIN `wsps_warehouse` AS w ON w.id_warehouse = a.id_warehouse WHERE 1 AND a.id_product = 162 AND a.id_product_attribute = 542
AND `name` LIKE '%kasa%'
ORDER BY `name` ASC LIMIT 0, 50

See the difference? Is it possible to fix it with some setting or do we have to wait for the next version?

 

Thanks,

 

peter

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...