Export orders to Spreadsheet / Excel to email to suppliers

Sam_uk:

Hi,

I hope someone can help me. I used to use the addon some time ago on 1.3.7 and was working great. An excellent module.
I have now created a new site and using 1.3.8a.
I have tried using all the options but no information is downloaded. I get all the information showing on the left hand side. All I get are the field names and no orders data. I always use test mode so they can be re-expored if required.
I dont know if there is a problem with this in 1.3.8a?
I have updated with the SQL statement. So cant see where I am going wrong, some help would be really appreciated if possible.

Many Thanks
Samantha

This mod had been tested and works on all versions of zen (including 1.3.8a).

When you upgraded could you possibly have altered the way the "state" field displays on the "create an account" form?

Older versions had a bug in them when the state was selected from a drop down (instead of entered by hand into a text field.)

My new version (1.2.7) soon to be released should correct this issue.

How do you have customers enter their "state" on that form currently?

Sam_uk:

Hi,

I hope someone can help me. I used to use the addon some time ago on 1.3.7 and was working great. An excellent module.
I have now created a new site and using 1.3.8a.
I have tried using all the options but no information is downloaded. I get all the information showing on the left hand side. All I get are the field names and no orders data. I always use test mode so they can be re-expored if required.
I dont know if there is a problem with this in 1.3.8a?
I have updated with the SQL statement. So cant see where I am going wrong, some help would be really appreciated if possible.

Many Thanks
Samantha

You might also try the add-on we've contributed: http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=1500
Please let me know if you see problems with it.

Hope this helps.
Apsona
http://apsona.com

Hi Guys,

The install is a fresh 1.3.8a no upgrades, no alterations made to the state field from what I know.
Apsona thank you for the alternative, will do the job for now

Thanks for all your help guys

Samantha

Sam_uk:

Hi Guys,

The install is a fresh 1.3.8a no upgrades, no alterations made to the state field from what I know.
Apsona thank you for the alternative, will do the job for now

Thanks for all your help guys

Samantha

Sam,

What version of the mod are you running?

1.2.7 is being BETA tested by my members currently and is just about ready for release (a few minor bugs we ran across). This corrects a number of bugs that were introduced in versions 1.2.5 and 1.2.6.

Also, did anything change on your server (PHP version, MySQL Version, etc...)

I would like to export:

products

total sale price

delivery method

name/company address

into .doc file. Is this possible?

Some suggestions, though I'm not sure I fully understand your requirement. If you want to simply export all fields from your order records, you could use our add-on available here: http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=1500

If you want to export fields from multiple records, e.g., some fields from orders, some from the related products, and some from the related customer, you can use our free ShopAdmin tool to create a custom report containing the fields you want, and then export the results of running it.

Hope this helps.
Apsona
http://apsona.com

i want to export to .doc file and then just print all orders out.

What ever became of v1.2.7?

Did the focus shift to Apsona CSV data exporter?

i need a way to export the order info into word so it is easy to print out for the packaging...

split63:

What ever became of v1.2.7?

Did the focus shift to Apsona CSV data exporter?

Nope. No focus on that at the moment.

I just completed the newest version and that is being uploaded now. It is 1.3.0 (moved from 1.2.6 to 1.3.0 due to some new functionality add-ons.)

I just submitted to the zen cart upload section and will post a direct link to it here (with more info) in a minute (in case you can't wait for it to activate on the zen cart downloads side.)

Ok, here is the direct link to the page you can download this new 1.3.0 version from if you don't want to wait for it to be activated in the Zen Cart downloads section (it has been submitted ... just waiting for the Zen Cart team to activate it.)

http://www.zencartoptimization.com/downloads/

Here are the changes and updates you'll find in the 1.3.0 version:

1. Added ability to have the exported file either downloaded to your computer or automatically sent to a desired email address. This is nice for automating the sending of orders to suppliers for fulfillment (as in the case of those using zen cart to drop ship).

2. Added ability to automatically update the order status after a successful export. Status can be updated to what ever you choose (from dropdown).

3. Added ability to include header row or leave it out of your exported file.

4. Added the ability to export different file types. (CSV / TXT)

5. Bugfix: REMOVED the option to export manufacturing data as it was causing problems. (This will be added in the next release after worked on a bit.)

6. Bugfix: Corrected issues with Company Name not showing up in export.

7. Bugfix: Corrected issue with some people getting a header row but no orders exported.

8. Moved product details field data to the end of the export again. After recent additions to new fields the product details were showing up in the middle of the exported file and this could throw off columns if exporting 1 order per line on mixed orders with attributes and without.

riolas:

I would like to export:

products

total sale price

delivery method

name/company address

into .doc file. Is this possible?

A number of things are needed for this to happen. Got your private message and am responding to that to figure out what might be able to be done (and present options available to you that you might want to consider which are already built into native zen cart.)

Great. Let me know as soon as you can.

econcepts:

Here are the changes and updates you'll find in the 1.3.0 version:

7. Bugfix: Corrected issue with some people getting a header row but no orders exported.I installed 1.3.0 into my 1.3.8a store-- I've become one of those people with no exports! I tried all sorts of combinations, everything I could think of. :yuck: I cannot get it to export anything, I am rolling back once again to 1.2.2 !:oops:

dhcernese:

I installed 1.3.0 into my 1.3.8a store-- I've become one of those people with no exports! I tried all sorts of combinations, everything I could think of. :yuck: I cannot get it to export anything, I am rolling back once again to 1.2.2 !:oops:...it does successfully set all the orders downloaded_ship = "yes" :wacko:

dhcernese:

...it does successfully set all the orders downloaded_ship = "yes" :wacko:I'm reading the code and I can't see how it could ever work!

Specifically, it no longer echos $str_export inside the loop. It only writes a single record to either to be emailed or the download. :blink:

So I change it to clear the $str_export before the loop and inside the loop begin $str_export construction with .=

Now it outputs orders :clap: (but only in 1 order per row mode)

You got same major bugs dude, maybe you uploaded the wrong version??

dhcernese:

I'm reading the code and I can't see how it could ever work!

Specifically, it no longer echos $str_export inside the loop. It only writes a single record to either to be emailed or the download. :blink:

So I change it to clear the $str_export before the loop and inside the loop begin $str_export construction with .=

Now it outputs orders :clap: (but only in 1 order per row mode)

You got same major bugs dude, maybe you uploaded the wrong version??I debugged a little further, I need 1 order per product-- if I try that it outputs every order 240 times! :(

dhcernese:

I debugged a little further, I need 1 order per product-- if I try that it outputs every order 240 times! :(I forgot to mention: in order to get this to work at all for my order, I had to *rename *the ACCOUNT_STATE variable (and just to be safe, I commented out the devliery_country stuff).. ..that indicates to me that your ACCOUNT_STATE code is not going to work for me.

dhcernese:

I forgot to mention: in order to get this to work at all for my order, I had to *rename *the ACCOUNT_STATE variable (and just to be safe, I commented out the devliery_country stuff).. ..that indicates to me that your ACCOUNT_STATE code is not going to work for me.:clap: I commented out all the country code stuff and now even 1 product per row works (and no multiplier by 240, which might have something to do with the number of countries?).

fyi -- the last history comment can have newlines in it and the attributes can have ^M^J in them, neither are cleaned.