mkp007
Dec '11

I would like to download new orders in excel using visual basic.



Right now I have to log into E-Junkie, click on the download transaction buttons, wait for the transaction log page to load, then click on "past 7 days", then click the "download log" button, wait for the zip file to down load, open it, highlight new orders, copy, and finally paste into excel. This is a pain in the ass and makes it harder for me to hand off the task to employees.



Perhaps this could be best done by new orders being posted to a file on my server. Or, if there was somehow a link that had variables (for account and transaction date range) that downloaded data from your server in xml form or something to that effect.



I hate to think that this will be just a another feature added to a list that never gets looked at. How are other people managing orders? I have an excel program with several macros that allow me to process orders more efficiently (ie send shipping confirmation emails and print packing slips). Anyone?



Thanks.

  • created

    Dec '11

  • last reply

    Dec '11
  • 1

    reply

  • 1.0k

    views

  • 2

    users

  • 1

    link

E-junkie_MonsterSupport Monster
Dec '11

For this purpose I'd recommend using our third party integration feature to have order data sent to your own system as each order is placed. That will allow you to compile that information for your own use outside our system without having to go through your transaction logs to download it:

http://www.e-junkie.com/ej/help.integration.htm



That is often specifically used for people who need to print packing slips and similar information as orders come in, the help page above explains the format we send the data out in and any generic form-handling script should be able to receive it and parse that data however you wish.



Since we already have a way to send order data out I can't promise that we could offer any new feature to get order data downloaded faster but we can still add that to the wishlist for consideration in the future.



One thing that we hope to have improved soon is getting transaction logs to load faster for clients who have large amounts of sales data. We're waiting on a third party software update for that, once that gets done we hope to see some faster load times for everyone.