Resolved Blank fields when exporting Orders from Virtuemart

Hello,

1. The Custom Field is not exporting properly. I have a custom field called UOM (Unit of Measure). Type = String, Values= EA;CS;PK;2PK;3PK. When I export an order with Advanced Order Export the custom field shows as "UOM - ".

There were some improvements made to product_attribute fields in Order, Order advanced and Order item export of VirtueMart which will be included in our next release. I have attached the patch file with these improvements. Can you load the patch file and check your export? Let me know if it exports the string custom field values.

2. The address, city, state and zip code to not export at all. They are always blank. This has been an ongoing issue from day one of installing CSVI Pro.

You have set filter by virtuemart_order_id 157 in your export template, Could be that this order has no shipping address but only billing address in database and so shipping fields for address, city, state and zip code does not export. Are you sure that this order have a shipping address stored?

patch_vm_2018_12_19.zip

I applied the patch, however the Custom Filed still exported only "UOM - " instead of the expected result. I did receive two errors when applying the patch.

Incorrect Failure Cannot copy patch file /plugins/csviext/stockablecustomfields/stockablecustomfields.php
Incorrect Failure Cannot copy patch file /plugins/csviext/customfieldsforall/customfieldsforall.php

Do I need Custom Fields for All for this to work?

I changed the fields in the export template from shipping_address_1, shipping_Address_2, etc.. to just Address_1, Address_2 etc. that works for orders where the Bill To and Ship To are the same (via checkbox on checkout). I will have to monitor for when the Bill To and Ship To are not the same and hopefully the export will pick up the correct fields.

Hello,

I applied the patch, however the Custom Filed still exported only "UOM - " instead of the expected result. I did receive two errors when applying the patch.

Incorrect Failure Cannot copy patch file /plugins/csviext/stockablecustomfields/stockablecustomfields.php
Incorrect Failure Cannot copy patch file /plugins/csviext/customfieldsforall/customfieldsforall.php

Do I need Custom Fields for All for this to work?

The patch includes changes to product_attribute field for CSVI stockable custom fields and CSVI custom fields for all plugins too. You may not be using these plugins and so these plugin files are not available on your site hence the error. You don't need to use Custom Fields for All if you don't use it. Regarding your string custom field. Can you send me the value of product_attribute field as stored in your virtuemart_order_items table?

When the product_attribute worked correctly I would see entries like {"3":{"4"": false}, now every product_attribute is {"4":[]}

Hello,
Two things to explain here

1. As much as i know the values for VirtueMart core string custom field is stored as { "3": "2" } in product_attribute field. The example you have posted does not match this pattern. Are you sure you are talking about VirtueMart core string custom field? If yes, which version of VirtueMart you are using?

When the product_attribute worked correctly I would see entries like {"3":{"4"": false}, now every product_attribute is {"4":[]}

Are you saying the value stored in product_attribute field is wrong? If yes, CSVI has nothing to do with product_attribute stored value whereas it reads the value which is saved in database and converts it to readable format on export.

Hello,

It would also help us if you post screenshots of your custom field setup.

Not sure why my previous post from 12/28/18 did go trough. after changing the fields for export to the address_1, address_2, etc.. I'm getting better results. Still haven't had an order with different bill to / ship to addresses. Attached are screenshot of the custom filed setup. It does seem that VirtueMart did change the Custom Fields, but I'm not sure where to look or how to fix it. The Custom Filed displays correctly in every other part of Virtuemart, site, invoice, etc

Hello,
The attached screenshots are very small and we could hardly see the values in them. But still looking at those screenshots for what is in the database, there is no value stored for UOM in product_attribute field so your export is not any getting values. For the values where UOM is saved, export works fine. CSVI will process the data stored in database and exports it. If the value saved is empty in database, CSVI has nothing to process and so your export value is empty. What is in database is what processed and exported. Let me know if that explains your issue.

Sorry for the small screenshots. I had to crop, shrink, and compress them to get the Word document under your file size limit.

Would it be possible that we could pull the customfield_value from the virtuemart_product_customfields table where the virtuemart_order_items.virtuemart_product_id = the virtuemart_product_customfields.virtuemart_product_id? the Value in the virtuemart_product_customfields.customfield_value is what I need.

I can also post on the VirtueMart forum about how and why the custom field sting has changed, hopefully someone can help.

Hello,

You can also post the screenshots in your message, as you can add multiple images to a post. They don't need to be in a Word document.

Ideally order details must be stored in the order database because you should be able to reproduce the situation at the time of purchase. Having data in linked tables makes this fragile because that can change. Now, VirtueMart doesn't store all data in the order details and some data is linked to external tables.

Looking at your screenshots, the order only has the ID 4 stored now. Can you actually see the PK value in the order details when you view the order? If this is the case, there should be some kind of relation between that 4 and PK value.

What I wonder is if something changed in how they store and read the values.

I thought about it after I posted the last message and I see that wouldn't be a solution. Since VirtueMart can support multiple custom fields per product, that would complicate the issue. I created a topic on Virtuemart forum (http://forum.virtuemart.net/index.php?topic=141853.0). Someone has suggested that there is a potential fix. The reason that the ID changed from 3 to 4 is because I deleted the original custom filed and recreated it, seeing if that made a difference, the value of 4 seems to be the ID of the custom filed. the table virtuemart_product_customfields contains all the values and the ID's for the custom fields. The problem must be in the function that writes the values into the virtuemart_order_items table not gathering all the info as before. The value is displayed correctly every where else in the backend.

Hello,
I don't think deleting a custom field and recreating it will be a solution here as this will not change the values stored in product_attribute field for any old orders. Anyways this issue is something to do with VirtueMart and is above our limits to help.