Project Description:
I'm using Hikashop component in Joomla which takes online e-commerce and vTiger CRM for backend invoicing/stocktaking.
What I need is that:
- If there is a successful order through Hikashop (status Paid), I require the customer's contact details to be imported as a vTiger contact (name and details, email, billing/shipping address) and their Hikashop order to be imported as a vTiger invoice (products ordered, qty ordered, per product tax, shipping).
Hikashop supports a 'payment success' page where you can write any PHP/MySQL code to process upon successful order.
- Once order is created, decrease the inventory of product in vTiger.
There will be a product field that have the same SKU on both the platforms, so you will need to do some sort of search/comparison to 'link' products between them.
I think there will not be much complex work involved, and most of the time spent learning/finding SQL data to be used...
