Issue with product attributes values returned empty

[jasonknight]

Issue with product attributes values returned empty

[jasonknight]

Yeah, Attribute support is being worked on right now. It's problematic because it's a database within a database...

[jasonknight]

Attribute reading is added in. Writing hasn't been tested...

[sdelamo]

Thanks for working so fast in the issue. Unfortunately I am afraid the issue is still opened. I pulled the new code and tested the get products call again and now the attributes values are shown as null instead of empty.

[jasonknight]

what is the database value, exactly. i.e. select the raw value and put it in your comment so I can recreate the values on my local system.

[sdelamo]

The attributes are of type "Text". The values are text strings.

[jasonknight]

Which version of WooCom do you have? It's look slightly different to mine...

Also, I kind of need the database represetation. Will prolly look like a:{i:1:"pa_ean blah blah,

You can run these commands to find out:

$ mysql -u myuname -pPASSNOSPACEAFTERp my_database_name
> select meta_key, meta_value from wp_postmeta where meta_key = '_product_attributes' and post_id = 'mypostidhere'

Or use PHPMyAdmin or something.

[sdelamo]

I am running Woocommerce 2.0.14 in Wordpress 3.6.1

This is the output of the next query:

select meta_key, meta_value from wp_postmeta where meta_key = '_product_attributes' and post_id = '84';

meta_id: 2425
post_id: 84
meta_key: _product_attributes
meta_value: a:4:{s:6:"pa_ean";a:6:{s:4:"name";s:6:"pa_ean";s:5:"value";N;s:8:"position";i:0;s:10:"is_visible";i:1;s:12:"is_variation";i:0;s:11:"is_taxonomy";i:1;}s:12:"pa_packaging";a:6:{s:4:"name";s:12:"pa_packaging";s:5:"value";N;s:8:"position";i:4;s:10:"is_visible";i:1;s:12:"is_variation";i:0;s:11:"is_taxonomy";i:1;}s:6:"pa_adr";a:6:{s:4:"name";s:6:"pa_adr";s:5:"value";N;s:8:"position";i:5;s:10:"is_visible";i:1;s:12:"is_variation";i:0;s:11:"is_taxonomy";i:1;}s:6:"pa_nem";a:6:{s:4:"name";s:6:"pa_nem";s:5:"value";N;s:8:"position";i:7;s:10:"is_visible";i:1;s:12:"is_variation";i:0;s:11:"is_taxonomy";i:1;}}

[jasonknight]

The values are null.

{
    s:4:"name";
    s:6:"pa_ean";
    s:5:"value";N;
    s:8:"position";
    i:0;
    s:10:"is_visible";
    i:1;
    s:12:"is_variation";
    i:0;
    s:11:"is_taxonomy";
    i:1;
}

s:5:"value";N; means Null.

Do you have a plugin running that filters these attributes?

[jasonknight]

I see the problem, your product attributes are a taxonomy.

[jasonknight]

Alright, latest version supports the WooComm attribute taxonomy reading.

Writing them doesn't have 100% support just yet but the code is in place but will have to wait till I cam write up a test case for it.

[sdelamo]

@jasonknight is there any plans to fix this issue? I am still getting all attributes blank.

[jasonknight]

Yes, could you provide me with your testing db so I can work against your precise situation? You can send it via dropbox or something?

[jasonknight]

Okay, I just pushed a change that should let you at least read the taxonomy values...

Part of the product taxonomy system.

[sdelamo]

I uploaded your updated code and I can read attributes without any problems. Thanks!

[PriyankaRose]

I'm also sailing in the same issue. Could you post the updated code, it would be a great help. Thanks

[jasonknight]

The latest code is always in the repo. If you are having issues, maybe you can poke around and see what is up?

[PriyankaRose]

I couldn't able to get attribute values from taxonomy. I have tried
select meta_value from wp_postmeta where meta_key = '_product_attributes' and post_id = '55';

It gives an array a:1:{s:13:"pa_size-value";a:6:{s:4:"name";s:13:"pa_size-value";s:5:"value";s:0:"";s:8:"position";s:1:"0";s:10:"is_visible";i:1;s:12:"is_variation";i:1;s:11:"is_taxonomy";i:1;}}

With these array values, i dono how to proceed.
Could you mention how to walk around with woocommerce taxonomy?

[jasonknight]

Aiyiyi. The WC Product Attribute Taxonomy is so insane, I don't even pretend to understand it. It's a pretty circuitous route to any. Basically they have their own table that you select against. You'll have to look at the table structure, I don't recall off the top of my head. It's a similar query to getting a regular taxonomy, I think you may even be able to use WP Core functions to do it...