Resolved export virtuemart orders : 1 order per file

Hello Olivier,

I need to have 1 order=1 file when I export the virtuemart orders, how can this be done ?

You can export your 1 order from VirtueMart by setting up the order id in your order export template settings and on options tab.

I read on the forum that with Hikashop we can export as soon as an order is created, is there an equivalent for Virtuemart ?

The HikaShop plugin in CSVI will export the order as soon as customer places his order on front end, we don't have this in VirtueMart but you can export your order by setting the order ids in your export template as explained above.

Hello Olivier,

As Tharuna said, VirtueMart has no support for this except you hack VirtueMart to trigger CSVI upon order completion. The other way would be to have a cron job run every minute for example which triggers a CSVI order export template and you set to only export records since the last time it ran. Assuming you don't get multiple orders within the minute, this works pretty OK.

Thanks for your answers guys,

As there are between 50 and 100 orders per day I can't export each one manually, it has to be triggered automatically so I will go for CRON jobs.

If there's no new order between 2 cron job runs, will CSVI create an empty file (I'm not allowed to place empty files on my customer's FTP server) or do nothing ?

Hello,

If there's no new order between 2 cron job runs, will CSVI create an empty file (I'm not allowed to place empty files on my customer's FTP server) or do nothing ?

Yes, when there are no orders from the last ran time, CSVI will create an export file with no records found message. You can think of a way to delete these empty files or go for the option of having VirtueMart plugin which can be triggered when an order is placed.

Hello,

In addition to what Tharuna wrote. You could parse the cron output of CSVI. This will tell you how many records were processed. If that number is 0, you could just delete the file and not do the FTP upload.

In the meantime, I will check if we can add some kind of logic not to do post-processing on empty results. That way CSVI won't upload the file if there are no processed records.

In the meantime, I will check if we can add some kind of logic not to do post-processing on empty results. That way CSVI won't upload the file if there are no processed records.

Thanks Roland, that would be great !

Hi,
are there some news on this topic?

I need also 1 order per file.

Thank you.

Hello,

There is no news on this topic because there is no trigger in VM that I am aware of that allows you to export the just created order. CSVI only exports the orders in the range you set in the template. If you want to export 1 order per file, you would have to run the export with a given order ID.