WebSite X5Help Center

 
Vladimir A.
Vladimir A.
User

Updating products availability and quantity via direct Db connection  en

Author: Vladimir A.
Visited 434, Followers 1, Shared 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
3 ANSWERS - 2 USEFUL - 1 CORRECT
Axel  
Axel  
User
Best User of the month FR

Db structure is not complete to do many things

a full rebuild should be good !

Read more
Posted on the from Axel  
Vladimir A.
Vladimir A.
User
Author

Are you saying the essential product information I'm trying to update is compiled into a binary resource?

Read more
Posted on the from Vladimir A.
Axel  
Axel  
User
Best User of the month FR

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

Read more
Posted on the from Axel