Author Topic: Virtuemart to connect with an external data base  (Read 569 times)

Indiaexcite

  • Readers
  • *
  • Posts: 0
  • A beginner
Virtuemart to connect with an external data base
« 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.

pinochico

  • 3rd party VirtueMart Developer
  • Full Member
  • *
  • Posts: 817
    • MiniJoomla
  • Skype Name: support-easysoftware
  • VirtueMart Version: 3
Re: Virtuemart to connect with an external data base
« Reply #1 on: October 15, 2020, 16:03:24 pm »
We have to :)
www.minijoomla.org  - new portal for Joomla!, Virtuemart and other extensions
XML Easy Feeder - feeds from products, orders and database table
Virtuemart Email Manager - customs email templates

Rsn

  • Jr. Member
  • **
  • Posts: 55
  • Advanced user
    • Blog InformResource
Re: Virtuemart to connect with an external data base
« Reply #2 on: October 15, 2020, 22:19:30 pm »
Have experience working with external databases. Not only MySQL, but also, for example, MS SQL and others.

CarterW

  • Readers
  • *
  • Posts: 0
  • A beginner
  • Skype Name: live:carter_1594
Re: Virtuemart to connect with an external data base
« Reply #3 on: October 17, 2020, 17:55:28 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

  • 3rd party VirtueMart Developer
  • Full Member
  • *
  • Posts: 817
    • MiniJoomla
  • Skype Name: support-easysoftware
  • VirtueMart Version: 3
Re: Virtuemart to connect with an external data base
« Reply #4 on: October 18, 2020, 05:59:13 am »
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 from products, orders and database table
Virtuemart Email Manager - customs email templates

stAn99

  • Contributing Developer
  • Jr. Member
  • *
  • Posts: 90
    • One Page Checkout for Virtuemart 2
Re: Virtuemart to connect with an external data base
« Reply #5 on: November 17, 2020, 13:57:15 pm »
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