Tell us what you are trying to do?
i performed an import and now have
Associations loaded:
146 Associations ready to be imported
Start Import
when i start the import it shows it cant fix the 146 lines.
how do i clear the associations ready to be imported?
Hello. Thank you for contacting the Toolset support.
Can you please share bit more details where I can see the issue as well as please share admin access details.
*** Please make a FULL BACKUP of your database and website.***
I would also eventually need to request temporary access (WP-Admin and FTP) to your site. Preferably to a test site where the problem has been replicated if possible in order to be of better help and check if some configurations might need to be changed.
I have set the next reply to private which means only you and I have access to it.
Hello there. Minesh won't be available for a couple of days. If you don't mind, I'll continue with you on this ticket.
I can see the issue on the backend, and unfortunately, the error message are not very informative and does not tell us what is the cause of them.
However, I checked the first and second product, then the latest product on the latest page, and they seem to be correctly attached to their parent Recipe post. Check this screenshot hidden link
Can you check from your side, and see if there is any broken relationship that should work after the import?
If no relationship is broker, I'll suggest to just ignore that message. Otherwise, we'll need to take a copy of your website, and we'll need your import files to investigate the issue further. We will also need to know the steps that you followed during the update and what plugins are involved on it.
This is a base website that i work on and then duplicate it to other sites. The error goes with the site when i do this.
So you are telling me there is no way to clear the 146 pending associations ? I don't believe ignoring this error is the long term solution. Every new site i make now has 146 pending associations!!
I think that the associations are created correctly, but the message is not removed as it should. I understand that the message is confusing. Can I take a copy of your website to analyze it locally?
Can you also share the imported file? You can send it to my email address jamal.b+2211377@onthegosystems.com
Thank you Tim, I build a local copy and I am getting the same errors. The CSV file was not gathered during Duplicator's copy build. I am assuming it is the last import(#35) from this page hidden link
Unfortunately, I was not able to figure this issue out. Let me escalate this issue to our 2nd Tier team for further analysis, and I'll get back to you as soon as possible.
Our 2nd Tier team has worked on this and found out that the reason the problem arose in the first place is because the relationship is between recipes << products, but those problem associations that won't import properly are for **product variations** rather than simple products, and so their post type is not "product". A relationship with variable products cannot work for the variations for that reason.
So, the way to get rid of the notice about associations it to delete the corresponding post_meta entries that relate to the failed association, which you can do in phpMyAdmin (or a database manager plugin) with:
DELETE FROM `z0IQXSEiIq_postmeta` WHERE `meta_key` LIKE '_toolset_associations_recipe-product'
Note that there is an entry in wp_options which will make Toolset still think there are associations to import, but if you click the link in the notice, when it goes to try and import them it will realize there are none, and then the notice will be gone for good.
If you need me to help you implement this on the live site, take a full database backup before letting me applying it.
