Page 1 of 1

Looking to delete attribute for multiple products at once

Posted: Mon Nov 06, 2023 4:44 am
by oc-666
Opencart Version: 2.3.0.0-2.3.0.2
Journal Theme

Hi Guys,

I am working on an opencart website that is selling lots of kitchen appliances, heavy products that used to only be for local delivery and the person who listed these products listed them with an attribute of "Local Delivery Only = Yes", see attached image.

I am looking to change these products now as being available for nationwide delivery, but there is alot of these products, and I dont want to go into every single one, as their is loads, and delete the "local delivery attribute" as it would take too much time. I also use the "Ultimate Shipping Extension" ... is there a way or deleting this attribute for all the heavy products at once or I can override the "local delivery=yes" attribute by adding in a rule into Ultimate Shipping??

Image

Any help/info. very much appreciated.

Re: Looking to delete attribute for multiple products at once

Posted: Mon Nov 06, 2023 5:22 pm
by khnaz35
If you are looking for real qucik fix, then disable the attribute from the journal theme itself.
you should be looking under Jouranl->product extras ->product T.A.B

Re: Looking to delete attribute for multiple products at once

Posted: Mon Nov 06, 2023 6:16 pm
by oc-666
Thanks but there are some products, small items, that would still be "Local Deluvery Only", so if I delete the attribute from the theme itself, will that effect the other items that are still local delivery? Many thanks for you input

Re: Looking to delete attribute for multiple products at once

Posted: Mon Nov 06, 2023 10:36 pm
by paulfeakins
oc-666 wrote:
Mon Nov 06, 2023 4:44 am
... is there a way or deleting this attribute for all the heavy products at once or I can override the "local delivery=yes" attribute by adding in a rule into Ultimate Shipping??
You could write a script to do it, or an SQL query, or you could ask Johnathan from Clear Thinking if Ultimate Shipping can do it.

Re: Looking to delete attribute for multiple products at once

Posted: Tue Nov 07, 2023 12:56 am
by oc-666
Thanks alot for the suggestions paul, much appreciated. .... so they are the only options available to me? It can't be done any other way?

Thanks again.

paulfeakins wrote:
Mon Nov 06, 2023 10:36 pm
oc-666 wrote:
Mon Nov 06, 2023 4:44 am
... is there a way or deleting this attribute for all the heavy products at once or I can override the "local delivery=yes" attribute by adding in a rule into Ultimate Shipping??
You could write a script to do it, or an SQL query, or you could ask Johnathan from Clear Thinking if Ultimate Shipping can do it.

Re: Looking to delete attribute for multiple products at once

Posted: Tue Nov 07, 2023 11:48 pm
by paulfeakins
oc-666 wrote:
Tue Nov 07, 2023 12:56 am
so they are the only options available to me? It can't be done any other way?
What's wrong with those options?

Asking for help from Johnathan and Ultimate Shipping is quick and easy and would probably be the first thing to try.

Otherwise it's a script. I don't think there's any other way.