Jump to content

sheraz4pro

Members
  • Posts

    27
  • Joined

  • Last visited

Profile Information

  • Activity
    Developer

Recent Profile Visitors

2,128,276 profile views

sheraz4pro's Achievements

Newbie

Newbie (1/14)

0

Reputation

  1. I have just echo the query which is being used to get products. SELECT p.*, product_shop.*, product_shop.id_category_default, pl.*, i.id_image, il.legend, m.name manufacturer_name, DATEDIFF(product_shop.`date_add`, DATE_SUB(NOW(), INTERVAL 20 DAY)) > 0 AS new FROM `ps_category_product` cp LEFT JOIN ps_category c ON (c.id_category = cp.id_category) LEFT JOIN `ps_product` p ON p.`id_product` = cp.`id_product` INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN ps_product_lang pl ON (pl.id_product = p.id_product AND pl.id_shop = 1 ) LEFT JOIN ps_image i ON (i.id_product = p.id_product AND i.cover = 1) LEFT JOIN ps_image_lang il ON (i.id_image = il.id_image AND il.id_lang = 1) LEFT JOIN ps_manufacturer m ON (m.id_manufacturer = p.id_manufacturer) WHERE product_shop.`active` = 1 AND c.nleft >= 3 AND c.nright <= 4 AND c.active = 1 AND pl.id_lang = 1 AND p.id_product IN ( PRODUCTS_IDS ) GROUP BY p.id_product ORDER BY cp.position asc LIMIT 0,20 PRODUCT_IDS are comma separated ids. i am unable to understand the if there are millions of products, then the millions of products ids will be used in the IN clause to filter the products. i think this query is having issues while getting products. this query is in blocklayered module/blocklayered.php file. this query is being used as i am using block layered navigation module.
  2. i am using prestashop 1.5.4. i have scrapped data from another site and then inserted data in prestashop manually by writing scripts. I have not used csv import because the data will be scrapped on daily bases. i had to automate this thing. so csv import was not a solution.
  3. thanks for your reply. Yes it is a VPS , prestashop is deployed on it. what else you think can be done ??
  4. Hi, i am working on a project in which i have scraped data from some external site and then insert it in prestashop DB. I have to add 60,000 products in prestashop DB. But unfortunately, i have only added 2500 products with their images, attributes, and combinations and the site slows down.it is barely loading the home page. i have see prestashop support. The Server meets all the requirements. Please help me and give me some solutions or suggestions to get rid of it.
  5. Hi, i am working on a project in which i am scraping data from DB then i will store it in prestashop DB. Can someone please guide me how prestashop calculates combinations of a product attributes.? what is the formula or logic to create combinations. if i have colors: red, blue brand: nike, hush puppies sizes: 33 ,34 35 width: small, medium, large then how much combinations prestashop will create?? please guide me . Thanks
  6. Currently it is on our development server. however you can check it here http://staging.dplit.com:8080/shoestore
  7. yes i did the same thing you are talking about. now it is working fine. Thanks
  8. I think it is a bug in Prestashop 1.5.4.1 because i have installed 1.5.4 and it is working perfectly.
  9. Currently it is deployed on staging server. URL: http://staging.dplit.com:8080/shoestore I have also downloaded the latest version, it was also doing the same thing. I don't know whether it is a bug or default functionality.
  10. Hi, I am facing an issue in JQZoom. The problem is , On first hover on the image , it shows the same image as the image thumbnail in left side. But if i hover over another image in images slider. Then it shows all large size images even for first image too. Can someone guide me that is it a bug in jqzoom or default functionality ?? for detail please see attachment. You will notice that in 1st pic, zomm image is medium, but in second, it is large image.
  11. Thanks for your help. i am unable to understand that how to customize th pagination URL. In pagination.tpl, it is call $link->goVPage($requestPage, 2) function. AND in goPage() function public function goPage($url, $p) { return $url.($p == 1 ? '' : (!strstr($url, '?') ? '?' : '&').'p='.(int)$p); } pleas guide me how to customize the query string, in which file I have to do changes.
  12. is there any one who can tell me how to display multiple pagination in multiple product listings???
  13. Hi everybody, i am working on a project and i have to display products Which are new Which are recently viewed by user. Both these listing will have their own pagination. I have done the listing but the pagination is not working correctly. clicking on page 2 or 3 moves to 2 or 3rd page of both listings. I want to display the pagination independent of each other. Can somebody guide me how i can do this.?? I have also attach screen shot. please look it for better understanding.
  14. Thanks for the help. i have solved the issue. Actually i have enabled "Layered Navigation Module" thats why category page was not using classes/Category.php class but it was using its own class. issue resolved.
  15. Hi, i have to customize the category products which shows on the page after clicking on a category.can you tell me which function i have to customize for this purpose.?? i have searched on google and found that Category::getProducts() is used to get category products. i am making changes in this function but changes are not taking place. Can you guide me how i can customize category products.???
×
×
  • Create New...