Excel Products Export
Snadná export produktů do excelu.
Můžete zakliknout vlastní data, která chcete exportovat.
Export podporuje také možnost výběru překladu pro název a popis produktu, včetně výběru měny.
Soubor s exportem se ukládá do "download/NAZEV.xls"
- Snadná instalace - VQMod
- Vlastní data pro export
- Volba překladu a měny pro export
75 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, 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 |
| Návod na instalaci | Ano |
| Multi-store | Ano |
| Přepsání souborů | Ne |
| Typ modulu | vQmod |
| Podpora zdarma | Ano |
I need the URL item in the options for each product. Is it possible to upgrade the module? OC version 1.5.6.4
Vqmod in 2+? Why? :(
Because vqmod is better to edit.
@clickbizz: Hi, please simply create ticket on http://www.deawid.com/support
Thanks
Hello.
I have installed the extension and the menu item is not visible. When I go to index.php?route=tool/excel_export I can select options but after clicking at the submit the page is blank.
Please send your e-mail address for admin and ftp.
Thank you,
Manolito
Dude is a genius. Great software. Great coding.
This guy is amazing. He jumped on every single little problem I had (all my own, nothing wrong with his code), and helped me the entire way, until it was working juuuuuust right. Fantastic support. Highly recommend this plugin! Thanks again!
I have the logged in user to Top Administrator... but I'm still getting the error "Permission Denied!" "You do not have permission to access this page, please refer to your system administrator." Help! Thanks. :)
Great fast support.
Thank you
5 stars.
Fast support, as a newbee with little coding comfort DEAWid made this easy. Thanks!
I forgot to give you my Email address,
jason@beadusainc.com
Hi, there,
I just bought your product last week, after I installed to the OC 2.0.1.0 and 2.0.1.1.
I try to save the export, it go to a blank page without any error message,
I try to reduce the export data only "category", it still show a blank page only.
can you help!
@yasniel:
Hi Yasniel.
You must set user permission in admin - system - users - user groups
Thanks
You do not have permission to access this page, please refer to your system administrator. I have this problems in opencast 1.5.6.4 please help me
Thanks for the fast and outstanding support for an issue I had.
5 Stars!! Great Mod and Great Support!! Thank you!!
Hello,
There is a permission denied with your demo.
Admin/System/Excel product export
Cheers,
Hertz
Bought this extension using 1.5.6, only issue i had was Excel "Save as" window wasn't popping out.. after opening a support ticket they fixed. Great extension 5 stars... Very useful!! Thanks DEAwid
I wish to know if this extension will fit my needs and DEAWid reply installing the extension in my testing server to test and buy if I like.
This extension works smoothly in the way he told me, so I wish to recommend him work, as a very well done work and remark his helping attitude.
Thank you.
aha .. ok .. use http://deawid.com/support .. thanks
@csb89: copy english language to russian...
The error above I have fixed by copying the excel_export.php file to the russian language folder in admin.
However, there is a problem and I can not download. Would you be able to have a look at this?
I have this error (exact web address removed for privacy)
Fatal error: require() [function.require]: Failed opening required '************/admin/language/russian/tool/excel_export.php' (include_path='.:') in ************/admin/model/tool/excel_export.php on line 266
Please can you give me your support email?
@csb89: Sorry, that's not possible right now. Thanks
Is it possible to make this extension with an option to insert the image itself into the excel file as well as just the URL to the image?
@antmpro: everything are fine ... thanks :)
Fast response and Great Extension from DEAWid. He provided "FREE Installation for testing before purchase". He do some modification for extra option which fulfilled my requirement. Thanks for your works!
Regards
Eric
www.printerbullet.com
Hi,
I very interested on your module. Before purchase, i need to verify few question.
1) Does it will get memory limitation when export product? ( I have around 2000 products)
2) For my necessary, i do need export "product link" as well into excel. Is it possible to make it?
Regards
Eric
www.printerbullet.com
Awesome support - literally took 5 minutes to solve my issue above. For anyone else having the same problem it may be an issue with the htaccess file - you need to comment out a line as follows:
from:
RewriteRule ^download/(.*) /index.php?route=error/not_found [L]
to:
#RewriteRule ^download/(.*) /index.php?route=error/not_found [L]
5 stars :)
How was the above issue fixed? I was getting 403, now 404 errors when it attempts to open the exported XLS file. I tried CHModding the hell out of the Download folder but nothing worked...
Had a "page not found" error initially when trying to download a spreadsheet, but support by the developer quickly sorted out the issue (a small change to the htaccess file). Thanks!
Also could I export tax and shipping prices too? Seem only product price and final price.
thanks
I get the following error multiple times please help. Version is 1.5.4
Notice: Undefined index: symbol_left in /var/www/html/store/admin/model/tool/excel_export_orders.php on line 82
Notice: Undefined index: symbol_right in /var/www/html/store/admin/model/tool/excel_export_orders.php on line 87
thanks
I love your products, you can add import same, now only export
@outdoort:
Hi, thanks for comment ... but there is "Image" checkbox for export. If you want add full link to that image, I can edit it for you. Just leave message.
Thanks
Is there a way to add the image url?
This guy is a ****ing boss. He solve my problem in minutes.
500 Stars!!
PD: a pity that have no more extensions, i may buy some more
We were getting some errors at first but DEAWid has fixed them. Now it all works well. Thanks!
Great Support!
Had an issue with SEO friendly URLs. Quick support and easy fix.
@DEAWid: This is export NOT import
i ask if option to Import back the file i export before
Thank you
In admin>system>excel product export
How to import the Excel File????
Hi:
I recently purchased your extension and it's working fine but it would be extremely useful, at least for me, to include a "price including tax" field.
Could it be possible or could you tell me how to do it by myself?
thank you
Thanks DEAWid for you very quick help with the small problem with exporting Dutch product names!
Hi, I must reinstall demo.
try now admin/admin and system->excel product export ... (latest link)
And I don't understand your previous comment. If you want import back from Excel to OC this module doesn't support back import. Only Export..
Just try demo now and contact me to my mail: DEAWid@seznam.cz
Thanks
I did not see any IMPORT XLS link on the demo website
Hello,
I am doing a Bookstore using version 1.5.5.1, I checked out the sample XLS file and have a question.
I want to add products data to an EXCEL file and import them as there are large number of books (products) i want to add to the website
I am using a extension for showing extra attributes of the Book on the product page. for that I had to add a few new Attributes to the table oc_product like "Author", "Book Name" etc.
I want to ask that will your extension also work for those additional attributes in the oc_product table?
thanks,
Prb
Thank you DEAWid! It Works great!
@cpuricelli:
Hi, so I edit my module to your request ... token bux fixed, and I insert: EAN, JAN, ISBN, MPN to export.
Try yourself, and contact me if is all okey..
Thanks
Ok, I will fix it and add that MPN .. ok
I will contact you
another issue: when I go to mywebsite.com/admin I get this error:
Notice: Undefined index: token in ....com/httpdocs/vqmod/vqcache/vq2-admin_controller_common_header.php on line 9
and the row 9 is:
$this->data['excel_export'] = $this->url->link('tool/excel_export', 'token=' . $this->session->data['token'], 'SSL');
Once I log in the message disappears.. It is probably due to the session which isnt already created?
@DEAWid:
no, not the manufacturer ID, but the MPN code (Manufacturer Part Number). You can find it in the Data tab of the product. It is stored in product table, field name: mpn
@cpuricelli:
Hello.. you mean manufacturer ID ?
Hello, I noticed that in the excel export is not possible to export the MPN (Manufacturer Part Number)... why is this field missing? Do you think is possible to add it?
thanks
Admin/System/Excel product export
Hi
How do i import the Excel File????
This extensions is really good. For a first time I got an error but the developer help until the error fixed. Awesome.
The extension works great!
I have OpenStock extension installed which allows me to track quantity by combinations of options (for example, size). When I export the store data though, the "Quantity" for each option does not export. Is there a modification that can be made to accommodate this other extension?
@colinw: Hello colinw ... I publish this module for 1.5.4 right now ...
is this v1.5.4 compatible?
@choco: Thanks for your help to sort out the installation, now works great.
Published for version 1.5.6. Enjoy
HI
I have 1.5.5.1 and put the suppplied vqmod into the public html file on the server and set required permissions.
The extension is not showing in the system drop down within admin.
Suggestions please.
Hi,
This looks like the extension I have been searching for.
I have all the data in xls/xlsx format. I have manually added a few products to the opencart. Now the price has to be changed in all the products and I have to add new products from the xls sheets.
Can your module add new products to existing categories/manufacturers. All the data is present in the xls sheets.
@evgen.koshevoy:
Hello, thanks for buy my module..
The easiest way for product link is this:
http://www.yourshop.xxx/index.php?route=product/product&product_id=PRODUCT_ID
And the PRODUCT_ID you have in XML..
but if you need add product link, contact me, and I edit that on your shop.
Thanks
Good day. have the opportunity to do that would be exported an external link to the product?
@tafeltennisnu:
Hi, you must set permission
System -> Users -> User group
Hi there,
When i go to export i get the message No Access....... Can you help me please?
Sorry, OC v1.5.5.1.
Hi DEAWid,
Just installed on OC 5.1.1.5. Getting the following error after clicking 'Download Excel' button...
Warning: stream_wrapper_unregister(): Unable to unregister protocol zip:// in /home/coffcra2/public_html/system/phpexcel/Classes/PHPExcel/Shared/ZipStreamWrapper.php on line 69Warning: Cannot modify header information - headers already sent by (output started at /home/coffcra2/public_html/admin/index.php:83) in /home/coffcra2/public_html/vqmod/vqcache/vq2-system_engine_controller.php on line 28Warning: Cannot modify header information - headers already sent by (output started at /home/coffcra2/public_html/admin/index.php:83) in /home/coffcra2/public_html/vqmod/vqcache/vq2-system_engine_controller.php on line 29
Any idea on how to fix this?
Thanks.
@cpuricelli:
Hello, try my demo now, I edit export values from integer to string .. so if you have model like "00005" now export "00005" ..
Thanks
Hello, is it possible to set a field to be formatted as text and not number before the export?
I have an issue with product model: I use numeric values like 01010061, but when I open the excel export, it automatically truncates the leading zero, and it changes the product model to 1010061
Thanks
DEMO: http://deawid.com/opencart/profi-excel-export/admin
Login to admin: admin/admin
@isvaradas: Resolved with reupload :) works great
Hello, I installed the module on my Opencart version 1.5.3.1. I am getting this error:
Parse error: syntax error, unexpected $end, expecting ')' in /home/content/04/9612604/html/system/phpexcel/Classes/PHPExcel/Calculation.php on line 2652
Is there a fix for this, thanks. My email address is "isvara99@gmail.com"