News:

Support the VirtueMart project and become a member

Main Menu

Update VirtueMart product price directly from MySQLi database

Started by MajorDang, July 02, 2019, 16:58:28 PM

Previous topic - Next topic

MajorDang

Greetings,
i want to be able to change my VirtueMart product prices directly from a C# application im developing.
To do so, i need to be able to connect to the VirtueMart database using the C# mySQL libraries, and update the price directly to the database by SKU of the product
Is this even possible ? If yes, where do i find the credentials of the database and the table name/field of VirtueMart. I have no experience in Joomla  so this may be a noob question. This is for a client of mine that has an eshop that uses Joomla 3
Thank you for your replies

Studio 42

database credential is same as Joomla.
So check your server support or joomla config.
Most database dont permit external acces(they use localhost) so it's possible that you cannnot connect to your shop
See JOOMLAROOT/administrator/components/com_virtuemart/tables/product_prices.php for table structure or simply use phpmyadmin.