Thanks for keeping this up-to-date. I'm looking forward to messing with it.
Naive question: is this essentially a much more robust version of Orders Exporter?
THANKS AGAIN!
Thanks for keeping this up-to-date. I'm looking forward to messing with it.
Naive question: is this essentially a much more robust version of Orders Exporter?
THANKS AGAIN!
There is actually a 1.3.1 version now out (at the same link posted previously) which addresses a few bugs the 1.3.0 version had. Will post that officially to the Zen Downloads section after I see how it fairs with those using it.
I don't know how the Orders Exporter works to be honest (never used it) so I don't know if it is a more robust version. I saw that the orders exporter is based off of Easy Populate so that may be a little different (mine was basically written years ago from scratch for the most part.)
Eric
20 Ways to Increase Sales Using Zen Cart
Zen Cart contribs: Simple Google Analytics, Export Shipping Information
Once this mod is up and running, could the csv file be automatically generated using a cron job?
Thanks!
Danielle
what are the chances there is an update for the 1.3.9h version??? I could really use a mod like this.
Thanks
With a number of adjustments (and a new file ready for cron) yes. I have built this custom type of job for a number of users. If interested, send me a private message and we can go over details etc...
I've customized it for number of people where it not only runs the cron job, but emails (or even FTP's) the completed file to the supplier for fulfillment.
Eric
20 Ways to Increase Sales Using Zen Cart
Zen Cart contribs: Simple Google Analytics, Export Shipping Information
Eric
20 Ways to Increase Sales Using Zen Cart
Zen Cart contribs: Simple Google Analytics, Export Shipping Information
How hard would it be to split my attributes into separate columns? I am using flexible attributes and I am running up to 13 attributes for some products.
This looks like a great tool and I will use it to import to my sage peachtree accounting package.
I have installed it and did my 1st 'test mode' export and had the check box for ISO Country Code (2 Character) checked and received this error.
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND cc.countries_name = o.delivery_country WHERE o.orders_id = ot.orders_id AND' at line 1
in:
[SELECT o.orders_id, customers_email_address, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, shipping_method, customers_telephone, order_total, op.products_model, products_name, op.products_price, final_price, op.products_quantity, date_purchased, ot.value, orders_products_id, order_tax, o.orders_status, o.payment_method, cc.countries_iso_code_2 FROM (zen_orders o LEFT JOIN zen_orders_products op ON o.orders_id = op.orders_id), zen_orders_total ot, zen_countries cc AND cc.countries_name = o.delivery_country WHERE o.orders_id = ot.orders_id AND ot.class = 'ot_shipping' AND downloaded_ship='no' ORDER BY orders_id ASC]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
Unchecking the ISO Country Code (2 Character) option
runs fine.
BowEquipped.com
ver 1.3.9.f
Any ideas what i did wrong?
Just installed the latest version in 1.5 store but I get nothing in my tools menu. Tried in different browsers too. I do have the "orders export" add-on installed, could that mess things up? All files uploaded and confirmed and ran the sql with no problem, any ideas?
Bookmarks