sting5

If anyone looks for an answer, here's the archived thread (code works):

Hi Andrew, No, You need to edit Your own files (make copies of originals first to be safe..!). Green rows shows text added (use number index to see where they are), and red rows shows what to delete. So edit files, watch changes carefully and it'll pass like a dream.

I do highly recommend adding 2-step prevention when it comes to stopping spam: 1 Step - install eicaptcha module (https://github.com/nenes25/eicaptcha - both 1.6.x and 1.7.x are available). 2 Step - modify 2 files in Your Prestashop to avoid bots from passing through captcha easily: https://github.com/PrestaShop/PrestaShop/pull/8168/files Both aren't necessary, really... but (at least for me) eicaptcha module alone could handle only around 70-80% of spam messages. Some went through. So 2nd tool killed it.

Senoka tema, vis tiek brūkštelsiu, jei kam reiktų: https://www.dpd.com/lt/lt/siusti-siunta/moduliai-el-komercijai/#moduliai Bet kokiu atveju, bus reikalingi API prisijungimai iš DPD klientų aptarnavimo.

Is Prestashop so desperate on sales, that You force clients on buying products, instead of having them buy what they need extra? Who removes used-to-be defaults instead of expanding on them? If anyone is looking for a FREE module on loyalty, here's a link: https://www.team-ever.com/prestashop-module-points-fidelite/ It's in french language, but it won't cause too much trouble, I'm sure.

Muuuch better and quicker solution than all these alternatives on cloning the product..! Thank You Henrik for sharing this!

Thanks for Your help everyone - really appreciated! I've managed to find the correct syntax. If anyone needs it, here is the full MySQL command line (1.6.x.x): UPDATE ps_loyalty SET id_loyalty_state = '2' WHERE id_order IN (SELECT id_order FROM ps_orders WHERE current_state = '4') AND id_loyalty_state = '1' This will change loyalty points status to "available" for orders which are set as "shipped", if the points are for some reason "awaiting validation".

Anyone? Please?

Sorry, not sure if I have explained it in the best way possible... We have around 2500 orders, where customers did not get their loyalty points validated - we need to edit the database table with mass query, so orders, which have status "shipped", would get their points validated. Problem is, that order status is in one table, while point status/validity is set in another table. I've tried using this code, but no luck: UPDATE ps_loyalty SET id_loyalty_state = '2', WHERE ps_orders.id_order = ps_loyalty.id_order AND ps_orders.current_state = '4' As I've said, I don't know sql programming language, thus not sure how to set the query right. Any help would be greatly appreciated..!

Due to emoployee profile permissions, orders, whose status was set to "shipped", did not get loyalty points as "validated". Could someone help me to set up the correct syntax for mass-changing loyalty points state to "2" instead of "1", if order was shipped? I need something like: IF COLUMN "current_state" ROW value IN TABLE ps_orders" is "20" FOR id_order, then FIND ROW value in COLUMN "id_order" AND SET "id_loalty_state" value to "2" If anyone could tell me where to find correct syntax, that would be great!

It is because the new translation system in Prestashop is bugged and still in testing phase. But this topic is mean to search for a solution on different plural forms integration, translation is next step of this issue...

Unfortunately no - it seems that this code only works when there are 2 possible words - one plural, one singular. It does not take into account the fact that some languages may have few plural forms available, sadly.

My language requires different words for certain plural values for products, so I've added this line of code in CartPresenter.php: $summary_string = $products_count === 1 ? $this->translator->trans('1 item', array(), 'Shop.Theme.Checkout') : $this->translator->trans('%count% items', array('%count%' => $products_count), 'Shop.Theme.Checkout') ; <!-- new variable line --> $summary_string = $products_count === 2 ? $this->translator->trans('2 items', array(), 'Shop.Theme.Checkout') : $this->translator->trans('%count% items', array('%count%' => $products_count), 'Shop.Theme.Checkout') ; <!-- end of new variable line --> After that I wanted to translate the word "items" to correct representing word in my language, but the Translations page does not find it. Maybe i'ts possible to manually add a code into {main_dir}\app\Resources\translations\lt-LT\ShopThemeCheckout.lt-LT.xlf somehow for this to work?

Sadly none of the above works when You try to find translations for status label "NEW". Search filted does not find this one.

For me (version 1.7.4.2.) this fix worked well (in the begining of the \themes\{your_template}\templates\_partials\form-fields.tpl): Find this part {if $field.type == 'hidden'} {block name='form_field_item_hidden'} <input type="hidden" name="{$field.name}" value="{$field.value}"> {/block} Add this line " or $field.name=='id_gender' " to the if parameters, to make it look like this: {if $field.type == 'hidden' or $field.name=='id_gender'} {block name='form_field_item_hidden'} <input type="hidden" name="{$field.name}" value="{$field.value}"> {/block} This should influence all the filling forms globally, not only in checkout page.