Export orders to Spreadsheet / Excel to email to suppliers

Quote:

---

Originally Posted by dhcernese

Curious, why the "WHERE" clause? Can I leave it out?

---

Sure, you could leave it out, however it is there so that it finds every record that has already been exported (once exported, that field is marked as 'yes') and the resets it to 'no' (as if the export never occurred.)

If you leave it out, it will set everything in the database to 'no'. This may be what you want. Either way will work. Including the WHERE clause gives you more control over what exact records are being updated.

For example, if you decide to only include orders to set as "no" (not exported) in the db, then you would want to add the date to the sql commands and include the fact that you want to also take only those orders that have been exported already.

Just a "completion" type thing.

Minor but annoying bug, in admin/shopping_export.php is this:

<img src="/z137/admin/images/icons/preview.gif" border="0" ALT="Preview Order Details">

Note the hard-coded path to the preview.gif

I suggest this to resolve quoting problems, if losing the quotes is acceptable. If not, it's a little more complicated:

Code:

---

[FONT="Courier New"]                if ($_POST['order_comments'] == 1) {
                        if ($_POST['filelayout2'] == 1) { // 1 Product per row
                                $orders_comments_query="SELECT *  FROM " . TABLE_ORDERS_STATUS_HISTORY . " WHERE orders_id = " . $order_details->fields['orders_id'] . " GROUP BY orders_id ORDER BY orders_status_history_id ASC";
                                $orders_comments = $db->Execute($orders_comments_query);
                                $note = $orders_comments->fields['comments'];
                        } else {
                                $note = $order_details->fields['comments'];
                        }
                        $cnote = str_replace(array("\"","\'"), "", $note); // Remove any double or single quotes
                        $str_export = $str_export . ",\"". str_replace(array("\r\n","\r","\n"), " ", $cnote) . "\""; // Remove any line breaks in first comment and print to export string
                }[/FONT]

---

Hi Eric, I just downloaded and installed your export feature and it RULES!!! works like a charm:clap:

thanks so much for making this excellent mod available!

Let me tell you, i have been getting the info from copy's of order conformation mailes. So i had to copy, name, adres, the likes into an excell sheet for external use... took me like an hour for the first 20 orders.

With your tool, i now do the same in a minute. THANKS THANKS THANKS!:clap:

(just a little thing i'd apreciate for a next release: selectoption to add manufacturer info)
Keep up the great work :smile:

Glad you like the mod. I think you'll like the next release as well (coming very soon). :)

Can't wait. there's some small things i'd like to see added. (more options to export data)

Just got the conversion pack/book and google workbook as an apriciation of this great module :) Keep these handy items coming :) I'm gonna get the analytics implemented now

I'm having trouble downloading this mod. I keep getting an unable to determine file format message from Stuffit. Is there any other source for the file? Thanks

Quote:

---

Originally Posted by johnga

I'm having trouble downloading this mod. I keep getting an unable to determine file format message from Stuffit. Is there any other source for the file? Thanks

---

I had only one other user inform me of this message as well (using the same Stuffit program).

They contacted Stuffit and found out that it had to do with a flaw in the version of Stuffit they were using. They updated (or somehow corrected the issue) and were able to open the file just fine.

You may want to contact the guys over at Stuffit to find out what the issue is. If I find his exact response in my messages here (if I still got it) I'll post it. You may already have the answer by then though.

Quote:

---

Originally Posted by econcepts

I had only one other user inform me of this message as well (using the same Stuffit program).

They contacted Stuffit and found out that it had to do with a flaw in the version of Stuffit they were using. They updated (or somehow corrected the issue) and were able to open the file just fine.

You may want to contact the guys over at Stuffit to find out what the issue is. If I find his exact response in my messages here (if I still got it) I'll post it. You may already have the answer by then though.

---

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.

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

Thanks

JON