I need the ability to export CSV files of selected data, for example shipping address for address label printing. Ideally I'd like to print shipping address label directly from Opencart but maybe that's asking too much? I'm surprised some carts still dont offer this. What do other users do, write address labels by hand??!!
Also would like order details to be sent automatically to fulfilment company FTP box when a customer orders.
With this contribution, http://www.opencart.com/index.php?route ... on_id=9380
it already does more than that actually.
Once installed, go to admin - > extensions - > modules - > database select monitor . In the text area, paste this command:
Then, go to your FTP / File Manager and under the system/cache folder, you'll see the: data_<<your_token>>.csv file.
From the browser, you'll see your token string on the OpenCart admin so simply search for that token on the FTP list. Then, you'll be able to download the results in CSV.
it already does more than that actually.
Once installed, go to admin - > extensions - > modules - > database select monitor . In the text area, paste this command:
Code: Select all
SELECT `shipping_address_1`
FROM `:db_prefix:order`
WHERE `order_status_id` = ':config_complete_status_id:';
From the browser, you'll see your token string on the OpenCart admin so simply search for that token on the FTP list. Then, you'll be able to download the results in CSV.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Thanks a lot for that straightlight. Sorry about the delay - I tried something different so didn't come back to check for replies. I'll get my site manager to have a look at it. My understanding of the extension you told me about is that it exports order information as CSV. That's great for when I start using a mailing company but in the meantime I'd love to be able to select a number of orders and print the shipping addresses from Opencart, onto some standard Avery size address labels on A4 sheets - maybe 12 up. Is anyone interested in quoting me a price to do an extension for that? The only ones I can find can only print one label at a time.
Who is online
Users browsing this forum: No registered users and 2 guests
