Magento

Hi

Were having a problem

Were trying to create an attribute based on the info on another attribute, but we do not want to enter all the information all over again.

The reason is this:

We have a product that can have multiple attributes like so.

Is Instant, Flies, Has Protection from Red, is a Land

Those are 4 different attributes and the product can have them in any order, so basically we have 5 possible attributes each being any possible of 150 atributes in 3 different languages…

So what we want to do is have 5 different variable values (for import/export purposes)

Like mtgvariable1, mtgvariable2, mtgvariable3, mtgvariable4, mtgvariable5

Basically these are all IDENTICAL attribute fields with the exception of the name, and atm we dont see any option to “copy” an attribute and rename it so we dont have to do every attribute all over again.

Is there any way to do this?

I understand having “Multiple Selection” is “basically” the same thing however when you use this option, and export products using CSV the variable that results is one long line, when trying to import it back into magento it detects the entire line as one long new value instead of multiple selected existing attributes and it messes it up.

Thats why we want to use one attribute per individual attribute instead of “multiple selection” attributes.

I hope someone can steer us in the right direction..

Thanks

anyone :/

create these attributes in admin, note their type (int, varchar, text, ...) and attribute_id, then fill catalog_product_entity_varchar or catalog_product_entity_text or whatever with your data records:

entity_type_id - look up in eav_entity_type table for ‘catalog_product’
attribute_id - your new attribute id
store_id - 0 for default values, or from core_store table
entity_id - your product_id
value - your custom value

not too complicated, eh?

Saharian - 21 June 2008 08:47 PM

create these attributes in admin, note their type (int, varchar, text, ...) and attribute_id, then fill catalog_product_entity_varchar or catalog_product_entity_text or whatever with your data records:

entity_type_id - look up in eav_entity_type table for ‘catalog_product’
attribute_id - your new attribute id
store_id - 0 for default values, or from core_store table
entity_id - your product_id
value - your custom value

not too complicated, eh?

Haha well your idea seems to work but i have no idea where the stuff you are mentioning is,

Bah is there any way i could persuade you into putting it into noob mode? lol

something like.....

Go here, type this then add that copy that and add into those areas.

I SORTA understand what you are trying to say but its just past my SQL skills lol

Ill put a checklist into what i got lost:

“create these attributes in the admin panel ,” ok Done!

“note their type (int, varchar, text, ...) and attribute_id,” Where do i find this?

“then fill catalog_product_entity_varchar or catalog_product_entity_text or whatever with your data records:” ive seen the tables but they dont seem like they contain any info regarding the attributes

“entity_type_id - look up in eav_entity_type table for ‘catalog_product’” cant find the table containing this
attribute_id - your new attribute id” ditto.
store_id - 0 for default values, or from core_store table ditto.
entity_id - your product_id ditto.
value - your custom value ditto.

ok ive been trying to find what you were telling me i found out the following:

mtgcardtype attribute_id:584

catalog_product_entity_varchar, catalog_product_entity_text, etc etc etc
all of these were empty with no data

the rest are these with the following but none have that breadcrumb that you specify

http://www.xionics.com/files/catalog_product_entity_text.png
http://www.xionics.com/files/eav_attribute.png
http://www.xionics.com/files/eav_attribute_option.png
http://www.xionics.com/files/eav_attribute_option_value.png

Click thumbnail to see full-size image