Orders Exporter Module

29 Feb 2012, 14:58

#1

Totally Zenned

Join Date:: Nov 2007
Posts:: 4,260
Plugin Contributions:: 34

Orders Exporter Module

Orders Exporter allows you to download orders from your Zen Cart to a flexible tab delimited text file, which can be edited (printed, saved) in MS Excel, OpenOffice and other applications for bookkeeping and such.

Download Orders - tab-delimited .txt file

all orders full export
all orders full export WITHOUT DELIVERED ORDERS
all ordered products WITHOUT DELIVERED ORDERS (attributes excluded)
ordered products with attributes (only) WITHOUT DELIVERED ORDERS

Save Orders in directory on the server - tab-delimited .txt file

all orders full export
all orders full export WITHOUT DELIVERED ORDERS
all ordered products WITHOUT DELIVERED ORDERS (attributes excluded)
ordered products with attributes (only) WITHOUT DELIVERED ORDERS

20 Mar 2012, 23:24

#2

rixstix

Totally Zenned

Join Date:: Aug 2009
Posts:: 2,015
Plugin Contributions:: 0

Re: Orders Exporter Module

When I attempt to unzip the module, I get an error message for most of the folders that they require a password to be extracted for both versions.

I've never had this happen to any addon module in the past.

20 Mar 2012, 23:42

#3

mprough

Totally Zenned

Join Date:: Nov 2007
Posts:: 4,260
Plugin Contributions:: 34

Re: Orders Exporter Module

RixStix:
When I attempt to unzip the module, I get an error message for most of the folders that they require a password to be extracted for both versions.

I've never had this happen to any addon module in the past.

Sorry you are having difficulty, but I suspect you will need to check with a tech person with regard to your computer.

I downloaded this, unzipped it just fine and accessed all files.

Perhaps just a reboot to start is a good idea.

~Melanie

21 Mar 2012, 00:35

#4

rixstix

Totally Zenned

Join Date:: Aug 2009
Posts:: 2,015
Plugin Contributions:: 0

Re: Orders Exporter Module

TNX Melanie,

It was something in this computer. I had downloaded and extracted several files earlier today. This download must have had a hiccup and I had a brainfart and didn't think to re-download it.

All was fine once I went to the laptop instead.

Sorry to trouble you but TNX for jumpstarting my thinking process.

30 Apr 2012, 19:06

#5

irishshopper

Zen Follower

Join Date:: Apr 2010
Posts:: 302
Plugin Contributions:: 0

Re: Orders Exporter Module

www.irishshopper.com ZenCart 1.3.9b

I want to get it to output details for ALL ORDERS including delivered orders but it DOES NOT include any order totals (prices). How can I get it to do this ?

30 Apr 2012, 19:40

#6

mprough

Totally Zenned

Join Date:: Nov 2007
Posts:: 4,260
Plugin Contributions:: 34

Re: Orders Exporter Module

I didn't write this, only upgraded it for 1.5.0. I think you will have to contact the original source author. Sorry

11 May 2012, 02:14

#7

boum

New Zenner

Join Date:: May 2012
Posts:: 6
Plugin Contributions:: 0

Re: Orders Exporter Module

Hi, I run 1.5.0 and just installed the package as instructed (from folder: orders_exporter_installation_for_zen_cart_1.5.0). Logged off and on again, refreshed my browser but Inventory Report doesn't show up in the Report menu. Any insight of what may have gone wrong?

11 May 2012, 02:42

#8

mprough

Totally Zenned

Join Date:: Nov 2007
Posts:: 4,260
Plugin Contributions:: 34

Re: Orders Exporter Module

orders_exporter_installation_for_zen_cart_1.5.0 is not inventory report

11 May 2012, 02:59

#9

boum

New Zenner

Join Date:: May 2012
Posts:: 6
Plugin Contributions:: 0

Re: Orders Exporter Module

Thank you for your reply. Sorry, I took "Inventory Report" from the readme file in your installation folder. In fact, I am interested in exporting orders as mentioned in your module description. But I didn't find any new menu item after installation. Am I missing something? How does your module work?

11 May 2012, 03:12

#10

mprough

Totally Zenned

Join Date:: Nov 2007
Posts:: 4,260
Plugin Contributions:: 34

Re: Orders Exporter Module

Zen Cart version?

You renamed to your own admin directory name?

You have privileges, superuser?

11 May 2012, 03:35

#11

boum

New Zenner

Join Date:: May 2012
Posts:: 6
Plugin Contributions:: 0

Re: Orders Exporter Module

Zen Cart version: v1.5.0

Superuser with all privileges.

I changed my admin directory name when I installed Zen Cart. I renamed the admin directory name in the Orders Exporter Module package and dropped (merged) the two first directories (oexport and renamed admin) in my Zen Cart directory. As far as I can tell, all your file/folders have been installed in their corresponding locations in my Zen Cart directory. The paths for each have been maintained.

11 May 2012, 11:56

#12

mprough

Totally Zenned

Join Date:: Nov 2007
Posts:: 4,260
Plugin Contributions:: 34

Re: Orders Exporter Module

Not sure what then, this one is so straightforward.

~Melanie

11 May 2012, 14:53

#13

boum

New Zenner

Join Date:: May 2012
Posts:: 6
Plugin Contributions:: 0

Re: Orders Exporter Module

mprough:
Not sure what then, this one is so straightforward.

~Melanie

Feel sorry to hear that. I really need to export orders in csv format. Thank you very much for your input.

12 May 2012, 02:48

#14

boum

New Zenner

Join Date:: May 2012
Posts:: 6
Plugin Contributions:: 0

Re: Orders Exporter Module

Mystery solved! I had been confused by what the readme document says: You will find your new report in your administration interface under the reports menu called "Inventory Report".

In fact, the menu item is called "Orders Export" and is found in the Tools menu. Thank you!

12 May 2012, 02:58

#15

boum

New Zenner

Join Date:: May 2012
Posts:: 6
Plugin Contributions:: 0

Re: Orders Exporter Module

Works great except that all data related to money (such as price, total, etc.) is not added to the csv file. Is there a way to get this data as well?

19 May 2012, 23:10

#16

panelcart

Zen Follower

Join Date:: Sep 2006
Posts:: 125
Plugin Contributions:: 0

Re: Orders Exporter Module

Hi,

Is it possible to have this work with Amazon Fulfillment? I'm looking to have a mod where you select check boxes or something like that and click export and it exports orders in a format that can be uploaded to Amazon (without needing any extra tweaking) as they will be fulfilling my orders.

Basically download and upload to amazon exactly in the format that Amazon will accept.

Thanks in advance!

02 Jul 2012, 18:36

#17

flyingchangewebs

New Zenner

Join Date:: Jul 2012
Posts:: 1
Plugin Contributions:: 0

Re: Orders Exporter Module

boum:
Works great except that all data related to money (such as price, total, etc.) is not added to the csv file. Is there a way to get this data as well?

I need this same feature. Is there a way to ADD the quantity into the full report? That's a pretty important piece to be missing.

11 Jul 2012, 15:50

#18

dpmark

New Zenner

Join Date:: Apr 2012
Posts:: 11
Plugin Contributions:: 0

Re: Orders Exporter Module

Can someone email me a sample of the export file? We are working with a vendor that wants to read this file into their ordering system and they are asking for a sample of the output file. My email is ContactingMark at Gmail ... thank you.

15 Dec 2012, 22:33

#19

beyerg

New Zenner

Join Date:: Oct 2008
Posts:: 61
Plugin Contributions:: 0

Re: Orders Exporter Module

Hello,

I need to export orders only to get delivery name and address info for importing into my UPS software. The files downloaded have multiple, lines of duplicate customer info for customers who order more than one item in their order. I'm thinking it is cuased by this portion of the querry:

products_model as v_products_model,
products_name as v_products_name,
products_options as v_products_options,
products_options_values as v_products_options_values

Customers who order only one item, have only one line of data.

I have tried remming these lines out with "--" but when I do that the file comes back entirely empty, with only the column headers.

What can I do to not have duplicate customer data? For each order, I want ONE line, containing name, address, email, etc.

BTW I've discovered I need to pull delivery_XXXXX instead of customer_XXXXX for each of those fields and have fixed the code to pull that info I need for shipping address labels.

Thanks very much,

Greg

22 Jan 2013, 00:59

#20

heteromorphic

New Zenner

Join Date:: Jul 2012
Posts:: 60
Plugin Contributions:: 0

Re: Orders Exporter Module

I am also looking to download pricing with the orders (total with and without shipping). Has anyone figured this out yet or know of another module that does both?

Thanks in advanced!