sheraz4pro
Members-
Posts
27 -
Joined
-
Last visited
Profile Information
-
Activity
Developer
Recent Profile Visitors
2,128,276 profile views
sheraz4pro's Achievements
Newbie (1/14)
0
Reputation
-
How much data prestashop can handle easily
sheraz4pro replied to sheraz4pro's topic in Ecommerce x PrestaShop [ARCHIVE BOARD]
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. -
How much data prestashop can handle easily
sheraz4pro replied to sheraz4pro's topic in Ecommerce x PrestaShop [ARCHIVE BOARD]
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. -
How much data prestashop can handle easily
sheraz4pro replied to sheraz4pro's topic in Ecommerce x PrestaShop [ARCHIVE BOARD]
thanks for your reply. Yes it is a VPS , prestashop is deployed on it. what else you think can be done ?? -
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.
-
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
- 3 replies
-
- attributes
- products
-
(and 1 more)
Tagged with:
-
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.
-
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.
- 4 replies
-
- pagination
- category
-
(and 2 more)
Tagged with:
-
is there any one who can tell me how to display multiple pagination in multiple product listings???
- 4 replies
-
- pagination
- category
-
(and 2 more)
Tagged with:
-
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.
- 4 replies
-
- pagination
- category
-
(and 2 more)
Tagged with:
-
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.
- 8 replies
-
- product.tpl
- product-list
-
(and 2 more)
Tagged with:
-
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.???