How to add new tables in REST API of PrestaShop Webservice

From last 2-3 days , I hitched in a problem , actually my problem was to create an entry in prestashop`s table(created by me) using webservices , but as we all know that , the webService of Prestashop includes only REST API which has very limited number of nodes(tables) for performing CRUD(Create/Read/Update/Delete) operations. I googled a lot for finding a solution, but found nothing.

Finally, I did it by reading codes of prestashop ,also by HIT n TRY method. Now , I want to share it with all of you .May be it will help someone like me n save his/her time. Here it is,

Table Information : (which we want to add in prestashop`s webservice)

Table Name   : erp_product_merge
Columns name : id , erp_product_id ,  prestashop_product_id , created_by.
Primary key  : id

PHP Code :  [stextbox id=”info”]save this code as ‘ProductMerge.php’ in ‘~prestashop\override\classes’ folder.[/stextbox]

class ProductMergeCore extends ObjectModel

{	public $erp_product_id;
	public $prestashop_product_id;
	public $created_by ;
	public static $definition = array(
	'table' => 'erp_product_merge',
	'primary' => 'id',
	'fields' => array(
	'erp_product_id' => array('type' => self::TYPE_INT, 'required' => true),
	'prestashop_product_id' => array('type' => self::TYPE_INT,  'required' => true),
	'created_by' => array('type' => self::TYPE_STRING,  'required' => false, 'size' => 64),
	),
	);
	protected $webserviceParameters = array();
}

PHP Code :  [stextbox id=”info”]save this code as ‘WebserviceRequest.php’ in ‘~prestashop\override\classes\webservice’ folder.[/stextbox]

<?php
class WebserviceRequest extends WebserviceRequestCore
{
public static function getResources()
{
$resources=parent::getResources();
$resources['erp_product_merges'] = array('description' => 'Test Demo', 'class' => 'ProductMerge');
ksort($resources);
return $resources;
}
}

Now , give the permissions to this resource from prestashop`s admin panel and try to perform CRUD operations on this resource via WebServices. Enjoy !!

[stextbox id=”warning”]Your opinions, comments and suggestions are important to keep the page updated and interesting. [/stextbox]

Mohit Chandra 6 Badges

Mohit Chandra is an expert Odoo developer and the Owl framework, specializing in multi-platform integration services. He excels in developing dynamic, scalable solutions that seamlessly integrate diverse systems, leveraging his deep knowledge to enhance business efficiency and drive technological innovation.

• 10 Oct, 2017
  Updated by - Mohit Chandra
• 26 Mar, 2015
  Updated by - Neha Sharma

View More