Jump to content

Mat_D1245

Members
  • Content count

    142
  • Joined

  • Last visited

1 Follower

About Mat_D1245

  • Rank
    PrestaShop Enthusiast
  1. Deleting language packs properly

    Presta is really annoying. Installing language packs I don't want against my will, and by deleting them in my backoffice I still have to clean up the crappy bulk it put in my DB. A roll-back is not an option, this "Presta style" of trial/errors does really set you back. Having to deal with problems I shouldn't have stops to be fun after a while. But thanks for offering help!
  2. Hi Presta People, I installed the "Spain" language pack, and it came with three other languages (Euskal, Galego and Catalan). I didn't want those 3 further languages so I deleted them. Unfortunately, they still stay everywhere in my DB, multiplying the rows in my Presta for nothing. I have a multishop (5 shops) and about 12000 products in each. I let you do the math on how many unnecessary rows where created there . About 180000!!!! Is there a proper way to clean that mess up? Or do I have to check all the tables and run sql commands to delete all the unwanted occurrences? Thanks for any tip!
  3. Voucher nicht bei Mwst. berücksichtigt

    Hallo Claudiocool, das Problem ist mir sehr bekannt... ich habe Foren in drei Sprachen durchgesucht, Presta Profis gefragt, keine Lösung. Ich habe Presta das Bug gemeldet, wurde als solche anerkannt, aber letzte Woche kam die beste Antwort überhaupt... Es ist halt so und wird so bleiben, vielleicht wird Presta sich darum kümmern für die 1.7, aber zu eine spätere Zeitpunkt. Hier den Bugmeldung: http://forge.prestashop.com/browse/PSCSX-9231 und hier die Atwort von Vinecent Beudez: Es lässt mich Fassungslos, dass Presta Preise nicht richtig kalkulieren kann. Es ist doch eine Grundfunktion von ein Shopsystem!!!
  4. Ich bin mit der 1.6.0.14 unterwegs. Mein EU-Legal im Modulauflistung im BO ist die 1.4.2. Im Quellecode steht es aber meistens anders... aber ist auch so im Github. Ich bin aber mir fast sicher, dass ich es getestet hatte, und dass es mal ging...
  5. Hi Presta People, I have an issue with our Presta 1.6.0.14 and EU-Legal (now called AdvancedEUCompliance). Up to now, I could select the countries that should list specific payment methods, but since a while (when? not sure about it) the restriction doesn't work anymore. It works though fr customer groups, and these two conditions are checked at the same place in the hook.php file. It seems like a known issue, there should be a fix, but I didn't find it... https://www.prestashop.com/forums/topic/316947-eu-legal-modul-zur-verbesserung-der-rechtssicherheit-für-prestashop-1606-16014/?p=2034714 I'd be really thankful for any tips.
  6. Hallo, Es mag lange her zu sein, das Problem mit der Länderbeschränkung bei Zahlungsarten bleibt, leider... Und einen Bugfix auf Github habe ich leider nicht gefunden?? Kann Jemand mir weiterhelfen?
  7. ps_product and ps_product_shop in multistore

    I'd also be interested in that answer...
  8. Another solution for multiple groups of shops would be to modify hatak's hack, to get a function like so: public static function resetProductFromStockAvailableByShopGroup(ShopGroup $shop_group) { if ($shop_group->share_stock) { $shop_list = Shop::getShops(false, $shop_group->id, true); if (count($shop_list) > 0) { $id_shops_list = implode(', ', $shop_list); return Db::getInstance()->execute(' UPDATE '._DB_PREFIX_.'stock_available SET id_shop=0, id_shop_group='.$shop_group->id.' WHERE id_shop IN ('.$id_shops_list.')' ); } } else { return Db::getInstance()->execute(' DELETE FROM '._DB_PREFIX_.'stock_available WHERE id_shop_group = '.$shop_group->id ); } } I didn't test it yet, but theoretically, it should work without having to do any sql request, and moreover it should take in count the shops and groups of shops we are actually concerned about (for those who have several groups).
  9. ... ceci dit, j'imagine que l'on peut aussi modifier dans classes/stock/StockAvailable.php la fonction : public static function resetProductFromStockAvailableByShopGroup(ShopGroup $shop_group) { if ($shop_group->share_stock) { $shop_list = Shop::getShops(false, $shop_group->id, true); if (count($shop_list) > 0) { $id_shops_list = implode(', ', $shop_list); return Db::getInstance()->execute(' DELETE FROM '._DB_PREFIX_.'stock_available WHERE id_shop IN ('.$id_shops_list.')' ); } } else { return Db::getInstance()->execute(' DELETE FROM '._DB_PREFIX_.'stock_available WHERE id_shop_group = '.$shop_group->id ); } } Pour que les gens qui comme moi ont plusieurs groupes ne soient pas obligés de repasser en plus par le sql. Je ne l'ai pas encore testée, mais la fonction pourrait ressembler à ceci: public static function resetProductFromStockAvailableByShopGroup(ShopGroup $shop_group) { if ($shop_group->share_stock) { $shop_list = Shop::getShops(false, $shop_group->id, true); if (count($shop_list) > 0) { $id_shops_list = implode(', ', $shop_list); return Db::getInstance()->execute(' UPDATE '._DB_PREFIX_.'stock_available SET id_shop=0, id_shop_group='.$shop_group->id.' WHERE id_shop IN ('.$id_shops_list.')' ); } } else { return Db::getInstance()->execute(' DELETE FROM '._DB_PREFIX_.'stock_available WHERE id_shop_group = '.$shop_group->id ); } } A tester, mais surtout faire un backup avant. EDIT: je suis sur Presta 1.6.0.14
  10. Sooo, me again... I found that: http://blog.irrelevant.com/2013/08/prestashop-switching-to-shared-stock.html Is it really that simple?? I mean, when I code something, there is always a purpose behind a function, otherwise I wouldn't spend time on it. And I'm not a pro-team of international coders like Prestashop has. But I really don't get the point of that reset function if it is that simple to switch from shared to not shared. I guess undoing would be more problematic, though IMHO a simple droplist for the choice of who's keeping the children or do we share them half/half wouldn't be that hard to implement... But as said, I'm more of a designer with coding abilities than a presta core developer. Anyway, before I commit, I'd like to hear of any problem I might run in doing it. Thanks in advance!
  11. Vieux topic, même problème, comme souvent avec Prestashop As-tu trouvé une solution ou tu as juste lâché l'affaire? Moi j'aimerais avoir dans mes stats les commandes classées comme expédiées, pour pouvoir suivre l'évolution des ventes... Amicalement, Mathieu.
  12. Hi Presta community, here is a little trick to get your pick list done. Go to Advanced Settings > SQL query and save this one: SELECT SQL_CALC_FOUND_ROWS a.`id_order`, CONCAT(LEFT(c.`firstname`, 1), '. ', c.`lastname`) AS `Name`, shop.name as shop_name, od.`product_id`,od.`product_reference`, od.`product_name`,od.`product_quantity` AS `qty`,a.`date_add` AS `date order`, IF(SUBTIME(a.`date_upd`,'0 0:0:3')>a.`date_add`, a.`date_upd`,'---') AS `Updated am` FROM `ps_orders` a LEFT JOIN `ps_customer` c ON (c.`id_customer` = a.`id_customer`) INNER JOIN `ps_address` address ON address.id_address = a.id_address_delivery INNER JOIN `ps_country` country ON address.id_country = country.id_country INNER JOIN `ps_country_lang` country_lang ON (country.`id_country` = country_lang.`id_country` AND country_lang.`id_lang` = 2) LEFT JOIN `ps_order_state` os ON (os.`id_order_state` = a.`current_state`) LEFT JOIN `ps_order_state_lang` osl ON (os.`id_order_state` = osl.`id_order_state` AND osl.`id_lang` = 2) LEFT JOIN ps_shop shop ON a.id_shop = shop.id_shop LEFT JOIN `ps_order_detail` od ON od.`id_order`=a.`id_order` WHERE 1 AND os.`id_order_state` IN (2,3,10,11) AND a.id_shop IN (2, 1) ORDER BY a.`id_order` DESC Of course you'll have to fit the "where" clause to your needs... Line 3 the subtime thing is meant show an update date only if there is a difference of more than 3 seconds between the dat_add and date_upd, just to make the whole list more readable. Make create a shortcut to this query, and call it when you need it, and make paper print directly from your browser (ctrl+P). Et voilà. Hope sharing this will be helpful! In return, I'd like some help in building a multishop with shared products and quantities, _without_ having to reset all quantities, if anyone knows. Have a nice day picking your items before packing Mathieu.
  13. I'm really interested in that hack! It's just what I was looking for. But trying to figure out the function you wrote, i guess I have to fit the id_shop and the id_shop_group variables... And moreover, I don't get the point of that "if" condition, since you return the the same whatever... Can you (or whoever) please clarify that point? I'd be really thankful for any infos to fix that stupid reset function built by Presta !
  14. Bloc Mots-Clés

    En MP c'est légal?
  15. Bloc Mots-Clés

    Des noms, je veux des noms, surtout pour la désindexation à la volée!!!
×