Export orders to Spreadsheet / Excel to email to suppliers

[econcepts]

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.

[apemusic]

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 :)

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!

[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';

[dhcernese]

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

[panelcart]

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

[econcepts]

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.

[barrys]

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?

[dhcernese]

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

Thanks, I appreicate it!

[apemusic]

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

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';

[dhcernese]

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

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