We have two drop-shippers in our Volusion store, one that uses the PO Email without issue, and another that cannot.
For the drop-shipper that can't use emails, we need somebody familiar with Volusion's API or SQL or both to create a solution. We need an XML file with products broken down by row, the qty, the order #, shipping address, shipping method, etc to send to the drop-shipper.
Also, we need a plan and method to import tracking numbers from both our drop-shippers.
Layout of needs:
Our fulfillment vendor accepts XML formats to an ftp, and provides .csv with tracking numbers via ftp as well.
Is it possible to create the hosted script utility you mentioned to create and send the proper XML file to ftp while marking those orders with a different status like "Shipping"?
And could it also import the .csv with tracking numbers, updating each order's status and marking as "Shipped"?
Lastly, can this utility be setup to either send orders or receive tracking numbers with the click of a button as well as scheduling it using a cron?