Jump to content


  • Content count

  • Joined

  • Last visited

About mpatzekov

  • Rank
    PrestaShop Newbie
  • Birthday 03/20/1986

Profile Information

  • Gender
  • Location

Contact Methods

  • Website URL
  1. Rocky's solution actually works on Thanks
  2. Product in DB, not showing in CMS

    Up! Anybody with any ideas???
  3. Product in DB, not showing in CMS

    Good point. The out put of: SELECT * FROM ps_category_product WHERE id_product=2773; is: +-------------+------------+----------+ | id_category | id_product | position | +-------------+------------+----------+ | 2 | 2773 | 720 | +-------------+------------+----------+ 1 row in set (0.00 sec) I am wondering can this problem be connected with the SQL QUERY in the cms? My current query (show sql query) is : SELECT a.`id_product`, b.`name` AS `name`, `reference`, manu.`name` AS `manufacturer`, a.`price` AS `price`, sa.`active` AS `active` , shop.`name` AS `shopname`, a.`id_shop_default`, image_shop.`id_image` AS `id_image`, cl.`name` AS `name_category`, sa.`price`, 0 AS `price_final`, a.`is_virtual`, pd.`nb_downloadable`, sav.`quantity` AS `sav_quantity`, sa.`active`, IF(sav.`quantity`<=0, 1, 0) AS `badge_danger` FROM `ps_product` a LEFT JOIN `ps_product_lang` b ON (b.`id_product` = a.`id_product` AND b.`id_lang` = 1 AND b.`id_shop` = 1) LEFT JOIN `ps_stock_available` sav ON (sav.`id_product` = a.`id_product` AND sav.`id_product_attribute` = 0 AND sav.id_shop = 1 AND sav.id_shop_group = 0 ) JOIN `ps_product_shop` sa ON (a.`id_product` = sa.`id_product` AND sa.id_shop = a.id_shop_default) LEFT JOIN `ps_category_lang` cl ON (sa.`id_category_default` = cl.`id_category` AND b.`id_lang` = cl.`id_lang` AND cl.id_shop = a.id_shop_default) LEFT JOIN `ps_shop` shop ON (shop.id_shop = a.id_shop_default) LEFT JOIN `ps_image_shop` image_shop ON (image_shop.`id_product` = a.`id_product` AND image_shop.`cover` = 1 AND image_shop.id_shop = a.id_shop_default) LEFT JOIN `ps_image` i ON (i.`id_image` = image_shop.`id_image`) LEFT JOIN `ps_product_download` pd ON (pd.`id_product` = a.`id_product`) INNER JOIN `ps_manufacturer` AS manu ON (manu.`id_manufacturer` = a.`id_manufacturer`) WHERE 1 ORDER BY a.`id_product` ASC LIMIT 0, 50
  4. Did somebody experienced the problem I have now? I can see that 1 product is written in the database. Here is the output of : mysql> select id_product,id_category_default, id_manufacturer, reference, date_add from ps_product; What I get as output is: +------------+---------------------+-----------------+-------------------+---------------------+ | id_product | id_category_default | id_manufacturer | reference | date_add | +------------+---------------------+-----------------+-------------------+---------------------+ | 2773 | 2 | 0 | BSN0003 | 2017-11-18 17:16:15 | +------------+---------------------+-----------------+-------------------+---------------------+ So, I can see that this product is written in the DB, however it is not showing in Catalog --> Products. I have searched using Reference, ID (beause I see the ID), name, but this product never shows up. On the other hand, I can see it in the frontend, but I need to delete/edit it. Is this because the product is not associated with any manufacturer? Is this a bug? Am I doing something wrong? Somebody else with the same problem? What can I do in order to edit this product? My Prestashop is
  5. Accented URLs replacements

    UPDATE: I found it on my own. Just changed "kh" to "h" and "KH" to "H" in /js/admin.js
  6. Accented URLs replacements

    Hey! I want to change some of the replacements of accented characters with non-accented ones, because in some languages they are not correct. For example, the cyrillic "х" is substituted by "kh" . For example with the following configuration: - friendly URLS enabled; - accented URLs disabled; - I want to create a product named "Храна" - Prestashop replaces the accented characters in the auto-generated URL with "khrana". And this is not correct. It should be "hrana", only the letter "h" not "kh". Is this even possible to be changed? Thanks a lot to anyone with some ideas!
  7. Hey, trace... Many thanks on the assistance, I really appreciate it. Well, this is interesting... I am sure that there may be some recommendations that give the 0 as a starting position. Actually, I haven't checked if there are examples in schema.org. What I've found is this: https://developers.google.com/search/docs/data-types/breadcrumbs and in all the examples (see markup buttons), the starting position is 1, so that's why I assumed that I should use 1 instead of 0. What do you think, is it possible that I may be wrong?
  8. Hi, trace. Is there any option to start the counter of the position property from 1 instead of 0?
  9. Hi guys, Does anyone have a clue how can I modify the blocklayered module, so it can display manufacturer's meta_title instead of the name? I think that this will be very userful not only for me. For example, in other smarty templates I can do the following thing: {if isset($manufacturer.meta_title) AND $manufacturer.meta_title} {$manufacturer.meta_title|escape:'html':'UTF-8'} {else} {$manufacturer.name|truncate:60:'...'|escape:'html':'UTF-8'} {/if} This is the perfect scenario - if the meta title is set, show it. If it is not set, show the name. Of course, there was a modification in the clasess/Manufacturer.php so that the meta_title can be extracted from the DB. But how can this functionality be applied for the blocklayered module? I see that in the tpl files you can hardly do anything like the mentioned above code, so I guess there should be some modifications in /modules/blocklayered/blocklayered.php . I would really appreciate it if someone can help me figure this out. Thanks for the info in advance! Regards, Martin
  10. Display Product by ID

    Sounds like a big headache. Yes, I am not a professional developer but I know this and that... and I was wondering isn't there a more easy way to show all details of product_id = 5 for example in the template? Or is there documentation how to work with product ids and how to call information about products with certain ids?
  11. Display Product by ID

    I am trying to do one very simple thing. In the front end of a product, let's say in product.tpl below all the information of the certain product - long description, comments, etc, I want to display 4 products by custom choosing their ids. A NOTE: the accessories functionality is not an option because I use it for another thing. Well, the perfect scenario would be to replicate this functionality, but I don't think it will be possible. So, below the product I want to show a list of 4 product with ids - 220, 105, 452, 8. All of them should have a name, price, link to the product and add to cart functionality, so I guess calling the $tpl_dir./product-list.tpl is essential. I tried several scenarios but none of them worked. I would really appreciate any kind of suggestions! This should be very simple but I just can't figure it out - I always get some kind of php syntax errors or smarty template errors.
  12. Digital Ocean Hosting

    Hi again, Well, yes. If you are familiar with the Apache server, then go for the LAMP. I prefer working with NGINX, so I always have the LEMP stack. You are right, this is the way of doing the things. First, the operating system, them the web sever, mysql and php interpreter. As for the graphic interface, I don't use it so I can't tell you for sure how do to it. 1. The OS - usually, the DO droplets come with installed OS. I suggest that you go for the Ubuntu 16.04 x64; You can also choose the 14.04 x64, it works great. 2. Install nginx from the DO repositiories; 3. Install mysql from the DO repositories; 4. Install php processor. Personally, I use php5-fpm, but you can use the most modern php-fpm which uses PHP7; After you create your droplet, I suggest that you read this: https://www.digitalocean.com/community/tutorials/how-to-install-linux-nginx-mysql-php-lemp-stack-in-ubuntu-16-04 Digital Ocean are great with their community. They have tutorials for almost anything you can imagine doing with your VPS. They cover a lot of open-source software topics and provide how-tos. That's why people love then and they have so many customers. If you need something special for the configuration for your virtual server, just search the community. Best, Martin
  13. Back Office Customer Support & Employees

    Thanks for the suggestions. Just to add, my installation is Actually, I have the logic in my head but it's hard to execute it in the php template. However, I tried to do something like this in /controllers/admin/AdminCustomerThreadsController.php So, my idea was to do something like: global $cookie; $id_employee = $this->context->employee->id; $action1 = show the threads assigned only to customer with email employee1@mydomain.com; $action2 = show the threads assigned only to customer with email employee2@mydomain.com; $action3 = show all threads; if ($id_employee == 1) { $action1; } elseif ($id_employee == 5) { $action2; } else { $action3; } Unfortunately, I find it difficult to make the system understand the php conditions and even do the easiest thing - to echo some custom text depending on the user id. For example: if ($id_employee == 1) { echo 'Hey, you are user #1'; } else { echo 'Hey, you are NOT user #1'; } If anyone has an idea how to do this thing, I will really appreciate the help! Thanks, Martin
  14. Hi guys, I am currently developing a Prestashop site and I was wondering if I can do one very useful thing, either by modifying the templates or by using a module. So, here is the situation: 1. I have Employee 1; 2. I have Employee 2; 3. In the front office, there is a Customer and he or she goes to the contacts page; 4. The Customer chooses to send a message to Employee 1; 5. The message is sent and it can be seen at the Back Office; 6. Employee 1 and Employee 2 can see the thread and answer to it; 7. Is it possible to restrict the access to a thread in customer service only to the Employee it is intended to? In other words, Employee 1 sees only the threads which are assigned to him or her via the contact form at the front office contacts page, Employee 2 sees his or hers threads and the Administrators see all threads. Does somebody know a solution to this scenario? Thanks! Martin P.
  15. Digital Ocean Hosting

    I am pretty sure that you will be able to do this. I am using DO with several Wordpress installations, exactly the 10$ VPS package and don't have any issues at all. You just need to configure your system properly - web servers, php interpretators, mind the mail servers, etc.. and it will be able to handle all requests and traffic. 100 products are not that much, so you can be sure that placing 2 or 3 installations on the same droplet will be ok. Of course, in my opinion, it's best to host 1 installation with 1 domain on a single droplet. This way each of your installations will be hosted on a different IP, for example.