Export orders to Spreadsheet / Excel to email to suppliers

Quote:

---

Originally Posted by jonsnolen

The mod looks to be great, but I am obviously doing something wrong. I have followed the install, but nothing shows up in the lower portion of my screen. The last thing showing is the Notice, and nothing at all below there. I have verified that I have had sales since the install. Any ideas???

---

I would try to reinstall and make sure you didn't miss anything. The other thing to note is that it will only show orders on the screen if any NEW orders have been added.

In addition, make sure you ran the SQL query to add the extra field in the db for it.

Quote:

---

Originally Posted by Boby55

Great Mod!!!

I will be very happy to use the "Tax" as well.

---

I'll look at splitting this out in a future version. The current "total" amount includes everything that could go into a total including tax and shipping.

Quote:

---

Originally Posted by econcepts

I would try to reinstall and make sure you didn't miss anything. The other thing to note is that it will only show orders on the screen if any NEW orders have been added.

In addition, make sure you ran the SQL query to add the extra field in the db for it.

---

Thanks! That got me seeing the orders and if i run the export, they correctly do not show next time. Any idea why the csv would only have the column headers? This will help me out a whole bunch if the operator (me) errors can get fixed....

Quote:

---

Originally Posted by jonsnolen

Thanks! That got me seeing the orders and if i run the export, they correctly do not show next time. Any idea why the csv would only have the column headers? This will help me out a whole bunch if the operator (me) errors can get fixed....

---

See my earlier post on this same issue. Just a little further back in the postings. I refer to the following post in it.

http://www.zen-cart.com/forum/showpo...5&postcount=69

Quote:

---

Originally Posted by econcepts

I'll look at splitting this out in a future version. The current "total" amount includes everything that could go into a total including tax and shipping.

---

Thanks, I look forward to that. again great mod.

Hi Eric and everyone,

I need to export some orders from last year again for tax reporting purposes?

Any idea how I get them to show up again so I can export them? Any code I can reset or edit?

I did export them before but did not include proper field last time and it didn't work properly??

Also is this the most suitable tool to export orders for tax reporting or does someone know something more appropriate (something that shows sales taxes, last order status, payment method would really help!)

cheers,
Dave

Dave,

Great stuff here. I've had a number of request for similar functionality and planned on adding the ability to export
"tax"
"payment method"
and possibly last order status as well.

I've been in the middle of a number of projects, but it looks like it is time to move this next version forward a bit (which would be 1.2.3).

I'll get cracking here and keep you all updated.

Thanks!

Thanks Eric!

Gday from Australia, 1am here

Just for now how can I re-export some old orders again?

Obviously since I exported before they are not showing, but I didn't include the order totals etc last time so need to export again

can I edit or reset the code somewhere? Or will an uninstall / reinstall do the trick? I don't want to mess anything up :)

cheers,
Dave

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!

how can I export the product id field or add any other field from the database as well as the model field . I could do with the product ID so I can link with sage.

Many thanks

MG