How to Add a New Custom Field in Prestashop
I’ve figured out how to add new field to database using Prestashop (1.4.3, but I think for the newer versions would be the same). This solution gives you new field in database and you will be able to edit / save data to this field in your admin panel, for my example I needed a field which was called “number of photos”. Below you can see how it works.
Read the full article »
Getting Cart From Prestashop
If you have a problem with getting cart from prestashop that would be interesting for you.
I had a huge problem with Prestashop (version 1.4.3) because I didn’t know how exactly I should get cart from Prestashop to the WordPress or somewhere else. However I spent some time to resolve that issue and I wrote that:
First of all we should get session data from Pretashop:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
require_once dirname(__FILE__) . '/config/config.inc.php' ; require_once(dirname(__FILE__) . '/config/settings.inc.php'); require_once dirname(__FILE__) . '/init.php' ; // this initializes the Cookie singleton, which is available in any script function getAllCookies(){ global $cookie ; // var_dump($cookie); return $cookie; } $cookie = getAllCookies(); |
As you see you should add some lines from Prestashop configuration and then you should create a function in which you have cart ID. And then you can easily get all data from the cart:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 |
$query = "SELECT p.id_product, pl.name, p.quantity, pp.price, p.id_product_attribute, pp.price * cu.conversion_rate AS orderprice, cu.sign, cu.format FROM ps_cart c LEFT JOIN ps_cart_product p ON (p.id_cart = c.id_cart) LEFT JOIN ps_product pp ON (pp.id_product = p.id_product) LEFT JOIN ps_product_lang pl ON (pl.id_product = p.id_product) LEFT JOIN ps_currency cu ON (cu.id_currency = c.id_currency) WHERE c.id_cart = " . (int) $cookie->id_cart . " AND pl.id_lang = 1 ORDER BY p.date_add ASC"; $link1 = mysql_connect(_DB_SERVER_, _DB_USER_, _DB_PASSWD_); if ($link1) { $db_selected = @mysql_select_db(_DB_NAME_, $link1); $res = mysql_query($query); $arrProducts = array(); while ($row = mysql_fetch_assoc($res)) { $arrProducts[] = $row; } var_dump($arrProducts); // all products from session cart } mysql_close($link1); |
(Sorry for quality of code but I had to wrote this as quick as possible)
And that’s all 