Export orders to Spreadsheet / Excel to email to suppliers

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.

Quote:

---

Originally Posted by 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.

Quote:

---

Originally Posted by 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:

Quote:

---

Originally Posted by 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:

Quote:

---

Originally Posted by 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??

Quote:

---

Originally Posted by 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! :(

Quote:

---

Originally Posted by 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.

Quote:

---

Originally Posted by 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.