PluginUs.Net - Business Tools for WooCommerce and WordPress

[realize your idea - make your dreams come true]

Support Forum

You need to log-in to create request (topic) to the support

bulk editing serialized arrays doesn't work on integers

The support doesn work on Saturdays and Sundays, so some Friday requests can be answered on Monday. If you have problems with registration ask help on contact us page please
If you not got email within 24~36 business hours, firstly check your spam box, and if no any email from the support there - back to the forum and read answer here. DO NOT ANSWER ON EMAILS [noreply@pluginus.net] FROM THE FORUM!! Emails are just for your info, all answers should be published only here.
The support doesn work on Saturdays and Sundays, so some Friday requests can be answered on Monday.

Hi,

I have specified a custom field from wp_postmeta as an array for bulk editing/filtering.

Unfortunately BEAR doesn't work with integers on the serialized array

for instance my current array is: a:2:{i:0;i:5843;i:1;i:53203;} which is not recognised by bear.

if i change the array to string like: a:2:{i:0;i:"5843";i:1;i:"53203";} it works perfectly.

Is there any workaround on this issue?

thank you in advance,

Menelaos

Hello Menelaos

Please  watch  this  video - https://bulk-editor.com/video#video_3044

Hi Pablo,

i hope that my message finds you well.

I have watched the video and i have carefully followed the instructions.

The fields are visible in BEAR editor however they show up empty although they have values.

After checking the relative sql entry in wp_postmeta table i can see that exists: a:2:{i:0;i:5843;i:1;i:53203;}

which is a serialized array based in integer values.

 

Now if i manually change the array from phpmyadmin to: a:2:{i:0;i:"5843";i:1;i:"53203";}

and i click on the corresponding"array" button, it reads the existing information without an issue.

So i concluded that BEAR doesn't support int type serialized values but works well with string type serialized values.

 

I have modified the plugin(WCPA)  where these values come from and forced to create string type values, which solves the problem for new entries.

However all old entries are set as integers and it needs a lot of custom work in order to make the compatibled with BEAR.

 

is it possible to modify BEAR so it can work with integer serialized arrays?

if yes, how much would it cost us?

 

thank you in advance,

Menelaos

 

 

Hello Menelaos

What plugin version number are you using?

v.2.1.3.1

Please paste your license key here - https://share.pluginus.net/image/i20230222134241.png -> https://share.pluginus.net/image/i20230222134511.png and  wp-admin access - https://share.pluginus.net/image/i20230222134615.png - I will check it

Hi Pablo,

I have provided necessary information

thaank you for your time,

Menelaos

Please add  FTP access - https://share.pluginus.net/image/i20230222134241.png ->https://share.pluginus.net/image/i20230222134615.png

and  exact  link  or ID  of a product where this feature does not work

Hi Pablo,

i have added ftp connection credentials.

one of the products is id: 151437

a screenshot with the relative sql entry in wp_postmeta is: https://prnt.sc/7NAY-CUSkKuD

if you go to https://new.an-agapas.gr/wp-admin/post.php?post=151437&action=edit&lang=el and click on Custom Product Options you can see that the 2 forms are selected connecting them with the sql entry i have provided the screenshot above.

However in BEAR it's empty like: https://prnt.sc/w9b6xgWBX5Jk

now if i transform the entry to: a:2:{i:0;i:"5843";i:1;i:"44667";} it's working perfect

thank you again for your time,

Menelaos

 

Hello Menelaos

Please give me the product ID where it doesn't work. I can't test it if I don't see an error. You have over 15,000 products and it's hard for me to find a product with an error

hi, i have provided product id on my previous answer.

the edit link is: https://new.an-agapas.gr/wp-admin/post.php?post=151437&action=edit&lang=en

Hello

Ok!  I checked   it -  https://c2n.me/4ihNsKK.png - everything works correctly

Hi Pablo,

I can confirm that it's working now.

if i update the plugin on next release, will we loose this funcionality?

thank you in advance,

Menelaos

I didn't change anything at all. I checked and from the beginning everything worked correctly. For this reason, I wrote to you so that you would give a link to a product where it does not work

Hi Pablo,

All old products still face the same issue.

please check product ids: 151437 15496 159490 159486 159476 159480

the issue is there in all old products.

products that have been updated don't face this issue anymore as i have modified the plugin that saves the custom array to use string instead of int.

So all products that have been editing using standard woocommerce product editor seems to be working on BEAR because of the above fix.

However all older products still face the issue.

please advice,

kind regards,

Menelaos

Hello Menelaos

I did  a test - https://c2n.me/4iisV8M.mp4

products that have been updated don't face this issue anymore as i have modified the plugin that saves the custom array to use string instead of int.  - I get it, do you have products where you haven't updated it?

please check product ids: 151437 15496 159490 159486 159476 159480

the above are only some of them

Ok!  I  checked  these  products  - https://c2n.me/4iitE5I.mp4

the issue is with column Custom_forms and not with tiered_pricing

Hello

Please  do a test

In  file - \wp-content\plugins\woocommerce-bulk-editor\ext\meta\assets\js\meta.js - I added  this  code  - https://share.pluginus.net/image/i20230414141655.png