Export orders to Spreadsheet / Excel to email to suppliers

[calmo]

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.

[econcepts]

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.)

[slavka001]

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).

[slavka001]

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.

[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.

[econcepts]

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.

[panelcart]

Hi,

A+ contrib. Thank you very much!

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

Thanks again
Gavin

[econcepts]

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.

[panelcart]

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

[econcepts]

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 .