Importing products attributes

Hey @wpallimport
The attributes in my XML feed are structured like this:
<name>Color</name>
<value>Green</value>
<name>Size</name>
<value>Medium</value>
and so on and so fourth. Additionally, the name-value-pairs are not always in the same order (sometimes Size would come before Color) and there are different ones for different kinds of products.

How can I import this?
The only way I see it could work is if I add like 10 attributes (more than the amount on the product that has the most) and drag in the Name and Value ones in the respective field. That would create new attributes for each product feed though and I’d like to be able to merge the attributes by mapping them against my own ones…

What would you suggest I do?

Hello @davidserrano72
I received a snippet of code from WP All Import support that solved the problem.

“Yes, it looks like you can use a custom PHP function for this: http://www.wpallimport.com/documentation/developers/execute-php/. The idea would be to pass the name of the attribute you want along with all of the names/values, then loop through them to find the value. Here’s how you’d call the function:

[my_get_attribute_value(“SIZE”,array({Extras/Name}),array({Extras/Value}))]

And the code would be:

function my_get_attribute_value( $attr, $name, $value ) {
if ( empty( $name ) || empty( $value ) ) return;

$names = explode( “, “, $name[0] );
$values = explode( “, “, $value[0] );

foreach ( $names as $key => $v ) {
if ( $v == $attr && array_key_exists( $key, $values ) ) {
return $values[ $key ];
}
}
}”