[Prestools - the free mass edit toolset]

I uploaded a new version of Prestools. Quite a lot of changes.

@CassimMulti-feature should now work for Thirty Bees. You need to download both to download this version and the newest version of the paid-for software.

@30knees"Proportionate tax for shipping and wrapping" should now work as in Thirty Bees.

Other parts that had major revisions:

 - the repair part of integrity checks

 - the adding of images in product-edit

 - indexation

The manual also got some updates.

Don't forget to use ctrl-F5 on your PC after the update in order to reload ignoring the browser cache. Otherwise you might be running the new version with the old javascript file.

[Prestools - the free mass edit toolset]

19 hours ago, Cassim said:

Something your working on.?
Or do you have a date on when it will? 

Probably a few weeks. There are also some other changes I am working on.

[Custom validator]

Once under Prestashop I built a custom validation routine for the address2 field of the customer registration form. It was quite simple:

In classes/Address.php I gave address2 it own validation routine (in the original it uses isAddress:

 'address1'        => ['type' => self::TYPE_STRING, 'validate' => 'isAddress', 'required' => true, 'size' => 128],
  'address2'        => ['type' => self::TYPE_STRING, 'validate' => 'isAddress2', 'size' => 128],`

address2() was then declared in classes/Validation.php.

 public static function isAddress2($address) 
 {  
   return empty($address) || preg_match(Tools::cleanNonUnicodeSupport('/^[^!<>?=+@{}_$%]+$/u'), $address);
 }

However, this doesn't work with Thirty Bees. I get a javascript error as soon as I add some content in the address2 field. The strange thing is that it doesn't even make an ajax call. The error (in js/validate.js) I get looks so:

What is going wrong here. And what can I do to have a custom validation?

[Prestools - the free mass edit toolset]

20 hours ago, Cassim said:

@musicmaster

Do your newest version support adding/removing/updating the Multiple Features of TB ?

Not yet

[Impossible to add items to the cart]

On 3/26/2023 at 11:40 PM, movieseals said:

You probably caught it while it was renewing.  Just checked and everything is fine: https://www.whynopadlock.com/results/b6467bb6-d31e-4837-9104-5dc0cc4ca4b6

The padlock is working even when there was cart issues.

Your SSL problems are still there. https://librairiezbookstore.com works but https://www.librairiezbookstore.com gives an error.

Also when I am on the checkout page (https://librairiezbookstore.com/en/quick-order) and I open the browser console I see several errors.

 

[Impossible to add items to the cart]

16 hours ago, movieseals said:

OK.  So how do I fix that?  What might be causing it?

Something is wrong with your SSL.

Test your site at https://www.whynopadlock.com/

 

 

[The description field is invalid. (ERROR)]

Try pressing the "source code" button after the text has been rejected and look for any illegal characters incl html. In some rare cases modules might try to put illegal text in the field.

[Search not working or working intermittently]

Some people report better results after first truncating the tb_search_index and tb_search_word tables and then running the re-indexation.

[Prestools - the free mass edit toolset]

On 3/22/2023 at 8:32 AM, musicmaster said:

BTW: do you use the most recent Prestools version? This part of the code recently had quite a few changes.

I assume that the new version solved your problem.

[Prestools - the free mass edit toolset]

BTW: do you use the most recent Prestools version? This part of the code recently had quite a few changes.

[Prestools - the free mass edit toolset]

2 hours ago, 30knees said:

Hi @musicmaster,

We started using Prestools to edit orders. For one order, I needed to edit the shipping costs. That worked fine. 

However, the associated taxes weren't updated accordingly:

You'll see that the total tax and the shipping tax are wrong.

Shipping 23,36 € x 19 % = 4,44 €

Total 98,36 € x 19 % = 18,69 €

Is this a limitation of the module or a bug or a user mistake?

Thank you.

Which program are you using? I don't recognize the page. This is not order-edit.php.

[How do you handle invalid VAT numbers for cross border transactions?]

I noticed that a lot of VAT numbers that are rejected are not really bad. Instead they are not correctly formatted. 

 - Many people enter use separators like a space or a dot. So "123 456 789" instead of "123456789".

 - The entry is case sensitive. Quite a few people enter lowercase where as far as I have seen always uppercase is required.

 - For some countries the country iso-code is part of the string. For others not. This goes often wrong.

In some cases people don't notice the rejection and without noticing it pay the VAT. It would be good to have a popup when a VAT number is rejected.

It would also be nice when the software provided automatic correction.

[What is the function of the trigger controller?]

Yes, this is 1.3.

[What is the function of the trigger controller?]

43 minutes ago, datakick said:

It's a synthetic event to trigger scheduler. To run scheduled and deferred tasks.

But what does that "failed"/"forbidden" reaction that I see mean for the functioning of my webshop?

[What is the function of the trigger controller?]

What is the function of the triggercontroller?

When I load a product page I see that a call is made to index.php?controller=trigger&ts=1677152722

What is returned is {"status":"failed","error":"Forbidden"}

When I look into the source code I see something about a scheduler but that doesn't make things much clearer. The line "ServiceLocator::getInstance()->getScheduler();" gives me nightmares about Symfony style complexity.

[Error PHP 8.1 - Unparenthesized `a ? b : c ? d : e` is not supported]

Corrected

I mentioned the likely problem in my page about updating the Panda theme: 

The problem is that some themes use parts of the themeconfigurator module even while it is not active. However, inactive modules are not updated during the update process. The solution is to download a recent version of the themeconfigurator module or Thirty Bees and copy the newer version of the module in place of the old one.

[Prestashop 1.6 to Thirtybees]

1 hour ago, Pedalman said:

Are you with Panda or Bootstrap5 theme? (pm)

I am using Panda. No idea about Bootstrap5

[Prestashop 1.6 to Thirtybees]

15 hours ago, Pedalman said:

Well, I am pretty certain that there are lots of old db entries from modules etc we dont use for a long time. But I am just a merchant and think that I should therefore install a fresh installation and migrate shop data (only) to get rid of old entries.

Sounds like you should consider my Copy_shopdata tool.

https://www.prestashop.com/forums/topic/445453-copy-shopdata-script-for-upgrading-and-fixing-buggy-shops-by-copying-business-data-and-images/

[PANDA theme]

I recently posted a list of fixes for Panda so that it can run without problems with the latest PHP and TB versions.

It would be nice when there was some kind of contact with SunnyToo so that such changes are absorbed in the version that they sell. I think Smile or Datakick should handle such contacts.

[Prestools - the free mass edit toolset]

2 hours ago, jn1 said:

Solved. I had a strange .htaccess file in my prestool-directory.

I have problems to get prestools running on TB 1.4 after an upgrade. I tried to install prestools again. But only will get

403

Forbidden

You don't have permission to access this resource.

The permissions for the prestools directory are 755 and the files have 644

Any ideas

 

Glad you solved it.

.htaccess can indeed cause strange problems.

[AWP and Thirty Bees]

I have a problem with the Attribute Wizard Pro module: it displays the prices excl. VAT.

When I searched for the cause I found that AWP uses a flag with the name "displayPrice" to indicate whether products should be displayed with or without VAT. It appears that Thirty Bees has in js/tools.js a function with the name displayPrice() and that interferes with this variable. This function is only present in Thirty Bees - not in Prestashop. 

Does anyone have a proven solution to solve this?

[Back office login loop]

Does this also solve the double login phenomena that I see on a stable 1.4? The first time nothing happens and the second time i am in.

[Prestools - the free mass edit toolset]

5 hours ago, tomek said:

Sorry, I am a bit lost 😉
When I create a new shop, the COOKIE_KEY and COOKIE_IV are different from the old one. When I change it to the old COOKIE_*, then I cannot login.

I cannot change the COOKIE_* things before running the shop installation (but after copying the TB data to my ftp). Doing it afetr installation results in failure of login into a new shop.

Fine. Keep your new keys. But then don't import customer tables from other shops.

[Prestools - the free mass edit toolset]

40 minutes ago, tomek said:

datakick, when I copy those to a new shop I cannot even login to it - it says something like that:

The user does not exists or password is invalid

 

The employee and the customer tables use the same encryption. So either you import them both from the old shop and use its Cookie and Rijndael keys or you create them both in the new shop.

[Prestools - the free mass edit toolset]

2 hours ago, tomek said:

Does it matter if I change the database prefix (the old one was ps_ and the new one is tb_ ) ?

That is not a problem