Export orders to Spreadsheet / Excel to email to suppliers

Sam_uk:

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.

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?

apemusic:

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.

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/2007/07/13/new-release-export-shipping-and-order-information-v122-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?main_page=product_contrib_info&cPath=40_41&products_id=604

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.

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

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

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.

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.

I have the same problem and no solution

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

andes:

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.

econcepts,

Your mod sounds like something we need. I need to capture some of the fields from Zen and export them into a membership database, and I would like to do every time an order executes. I get the impression that your current mod runs as a batch function.

What do you think?

Thanks.

It does run as a "batch function", but it does require you to "click a button" to export (user intervention) currently. (It is not setup to export a various timed intervals.)

Hello,
can somebody point me to the right direction.
I installed shipping_export module but getting:
2013 Lost connection to MySQL server during query
in:
[select count(*) as total from orders o where downloaded_ship='no' ]

Though I can not find that statement in shipping_export.php. Where does that sql comming from?

Also, i installed v1.2.2. but top right corner says VERSION: 1.2.1 (i guess version label is not updated).

Interesting that even after dropping 'downloaded_ship' column shipping_export.php displays error above. but when i run the same statement in Sql_patch window it error out due to unknown column.

it is gotta be my hosting. I did not touch anything and in the morning it starting working again.
Any idea how would I troubleshot the issue like that in the future?

econcepts, thanks for building a very nice module.

slavka001:

it is gotta be my hosting. I did not touch anything and in the morning it starting working again.
Any idea how would I troubleshot the issue like that in the future?

econcepts, thanks for building a very nice module.

Glad you got it working and equally glad you like it. It seems that from my reading, your initial error was directly related to a hosting issue (not being able to "hold" a connection to the MySQL DB). Once they resolved that, it probably resolved the rest.

In reference to the upper right corner saying "1.2.1" even though you are running 1.2.2 version, you are correct. There is one file (that will alter in a future release) which was not updated if you just upgraded from a previous mod.

The version number comes from one of the language files, so if when you upgraded, you didn't upload all files, it will show version 1.2.1 in the upper corner (when in fact it is 1.2.2).

Long story short. That version number will be moved to another file in a future release (1.2.3) which will have a number of improvements and options for export. No ETA on that version as it seems everyone likes the current one and it includes what was mainly needed.

Hi,

A+ contrib. Thank you very much!

Any chance you can add a option to download payment type chosen aswell? :)

Thanks again
Gavin

cyptc:

Hi,

A+ contrib. Thank you very much!

Any chance you can add a option to download payment type chosen aswell? :)

Thanks again
Gavin

Glad you like it.

So, let me make sure I got what you want here. You want an extra checkbox that allows you to include "payment type" as an option for export as well right?

I have a few plans for later releases, and I could include that in as well.

Hi,

Yes that is correct. Basically I download paypal csv accounts aswell.

I need to know which payments are with paypal so that dont re-enter the same info twice when combining the two together.

The reason I need the paypal sheet aswell is because I make sales on eBay aswell.

So if I can see what payment type they are I can delete those ones that are paid by paypal without having to compare with paypal one by one.

A HUGE time saver :)

This later release coming anytime soon?

Best wishes,
Gavin

I see. I hadn't had an official release date for the newest version (working on a few other mods currently), but this seems to be a pretty easy adjustment so I'll see what I can do .