Export orders to Spreadsheet / Excel to email to suppliers

supersnow:

I had the same problem when I tried to download your mod using my Mac. I have never had any issues with any other downloads. But if I downloaded your mod and unziped it on my PC it was okay. There must be something in your zip that is not recognizable with the stuffit for mac.

But I will update my stuffit and hopefully any of your new updates I will not have to go on my slow PC to get you mod.

Yes, that is what I heard from two other Mac stuffit users. They both told me that they could download all other zips but that one.

I even re-zipped it for them and resent in an email. In both cases they said the Stuffit team looked at the files and although I do not know what exactly they did, they determined that the files were fine, but that version of Stuffit for Mac had a glitch that caused the files not to open. Somehow they both corrected the issue and got them opened.

I wish I could find that original conversation from them and shoot it up here for you as it may help, but I looked and unfortunately can't locate it.

wapnoj:

Does this Mod have the ability to select a date range of orders to export?

Thanks

JON

The current version 1.2.2 does not. The next release won't either, but 1.2.4 will (2 releases from now). Unless I can squeeze it into 1.2.3 here (to be released shortly).

Is there a possibility to have the tax exported into a column. The tax is include into the total, but it woulb great for ivoice reasons to have the tax in a seperate column.

Having the attributes in seperate colmns would be awesome too.

Thanks

JON

wapnoj:

Is there a possibility to have the tax exported into a column. The tax is include into the total, but it woulb great for ivoice reasons to have the tax in a seperate column.

Having the attributes in seperate colmns would be awesome too.

Thanks

JON

The attributes can't be split into separate columns due to the unlimited and un "common" nature of them (throws off the number of columns in the import which many programs do not like). That is why the PIPE delimiter was used. You can parse that field based on the pipe and achieve the same effect.

The tax will be be in this next release. I have been working on it here but the holidays put me behind from when I wanted to release it (which was a few weeks ago). In any event, I hope to have the newest version released and posted soon. That will include the ability to export the tax into it's own column as well as a number of other requests I have gathered since the last 1.2.2 release.

Keep your eyes open. I'll post a message to this thread when the new version is ready for download.

Can I have some help please? I'm trying to get it so that is exports in this order

COMPANY NAME, CUSTOMER NAME, EMAIL, PHONE, ADDRESS LINE 1, ADDRESS LINE 2, CITY, STATE, POSTAL CODE, COUNTRY, ORDER QUANTITY

I only ever export 1 product per row. I really need some help because this is causing me to go crossed eyed.

Thanks

SJE

sjemms:

Can I have some help please? I'm trying to get it so that is exports in this order

COMPANY NAME, CUSTOMER NAME, EMAIL, PHONE, ADDRESS LINE 1, ADDRESS LINE 2, CITY, STATE, POSTAL CODE, COUNTRY, ORDER QUANTITY

I only ever export 1 product per row. I really need some help because this is causing me to go crossed eyed.

Thanks

SJE

The current mod already gives you the option of exporting only one product per row. This is selectable from within the Admin. That part is in place.

If you want the order of the fields to be altered, I can custom alter that for you if you would like. Just shoot me a private message.

Any news on the new version (1.2.4)? I hope I hope...
Also, Have you tried to save the file as well as open it. In other words, make a backup of the cvs file on the server as well as having the popup?
Marg

Marg:

Any news on the new version (1.2.4)? I hope I hope...
Also, Have you tried to save the file as well as open it. In other words, make a backup of the cvs file on the server as well as having the popup?
Marg
I've been customizing this mod for a number of different people that have requested it and that has taken some time from the 1.2.4 version. However, the 1.2.4 version is moving along, and will be out here. Hopefully soon.

It would be possible to save the file to the server as a backup. That would require the user to set the proper write permissions on the directory to which the file is saved.

econcepts:

Hopefully soon.I think you said that back in, oh, October 2007? Just poking fun! :shocking:

Will this mod work in version 1.3.8 because I don't want to try and explain to the client how to export via phpMyAdmin... ugh. This thing sounds perfect for what he needs.

robinstl:

Will this mod work in version 1.3.8 because I don't want to try and explain to the client how to export via phpMyAdmin... ugh. This thing sounds perfect for what he needs.

Yes, works without a hitch on 1.3.8 and up as well.

Just want to say I love this mod. I also would like to share what I think would make it even better and more useful.

• Export Tax info column
• Export by Date Range
• Export by payment method (credit card, money order etc)

If it could do the above that would be awesome.

Thanks again

JON

I have been using this mod for months with success however in the last week it has been harder to get a full download of orders to take place. For instance right now it only downloads about 80-90% of my orders and will also have different amounts each time I run it. I can run it once and get 900 orders and then run it 2 minutes later and get 850 and then 2 minutes later and get 965 but I never can get everything. this never happened to me before and nothing has ben changed on my server since it last workied correctly. Anyone know of a solution or experience this issue?

Any help or insight would be appreciated.

Thanks

JON

I've got a question... I just installed the export orders contrib and I get an "internal server error" when I click "export shipping/order information" in the tools menu. I tried the install on another install of zen cart on the same server and also got the same error. Any clue why??

i'm running zc 1.3.8 and have no orders/customers yet in the system. I don't know if this would be an issue. I really can't wait to use this mod, it sounds great. Thanks in advance..

Will this export the attributes?

I have installed this contribution and it works great!

What can I do to get the attributes on the same as the order?

As of now, it puts a new line for each attribute.

Does anyone know how to extract the pipes into sperate columns?

Thanks

wapnoj:

Does anyone know how to extract the pipes into sperate columns?

Thanks

You'll have to extract them in your spreadsheet if you want to do that. The reason is that most import programs require a set amount of columns and if you take each attribute and export it into it's own column, then you have an odd number of columns which will through off most imports.

webrob:

Will this export the attributes?

Yes, it exports the attributes as well.

kjott:

I've got a question... I just installed the export orders contrib and I get an "internal server error" when I click "export shipping/order information" in the tools menu. I tried the install on another install of zen cart on the same server and also got the same error. Any clue why??

i'm running zc 1.3.8 and have no orders/customers yet in the system. I don't know if this would be an issue. I really can't wait to use this mod, it sounds great. Thanks in advance..

This type of error is directly server (not module / contribution) related. You'll have to check with your host on it. It could be any number of things that are causing it.