If this is your first visit, check our documentation. To post, register or login.

Removing Value

Locked

Started by nindak on 14 Sep 2010, 3:54 PM · Views: 1,077

Results 1 to 13 of 13
This thread is locked. New replies are disabled.
14 Sep 2010, 3:54 PM
#1
nindak avatar

nindak

New Zenner

Join Date:
Sep 2010
Posts:
17
Plugin Contributions:
0

Removing Value

While I was trying to figure out the Attribute section, I have run across a problem. I have a value I cannot figure how to remove from the list. Is there a way to clear up all attributes and start over? I have looked in Store Manager and there really wasn't a reset for that in that area. I also have no option names either. The value shows up after I create an option name and go to option value.

Thank you

14 Sep 2010, 4:09 PM
#2
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Removing Value

The Option Names are defined in the Options Names Manager ...

The Option Values are defined in the Options Values Manager ...

What exactly are you trying to remove?

All existing Option Names?

All existing Option Values?

All existing Attributes?

Or ... something else?

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

14 Sep 2010, 4:16 PM
#3
nindak avatar

nindak

New Zenner

Join Date:
Sep 2010
Posts:
17
Plugin Contributions:
0

Re: Removing Value

I dont have any attributes name or value's that are assigned. If I do have something assigned it was by pure accident or luck. I would like to remove all attributes option names and values. Somehow a value is showing, every time I create a new option name. I can delete the option name and make a new one, go to option value it will always show.

14 Sep 2010, 4:46 PM
#5
nindak avatar

nindak

New Zenner

Join Date:
Sep 2010
Posts:
17
Plugin Contributions:
0

Re: Removing Value

Yes its the same value every time. I am trying to sell single trading cards. Some cards have various rarities and trying to set up the attributes to reflect that.

14 Sep 2010, 4:59 PM
#7
nindak avatar

nindak

New Zenner

Join Date:
Sep 2010
Posts:
17
Plugin Contributions:
0

Re: Removing Value

yes I currently have no option names... but if I create one.... go to Option Value.... there is a value from when I tried figuring it out previously. I doesn't matter what Name I create either.

14 Sep 2010, 5:12 PM
#9
nindak avatar

nindak

New Zenner

Join Date:
Sep 2010
Posts:
17
Plugin Contributions:
0

Re: Removing Value

I am on the Option Name Manager... I try and click the Option Values Manager it tells me Warning: No Option Names have been defined.

I assumed the values were removed with the names when I deleted a name.

15 Sep 2010, 1:47 AM
#10
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,512
Plugin Contributions:
176

Re: Removing Value

Nindak:

I assumed the values were removed with the names when I deleted a name.
You should not be able to delete an Option Name if Option Values are assigned for it.
Not sure how you got around that.
Maybe a bad addon?

While I NEVER recommend anyone mess around with raw database queries unless absolutely necessary, if you've got corrupted data, you'll need to.
Click on Admin->Tools->Install SQL Patch and paste the following into the box and click Send.```
truncate table products_options;
truncate table products_options_values;
INSERT INTO products_options_values (products_options_values_id, language_id, products_options_values_name) VALUES (0, 1, 'TEXT');
truncate table products_options_values_to_products_options;
truncate table products_attributes;
truncate table products_attributes_download;

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

15 Sep 2010, 2:02 AM
#11
nindak avatar

nindak

New Zenner

Join Date:
Sep 2010
Posts:
17
Plugin Contributions:
0

Re: Removing Value

Thank you very much... I did have someone help me earlier and got it figured out.

15 Sep 2010, 2:54 AM
#12
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Removing Value

NOTE: Make sure that in the products_options_values table that you have an entry for TEXT ...

If not, you will want to add:

INSERT INTO products_options_values (products_options_values_id, language_id, products_options_values_name) VALUES (0, 1, 'TEXT');

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

15 Sep 2010, 3:24 AM
#13
gjh42 avatar

gjh42

Black Belt

Join Date:
Jul 2005
Location:
Upstate NY
Posts:
21,874
Plugin Contributions:
8

Re: Removing Value

I had deleted that value years ago when I was a newbie because I thought I didn't need it... took me a long time to find out how to get it back a couple of years later when I did need it.