Jump to content

WaoX

Members
  • Posts

    19
  • Joined

  • Last visited

Everything posted by WaoX

  1. Hello, I have been using your module since 1.4. I am upgrading to prestashop 1.7. Do you have any information when will your module be ready for prestashop 1.7 and what is the price? Best regards, Andre Kirsanov
  2. Same problem need help. @allenhill can you please be more specific. Original google sitemap module for prestashop can't do that?
  3. Did anyone find another solution? I have same problem.
  4. How it isn't a prestashop problem. What is the point of Google Sitemap module if i cant use it with google? I would understand if it would be named just xml sitemap module. I would pay for it if you complete this module
  5. Hello, I have a problem with sitemap generator. I have over 50 000 links in it, but google only accepts xml site map files that have 50 000 or less. Can anyone please change default google sitemap generator so it would make a second file when it reaches 50 000 links or maybe some one can give me a link to module that would to it. Thank you in advance!
  6. I found another problem with prestashop. When I change minimum word length to 5 then when person searches 4 letter word it find no results. Prestashop should warn people that minimum search word length is 5 or what ever set in backend. Because you can lose many customers that way. Also it should be on system requirements that prestashop requires private server if you have more that *** categories and products. We have spend more that 600€ on prestashop and it is slower than our last platform. If I had know that search dosent work then I would have not spend months on going from virtuemart to prestashop and spending that much money on it. Any way I don't recommend prestashop do large online shops because it is unusable! Virtuemart search with 40 000 products took only 4-5 seconds.
  7. Maybe the problem is in server. I have 70 000 products and 8000 categories. Database is about 1gb. Search index table is 550mb. Right now I have VPS with 2 cores and 2gb of ram. I hoped i can first sort this out before i have to start paying 120€/month more only because of search is slow. Website itself is blazing fast.
  8. Thanyou that helped, but it is still 20 or so seconds, what is not good. I changed word length to 5 and disabled ajax & instant search. Maybe it is possible to remove some info from search index. For example these are not important: Tags weight,Attributes weight,Features weight, Short description weight. # Time: 121205 10:04:56 # [email protected]: root[root] @ localhost [] # Query_time: 23.894448 Lock_time: 0.000147 Rows_sent: 147 Rows_examined: 3875819 SET timestamp=1354694696; SELECT DISTINCT cp.`id_product` FROM `ps_category_group` cg INNER JOIN `ps_category_product` cp ON cp.`id_category` = cg.`id_category` INNER JOIN `ps_category` c ON cp.`id_category` = c.`id_category` INNER JOIN `ps_product` p ON cp.`id_product` = p.`id_product` WHERE c.`active` = 1 AND p.`active` = 1 AND cg.`id_group` = 1 AND p.id_product IN ( SELECT id_product FROM ps_search_word sw LEFT JOIN ps_search_index si ON sw.id_word = si.id_word WHERE sw.id_lang = 6 AND sw.word LIKE 'pirnid%' ); # Time: 121205 10:05:19 # [email protected]: root[root] @ localhost [] # Query_time: 23.307913 Lock_time: 0.000070 Rows_sent: 147 Rows_examined: 3875819 SET timestamp=1354694719; SELECT DISTINCT cp.`id_product` FROM `ps_category_group` cg INNER JOIN `ps_category_product` cp ON cp.`id_category` = cg.`id_category` INNER JOIN `ps_category` c ON cp.`id_category` = c.`id_category` INNER JOIN `ps_product` p ON cp.`id_product` = p.`id_product` WHERE c.`active` = 1 AND p.`active` = 1 AND cg.`id_group` = 1 AND p.id_product IN ( SELECT id_product FROM ps_search_word sw LEFT JOIN ps_search_index si ON sw.id_word = si.id_word WHERE sw.id_lang = 6 AND sw.word LIKE 'pirnid%' );
  9. Hello, I have a big problem with search. For some word it takes few minutes to finish searching. Mysql slow query log shows following info: # Time: 121204 16:06:25 # [email protected]: root[root] @ localhost [] # Query_time: 62.693404 Lock_time: 0.000120 Rows_sent: 277 Rows_examined: 12304213 SET timestamp=1354629985; SELECT DISTINCT cp.`id_product` FROM `ps_category_group` cg INNER JOIN `ps_category_product` cp ON cp.`id_category` = cg.`id_category` INNER JOIN `ps_category` c ON cp.`id_category` = c.`id_category` INNER JOIN `ps_product` p ON cp.`id_product` = p.`id_product` WHERE c.`active` = 1 AND p.`active` = 1 AND cg.`id_group` = 1 AND p.id_product IN ( SELECT id_product FROM ps_search_word sw LEFT JOIN ps_search_index si ON sw.id_word = si.id_word WHERE sw.id_lang = 6 AND sw.word LIKE 'pirn%' ); # Time: 121204 16:07:29 # [email protected]: root[root] @ localhost [] # Query_time: 63.711820 Lock_time: 0.000071 Rows_sent: 277 Rows_examined: 12304213 SET timestamp=1354630049; SELECT DISTINCT cp.`id_product` FROM `ps_category_group` cg INNER JOIN `ps_category_product` cp ON cp.`id_category` = cg.`id_category` INNER JOIN `ps_category` c ON cp.`id_category` = c.`id_category` INNER JOIN `ps_product` p ON cp.`id_product` = p.`id_product` WHERE c.`active` = 1 AND p.`active` = 1 AND cg.`id_group` = 1 AND p.id_product IN ( SELECT id_product FROM ps_search_word sw LEFT JOIN ps_search_index si ON sw.id_word = si.id_word WHERE sw.id_lang = 6 AND sw.word LIKE 'pirn%' ); As you can see it runs this query 2 times and it takes one time around 60+ seconds. This is very bad and most of customers dont wate this long. I was on Joomla + Virtumart before I started using Prestashop and I didn't have this kind of problem not once. Maximum wait time was 10 seconds. Hope someone can help me. PS! I searched "pirn" and it return with 200 results. Website www.cn-parts.ee
  10. Hello, I want to upgrade to Prestashop 1.5.1, but new version with same or little bit less information loads so much slower. My old site with 1.4.9 loads category with products in 3-5 seconds. Prestashop 1.5.1 loads 20+ seconds. Is there something broken? It is new install and used import for all the products. I have activated all performance features for 1.5.1. link www.cn-parts.ee/pood15 <- 1.5.1 current site www.cn-parts.ee <- 1.4.9 Can anyone tell me what can I do to speed thigs up. Or Prestashop 1.5.1 is just to new and dosent work yet? PS. I am using VPS server Virtual private server. EDIT: I disabled all menus now its is down to 5 seconds. So "Top horizontal menu" is broken.
  11. Hello, Can anyone help me to make following: I need that for certan groups price woulb be following discount_price = price - -50% if discount_price < purchase_price then doscount_price = purchase_price + 10% Anyway I want that it would check that purchase price would not be bigger that discount price. If it is bigger then I would like to add 10% to the puurchase price and show it to the client. Dose anyone know this kind of module or how it would be possible to add. I use prestasho 1.4
  12. OK I discovered the reason. It was because in the database at ps_compare_product had 3 entries. I deleted them but now for some reason I can't compare products even when i select them. Any help? Can anyone tell me where is the code that must remove these entries from database. Because when I click on the products that I want to compare but then wont compare them and go to another category it wont remove these entries from database. Only when I deselect the products that i had previously selected are databse entries removed.
  13. Hello, I recently upgraded from 1.4.4.1 to 1.4.5.1 to 1.4.6.1 And now product compare dosen't work. When I try to select a product to copare it says following: You cannot add more than 3 product(s) in the product comparator I havent checked any product so.... Link to products is here: http://www.cn-parts.ee/pood/en/10345-aragon-50cc-1e40qmb- Tankyou in advance
  14. I found the problem and it is a module that i purchased. It is this module: AJAX Dropdown Categories v1.7 by Nethercott Construct... Dynamically loads product categories and presents them in dropdowns When I removed this module everything started to work again. Can someone please help me with this module.
  15. Hello, I have a problem with product category list loading very slow. Something like 1-2 minutes. I just migrated from Joomla + Virtuemart to prestashop. I didn't have the same problem with virtuemart it was always realy fast. Can you tell me what is the problem? Do i have some kind of problems with my server? I have a virtual private server so it is quite fast. Front end works perfectly. I also just purchased new template and modules so don't want not to use them. I have 3000+ categories and 10000+ products.
×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More