{"id":304333,"date":"2021-09-03T10:21:04","date_gmt":"2021-09-03T10:21:04","guid":{"rendered":"https:\/\/webkul.com\/blog\/?p=304333"},"modified":"2022-04-26T10:52:32","modified_gmt":"2022-04-26T10:52:32","slug":"managing-custom-field-in-database-using-webservice","status":"publish","type":"post","link":"https:\/\/webkul.com\/blog\/managing-custom-field-in-database-using-webservice\/","title":{"rendered":"Managing custom field in database using webservice"},"content":{"rendered":"\n

In this blog we are going to learn how to manage custom fields in database using webservice in PrestaShop.<\/p>\n\n\n\n

In PrestaShop, If we have added a custom column in the core table & we want to manage this column with the webservice than we need to make some changes in core class.<\/p>\n\n\n\n

Let’s Practical…!<\/em><\/p>\n\n\n\n

Suppose, We have alter a new column in customer table named “mobile” & we need to manage this using webservice. Now, we will set this mobile column in webservicePerameters with setter & getter in customer class file. See steps below:<\/p>\n\n\n\n

Step 1 :<\/strong><\/h2>\n\n\n\n

In classes\/customer.php file write the code as given below (Add mobile with getter & setter methods):<\/p>\n\n\n\n

protected $webserviceParameters = array(\n    'fields' => array(\n        'id_default_group' => array('xlink_resource' => 'groups'),\n        'id_lang' => array('xlink_resource' => 'languages'),\n        'newsletter_date_add' => array(),\n        'ip_registration_newsletter' => array(),\n        'last_passwd_gen' => array('setter' => null),\n        'secure_key' => array('setter' => null),\n        'deleted' => array(),\n        'passwd' => array('setter' => 'setWsPasswd'),\n        'mobile' => array('setter' => 'setWsMobile', 'getter' => 'getWsMobile'),\n    ),\n    'associations' => array(\n        'groups' => array('resource' => 'group'),\n    ),\n);<\/pre>\n\n\n\n
Step 2 :<\/strong><\/h2>\n\n\n\n
We need to create two functions in classes\/customer.php file to get\/set mobile field value. See below custom functions:<\/p>\n\n\n\n
public function getWsMobile()\n{\n    $customer = new self((int) $this->id);\n    return $customer->mobile;\n}\n\npublic function setWsMobile($mobile)\n{\n    $this->mobile = $mobile;\n    return true;\n}<\/pre>\n\n\n\n
Now, When we will hit customer API to create\/update record using POST\/PUT request type than we need to send extra key named ‘mobile’ in request data. Follow same as we have explained below.  After adding ‘mobile’ key in request data setter method will automatically handle the save process & will update value in database table.<\/p>\n\n\n\n
<prestashop xmlns:xlink="http:\/\/www.w3.org\/1999\/xlink">\n  <customer>\n    <id>1<\/id>\n    <passwd>123456<\/passwd>\n    <lastname>DOE<\/lastname>\n    <firstname>John<\/firstname>\n    <email>pub@prestashop.com<\/email>\n    <mobile>9876543210<\/mobile>\n  <\/customer>\n<\/prestashop><\/pre>\n\n\n\n
Now when you will hit the API to get customer details than a extra key you will get in API response with the value.<\/p>\n\n\n\n
\"Screenshot\"<\/figure>\n\n\n\n
Note:<\/strong><\/p>\n\n\n\n
This is a basic example in which we shows only one custom field. You can follow same for the multiple columns\/fields.<\/p>\n\n\n\n
Also, you can explore our PrestaShop Development Services<\/a> and a large range of quality PrestaShop Modules<\/a>.<\/p>\n\n\n\n
For any doubt contact us at support@webkul.com<\/p>\n","protected":false},"excerpt":{"rendered":"
In this blog we are going to learn how to manage custom fields in database using webservice in PrestaShop. In PrestaShop, If we have added a custom column in the core table & we want to manage this column with the webservice than we need to make some changes in core class. Let’s Practical…! Suppose, […]<\/a><\/p>\n","protected":false},"author":387,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1173,209,1172],"tags":[292,3291,3283,293],"class_list":["post-304333","post","type-post","status-publish","format-standard","hentry","category-api-2","category-prestashop","category-web-service","tag-api","tag-prestashop-webservice","tag-prestashop-webservice-api","tag-webservice"],"yoast_head":"\nManaging custom field in database using webservice - Webkul Blog<\/title>\n<meta name=\"description\" content=\"In PrestaShop, If we have added a custom column in the core table & we want to manage this column with the webservice than we need to make some changes in core class.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/webkul.com\/blog\/managing-custom-field-in-database-using-webservice\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Managing custom field in database using webservice - Webkul Blog\" \/>\n<meta property=\"og:description\" content=\"In PrestaShop, If we have added a custom column in the core table & we want to manage this column with the webservice than we need to make some changes in core class.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/webkul.com\/blog\/managing-custom-field-in-database-using-webservice\/\" \/>\n<meta property=\"og:site_name\" content=\"Webkul Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/webkul\/\" \/>\n<meta property=\"article:published_time\" content=\"2021-09-03T10:21:04+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-04-26T10:52:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/webkul.com\/blog\/wp-content\/uploads\/2021\/09\/Screenshot.png\" \/>\n<meta name=\"author\" content=\"Sunny Kumar\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@webkul\" \/>\n<meta name=\"twitter:site\" content=\"@webkul\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sunny Kumar\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/webkul.com\/blog\/managing-custom-field-in-database-using-webservice\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/webkul.com\/blog\/managing-custom-field-in-database-using-webservice\/\"},\"author\":{\"name\":\"Sunny Kumar\",\"@id\":\"https:\/\/webkul.com\/blog\/#\/schema\/person\/82afaa5265683f080b52d639e7cdaf67\"},\"headline\":\"Managing custom field in database using webservice\",\"datePublished\":\"2021-09-03T10:21:04+00:00\",\"dateModified\":\"2022-04-26T10:52:32+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/webkul.com\/blog\/managing-custom-field-in-database-using-webservice\/\"},\"wordCount\":271,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/webkul.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/webkul.com\/blog\/managing-custom-field-in-database-using-webservice\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/webkul.com\/blog\/wp-content\/uploads\/2021\/09\/Screenshot.png\",\"keywords\":[\"api\",\"Prestashop Webservice\",\"Prestashop WebService API\",\"webservice\"],\"articleSection\":[\"API\",\"prestashop\",\"web service\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/webkul.com\/blog\/managing-custom-field-in-database-using-webservice\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/webkul.com\/blog\/managing-custom-field-in-database-using-webservice\/\",\"url\":\"https:\/\/webkul.com\/blog\/managing-custom-field-in-database-using-webservice\/\",\"name\":\"Managing custom field in database using webservice - Webkul Blog\",\"isPartOf\":{\"@id\":\"https:\/\/webkul.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/webkul.com\/blog\/managing-custom-field-in-database-using-webservice\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/webkul.com\/blog\/managing-custom-field-in-database-using-webservice\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/webkul.com\/blog\/wp-content\/uploads\/2021\/09\/Screenshot.png\",\"datePublished\":\"2021-09-03T10:21:04+00:00\",\"dateModified\":\"2022-04-26T10:52:32+00:00\",\"description\":\"In PrestaShop, If we have added a custom column in the core table & we want to manage this column with the webservice than we need to make some changes in core class.\",\"breadcrumb\":{\"@id\":\"https:\/\/webkul.com\/blog\/managing-custom-field-in-database-using-webservice\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/webkul.com\/blog\/managing-custom-field-in-database-using-webservice\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/webkul.com\/blog\/managing-custom-field-in-database-using-webservice\/#primaryimage\",\"url\":\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/09\/Screenshot.png\",\"contentUrl\":\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/09\/Screenshot.png\",\"width\":897,\"height\":669,\"caption\":\"Screenshot\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/webkul.com\/blog\/managing-custom-field-in-database-using-webservice\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/webkul.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Managing custom field in database using webservice\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/webkul.com\/blog\/#website\",\"url\":\"https:\/\/webkul.com\/blog\/\",\"name\":\"Webkul Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/webkul.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/webkul.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/webkul.com\/blog\/#organization\",\"name\":\"WebKul Software Private Limited\",\"url\":\"https:\/\/webkul.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/webkul.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/08\/webkul-logo-accent-sq.png\",\"contentUrl\":\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/08\/webkul-logo-accent-sq.png\",\"width\":380,\"height\":380,\"caption\":\"WebKul Software Private Limited\"},\"image\":{\"@id\":\"https:\/\/webkul.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/webkul\/\",\"https:\/\/x.com\/webkul\",\"https:\/\/www.instagram.com\/webkul\/\",\"https:\/\/www.linkedin.com\/company\/webkul\",\"https:\/\/www.youtube.com\/user\/webkul\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/webkul.com\/blog\/#\/schema\/person\/82afaa5265683f080b52d639e7cdaf67\",\"name\":\"Sunny Kumar\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/webkul.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/71f74f424b1b289dfe7a885325f69bf2ecd11c159d2c3ee19fc5df341650df4c?s=96&d=https%3A%2F%2Fcdnblog.webkul.com%2Fblog%2Fwp-content%2Fuploads%2F2019%2F10%2Fmike.png&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/71f74f424b1b289dfe7a885325f69bf2ecd11c159d2c3ee19fc5df341650df4c?s=96&d=https%3A%2F%2Fcdnblog.webkul.com%2Fblog%2Fwp-content%2Fuploads%2F2019%2F10%2Fmike.png&r=g\",\"caption\":\"Sunny Kumar\"},\"description\":\"Sunny, a Prestashop virtuoso, crafts innovative eCommerce solutions. His expertise in marketplace development is unparalleled, seamlessly integrating modules. With precision coding, Sunny creates robust online stores, ensuring a seamless user experience. His engineering prowess enhances digital retail, leaving a lasting impact on the Prestashop community.\",\"url\":\"https:\/\/webkul.com\/blog\/author\/sunny-kumar912\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Managing custom field in database using webservice - Webkul Blog","description":"In PrestaShop, If we have added a custom column in the core table & we want to manage this column with the webservice than we need to make some changes in core class.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/webkul.com\/blog\/managing-custom-field-in-database-using-webservice\/","og_locale":"en_US","og_type":"article","og_title":"Managing custom field in database using webservice - Webkul Blog","og_description":"In PrestaShop, If we have added a custom column in the core table & we want to manage this column with the webservice than we need to make some changes in core class.","og_url":"https:\/\/webkul.com\/blog\/managing-custom-field-in-database-using-webservice\/","og_site_name":"Webkul Blog","article_publisher":"https:\/\/www.facebook.com\/webkul\/","article_published_time":"2021-09-03T10:21:04+00:00","article_modified_time":"2022-04-26T10:52:32+00:00","og_image":[{"url":"https:\/\/webkul.com\/blog\/wp-content\/uploads\/2021\/09\/Screenshot.png","type":"","width":"","height":""}],"author":"Sunny Kumar","twitter_card":"summary_large_image","twitter_creator":"@webkul","twitter_site":"@webkul","twitter_misc":{"Written by":"Sunny Kumar","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/webkul.com\/blog\/managing-custom-field-in-database-using-webservice\/#article","isPartOf":{"@id":"https:\/\/webkul.com\/blog\/managing-custom-field-in-database-using-webservice\/"},"author":{"name":"Sunny Kumar","@id":"https:\/\/webkul.com\/blog\/#\/schema\/person\/82afaa5265683f080b52d639e7cdaf67"},"headline":"Managing custom field in database using webservice","datePublished":"2021-09-03T10:21:04+00:00","dateModified":"2022-04-26T10:52:32+00:00","mainEntityOfPage":{"@id":"https:\/\/webkul.com\/blog\/managing-custom-field-in-database-using-webservice\/"},"wordCount":271,"commentCount":0,"publisher":{"@id":"https:\/\/webkul.com\/blog\/#organization"},"image":{"@id":"https:\/\/webkul.com\/blog\/managing-custom-field-in-database-using-webservice\/#primaryimage"},"thumbnailUrl":"https:\/\/webkul.com\/blog\/wp-content\/uploads\/2021\/09\/Screenshot.png","keywords":["api","Prestashop Webservice","Prestashop WebService API","webservice"],"articleSection":["API","prestashop","web service"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/webkul.com\/blog\/managing-custom-field-in-database-using-webservice\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/webkul.com\/blog\/managing-custom-field-in-database-using-webservice\/","url":"https:\/\/webkul.com\/blog\/managing-custom-field-in-database-using-webservice\/","name":"Managing custom field in database using webservice - Webkul Blog","isPartOf":{"@id":"https:\/\/webkul.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/webkul.com\/blog\/managing-custom-field-in-database-using-webservice\/#primaryimage"},"image":{"@id":"https:\/\/webkul.com\/blog\/managing-custom-field-in-database-using-webservice\/#primaryimage"},"thumbnailUrl":"https:\/\/webkul.com\/blog\/wp-content\/uploads\/2021\/09\/Screenshot.png","datePublished":"2021-09-03T10:21:04+00:00","dateModified":"2022-04-26T10:52:32+00:00","description":"In PrestaShop, If we have added a custom column in the core table & we want to manage this column with the webservice than we need to make some changes in core class.","breadcrumb":{"@id":"https:\/\/webkul.com\/blog\/managing-custom-field-in-database-using-webservice\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/webkul.com\/blog\/managing-custom-field-in-database-using-webservice\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/webkul.com\/blog\/managing-custom-field-in-database-using-webservice\/#primaryimage","url":"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/09\/Screenshot.png","contentUrl":"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/09\/Screenshot.png","width":897,"height":669,"caption":"Screenshot"},{"@type":"BreadcrumbList","@id":"https:\/\/webkul.com\/blog\/managing-custom-field-in-database-using-webservice\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/webkul.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Managing custom field in database using webservice"}]},{"@type":"WebSite","@id":"https:\/\/webkul.com\/blog\/#website","url":"https:\/\/webkul.com\/blog\/","name":"Webkul Blog","description":"","publisher":{"@id":"https:\/\/webkul.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/webkul.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/webkul.com\/blog\/#organization","name":"WebKul Software Private Limited","url":"https:\/\/webkul.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/webkul.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/08\/webkul-logo-accent-sq.png","contentUrl":"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/08\/webkul-logo-accent-sq.png","width":380,"height":380,"caption":"WebKul Software Private Limited"},"image":{"@id":"https:\/\/webkul.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/webkul\/","https:\/\/x.com\/webkul","https:\/\/www.instagram.com\/webkul\/","https:\/\/www.linkedin.com\/company\/webkul","https:\/\/www.youtube.com\/user\/webkul\/"]},{"@type":"Person","@id":"https:\/\/webkul.com\/blog\/#\/schema\/person\/82afaa5265683f080b52d639e7cdaf67","name":"Sunny Kumar","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/webkul.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/71f74f424b1b289dfe7a885325f69bf2ecd11c159d2c3ee19fc5df341650df4c?s=96&d=https%3A%2F%2Fcdnblog.webkul.com%2Fblog%2Fwp-content%2Fuploads%2F2019%2F10%2Fmike.png&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/71f74f424b1b289dfe7a885325f69bf2ecd11c159d2c3ee19fc5df341650df4c?s=96&d=https%3A%2F%2Fcdnblog.webkul.com%2Fblog%2Fwp-content%2Fuploads%2F2019%2F10%2Fmike.png&r=g","caption":"Sunny Kumar"},"description":"Sunny, a Prestashop virtuoso, crafts innovative eCommerce solutions. His expertise in marketplace development is unparalleled, seamlessly integrating modules. With precision coding, Sunny creates robust online stores, ensuring a seamless user experience. His engineering prowess enhances digital retail, leaving a lasting impact on the Prestashop community.","url":"https:\/\/webkul.com\/blog\/author\/sunny-kumar912\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/posts\/304333","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/users\/387"}],"replies":[{"embeddable":true,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/comments?post=304333"}],"version-history":[{"count":5,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/posts\/304333\/revisions"}],"predecessor-version":[{"id":349608,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/posts\/304333\/revisions\/349608"}],"wp:attachment":[{"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/media?parent=304333"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/categories?post=304333"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/tags?post=304333"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}