Auto update shipping from VtigerCRM

[hrhsii]

Hi,
I am using Joomla 3.6 and VirtueMart 3.0.16

I use vtiger CRM to pull in all my orders from ebay and Amazon, once processed, I update the shipping for Amazon and eBay from vtiger.

I want to pull in the Virtuemart orders, i have seen the orders db table so that should be easy.

But how do i update the shipping so that the customer is emailed from VM once shipped?

If i update a table field for shipping, will VM automatically send the shipped email to the customer, or is there some other process?

Any help will be appreciated.

[GJC Web Design]

you need some way to update the order via the VM api to "Shipped" etc which will trigger the emails and stock etc etc

Probably via a plugin somehow.. look at any payment plugin to see the function and triggers used

e.g. the orders model function  updateStatusForOneOrder()

[hrhsii]

Thanks for the quick reply

I will check the functions you recommended

Are orders in VM3 still stored in the same tables as in VM2?

[GJC Web Design]

yes.. only minor changes I think (comments etc)

[hrhsii]

Thanks for your help