write directly to Products

[stasila]

Hi, I hope someone can help with this. I created new fields in Products module and it created new table in the database. “products_cstm”
I want to write data into products directly though MySQL queries from my Online store database. My question is which table I need to write to and how these two tables products and products_cstm would work together.
I’m really confused here with the ID.
Please advice.

Thanks,

[eggsurplus]

The products.id column ties to the products_cstm.id_c column so when doing an update you can join the two like:

update products_cstm pc
inner join products p on pc.id_c = p.id
set pc.mycustomfield_c = 'Hello World'
where p.id = 'INSERT_GUID_HERE'

Or more simply:

update products_cstm
set mycustomfield_c = 'Hello World'
where id_c = 'INSERT_GUID_HERE'

[stasila]

Thanks for quick reply. I also would have to associate it with product_templates which is product catalog.
so when I run a query to Insert into products table and products_cstm it should grab the product name from the product_template somehow, can you please advice on that?
thanks in advance.

[eggsurplus]

My best advice at that point is to get comfortable with the schema by looking at the tables available in the database and then build the scripts as you need it. My guess is that there's a product_template table of some sort that will get you what you need.