Forums / Setting Up Categories, Products, Attributes / Attributes copied to all by mistake

Attributes copied to all by mistake

Locked

Views: 1,504

Results 1 to 6 of 6
This thread is locked. New replies are disabled.
27 Oct 2007, 12:59 PM
#1
acheem avatar

acheem

New Zenner

Join Date:
Sep 2005
Posts:
10
Plugin Contributions:
0

Attributes copied to all by mistake

My boss copied all the attributes to to the wrong categories. I have a backup of my shop from about a week back, but I am not keen on reverting back to that as I am going to loose orders/customers from the database. (Yes, I should have backed up more frequently) Is it possible to just import the tables that has to do with the attributes?

I am using an old 1.2.5-version

Best regards,
Acheem

27 Oct 2007, 2:26 PM
#2
econcepts avatar

econcepts

Totally Zenned

Join Date:
Dec 2005
Posts:
1,505
Plugin Contributions:
2

Re: Attributes copied to all by mistake

Can you just copy the attributes back (or delete them if needed) from the products you want?

Eric
20 Ways to Increase Sales Using Zen Cart
Zen Cart contribs: Simple Google Analytics, Export Shipping Information

27 Oct 2007, 2:39 PM
#3
acheem avatar

acheem

New Zenner

Join Date:
Sep 2005
Posts:
10
Plugin Contributions:
0

Re: Attributes copied to all by mistake

Yes, I can delete them, but I now have about 250 products with 300 attributes each. It's going to take a long time deleting them.

27 Oct 2007, 3:37 PM
#4
acheem avatar

acheem

New Zenner

Join Date:
Sep 2005
Posts:
10
Plugin Contributions:
0

Re: Attributes copied to all by mistake

Edit: It is not possible to use the "Delete Matching Attribute from ALL Products where Option Name and Value ..."-function on most of the categories. It simply can't find anything to delete. Example error message: "Error: Nothing found to copy from: Klasse # 4 to: Class TEXT Category: 17"

27 Oct 2007, 4:01 PM
#5
ajeh avatar

ajeh

Oba-san

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

Re: Attributes copied to all by mistake

In the bottom of the Option Names is the feature for:

Delete ALL Option Values to ONE Category of products for Option Name
Update ONE Category of products, when the product has at least ONE Option Value and Delete ALL Option Values in an Option Name

This allows you to pick 1 Category at a time and remove all attributes that are on it ...

But I cannot recall if that is in the ancient version that you are using ...

Or, you can go to each Category that is bad and set one product to the right attributes and copy those attributes to all products in 1 category and delete the old ones ... based on the premis that each Category is using the same attributes ...

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!

27 Oct 2007, 4:20 PM
#6
acheem avatar

acheem

New Zenner

Join Date:
Sep 2005
Posts:
10
Plugin Contributions:
0

Re: Attributes copied to all by mistake

Ajeh:

In the bottom of the Option Names is the feature for:

This allows you to pick 1 Category at a time and remove all attributes that are on it ...

But I cannot recall if that is in the ancient version that you are using ...

Or, you can go to each Category that is bad and set one product to the right attributes and copy those attributes to all products in 1 category and delete the old ones ... based on the premis that each Category is using the same attributes ...

Thanks, the option to delete all attributes on the chosen category was there. -Even in this ancient version ;-) So that actually gets rid of all the attributes for me.

And your premis that each Category uses the same attributes are very unfortunately wrong, hehe. But I think this is the kick in the ######## I need to stop using attributes and convert to separate products for a whole bunch of items. My last straw is the option of using phpMyAdmin to import the old attributes back where they belong, but I am not sure if this is even possible. The table products_attributes is surely involved, but there could easily be more. I dare not dive into that without guidance.