Agency/Woo Commerce variations NOT deleting

Community Forums Forums Design Tips and Tricks Agency/Woo Commerce variations NOT deleting

This topic is: not resolved

This topic contains 4 replies, has 3 voices, and was last updated by  anitac 2 weeks, 1 day ago.

Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • #64307

    KarenLeighBurton
    Participant
    Post count: 19

    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.
    – Ashley

    PS: 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 Support

    Ninja 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.
    – Ashley

    Patrick (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 Support

    Ninja 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,
    – Ashley

    Patrick (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 Support

    Ninja 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.
    – Ashley

    Patrick (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/M7tC

    Patrick – WooCommerceNinja
    WooThemes Support

    Ninja 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!!
    – Ashley

    C. 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
    ashleyspencer@casartcoverings.comboth here and in my WooCommerce
    Dashboard settings.

    Look forward to hearing from you hopefully soon.

    Thank you for your your help!
    – Ashley

    C. Ashley Spencer

    On Sun, Sep 22, 2013 at 4:42 PM, Ashley Spencer <contact@casartcoverings.com
    > 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 <notifications-help@woothemes.com
    > > 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,
    – Ashley

    C. 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 Support

    Ninja 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,
    – Ashley

    C. 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 Support

    Ninja 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!

    http://www.casartcoverings.net
    #74471

    Susan
    Moderator
    Post count: 7516

    Hi, 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!


    Susan @ Graphically Designing I’d love to customize your website! I tweet!
    I’ve taken up the challenge! – help me answer some of the unanswered posts

    #99252

    KarenLeighBurton
    Participant
    Post count: 19

    no we’ve never gotten a response or a fix.
    thank you for escalating

    #99258

    Susan
    Moderator
    Post count: 7516

    I’ve escalated – let’s see if we can get you some help!


    Susan @ Graphically Designing I’d love to customize your website! I tweet!
    I’ve taken up the challenge! – help me answer some of the unanswered posts

    #99292

    anitac
    Participant
    Post count: 6489

    If 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.


    Let me help you customize your theme, responsive header, Buddypress, Agentpress or technical issue!
    Visit me here: Cre8tiveDiva.com | Tweet Me! | Plus Me!
    When asking for help, please provide a link or screen shot showing your problem!

    • This reply was modified 2 weeks, 1 day ago by  anitac.
    • This reply was modified 2 weeks, 1 day ago by  anitac.
Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic.