Resolved Custom Fields For All export in orders

Hello,
Checking into your order items table shows that your product SKUs are empty for most of the rows. It is the same with your VirtueMart product tables too. CSVI uses product_sku for searching in order product field and the same is stored for running the export query. Since the product_sku is empty nothing stored in order product field. You can try storing a row with product_sku and it should work good. So may i know the reason why your SKUs are empty?

Hello,
Can you also send the dump of order items table? The product name is read from this table in the template product search option.

Thanks Roland,
I've send you a PM with the products.

Here you can an example of what I get when I search for "NFF Regio". There are 16 products with this name, but none shows up.

Hello,

Best wishes for 2017 to you as well

I also noticed not every product is shown when you type in the search-field.

That is correct, the list is limited to the first 10 matches. If you are looking for a specific product you would need to type a longer name.

Should I PM you user-details so you can see for yourself?

The linebreak you mentioned I think you mean the <br /> tag. If you could send me a dump of the order product table via a private message. I will load that here and see what happends.

When I add a <br /> tag it won't show when I select the product but it is shown after I save the template.

Here are the examples. I also noticed not every product is shown when you type in the search-field.
Should I PM you user-details so you can see for yourself?

Hello,
Even with line breaks in product name i don't see any issue in saving the Order product field. Can you post an example of one of your product name with line breaks and as it is saved in database to test it?

First of all.... Happy 2017!
These are the steps that I take:

• Open my template


• Go to "options"


• Type something in the searchfield of "Order Product"


• Click one of the searchresults, in this case "NFF PK 1
  Ommen
  19 mrt 2016"


• Click save

When the screen reloads, the input in "Order Product" is gone.

I now realize it probably has to do with the fact that my client added line breaks to the productname. Is there a way to get this to work, without removing the page breaks?

Hello,

Can you reproduce the scenario for when you can't save? Does the save button works but the selection is not saved? Which steps do you take that leads to the not saving of the products?

If I enter a product in "Order product" on the template options tab, it does not always save. So I can't seem to make export files per product. Did I add these products incorrectly?

Thanks! "Group by" did the trick.
Excuse me for my intusiveness, but when is the estimate for the patch to be ready? I'm considering if it is an option for my client to use the product attributes "as-is" until we can switch to the new version...

Hello,
Please check our Group by and sort by document to know on how to avoid duplicates in export.

Also, some orders are repeated 51 times. Did I set something wrong? export.txt

Hello,
As i already mentioned we don't support custom fields in order export other than what is in product_attribute field. This improvement is in our todo list and will send you the patch when it is ready. For now you can create a Override file for export and customise the product_attribute field as per your requirement.

Wow, thanks for the quick reply!
I'm sorry to hear that its not possible (yet) to export custom fields in order exports...

Is there a way to present the product attributes in a more userfriendly way? This is what I get now:

{
"23": {
"256": {
"customsforall_option": "88"
}
},
"14": {
"257": {
"comment": "Firstname Lastname"
}
}
}

Hello,
The custom fields data is stored in the product_attribute field in orders table, you can export this field to get your custom fields. Currently CSVI don't support individual custom fields in order export other than what is in product_attribute field. The data stored in product_attribute field depends on the custom fields you are using. It can be simple plain text or JSON string.