vTiger Prestashop Connector Installetion
   21/07/2017 00:00:00     vTiger Instructions    0 Comments

Folder from vtigersync_3.zip should be placed in prestashop root directory

  • vtigersyncconfigconfig.php

here connection with vtiger - ​link, access token and sync time interval

  • vtigersyncconfigmapfields.php

here field mapping - vtiger field vs prestashop fields

  • vtigersynccronvtigersync.sh

this file should be added in cron

You need to create table in Prestashop database and insert data inside

CREATE TABLE IF NOT EXISTS `vtigersync` (

  `id` int(11) NOT NULL,

  `time` datetime NOT NULL,

  `actual_order` datetime NOT NULL,

  `actual_contact` datetime NOT NULL,

  `actual_product` datetime NOT NULL,

  `next_order` datetime NOT NULL,

  `next_contact` datetime NOT NULL,

  `next_product` datetime NOT NULL,

  PRIMARY KEY (`id`)

) ENGINE=MyISAM;

INSERT INTO `vtigersync` (`id`, `time`, `actual_order`, `actual_contact`, `actual_product`, `next_order`, `next_contact`, `next_product`) VALUES

(1, '2017-01-31 09:00:02', '2017-01-31 09:00:02', '2017-01-31 09:00:02', '2017-01-31 08:45:01', '2017-01-31 09:15:02', '2017-01-31 09:15:02', '2017-01-31 10:45:03');

Its nessesary to create field in vtiger Product profile where will be placed prestashop_product_id

vtigersyncvtigerconnector.php

line 282 - need to place fieldname of prestashop_product_id that created in vtiger

$queryResult = $this->client->doQuery("SELECT * FROM Products WHERE cf_753<-!!HERE!! = '$sku';");

Share This Post :

Comments

Log in or register to post comments

Our team has enough experience in vTiger CRM to bring all your ideas according to life. Our experts will analyse your business needs and recommend you how to solve it better. And after our developers make it in your crm system.

What we do

  • Basic functional upgrade and customization
  • Migration crm to higher version
  • Migration from another crm to vTiger
  • Extensions and Modules Development
  • API integration with other software
  • 2rd, 3rd lines technical support

Send us your requirements by webform below and we will estimate it and back to you soon. Also you can send it on support@vordoom.com