Resolved VM Order Export: Total price and customer comment?

Hello,

The total order price is the field order_total if I am not mistaken. For the customer notes, there are three different ones. There are customer_note, billing_customer_note and shipping_customer_note. In general you should have enough with the customer_note.

Hello,

Those fields are meant to appear in the dropdown in the screenshot?

Because I do not find them there.

PS. This may be related to the other issue we are having where we are unable to update the fields yet
https://csvimproved.com/forum?view=topic&catid=44&id=34709

Hello,

Those fields are meant to appear in the dropdown in the screenshot?

Yes they should appear in the dropdown but it looks like you are searching fields on billing in the dropdown and so dropdown list shows all of billing_ fields.

Because I do not find them there.

I can see billing_customer_note field in the dropdown list screenshot.

PS. This may be related to the other issue we are having where we are unable to update the fields yet
http://csvimproved.com/forum?view=topic&catid=44&id=34709

Did you talk to your hosting provider on the errors? Once that is fixed you should be able to update your available fields.

Attaching a new screenshot.

I see the field I want in the available fields list.
But I do not see it in the Add field dropdown.

Hope it helps a little more.

Hello,
Can you tell us which VirtueMart template operation you are using? Edit your template and on Details tab check the Operation field, is it set to Order or Order item?

Operation -> Order

Hello,
Ok, The field order_salesprice has been added as a template field by CSVI when you installed Example VirtueMart templates but since your available fields are not updated because of the error, the field order_salesprice is not visible in the drop down list of available fields. The issue with available fields update should be solved so you see all the fields for import and export.

Hello,
Just noticed that you have Admin tools installed on your site. It is possible that Admin tools is blocking CSVI. Can you disable the extension and check if your available fields update works?

We use the free version of Admin Tools.
I removed the extension, and still the problem persisted... but now perhaps the problem shows up after a few more AJAX calls.

I noticed that your extension makes consecutive ajax calls in this manner:

/administrator/index.php?option=com_csvi&task=maintenance.runoperation&operation=updateavailablefields&component=com_csvi&format=json&run_id=90&key=1&454e2c0f2f74bf52b6cj60aebc32881b=1&_=1559285530200

I copied/pasted the URL to a new browser tab, and gradually increased the last numeric parameter and refreshed. In that manner, I was able to update the virtuemart fields!

This is sort of a hack, but at least I got the job done for now.

Perhaps you could consider the following:

1) Add a small timeout interval between each AJAX call, to potentially avoid any server protection kicking in (if that was the problem)
2) Add a per-component Fields update function, so I could just choose to update com_virtuemart

Thanks

Hello,

I copied/pasted the URL to a new browser tab, and gradually increased the last numeric parameter and refreshed. In that manner, I was able to update the virtuemart fields!

Atleast you found a way to update your available fields. You can also try the cron for maintenance task and see if that works.

Perhaps you could consider the following:

1) Add a small timeout interval between each AJAX call, to potentially avoid any server protection kicking in (if that was the problem)
2) Add a per-component Fields update function, so I could just choose to update com_virtuemart

You are the first user with an issue with available fields. If we see more users coming with same issue we will consider to implement your suggestions.