Community Forums › Forums › Archived Forums › Design Tips and Tricks › Agency/Woo Commerce variations NOT deleting
Tagged: Agency, configure terms, trouble deleting, variations, Woo Commerce
- This topic has 4 replies, 3 voices, and was last updated 10 years ago by Anita.
-
AuthorPosts
-
September 26, 2013 at 10:52 am #64307KarenLeighBurtonMember
I am copying and pasting a full thread of support back and forth from woo-commerce - they can't seem to help and I am hoping that SOMEONE in this community of geniuses can help us resolve this situation.
Original question posed to Woo Commerce
I need to permanently delete a large list of color/ style and size configured terms for these
Attributes so I can have a clean slate when I add another list. Although I have deleted they are not permanently deleted (just deleted from view). When I type in a previous attribute, Woocommerce/ WP remembers it and the full list of previous configured terms for these attributes has now reappeared preventing me from adding attributes to complete 6,000 variations. I am trying to complete a launch deadline this week and this is unfortunately holding me back. Going forward rides on correcting this. I would very much appreciate your help. Many thanks!Full thread of back and forth below.
Response to WooCommerce
Patrick -- it is very simple. I have simply typed in the attribute Color / Style that you deleted and it was remembered (as I have been stating would happen). When I entered this as a new attribute it appeared with ALL the configured terms that you had previously deleted -- as my screen capture shows. Showing you again and getting the same result with a screen cast is honestly, a waste of more time. This issue has been going on for weeks and now taking weeks to resolve.
Please try it yourself -- using the steps that both you and I are using. Delete the configured terms for this attribute. Delete the Color / Style attribute. Optimize the database if you want (it doesn't work). Then retype in Color / Style as a "new attribute". Hit save and see if it appears with all of the configured terms that you have just re-deleted.
Would you like me to give you access to the c-panel so that these can be removed directly from the MySQL? Once entered into the theme anything that gets put in the database never seems to fully disappear even when the theme says it is "permanently deleted." It is not.
I would really appreciate if you could help me resolve this today.
-- AshleyPS: Here is my toll free number if you would like to discuss by phone. A lot of time has been taken just with this back and forth: 888.960.5554
Patrick (WooThemes)
Sep 26 00:36 (UTC)Unless you can give me specific instructions on how to reproduce this, there is very little I can do to help. Can you try recording a screencast showing what you are trying to do and how it is not working?
Patrick - WooCommerceNinja
WooThemes SupportNinja Announcement! Share your finished site and lessons learned in the Community Forum
C. Ashley Spencer
Sep 26 00:07 (UTC)Patrick,
I am so disappointed!! It looked like it was working. I was ready to test. I typed in the color / style attribute before trying to import and guess what, ALL and I mean every single one that you deleted and that would take me hours to delete, CAME BACK!
I really cannot move forward. I truly believe that all these terms and attributes and even the variations that I'm trying to delete for each product, exist in MySQL and the theme is remembering them from there. They are not permanently deleted until they can be manually removed from the database. Optimizing the database does not work. I don't believe this aspect of what is happening is a web server problem. These need to be removed permanently. It just doesn't work otherwise. My business is being impeded with this function problem.
Please address. Can you please remove the color / style and size attributes + all their configured terms and all the product variations from the MySQL. I don't know how to do this. There is no one I can ask who knows how either. I'm really stuck.
Thank you -- whatever you can do will help.
-- AshleyPatrick (WooThemes)
Sep 25 19:05 (UTC)The ticket will be pending your response in our system so after a few days I think it tries to auto-close it, but if you have any issues you can easily re-open it just by replying to it and it will go back to me.
Patrick - WooCommerceNinja
WooThemes SupportNinja Announcement! Share your finished site and lessons learned in the Community Forum
C. Ashley Spencer
Sep 25 18:50 (UTC)Thanks, Patrick. I was deleting the terms and had to resort to deleting them individually just as you mentioned and just as I described in my last email.
I appreciate your explanation about the bulk delete and server (asking them now for support regarding) and your assurance on re-importing of items not duplicating, esp. with the same slug. Huge confirmation that I couldn't find anywhere else.
Hope all goes well when we try. I'm leaving this ticket open until we test this week and if no further issues will then close.
Thanks again,
-- AshleyPatrick (WooThemes)
Sep 25 16:51 (UTC)I did exactly what I'd explained before, go into configure terms and delete the terms within the attribute, then go delete the attribute itself. You keep having the terms within th attribute re-appear because you are not deleting the terms themselves. You can delete them either individually if there are not many or by using the bulk delete method (I deleted two attributes and did one of each method and it had worked fine).
If you are having errors deleting large numbers of attributes that is because your web server cannot handle the request and you will need to delete the attributes in smaller batches. The bulk delete works fine but the amount you can delete at one time relies completely on whether or not your web server can handle it.
It you are re-importing products, terms will not be duplicated if you have the same slugs in the CSV. As long as the slugs and everything matches it will use the existing one and there should be no duplication.
With as much data as you have and as many issues as your web server is causing, you may want to consider simply dumping the entire database and starting with fresh data. Unfortunately everything works exactly as it's designed, there is just too much data for you to be able to delete in one run with your web server and thats not something we support.
Patrick - WooCommerceNinja
WooThemes SupportNinja Announcement! Share your finished site and lessons learned in the Community Forum
C. Ashley Spencer
Sep 24 22:46 (UTC)Patrick,
I'm glad it's working for you, but unfortunately for me, the customer, it is not working. Thank you for deleting the color/style attribute!! Did you try various ways of deleting? Because simply deleting the attribute does not work for me, as you suggest. I wish it did! See screen captures. Did you also click on configured terms and delete each one individually or did you click all and apply a bulk delete? Because these are the screen captures I get when I do this. Sometimes I get "connection reset."I have tried this in both Firefox and Safari and get the same non-functionality each time. I am having to delete each configured term individually (very time consuming and why have bulk delete if it doesn't work?). Finally, I did this but the theme will not allow me to delete the size attribute AT ALL now.
At least now when I retype a configured term that I just deleted the theme does not appear to remember or suggest it for me. I may have that part resolved but not solved is being able to permanently delete and delete large amounts of items. I'm wary to proceed having just had this experience.
1) Can you please delete the size attribute and the one configured term I added hoping that would help me delete it.
2) Can you please assure me that if I use your importer to reapply terms that these all won't be duplicated and will they will be able to be deleted?
3) If I use an importer -- to make this go faster -- what is the best way to avoid possible duplication and then having to delete?
4) Will parent sku's help avoid duplication and then having to delete?
I need to make up for some lost time with this. Really trying to get back on track today.
Thanks.
-- AshleyPatrick (WooThemes)
Sep 24 20:07 (UTC)I just tested this doing exactly as I've been describing and had no issues. See the screenshots below for what happened when i did this.
Before: http://cld.wthms.co/t7kc
After Term Deletion: http://cld.wthms.co/cQCv
Deleted Attribute: http://cld.wthms.co/3znN
Added Back, No Terms Appear: http://cld.wthms.co/4TI0, http://cld.wthms.co/M7tCPatrick - WooCommerceNinja
WooThemes SupportNinja Announcement! Share your finished site and lessons learned in the Community Forum
C. Ashley Spencer
Sep 23 21:47 (UTC)Patrick,
This is not working. Can you please login to my site. Go into MySQL and
enter queries to delete the Attributes for color/ style and size and all of
their configured terms.Thank you!!
-- AshleyC. Ashley Spencer
Ashley Spencer
Sep 23 17:26 (UTC)Hi Patrick,
I wanted to get back to you after my last email in response to yours to see
if you could please help me resolve this today + I also wanted to let you
know that I changed the contact email to
[email protected] here and in my WooCommerce
Dashboard settings.Look forward to hearing from you hopefully soon.
Thank you for your your help!
-- AshleyC. Ashley Spencer
On Sun, Sep 22, 2013 at 4:42 PM, Ashley Spencer <[email protected]
> wrote:>
> Patrick,
>
> Steps I take:
>
> 1) I am bulk deleting the terms for the color/ style and size attributes
> (only). A blank screen appears after it cycles (timed out?). I can also
> delete just one or a few at a time but there are 1,115 items (56 pages)
> for just the color/style.
> 2) Then I delete these attributes.
> 3) The terms disappear and so do the attributes.
> 4) I optimize the database to permanently get rid of all of these
> 5) I type in color/ style and size for the attribute and it remembers and
> they reappear.
>
> Suggestions for getting this done quickly -- and working?
>
> Many thanks,
> -- Ashley
>
> C. Ashley Spencer
> Casart & Casart coverings, llc
>
>
> On Sun, Sep 22, 2013 at 2:51 PM, Patrick <[email protected]
> > wrote:
>
>> **
>>C. Ashley Spencer
Sep 22 20:42 (UTC)Patrick,
Steps I take:
1) I am bulk deleting the terms for the color/ style and size attributes
(only). A blank screen appears after it cycles (timed out?). I can also
delete just one or a few at a time but there are 1,115 items (56 pages) for
just the color/style.
2) Then I delete these attributes.
3) The terms disappear and so do the attributes.
4) I optimize the database to permanently get rid of all of these
5) I type in color/ style and size for the attribute and it remembers and
they reappear.Suggestions for getting this done quickly -- and working?
Many thanks,
-- AshleyC. Ashley Spencer
Patrick (WooThemes)
Sep 22 18:51 (UTC)Are you deleting the attributes, or the terms themselves? When you delete the terms directly, does the attribute still show that it has terms attached?
Patrick - WooCommerceNinja
WooThemes SupportNinja Announcement! Share your finished site and lessons learned in the Community Forum
C. Ashley Spencer
Sep 22 16:51 (UTC)Hello Patrick,
Thanks for getting back to me and yes, I have done this already -- bulk
delete after clicking configure terms. That is not the issue. The issue is
that they return (they are remembered by the system) and the are not
permanently deleted. I need to permanently delete them. How do I do this?I may want to use a csv importer to reimport and I have to have an absolute
clean slate. Also, I want to make absolutely sure that nothing get
duplicated in the process while doing this. This is why I need these
permanently deleted. Do you have any suggestions as to the best method of
making sure that attributes, terms, images, etc that are already on the
site are not duplicated when a mass upload is done. I will be using SKU's
to help prevent this.I look forward to you telling me how to do this permanent deletion with
specific steps, since I am not a web developer and am not familiar with all
the code and do not want to mess anything up, particularly if this issue
involved MySQL and PHP.Many thanks for your time and attention to help me quickly resolve,
-- AshleyC. Ashley Spencer
Patrick (WooThemes)
Sep 22 16:26 (UTC)Hi Ashley,
You should be able to do this by clicking "configure terms" and deleting them from there.
Patrick - WooCommerceNinja
WooThemes SupportNinja Announcement! Share your finished site and lessons learned in the Community Forum
C. Ashley Spencer
Sep 21 21:03 (UTC)I need to permanently delete a large list of color/ style and size configured terms for these
Attributes so I can have a clean slate when I add another list. Although I have deleted they are not permanently deleted (just deleted from view). When I type in a previous attribute, Woocommerce/ WP remembers it and the full list of previous configured terms for these attributes has now reappeared preventing me from adding attributes to complete 6,000 variations. I am trying to complete a launch deadline this week and this is unfortunately holding me back. Going forward rides on correcting this. I would very much appreciate your help. Many thanks!November 20, 2013 at 1:05 pm #74471SusanModeratorHi, as you posted this a while back, I hope you got your issue resolved. If not, please check back, and I will escalate for you. If it is resolved, please mark “resolved”, and I will close it. Thanks!
April 8, 2014 at 8:16 pm #99252KarenLeighBurtonMemberno we've never gotten a response or a fix.
thank you for escalatingApril 8, 2014 at 8:37 pm #99258SusanModeratorI've escalated - let's see if we can get you some help!
April 8, 2014 at 11:06 pm #99292AnitaKeymasterIf you want to get rid of *all* of the attributes in one whop and start off with a blank slate under the Attributes area, you can do it in the database. See image here - you just dump the Woocommerce Attributes. Not sure why they wouldn't tell you that. Or you can actually select different attributes and get rid of them.
Love coffee, chocolate and my Bella!
-
AuthorPosts
- The forum ‘Design Tips and Tricks’ is closed to new topics and replies.