Export orders to Spreadsheet / Excel to email to suppliers

Right now the product ID is not exported. Only the model etc.. I'll included that option within the next release which I am actively working on now. There have been enough requests for additional items that I moved the development of that release forward here.

I hope to have it complete in the near future.

I'll post to this board when ready.

Thanks Eric,

Appreciate your help :)

Except I went in Admin to Tools > Install SQL Patches, I cut and paste this in the box:

UPDATE orders SET downloaded_ship="no" WHERE downloaded_ship="yes"

and clicked "SEND" and it comes back with FAILED

Sorry but I don't know PHP or SQL so no clue what I would type for AND [add your other criteria here such as dates between etc...]. I tried a few thinngs but still "failed"
I just need July 2006 - June 2007, but if I can just reset all orders to NO and export them all again that is more than fine!! I can then sort in excel

Anyone know how I can correct that SQL statement above so it works and keep moving??

Basically for those who didn't see my last post I want to export all my past orders again, this time with the full details, but since I have exported them before they don't appear ... pls help :)

econcepts:

The only way right now is to go into the ORDERS database and set the "downloaded_ship" field in each record you want to re-export to "no".

This will make them show once again when you visit the "export shipping" page in your admin.

To speed up this process, you could write an SQL script that looks something like this and run it form within your admin.
**
UPDATE orders SET downloaded_ship="no" WHERE downloaded_ship="yes" AND [add your other criteria here such as dates between etc...]**

Hope that helps. :)

Now, would you get some sleep already!

Instead of that SQL, try this one. The quotes needed to be reworked.

UPDATE orders SET downloaded_ship='no' WHERE downloaded_ship='yes';

If you want to export just the orders between July 2006 and June 2007 then try something like the following:

UPDATE orders SET downloaded_ship='no' WHERE date_purchased >= '2006-07-01 00:00:00' AND date_purchased <= '2007-07-01 00:00:00' AND downloaded_ship='yes';

any update on a new release? specifically quoting bug fixes and the ability to clear the exported flag?

Hi,

A+ contrib. Thank you very much!

Any chance you can add a option to download payment type chosen aswell? :)

Thanks again
Gavin

Hi,

Yes that is correct. Basically I download paypal csv accounts aswell.

I need to know which payments are with paypal so that dont re-enter the same info twice when combining the two together.

The reason I need the paypal sheet aswell is because I make sales on eBay aswell.

So if I can see what payment type they are I can delete those ones that are paid by paypal without having to compare with paypal one by one.

A HUGE time saver :)

This later release coming anytime soon?

Best wishes,
Gavin

Hi,

Just wanted to remind you to include the above in the new relese if possible. Really would appreciate it. Thanks alot, is it coming out any time soon :blink::clap:

dhcernese:

any update on a new release? specifically quoting bug fixes and the ability to clear the exported flag?

Getting real close I'm hoping within the next 2 weeks to have it ready for release.

Eric,

Thanks for this contribution! I am new to Zen Cart and I like all of the help these forums offer.

I am setting up a new cart for event registrations. Because the product is virtual there is no shipping address needed. Is there any easy way to copy the customer information to the shipping fields so it will download? Would it just be easier to modify the shipping_export file to pull from other fields in the database?

econcepts:

Getting real close I'm hoping within the next 2 weeks to have it ready for release.Thanks, I appreicate it!

Thanks Eric you're a champ! This worked like a charm and is very handy when sometimes I export orders without all the fields I need and then need to reset them to export again

Just hanging out eagerly for the next release of Export Orders, atm cutting and pasting company name so just if that field is fixed will be a lifesaver

cheers,
Dave

econcepts:

Instead of that SQL, try this one. The quotes needed to be reworked.

UPDATE orders SET downloaded_ship='no' WHERE downloaded_ship='yes';

If you want to export just the orders between July 2006 and June 2007 then try something like the following:

UPDATE orders SET downloaded_ship='no' WHERE date_purchased >= '2006-07-01 00:00:00' AND date_purchased <= '2007-07-01 00:00:00' AND downloaded_ship='yes';

econcepts:

UPDATE orders SET downloaded_ship='no' WHERE downloaded_ship='yes';
Curious, why the "WHERE" clause? Can I leave it out?

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:

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:

                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
                }

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

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.

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