gitexperts

Hello everyone, I want a functionality in my web site, can anyone suggest me any module with this functionality I want show all products in a category page which sold in last 30 days and It'll be updated everyday by cron automatically.

I want show all products in a category page which sold in last 30 days and It'll be updated everyday by cron automatically.

Hello Everyone, Please help me How to get all products which sold in last 30 days by sql in prestashop1.7?

Hello all I have 2 site setup on same server , one is on dev mode and second is on live mode.. boths are working same functionlity but I'm facing cache issue in every 5-10 min in live mode, site is not load in incognito after 5-10 mins, It's working pefectly after flush cache. dev mode working perfectly..

Hello everyone, How to get star rating on custom product list page, Please see my attached code. public function getProductdata($p_id, $qty=1) { $product_data = array(); // Load Product Object $product = new Product($p_id); $is_product = Validate::isLoadedObject( $product ); if($is_product){ // Language id $id_lang = (int) Configuration::get('PS_LANG_DEFAULT'); // Get cover image for your product $image = Image::getCover($p_id); // Initialize the link object $link = new Link(); // Get Product URL $url = $link->getProductLink($product); $product_data['image_path'] = $link->getImageLink($product->link_rewrite[Context::getContext()->language->id], $image['id_image'], 'home_default'); $product_data['name'] = $product->name[$id_lang]; $product_data['price'] = Product::getPriceStatic($p_id); $product_data['_price'] = Tools::displayPrice($product_data['price']); $product_data['stock'] = Product::getQuantity($p_id); $product_data['url'] = $url; $product_data['qty'] = $qty; $product_data['p_id'] = $p_id; //$all_products[] = $product_data; } return $product_data; } I want get review in this function. Thanks in advance.

Hey, You can change it from admin, follow the path Open admin => Open tab "international" => Click on "translations => Select Translation Type (Topic translation) - Select your theme - Select your language => Enter it and you can directly search "Invoice" otherwise You can follow this : Shop > Theme > Checkout and You can change your text from here https://prnt.sc/z7VqBfZPpKdi

Hello @Knowband Team, Thanks for your reply, It's working after some modification "SELECT `OD`.`product_id` as product_id FROM "._DB_PREFIX_."order_detail OD INNER JOIN "._DB_PREFIX_."orders O ON O.id_order = OD.id_order WHERE O.id_customer = ".$customer_id." AND O.valid = 1";

Hello, I'm facing a issue with sorting and pagination, I have created a custom extension of custom products list but there are not working sorting and pagination functionality, Please help me. https://prnt.sc/AiijihoYFM1- https://prnt.sc/nxLEm-p5X8zn https://prnt.sc/oayCYWLhGfm1 https://prnt.sc/u_dZW41DlNXm

how to get all products from all orders id for customer on frontend by sql in prestashop 1.7