Excel Orders Export
Díky tomuto modulu můžete snadno exportovat všechny objednávky do excelu!
Můžete si sami zvolit, jaká data chcete exportovat a to včetně překladu pro název sloupce.
Exportovaný soubor je ukládán do "/download/NAME-AND-DATE-OF-EXCEL.xls"
Instalace je velmi jednoduchá, stačí zkopírovat soubory ze složky "UPLOAD" do rootu Vašeho eshopu..
- Vlastní výběr položek exportu
- Export podle data
- Přeloženy názvy sloupců
- Snadná instalace
132 Comments
Leave a comment
Price$29,99
Purchase
View Demo
Extension details
Extension details
| Kompatibilní s | 3.0.0.0, 3.0.1.1, 3.0.1.2, 3.0.2.0, 3.1.0.0_b, 3.0.3.0, 3.0.3.1, 1.5.4, 1.5.4.1, 1.5.5.1, 1.5.6, 1.5.6.1, 1.5.6.2, 1.5.6.3, 1.5.6.4, 2.0.0.0, 2.0.1.0, 2.0.1.1, 2.0.2.0, 2.0.3.1, 2.1.0.1, 2.1.0.2, 2.2.0.0, 2.3.0.0, 2.3.0.1, 2.3.0.2 |
| Multi-store | Ano |
| Návod na instalaci | Ano |
| Podpora zdarma | Ano |
| Přepsání souborů | Ne |
| Typ modulu | vQmod |
Hi DEAWid, I tried DEMO for 3.x and when I click the order date icon, that date doesn't appear and I have to type it manually. Does this module work if I use theme of Journal 2?, I am very interested to buy this module. thanks
This is admin export, so must works with all frontend themes.
Thanks
Hi, export "custom field" is possible?
No, sorry.
Can I store common options? Frequently used export options.
Yes - you can define what items you want export - you can edit this in tpl file.
Hi DEAWid
Thanks for your great support and very quickly!
Will surely buy other extensions from you
Hello
I would like to include ean product code to the excel, is that possible?
By other hand, I see in your excel, when an order has more than one product, only the first row (product) has order id, the rest are empty, I need order id showed in every product. Is that possible?
Regards
I already reply you on forum.
superrrrrrrrrrrrrrrrrrrrrr support thank you
hi, looked at the demo and notice there is no SKU offered is it in the purchased version
Yes, there is SKU in purchased version.
Hello Author,
Thanks for great Plugin, I need shipping cost column also in excel sheet. Please help..
If you need some special what isn't in module, then I can't help you in free support.
If you want payed support, then create ticket on https://www.opencart-support.com
Thanks
Hi,
I had a compatibility problem with my website and the extension. The developer was very helpful and solved it quickly and efficiently. Thank you. I have also found the extension to be very useful and easy to use.
Hello
I'm working with opencart 2..0X
With the option Each product to separate row selected does not throw me the data of
-Product ID
-Product name
-Product price
Hi, if you have problems, please use my free support on https://www.deawid.com/support
Thanks
Hello there,
I ordered a plugin for the open cart to download excel order sheet, however, it is not working, I have left an email as well but no reply, need help
Did you create ticket on https://www.deawid.com/support .............?
hello,
is it ocmod or vqmod? OC ver 3.0.2.0
is it possible to export to xml?
is it possible to set in the cron job url from which order id and after I want to export?
3.0.2.0 = vqmod
Cron filters:
'filter' => array(
'order_store' => '-', //store_id .. for all leave "-"
'order_status' => '-', //order_status_id .. for all leave "-"
'order_date_start' => date("Y-m-d"), //date from - YYYY-mm-dd like "2017-12-24" .. for actual day leave date("Y-m-d")
'order_date_stop' => date("Y-m-d"), //date to - YYYY-mm-dd like "2017-12-26" .. for actual day leave date("Y-m-d")
'separated_products' => true, //each product to new line .. true/false
'price_code' => true //currency code .. true/false
Hi, I am on OpenCart version 2.3.0.2 and I just purchased and installed version 2.x. I see the Excel Orders Export tab in the admin, but when I try to go there I am receiving a Permission Denied error.
I also saw this on the on the vqmods/logs folder, incase it helps solve the issue:
==========================================================================
MOD DETAILS:
modFile : /home/awinc/public_html/vqmod/xml/vqmod_excel_export_orders.xml
id : Profi Excel Export [ORDERS]
version : 1.5.x
vqmver : 2.x
author : DEAWid [www.deawid.com]
VQModObject::parseMods - Could not resolve path for [admin/controller/common/menu.php] (SKIPPED)
VQModObject::parseMods - Could not resolve path for [admin/view/template/common/menu.tpl] (SKIPPED)
===========================================================================
Thank you in advance for your help
Hi, please if you have any problems, use support, not comment.
Support is here: https://www.deawid.com/support
Thanks
Hi, I am on OpenCart version 2.3.0.2 and I just purchased and installed version 2.x. I see the Excel Orders Export tab in the admin, but when I try to go there I am receiving a Permission Denied error.
I also saw this on the on the vqmods/logs folder, incase it helps solve the issue:
==========================================================================
MOD DETAILS:
modFile : /home/awinc/public_html/vqmod/xml/vqmod_excel_export_orders.xml
id : Profi Excel Export [ORDERS]
version : 1.5.x
vqmver : 2.x
author : DEAWid [www.deawid.com]
VQModObject::parseMods - Could not resolve path for [admin/controller/common/menu.php] (SKIPPED)
VQModObject::parseMods - Could not resolve path for [admin/view/template/common/menu.tpl] (SKIPPED)
===========================================================================
Thank you in advance for your help
Hi, please if you have any problems, use support, not comment.
Support is here: https://www.deawid.com/support
Thanks
Excellent product and excellent support. Recommended.
Published version for OpenCart 3.0.2.0
Enjoy.
Excellent supporting. Extension is now working in Opencart 2.0.1.0. Thank you.
Excellent Module and Excellent Support.
Thanks Deawid.
Hi.
Copied all files over to the correct FTP locations. Can not seem to see anything else. No readme file included either.
Please advise
If you have any problems, please use my free support https://www.deawid.com/support
Thanks !
Warning: require(/data/home/bxu2341410126/htdocs/admin/language//tool/excel_export_orders.php): failed to open stream: No such file or directory in /data/home/bxu2341410126/htdocs/admin/model/tool/excel_export_orders.php on line 105
there is an error.
https://www.deawid.com/support
Not here..
Will this work OK with Opencart 1.5.5.1 and PHP 7 ?
Yes :) All my extensions are compatible with opencart version fro 1.5.0 > latest
I cannot export. After a long period I'm redirected to a page on the front end that says "Page Not Found."
Please if you have any problems, do not write it into comments, but create ticket on http://www.deawid.com/support
THANKS-
Previous comments don't lie - support was lightning fast. I ran into a couple issues while installing, but these were immediately dealt with by support and now the extension is running great. Just what I needed!
Where is the documentation? How to install this module on vers. 2.0.3.1?
Hi, sorry for late.
Simply copy all to correct folders on ftp .. admin to admin, vqmod to vqmod..
You must have installed vqmod system too..
That's all.
I had an issue after moving to a new server. DEAWid helped me promptly and got me back to exporting orders. Excellent service from a great developer. Thanks.
Do you support exporting any plugin / add on data for the orders?
Do you offer any customization of the plugin? - Thanks
Hi ab3Fr0man,
what you mean exporting any plugin?
Customizations are possible, but not in free support.
Thanks
Excellent support thank you so much DEAWID!
Hi JonWin, if you already purchase my module, simply login on opencart.com and download latest version of my module.
Hi! i purchase the extension in april 2015. It works perfect, but i cant get any information in customer group. Is this a known problem? How do i get the last update of the extension, do i have to buy it again?
Hi, could you add an export order weight in KG option please? Of course willing to pay extra for this modification. I've tried contacting you via your website but no reply.
@maiz: you can edit position. change code in vqmod xml file.
Manage to install this. Easy!
But can I change the location in side menu?
Right now is Extensions > Excel order export
I wan it to be at Sales > Excel order export
Reason because I want to hide all extension from user group..
How to install this module? I am noob..
@Alteide.com: Hi, please create ticket on http://www.deawid.com/support and I help you.
Thanks
hi, I installed your extension and it doesn't appear in the admin-end.I checked the user permits.
I have the 2.2.0.0. version.
Thanks
Hi guys ... Finally updated to latest opencart version 2.3.0.2
Enjoy! =)
@outstrap: Hi, I reply to your e-mail.
hello pro i need support i have module powertrack this for praint shipping number
i want add this shipping number to Exil sheet can u help me
@hudaha: find in .htaccess file this:
RewriteRule ^system/download/(.*) index.php?route=error/not_found [L]
replace with this:
#RewriteRule ^system/download/(.*) index.php?route=error/not_found [L]
Hi there,
When I click on download excel it redirect me to download/XLS-BACKUP-ORDERS-07-06-2016_16-13.xls
how can I fix this issue??
Hi, could you add an export order weight in KG option please? Of course willing to pay extra for this modification. I've tried contacting you via your website but no reply.
@sirena: Look to your email.
Hi,
i have a problem with the module, when i press the button to export the table, the module redirect me to page /download/XLS-BACKUP-ORDERS-16-05-2016_11-39.xls
Have a nice day and thank you for the module and the help.
@jferezy: in model file you must define that twice .. in get_data and add value to that array :)
Hi there - I am trying to add in the the column "company_id" to the excel file. I am able to get it into all main visual but it is not adding the data to the column in excel. Any idea what I am missing? Any help would be greatly appreciated...
Jason
Extension so good for making picking list and with other features, in additon that if you add one more column 'Product Location' to excel, extension can be used also selling goods for inventory management.
@fadyfikry:
you need enable access to download folder in .htaccess file :)
Thanks so much for this Bust after Installation I can not dwonload the file, I have to download it from FTP only so please help me ASAP this my link you when press dwonloade : http://okaziony.com/system/download/XLS-BACKUP-ORDERS.xls
Thanks in advance
Fady
5 star review granted. Excellent product for anybody who needs to export orders to xls. Simple to use and prompt, knowledgeable service.
@JeremyColvin: WOW! The comments were right about this guy... TOP NOTCH support, almost immediate response. I'm VERY impressed and will now look for other extensions of his that might benefit me because of it!
For those that run into this problem, the solution was simple, it was an error on my part, I forgot to go to "user group" permissions under settings and to set all the permissions for the administrator group (select all). Set the permissions correctly, and of course it worked.
As far as customer service though? This guy is amazing. LIGHTNING FAST responses. VERY impressed! BUY with confidence!
I am really excited to use this module because of the incredible comments in the feedback here..
Unfortunately, I too am getting a "You do not have permission to access this page, please refer to your system administrator." message when I try to access it.
I of course am the top administrator, and have never run into this before when installing/using modules.
Any help would be greatly appreciated!
Thanks!
I asked for support for my dutch language. I got great help within a few hours.
I can recommand this tool. works perfect!!
Frank
Thanks Deawid. Great support and great extension. 5 stars. Looking forward to buying your other extensions.
This easy to use module does exactly what we wanted. Support was really quick and took care of everything, even a modification to exclude missing orders. We're all set now, thanks to the export to excel module. And thanks for the super support!
Very helpful, good module. but has not filter order status and store filter. If you can add will be perfect.
I am willing to pay extra for the filter. Please quick reply...
The Export to Excel extension was just what we needed to export our orders into a spreadsheet for our fulfillment department. Support for a minor item was handled quickly and efficiently. Thanks for a really nice extension and your wonderful support.
Absolutely LOVE this! Exactly what I need to pull order for getting ready to print in pre-order environment! YAY! I have one question tho - would it be possible for a modification that puts each product option in its own column on the spreadsheet. So - option color in a column, option size in a column? email me at Beth@streetgraphex.com if needed.
THANK YOU!!!!
BethS
Does it support OC 2.x custom_fields?
Very useful export tool. I am using it for bulk shipping details for fedex, ems, local post etc
I wanted to customise it myself & DEAWid was willing to point me in the right direction so I could dive into the php myself. Thanks!
@PaulR: Thanks, Fixed :)
"Address" is mis-spelled in the XLS file & on the Admin export page.
eg: Shipping adress 1, IP adress, etc
Can export to download/ directory be set as cron job?
WOW WOW
I have support and a fix within 5 mins of downloading and asking a question - that is superb customer service, I have never had a faster response of no one, you really are a credit to opencart and the developer team. Well done , I will be back for more of modules as this service is unbeatable.
PS - what a great module, I have been looking for over a year for this, and here it is and then backed up with service like you have offered is world class.
Thank you Alexis x
Hello
Downloaded the module all ok, however it is saying I do not have permission to open the file, I am the site owner and set at top administrator , can you please email me and I can pass you my log in to take a look for me is that possible please ?
Thank you
Alex
sales@1-stopshopper.co.uk
Excellent module! Downloaded it a few months ago and everything has been working as described.
Extension is great!
Support is great !
Very fast support from DEAWid. Thank you.
Congratulations !!!
Hugs,
Jamerson
Hi, I bought this module, the module is installed, when we send to export, the file was created in the directory "download" but it isn't downloaded to computer.
Can you help me ?
Jamerson
Hi :) Export Orders (testing OC 1.5.6) module is working fast as the same fast is super support. Thank you. Really! If you want to go seriously with your system then you will buy this module.
Great module! Exactly what I needed. Very fast support from DEAWid. Thank you
Nice extension. I needed support and they helped immediately. WORKS PERFECTLY!!!
Thanks Deawid for this Nice module. this is what we are looking for.
and also a great appreciation because have do some customization for us.
in a reasonable prices and very quick response.
5 Stars for you :)
looking forward to buy your others extension.
Excellent Module.Excellent Support.Highly recommend for all shopping cart.
CHEERS ! ! ! ! !
Hi Deawid,
It was nice mod, can you add more one field for delivery date & time for me? please advise.
Justin
Great module and even better support, this module works perfect, i had no issues at all.
Thanks
DEAWid
Great extension to export all your order information to Excel for custom order forms. This, along with the Orders to XML extension will be able to help you tackle any custom workflows.
Support is also quick and excellent.
i needed my exported excel columns sorted differently. I contacted DEAWid and got an immediate response. now my client has the report the way they want it..
thanks . . great extension. . .
@DEAWid: Thank you for your help and support. This module now working perfectly. Really is a great module and 5* after sales and customer support. Highly recommended.
@bixamedia: Please use http://deawid.com/support
Thanks !
Hi DEAWid,
It's not clear to me where the directions for installation are located. Can you assist?
Thanks!
@mantis: Please use http://deawid.com/support
Thanks !
Hi,
I downloaded your plugin, however when I go to download orders it just hangs for a long time and then goes to a blank page?
Am I doing something wrong?
Please help
Great support! Recommend!
@lydia: Works great for me .. what exactly doesn't works please?
Thanks !
Hi this site:http://deawid.com/opencart/profi-excel-export-orders/admin is not work , I want to see the admin. Can you fix it up?
Great extension and great support!!! I gave you 5 stars. Regards
Excellent Extension. Worked straight out of the box and has saved me a lot of time doing sales reports manually. Thanks!
@epicsurfracks:
You must everytime check that .. you have there some "templates" so you can check for example to "Main data" and all main data checkboxes will be checked ..
But you can do a small change in tpl and you can have checked your own items onload..
So if you set for example "order_id" and "name" and you open export page, it will be automatically checked..
Anyway, I can help you do this changes, no problem... But please use (to next communication):
http://deawid.com/support
Thank You !
DEAWid I really like your module!
However, before purchasing we would like to know if the 'check boxes' under the area 'Export' get saved, or are cached after downloading? i.e. Every time we come back to the page to export data do we have to 're-check' each box we want or will it automatically re-populate?
Regards,
PC
Great export, combined the info from this to manage all my ebay, amazon and opencart orders (in a separate db). Saved me a heap of time.Very quick support as well when had an issue.
admin/view/template/tool/exce_export_orders.tpl
lines: 299-513
You will understand it ;)
Thanks
Sorry, can you tell me where can I find the file I must change? Regards
Thanks for your quick answer, we really appreciate this kind of support. Extension already buyed!!!
Regards
@dracoteam:
Hello, thanks for Your interest.
Sure you can set own selection.. It's in javascript for example:
customer_group = true;
order_id = false;
etc... :) I't easy.
Thank you
Hello
I see in the demo I can export only "All important data" my question is: may I modify that important data? I mean, I need to choose once the data I want to export, then I will be able to export every time just what I need choosing only "All important data".
Thanks
@sjrh43: Please use http://deawid.com/support . Thanks
Hi I have a similar problem as someone previously, I have added all the files and the tool appears in the permissions section but not under system.
Can you please help.
Very good seller helped me instantly with installing this wonderfull excel import extention!
Five stars! DEAWid really knows his stuff and is super kind with support. Highly recommend this plugin and the developer!
Thank you for a great extension. Just what I needed to create a file format workable for our despatch/ fulfilment. Really excellent responsive support when asked for, many thanks.
Works great. :D
Can you add a field with the cupom?
Thanks.
Thank you for a very useful module that was a must to me to get my accountant happy. Fast support to solve problems as well.
Awesome software. Exactly what we needed for a long time. Easy to understand and easy to use. And it's very flexible too! DEAWid is behind his product 100%! When we had an issue, he went ahead and fix it promptly! I couldn't be happier! Would recommend it to anyone. Thanks a lot!
Hi, you must set user permissions for your user group .. In Admin->System->Users->User Groups and there you must check " tool/excel_export_orders"
Thanks
@DEAWid:
I already purchase this extension but when i access to system/export, it show the permission error, could you please help me to fix that ?
Thanks.
Awesome module.Good support,5 min and module on my website.
Ahoj, pěkný modul, ale chybí mi možnost výběru exportu přímo do csv a je škoda, že se nedají vybírat konkrétní objednávky např. v přehledu objednávek a tlačítkem vyexportovat.
Hi,
Its a nice module and working smoothly now.
Thanks,
DEAWid
Hi, The SKU field is not populating for ebay and Amazon orders from the recent addition to Opencart of OpenBay. Is this something you can add?
Thanks
Matt
Hello,
Nice module.
But I can't see the Export date field.
Can you help?
Thanks
This module solves export in the most elegant way possible. Having just purchased it and used it I can attest that it works quite well and for the money, its a generous deal. Thanks @DEAWid This is exactly what we were looking for.
Cheers,
Peter
The extension is exactly what I needed, DEAWid is very reagent !
Very happy to find this page :D
@nodymedia:
Hello, thanks for buy, please, contact me on skype: deawid000, I will help you ASAP.
Hello DEAWid, I've got a problem with your extension, the “Excel order export” doesn't appear on the backoffice (menu › system)...
Could you help me ?
Is there a language problem ?
I duplicate the english folder and rename it to french but it's doesn't work...
Thank you per advance !
Best regards.
Is it possible to save a profile and then add that as a button to the orders list ?
is it possible to define what order the columns are in ?
I want to export order details one by one as I pack orders and send the CSV file to my carrier.
If yo added such a button, could you make it FTP the file to my carrier's FTP site when I press the order screen button ?