Updating products availability and quantity via direct Db connection 
Autor: Vladimir A.
Visited 800,
Followers 1,
Udostępniony 0
Hello All. I'm trying to find a simple way of updating products availability and other cart--> products params using direct connection to the database (MySql) instead of uploading the website from X5 every time I change something. I found the way to update the product's availability using the script below. However, I don't see the table where I can update the Description, Price, Qty etc. Any thoughts on how I can do it? Thx!
update my_db_name.w5_xxxxxx_cart_dynamicproducts set quantity = 10 where id = 'my_product_id';
Posted on the
Db structure is not complete to do many things
a full rebuild should be good !
Autor
Are you saying the essential product information I'm trying to update is compiled into a binary resource?
All e-commerce data are NOT into the db!
try to see and to check how it works...
not like any product using a db.
trust me, I worked long time to create a web interface to manage the db.
not possible to do all BECAUSE THE DB STRUCTURE is really bad
for fun check how the delivery address is managed. by line and not by row !!!!!
so the db is growing up very fast by using x lined for one address and not just one with x rows
Hope to clear to help you. actually not possible to manage the ecommerce data directly vis sql
Axel