Resolved custom fileds in order export

How is the product_attribute field stored in your database? I don't think there has been any changes to this field.

How is the product_attribute field stored in your database? I don't think there has been any changes to this field.

The screenshot explains a lot.

when i upgrade to vm3.0.2 the value in this filed is empty (see attache)

This is how CSVI get's your product attributes from PHP:

[7] => stdClass Object

        (

            [381893] =>

        )

As you see there is nothing after that number, that is because the value is false. I think a field like that is special. What kind of custom field do you use for these products? Can you post some screenshots of your setup?

So this is a String field, what values are stored in the product for this field? That field is set to Admin only, so it doesn't even show in the frontend.

So this is a String field, what values are stored in the product for this field? That field is set to Admin only, so it doesn't even show in the frontend.

This an id number for each product, i use this id when i import the orders to my local Software
i hide this number from the customer but i need it when i export the orders

I understand, let me look into this and I will get back to you.

So I had a look at this and the field you have is quite different from the rest because the order information doesn't contain the value of your field but it contains the database ID of where the value is stored.

Attached is a patch file you can load and you should be able to export your product_attribute field now.

It seems that fixed it.
but now it make a duplicate rows (attached
order3.xml
)

There are no duplicate rows, if you look at the first one in your file you can see that the <rivhit_id> field is different. In the first record it is empty and in the second record it is filled. Which field is this?

the rivhit_id is a shopper filed that i create to identify the customer in my local software.

It is because of this field you get everything twice. Does it exist twice for each customer? I wonder why it comes out twice. If it doesn't exist twice, maybe you can explain me how this is setup.

It is because of this field you get everything twice. Does it exist twice for each customer? I wonder why it comes out twice. If it doesn't exist twice, maybe you can explain me how this is setup.

i found the solution, in the DB every order item appear twice one row for BT and one row for ST, so i choose the BT export and it fix it.

Aha, ok. That will explain it indeed. BT is always there but if ST is different from BT, there are 2 rows stored.

the probleam with the product_attribute began again, it export empty value for th product_attribute, how can i fix it?

What did you change? The other issues could be that the ID no longer exists. The first product_attribute {"7":{"394658":false}} has the ID 394658. The value of this ID is stored in the table j5ef8_virtuemart_product_customfields. Check the table j5ef8_virtuemart_product_customfields for the virtuemart_customfield_id 394658 if it exists. If it doesn't exist, that is why your export would be empty.