Some products are not added to the wishlist

Hi there

There isn’t any specific check over product in the plugin, so any item of the catalog could be added to the wishlist

Could you please be more specific regarding the problem? Doesn’t the ATW button appear for those products? Does it appear but doesn’t it add item to the list?
Could you please share with us a link to your installation, so we can check the issue?

The button appears for all the products on the website, but it doesn’t add all the items to the list, it’s not working for all the items.
You can check the items on the homepage, in the section called ‘Ramadan’ the items will be added to the list after clicking on the heart icon, but in the other sections nothing happens after clicking on the button.
https://madeinlebanon.com/

Hi there

This is really strange
I tested your site, and I can see that most of the system is working (wishlist is created, AJAX call have correct answer)
Anyway, it doesn’t seem to correcly create item in database

My best guess is that maybe there is some problem with Wishlist installation, probably in the database structure (problem with update to new 4.0 version)
If you wish (and this could be a valid option for you) I could help you through the steps needed to re-install the plugin database

I really appreciate if you can help me to solve this issue, noting that I deleted the plugin and re-installed it again and nothing changes. What info do you need from my side?

• This reply was modified 3 years, 7 months ago by carla.zaiter.

Unfortunately just deleting plugin folder and installign it from scratch won’t help if problem is located in database structure

My suggestion here is to try to force again DB structure update by following these steps
1. go to /wp-admin/options.php
2. locate option yith_wcwl_db_version (it should be set to 3.0.0)
3. delete value for that option
4. save your options
5. try again to add something to wishlist

Hello,

I didn’t find the option ‘yith_wcwl_db_version’ in options.php

I apologize for the misunderstanding, I wasn’t able to change the ‘yith_wcwl_db_version’ value from options.php page so I changed it from the database, but even if I set the ‘option_value’ null it will always be 3.0.0 again.
I tried to put it 3.0.21 (the current version of the plugin) but nothing change on the frontend.

In addition to the above, I check in the database that both yith_wcwl and yith_wcwl_lists tables exists

The structure for yith_wcwl_lists table is up to date (it contains a column called session_id)

Finally, the system is registering the lists correctly in the table: I added something to the wishlist as a guest user, and a new record has been added to yith_wcwl_lists table, with session id not null, but there’s no lists on the frontend.
P.S. As I said before, I couldn’t clear the value of ‘yith_wcwl_db_version’ from options.php page or from the DB.

• This reply was modified 3 years, 7 months ago by carla.zaiter.

Hi there

Could you please check that yith_wcwl table has the following structure?

ID BIGINT( 20 ) NOT NULL AUTO_INCREMENT,
prod_id BIGINT( 20 ) NOT NULL,
quantity INT( 11 ) NOT NULL,
user_id BIGINT( 20 ) NULL DEFAULT NULL,
wishlist_id BIGINT( 20 ) NULL,
position INT( 11 ) DEFAULT 0,
original_price DECIMAL( 9,3 ) NULL DEFAULT NULL,
original_currency CHAR( 3 ) NULL DEFAULT NULL,
dateadded timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
on_sale tinyint NOT NULL DEFAULT 0,

When you add something to your list, apart from the list itsefl, does a record gets added to yith_wcwl table?

Hi,

Yes, it has the same structure
ID bigint(20) NOT NULL,
prod_id bigint(20) NOT NULL,
quantity int(11) NOT NULL,
user_id bigint(20) DEFAULT NULL,
wishlist_id bigint(20) DEFAULT NULL,
dateadded timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
position int(11) DEFAULT ‘0’,
original_price decimal(9,3) DEFAULT NULL,
original_currency char(3) DEFAULT NULL,
on_sale tinyint(4) NOT NULL DEFAULT ‘0’

And yes when I add something to the list a new record will be added to yith_wcwl table but it doesn’t appear in the frontend. But it’s not the case for all the products some products appear in the list and some doesn’t but all the products are presented in yith_wcwl table (there is a record for each product with proper product id and wishlist id) so everything in the database is correct and the same for all the products. The issue is on the frontend.

This sounds more and more like a cache issue; are you running under server cache, or have you installed any cache plugin?
Could you please add your wishlist page among cache exceptions?

I checked with the hosting we don’t have cache on the server, I have the same issue on staging link and on localhost noting that I am not using any cache plugin on these 2 environments.

Hi again

TBH I’m not sure what could possible cause this; I’d need to perform some debug in order to better understand
Anyway, since this is not possible, I’d like to check if any other plugin or the theme itself could be affecting wishlist behaviour

Could you please try plugin on a clean installation, with jsut WooCommerce and Twenty-default theme active, to see if it works?
If this is the case, could you please activate back your theme, and then your plugins, to find out who is interfering with wishlist?

I have the exact same problem and tried your previous steps. I have the same version ( 3.0.21 ), maybe there’s something going on?