Categories
View Replies (2)

Resolved Virtuemart 3.4.2 - XML Orders export - advanced cron job

  1. dml311071
    dml311071
  2. RO CSVI
  3. Tuesday, 04 December 2018
  4.  Subscribe via email
Joomla 3.9.1
Virtuemart 3.4.2
CSVI Pro 7.10.0

Hi, I am looking to synchronise stock using a server cron job; one for import from our EPOS system and one or export from VM via CSVI XML file.

The xml file used to update the stock from the EPOS has been tested and does work. However I have stumbled across an issue with the CSVI export XML process.

I have a template created using the tutorials here and this exports details from web orders in XML to the EPOS system. As an overview is there a way of just sending each XML generated by an order once only?

The logic here is to export the SKU and quantity ordered of each product so that the EPOS system then deducts the matching SKU by that amount. The way I have constructed the process all orders in the order list are processed each time. Effectively repeating the process and hitting stock levels multiple times.

I still will have the 'fun' of implementing this as a cron job on the server but if there is a solution to this specific problem then at least I can move on to that stage.

Sales XML is an example of the field that CSVI needs to export on a per order basis from the Virtuemart. This part of the process is where I am having trouble.
Products XML is an example of the stock update from the EPOS system. This would be generated by the EPOS when a product is created, updated or sold via the retail store

I have also attached examples of my templates. I do realise that there is a need to rename one or two of the template fields, but my main concern was the ability export each web sale order once only to ensure that stock is kept synchronised properly.

The EPOS system does have an exe file that handles these files and I have asked them to support their side of things whilst I find out how to sort this issue. I suspect that the timedate stamp will be relevant here.

PLEASE NOTE the filenames are generated by the existing system. I probably need to find a way of duplicating these however I have successfuly update stock using the CSVI import template.
0
Responses (2)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Starting from CSVI 7.10.0, we have added a new option in VirtueMart order export template to store the last used order id and so when the export runs again orders starting from last used order id will be included. So If first time export gets 5 orders, the last used order id will be saved with id value 5 and when the export runs again, orders starting from id 6 will be exported. This should help you to export orders only once. You can set Last used Order ID in your export template on Options tab under Date range filter. Let me know if this helps to solve your issue.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
dml311071
dml311071
Accepted Answer Pending Moderation
Hi Tharuna,

Quite incredible really given that this update appeared today (and even saw the extension become available while I was typing the request!)

This certainly should help make some headway into the issue.

Thanks for now
  1. more than a month ago
  2. RO CSVI
  3. # 2
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!