News:

Support the VirtueMart project and become a member

Main Menu

Virtuemart to connect with an external data base

Started by Indiaexcite, October 15, 2020, 15:27:27 PM

Previous topic - Next topic

Indiaexcite

Virtuemart to connect with an external data base (independent from Joomla and Virtuemart).
Set up a cronjob for updates.

Virtuemart / Connecting external database for inventory update.
We already have components installed to connect virtuemart with an external database.
Require expertise in Mysql and Php to achieve the perfect solution.

pinochico

www.minijoomla.org  - new portal for Joomla!, Virtuemart and other extensions
XML Easy Feeder - feeds for FB, GMC,.. from products, categories, orders, users, articles, acymailing subscribers and database table
Virtuemart Email Manager - customs email templates
Import products for Virtuemart - from CSV and XML
Rich Snippets - Google Structured Data
VirtueMart Products Extended - Slider with products, show Others bought, Products by CF ID and others filtering products

Rsn

Have experience working with external databases. Not only MySQL, but also, for example, MS SQL and others.

CarterW

Quote from: Indiaexcite on October 15, 2020, 15:27:27 PM
Virtuemart to connect with an external data base (independent from Joomla and Virtuemart).
Set up a cronjob for updates.

Virtuemart / Connecting external database for inventory update.
We already have components installed to connect virtuemart with an external database.
Require expertise in Mysql and Php to achieve the perfect solution.

Hello There,
I'd Glad to assist you.
Pm Sent with details, please check.
Thanks and Regards
Carter W

pinochico

#4
To CarterW:

Assist what???

All users in this post have the experience and software for connecting Virtuemart to external DB.

Which do you want to assist and for whom?

But if you need I can send to you PM, so you are not lonely :D
www.minijoomla.org  - new portal for Joomla!, Virtuemart and other extensions
XML Easy Feeder - feeds for FB, GMC,.. from products, categories, orders, users, articles, acymailing subscribers and database table
Virtuemart Email Manager - customs email templates
Import products for Virtuemart - from CSV and XML
Rich Snippets - Google Structured Data
VirtueMart Products Extended - Slider with products, show Others bought, Products by CF ID and others filtering products

stAn99

i've got a full shop sync software as well which syncs MS Sql based database (Helios stock accounting and stock system) running on remote server which syncs all the products, categories, customfields, images, prices, supplier databases with the remote system daily or on demand via background CLI jobs.

this type of custom sync system is usually a matter of hundreds of hours to get it done properly and effeciently and the system needs to handle addition/update/removal of all related items.

my system doesn't run on joomla or VM, but inserts the data directly into the database and expects a dedicated servers on both ends with plenty of RAM, system is optimized for high latency internet lines where queries might be returned in tens of seconds from the remote server.

another sync software which is part of our OPC syncs Sherpann.nl stock system (VM to Sherpa products, Sherpa to VM stock + invoices, VM to Sherpa orders ), it runs on PHP-CLI and loads VM and Joomla during the process.

best regards, stan

----
RuposTel.com
www.rupostel.com
Your customized checkout solution for Virtuemart