Jump to content

Leaderboard


Popular Content

Showing content with the highest reputation on 10/27/2018 in all areas

  1. 1 point
    Hi, Migrating your PrestaShop website from one server to another is not a difficult job if you know what you do. IT takes hardly 30 minutes if everything works fine and expected. Here is a guide you may find helpful: https://www.prestashop.com/en/blog/how-to-migrate-prestashop-to-a-new-server If you are not confident, I strongly recommend hiring an agency or freelancer to do this job. You can also get a friend with experience in web development. It's not a hard job and it doesn't take much time. If you couldn't find anyone, I would happy to help you free. You can check my profile to see my agency website. On the website you can send an enquiry with a reference of my name, Pavithra. Best wishes,
  2. 1 point
    Thanks you for your responsiveness, it works properly now
  3. 1 point
    There is definitely a problem here and I'm not sure it's a conflict. I'll try to reproduce the error calling these hooks and see what it is looking for. I suppose the fsredirect module is a paid one, so I can't have access to the source to exactly reproduce the error, correct?
  4. 1 point
  5. 1 point
    j'aime que tu publie de nouvelle erreur mais la 1ere à une cause différente de la seconde. Comme tes yeux devraient être capable de le voir. smtp-in.orange.fr [193.252.22.65]: 550 5.1.1 Adresse d au moins un destinataire invalide. Invalid recipient. OFR_416 [416] là c'était l'email du client qui n'était pas bon. 550 5.7.1 Unfortunately, messages from [87.106.166.147] weren't sent. Please contact your Internet service provider since part of their network is on our block list (S3140). You can also refer your provider to http://mail.live.com/mail/troubleshooting.aspx#errors. [AM5EUR03FT062.eop-EUR03.prod.protection.outlook.com] Et là c'est en effet que ton serveur est bloqué chez Microsoft. Tu dois leur faire une demande de reconsidération de ton IP. Rien qui ne soit du domaine de PrestaShop. Vois avec ton administrateur système
  6. 1 point
    under seo & urls disabled friendly urls save enable friendly urls save This will regenerate the .htaccess file.....
  7. 1 point
    Sortera produktnamn efter svenska bokstäver i prestashop's databas: i databasen, sök efter tabellen "PREFIX_product_lang" (exempel ps_product_lang) och klicka på den. Sedan i den högra spaltens övre flikar, klicka på "Operations" och under "Table Options" hittar du alternativet "Collation" som ska ändras till "utf8_swedish_ci" samt kryssa i rutan "Change all column collations" som ligger precis under och sedan "Go". nu sorterar databasen produktnamn efter svenska bokstäver, dvs. "ABC ... XYZ ÅÄÖ" jätte enkelt när man väl har lärt sig Clear Cache @ Back Office, Reload/Refresh Front Office & Have fun! xD xD xD
  8. 1 point
    Hi Zohaib, Thanks for clarifying. I only have approx 100 products, so its not too bad. Thank you for the kind offer anyhow. I will purchase this module soon as it looks like the best solution for rich snippets, even if there is lots of configuration to do. Regards
  9. 1 point
    @poukamisas άφαντος... ωραίος. Έφτιαξα ένα php που παράγει το xml για skroutz και bestprice. Το μόνο που πρέπει να αλλάξει κάποιος είναι το example με το όνομα από το κατάστημα του. Είναι για prestashop 1.7 . Το συγκεκριμένο είναι για μαγαζί με εσώρουχα. Οπότε έχουμε μέγεθος σουτίεν που είναι συνδυασμός δύο μεγεθών. Με λίγες αλλαγές μπορεί να το βάλει κάποιος σε ότι κατάστημα θέλει. <?php $databaseConfig = include 'app/config/parameters.php'; $servername = $databaseConfig[parameters][database_host]; $username = $databaseConfig[parameters][database_user]; $password = $databaseConfig[parameters][database_password]; $database = $databaseConfig[parameters][database_name]; // Create connection $link = mysqli_connect("$servername", "$username", "$password", "$database"); //set charset mysqli_set_charset($link, "utf8"); /* check connection */ if (mysqli_connect_errno()) { printf("Connect failed: %s\n", mysqli_connect_error()); exit(); } $sql = "select p.id_product as Product_id, concat(m.name,' ',pl.name) as Product_name, group_concat(distinct case when agl.id_attribute_group <> '6' and agl.id_attribute_group <> '5' and agl.id_attribute_group <> '4' then pal.name else null end order by agl.id_attribute_group desc separator ',') AS size, group_concat(case when agl.id_attribute_group = '5' or agl.id_attribute_group = '4' then pal.name else null end order by agl.id_attribute_group desc separator ',') AS bra_size, group_concat(distinct case when agl.id_attribute_group = '6' then pal.name else null end order by agl.id_attribute_group desc separator ',') AS color, sa.quantity as quantity, round((p.price-(p.price*sp.reduction))*1.24,2) as Price, p.reference as MPN, m.name as manufacturer, concat('https://','example.gr','/el/',cl.link_rewrite,'/',p.id_product,'-',pac.id_product_attribute,'-',pl.link_rewrite,'.html') as Product_Link, concat( 'https://example.gr/img/p/',mid(im.id_image,1,1),'/', if (length(im.id_image)>1,concat(mid(im.id_image,2,1),'/'),''), if (length(im.id_image)>2,concat(mid(im.id_image,3,1),'/'),''), if (length(im.id_image)>3,concat(mid(im.id_image,4,1),'/'),''), if (length(im.id_image)>4,concat(mid(im.id_image,5,1),'/'),''), im.id_image, '.jpg' ) AS Image_Link, (select group_concat('https://example.gr/img/p/',mid(im2.id_image,1,1),'/', if (length(im2.id_image)>1,concat(mid(im2.id_image,2,1),'/'),''), if (length(im2.id_image)>2,concat(mid(im2.id_image,3,1),'/'),''), if (length(im2.id_image)>3,concat(mid(im2.id_image,4,1),'/'),''), if (length(im2.id_image)>4,concat(mid(im2.id_image,5,1),'/'),''), im2.id_image, '.jpg' separator ',') from ps_image as im2 where im2.position > '1' and im2.id_product = p.id_product) AS extra_images, (select group_concat(cl.name order by c2.level_depth asc separator ' > ') from ps_category_lang as cl join ps_category as c2 on c2.id_category = cl.id_category where c2.nleft <= c.nleft and c2.nright >= c.nright and cl.id_lang= '2' and c2.id_category > '2') as category_path from ps_product as p left join ps_category_lang as cl on cl.id_category = p.id_category_default and cl.id_lang = '2' left join ps_product_lang as pl on pl.id_product = p.id_product left join ps_stock_available as sa on sa.id_product = p.id_product left join ps_category as c on c.id_category = p.id_category_default left join ps_manufacturer as m on p.id_manufacturer = m.id_manufacturer left join ps_image as im on im.id_product = p.id_product and im.position = '1' left join ps_product_attribute as pa on p.id_product = pa.id_product left join ps_product_attribute_combination as pac on pac.id_product_attribute = pa.id_product_attribute left join ps_attribute_lang as pal on pal.id_attribute = pac.id_attribute and pal.id_lang = '2' left join ps_attribute as a on a.id_attribute = pal.id_attribute left join ps_attribute_group_lang agl on agl.id_attribute_group = a.id_attribute_group and agl.id_lang = '2' left join ps_specific_price as sp on sp.id_product = p.id_product where pl.id_lang = '2' and p.active = '1' and sa.id_product_attribute = pa.id_product_attribute group by p.id_product order by p.id_product;"; header("Content-Type:text/xml; charset=utf-8"); print '<?xml version="1.0" encoding="UTF-8"?>'; print '<example>'; print '<created_at>' . date("Y-m-d H:m") . '</created_at>'; print '<products>'; /* if ($result = mysqli_query($link, $sql)) { printf("Select returned %d rows.\n", mysqli_num_rows($result)); } */ $result = mysqli_query($link, $sql); // Check result // This shows the actual query sent to MySQL, and the error. Useful for debugging. if (!$result) { $message = 'Invalid query: ' . mysqli_error($link) . "\n"; $message .= 'Whole query: ' . $sql; die($message); } while ($row = $result->fetch_object()) { $availabilty="Κατόπιν Παραγγελίας"; $instock="N"; $quantity=$row->quantity; if($quantity > 0) { $availabilty="Παράδοση 1 έως 3 ημέρες"; $instock="Y"; } $colors=$row->color; $color=explode(",", $colors); $temp_size=$row->size; if(!empty($temp_size)){ $size = $temp_size; }else { $temp_brasizes = $row->bra_size; $brasizes = explode(",", $temp_brasizes); $size_elements = count($brasizes); $size=""; for($i=0; $i<=($size_elements/2)-1; $i++) { if($i < ($size_elements/2)-1){ $size= $size . $brasizes[$i] . $brasizes[$i+($size_elements/2)] . ','; }else{ $size= $size . $brasizes[$i] . $brasizes[$i+($size_elements/2)]; } } } $temp_name=$row->Product_name; if (strpos(strtolower($temp_name), strtolower($color[0])) !== false) { $name=$temp_name; }else{ $name=$temp_name . ' ' . $color[0]; } $im_count=0; $temp_extra_images=$row->extra_images; if(!empty($temp_extra_images)){ $extra_image = explode(",", $temp_extra_images); $im_count=count($extra_image); } print '<product>'; print '<id>' . $row->Product_id . '</id>'; print '<name><![CDATA[' . $name . ']]></name>'; print '<link><![CDATA[' . $row->Product_Link . ']]></link>'; print '<image><![CDATA[' . $row->Image_Link . ']]></image>'; if($im_count>0) { for($i=0; $i<=$im_count-1; $i++) { print '<additional_image><![CDATA[' . $extra_image[$i] . ']]></additional_image>'; } } print '<category><![CDATA[' . $row->category_path . ']]></category>'; print '<price_with_vat>' . $row->Price . '</price_with_vat>'; print '<mpn>' . $row->MPN . '</mpn>'; print '<manufacturer><![CDATA[' . $row->manufacturer . ']]></manufacturer>'; print '<instock>' . $instock . '</instock>'; print '<color>' . $color[0] . '</color>'; print '<size>' . $size . '</size>'; print '<availability>' . $availabilty . '</availability>' ; print "</product>"; } print "</products>"; print "</example>"; /* free result set */ mysqli_free_result($result); mysqli_close($link); ?>
  10. 1 point
    Yes, you can change it back if you've finished editing TPL files. If you plan to edit them some more, I suggest choosing "Recompile templates if they've been updated". You can change <a to <a style="color: blue" or another colour to make it more obvious it is clickable.
  11. 1 point
    I tested the code above and the product image code had errors in it, so I removed it so there's only a link. Change line 302 (in PrestaShop v1.6.1.8) of themes/default-bootstrap/order-detail.tpl from: {$product.product_name|escape:'html':'UTF-8'} to: <a href="{$link->getProductLink($product)|escape:'html'}">{$product.product_name|escape:'htmlall':'UTF-8'}</a>
  12. 1 point
    Désolé, j'ai trouvé, c'est dans Administration->Préférences
×
×
  • Create New...

Important Information

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