Jump to content

Smiles

Ambassadors
  • Content count

    222
  • Joined

  • Last visited

1 Follower

About Smiles

  • Rank
    Ambassador Netherlands

Profile Information

  • Gender
    Not Telling
  • Activity
    Agency
  1. I found actually that the geolocations in prestashop does a good job for the shipping price and country vat. So that part is solved. Best would be an option to keep the end price of prices the same from from the default country. So a module where you can set per country what the default country is, and then to keep prices the same independet from vat in that country.
  2. Due to the vat rules in the EU and showing the actual shipping costs I am trying to achieve the following. In the first place the customer should end on the country or origin. Beside that the customer should be able to select the country of origin (if needed). This so that the right shipping price and vat is known. As for every country I like to have round numbers. Mostly sales will take place in the EU so prices will be for now in €. A website what does this brilliantly the way I prefer is: es.smallable.com What works out of the box with prestashop is that the language can be selected and that will change the website. For example website.com/fr Change the language and it changes to website.com/en Example: Origin is Germany, website origin is set to German, language is set to German. Prices depend on German shipping address. So for example € 20,- stays € 20 although the company is based in the Netherlands and has a vat of 21% compared to Germany 19%. What I need is: module to set prices by origin/shipping location in combination with vat. Preferably automatic compensation + or – from a standard basis price. Module what make location of origin changeable by customer and set the country in Prestashop.
  3. Ik ben zelf niet helemaal tevreden met de huidige bestaande koppeling van webwinkelfacturen.nl met YUKI. Daarom ben ik in een vergevorderd stadium om een koppeling/module te laten bouwen. Zijn er mensen die hier ook interesse in hebben en of tips hebben wat zij graag er in zouden willen zien? Ook als je interesse hebt in deze koppeling hoor ik het graag zo kunnen we de koste laag houden.
  4. Fix Tax Included Prices

    There is another topic here about this....
  5. Same question and problem here. It is very strange. Customers will get mad when the price increases for example form vat 19% to vat 25%....
  6. I.v.m. met de afstandsverkopen en btw die ik in andere landen moet afdragen ben ik aan het worstelen met de prijzen. Immers wil ik dat de eind prijs van producten gelijk blijft ongeacht de BTW. Zijn er meer mensen die over de drempel bedragen leveren en met dit probleem worstelen in Prestashop? Ik snap de logica in Prestashop maar voor de klant buiten Nederland geeft dit heel vreemde prijzen (19,95 veranders naar.....) als hij eenmaal zijn account heeft aangemaakt en in sommige gevallen zelf een stijging. Waardoor ik als klant gelijk zou afhaken…. Hoe stellen jullie deze prijzen in?
  7. Prestashop blog module

    I just installed PHP 7.1 and found out that the blog is not working. Is there someone who has a fix? 7.0 is working fine. Page for example where it is stuck on: index.php?controller=smartblog
  8. The module is making different meta property og:url(s). One shows up at a time in the page source. <meta property="og:url" content="https://webiste.com/cat/975-product.html?content_only=1" /> <meta property="og:url" content="https://webiste.com/cat/975-product.html?POST=1" /> <meta property="og:url" content="https://webiste.com/cat/975-product.html" /> This causes duplicate content for google. Can this be prevented to add in the field Ignore URL variables: POST and content_only?
  9. I am wondering if there is documentation of this module and where I can find it. Very much interested in the module and would like to check it once again
  10. Super weird, in the live store without doing anything is started working again. The test clone I made for fixing it though still has this error..... Makes me very curious.
  11. Would you be willing to explain a bit more? Im quite a noob in reading code... and do you have any idea how this could have changed? The problem exists with new and old orders...
  12. Due to an unexpected change error in shipping I decided to set back an snapshot from the webhoster. This did not work well. So I had to put a backup back from my own resources. So far so good. Happend yesterday. Today I wanted to change some statuses to shipped (set order as shipped is ticked). This is not possible to an error (see below). I think that restoring the backup by the hosters system caused some DB setting change on higher level.... Someone an idea? [PrestaShopDatabaseException] You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND TO_DAYS("2017-08-19 00:00:00") - TO_DAYS(sm.`date_add`) <= 7 AND s.`id_p' at line 14 SELECT SUM(view.quantity) as quantity_out FROM ( SELECT sm.`physical_quantity` as quantity FROM `ps_stock_mvt` sm LEFT JOIN `ps_stock` s ON (sm.`id_stock` = s.`id_stock`) LEFT JOIN `ps_product` p ON (p.`id_product` = s.`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_attribute` pa ON (p.`id_product` = pa.`id_product`) LEFT JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE sm.`sign` = -1 AND sm.`id_stock_mvt_reason` != AND TO_DAYS("2017-08-19 00:00:00") - TO_DAYS(sm.`date_add`) <= 7 AND s.`id_product` = 769 AND s.`id_product_attribute` = 0 AND s.`id_warehouse` = 1 GROUP BY sm.`id_stock_mvt` ) as view LIMIT 1 at line 791 in file classes/db/Db.php 786. if ($webservice_call && $errno) { 787. $dbg = debug_backtrace(); 788. WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97); 789. } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) { 790. if ($sql) { 791. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>'); 792. } 793. 794. throw new PrestaShopDatabaseException($this->getMsgError()); 795. } 796. } DbCore->displayError - [line 425 - classes/db/Db.php] - [1 Arguments] DbCore->query - [line 690 - classes/db/Db.php] - [1 Arguments] DbCore->getRow - [line 723 - classes/db/Db.php] - [2 Arguments] DbCore->getValue - [line 859 - classes/stock/StockManager.php] - [1 Arguments] StockManagerCore->getProductCoverage - [line 631 - modules/mailalerts/mailalerts.php] - [4 Arguments] MailAlerts->hookActionProductCoverage - [line 587 - classes/Hook.php] - [1 Arguments] HookCore::coreCallHook - [line 542 - classes/Hook.php] - [3 Arguments] HookCore::exec - [line 167 - override/classes/Hook.php] - [7 Arguments] Hook::exec_16 - [line 35 - override/classes/Hook.php] - [7 Arguments] Hook::exec - [line 1017 - classes/stock/StockManager.php] - [2 Arguments] StockManagerCore->hookCoverageOnProductRemoval - [line 539 - classes/stock/StockManager.php] - [4 Arguments] StockManagerCore->removeProduct - [line 241 - classes/order/OrderHistory.php] - [9 Arguments] OrderHistoryCore->changeIdOrderState - [line 531 - controllers/admin/AdminOrdersController.php] - [3 Arguments] AdminOrdersControllerCore->postProcess - [line 178 - classes/controller/Controller.php] ControllerCore->run - [line 391 - override/classes/Dispatcher.php] Dispatcher->dispatch_16 - [line 104 - override/classes/Dispatcher.php] Dispatcher->dispatch - [line 58 - admin/index.php]
  13. Do you have another status after that?
  14. Well probably you added a custom status right? 7th tickbox under a status but you have to move the orders to a new status otherwise it does not work....
  15. Problem is possible caused by having an order status which has not ticked the order shipped and validated. To solve this you have to make a new status with both ticked and move also orders to that status. And then fix the status causing the problem by ticking those boxes.
×