Export orders to Spreadsheet / Excel to email to suppliers

[econcepts]

Hiya guys,

There is a bulk process update available in Superorders addon.
Although I cannot get the email function to work

Samantha

Hey Samantha,

Thanks for the info. I recalled there being the bulk idea somewhere but couldn't put my finger on exactly where.

[apemusic]

Hi eConcepts,

Thanks for the hard work, just to recap I have been using your export orders mod for a few days and here are my suggestions and minor issues to fix for the next version
- Company field in the delivery address does not export, so I have to go through every order manually to get this
- Actually in the field "Delivery Post Code" it exports the state, and in the next field "Delivery State" it exports the postcode.
This is not that big a deal, actually I prefer that STATE is exported first and POSTCODE after that as that is the way addresses are written and that is the order I must give information to suppliers and couriers. So the way it is exporting is actually the best, you may want to fix the header to reflect the info being exported though.

1) What I would really like is to be able to TICK AND SELECT the particular orders and export those. E.g. because some orders are not paid yet, and some orders come from different suppliers.
2) Currently what I do manually after exporting each order is I have to click on it and change it usually from “Processing” or “Pending” I change the status to “Update”. I then have a standard message which I tick a box using Marg’s insert comment code, that automatically does a message:

“Hi [Customer’s First Name],

Thanks for your order, will ship ASAP and get back with a tracking number

Best Regards”

If I could export the orders and change the status and send this customized message out AUTOMATICALLY in BULK that would be awesome. That way I can process 20 orders at once rather than 1 at a time!

Does anyone know currently how I can just do the 2nd bit and bulk status update say 20 orders which I select to status: UPDATE and send out that custom message? Even if I could get the above done in 2 steps that would really help?

[econcepts]

Does anyone know currently how I can just do the 2nd bit and bulk status update say 20 orders which I select to status: UPDATE and send out that custom message? Even if I could get the above done in 2 steps that would really help?

Good comments Dave and thanks for the feedback. Will put these on the list for the next release.

As far as how to bulk update and send out a message now with Zen cart, I believe you could use the Super Orders contribution. I am positive it allows you to bulk update order statuses as you need. If you select "notify customer" I believe it would also then send out an email to each order that was updated.

That should do it for you at this point.

[econcepts]

Just a quick post to let everyone know I just released version 1.2.2 of the Shipping / Order Export Contribution.

It is primarily a bugfix release that addresses two reported issues:

1. Bugfix: Corrected “table not found” error message when exporting all attributes / 1 product per row

2. Bugfix: Corrected placement of Zip code and State fields in export.


There are a few requests for "added features" that I plan on getting to in a later release, but I wanted to address these two bug issues first.

You can get more information on the contribution from here:
http://www.zencartoptimization.com/2...-contribution/

You can download it from my site as well right now by going to:
http://www.zencartoptimization.com/?page_id=40

Or wait and get it from the Zen Cart downloads section when they add the update:

http://www.zen-cart.com/index.php?ma...roducts_id=604

[lyricwings]

Hi -

Eric (econcepts) and I have been trying to figure out why I'm having a problem getting his great mod to work, but have had no luck - so I thought I'd post the problem here, in case someone else has encountered it and has a possible solution.

When I export, no data is included. The column headers are there, but the data is completely empty. This occurs whether it's in test mode, or true export mode.

Has anyone else had this happen - and if so, did you find a solution?

Many thanks! I love the idea of this mod and it will help me hugely, if I can get it to work.

[rbobzin]

Hi,

GREAT mod - and one of the few with complete instructions and worked right out of the box (unlike some other mods I've been fighting with for days!).

One problem, though - every time I ran it (both test mode and real (reset worked well here))), it only exported the first 10 orders. I looked closely at the orders table to see if there were any significant differences between first ten orders and the rest, but couldn't find anything.

Any ideas why the other orders don't show up?

Thanks

[econcepts]

Hi,

GREAT mod - and one of the few with complete instructions and worked right out of the box (unlike some other mods I've been fighting with for days!).

One problem, though - every time I ran it (both test mode and real (reset worked well here))), it only exported the first 10 orders. I looked closely at the orders table to see if there were any significant differences between first ten orders and the rest, but couldn't find anything.

Any ideas why the other orders don't show up?

Thanks

Glad you like the mod. It should export more than the first 10 (obviously).

Can you PM me

- the site url you are running exports on
- An sample of one of the exports.

That will get me a start here for trying to figure out what is going on.

[andes]

Hi -

Eric (econcepts) and I have been trying to figure out why I'm having a problem getting his great mod to work, but have had no luck - so I thought I'd post the problem here, in case someone else has encountered it and has a possible solution.

When I export, no data is included. The column headers are there, but the data is completely empty. This occurs whether it's in test mode, or true export mode.

Has anyone else had this happen - and if so, did you find a solution?

Many thanks! I love the idea of this mod and it will help me hugely, if I can get it to work.

I have the same problem and no solution

[andes]

fixed, edited shipping_export.php and delete AND ot.class = 'ot_shipping' and now works

[econcepts]

fixed, edited shipping_export.php and delete AND ot.class = 'ot_shipping' and now works

Yes, this has been reported as the current "correction".

I am looking into it as well for the next release. That particular part of the SQL query was used to link up the proper class file for returning the Total Shipping amount.

Make sure you check your total shipping etc.. and compare with the actual transactions they represent to ensure it is all calculating correctly and "lining up with" the proper record.