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
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.