Export orders to Spreadsheet / Excel to email to suppliers

[econcepts]

I have installed this contribution and it works great!

What can I do to get the attributes on the same as the order?

As of now, it puts a new line for each attribute.

To get the attributes on the same line as the order, choose the "one order per row" option.

[wapnoj]

You'll have to extract them in your spreadsheet if you want to do that. The reason is that most import programs require a set amount of columns and if you take each attribute and export it into it's own column, then you have an odd number of columns which will through off most imports.

Thanks, I guess what I am asking is how to do it in the spreadsheet. Does anyone know how to do that?

Thanks

[DarkAzrael]

If you are using Google Checkout when you export your orders you will not be able to use this and see your order amount totals. Google checkout stores these values in another table (google_orders) not the default table (orders).

While this probably will not affect many people a company that I work for is using php scripts to automate shipping ( converting to xml, and using dazzle and worldship software ). Because of the possiblitiy of need to manual overrides we are using this mod to pull orders into a format viewable by excel, change the ship type variable if needed and run through the xml converter to print postage automatically. Seems more complicated than what it is, and it allows us to print postage for 300 orders very quickly.

At any rate the point is that they base their shipping methods in part on the the order totals. If orders are over $100 they go by UPS, not USPS, and if orders are $150 or more they are nsured.....

Since this mod doesn't take into account the order totals from Google Checkout, I had to modify it a bit. I added the following code to pull the order totals from the google checkout table into the order table:


$query = 'update orders,google_orders set orders.order_total=google_orders.order_amount where orders.orders_id=google_orders.orders_id';

If you need to see order totals and you are using Google Checkout you can place this code in the export file: Admin->shipping_export.php and it will solve the issue. Place the code near the top right after the includes.

Might be worthwile to include something like this or a conditional statment to grab the google info in future releases.

Thanks for the export btw, works great, and it saved me a lot of coding time! :-)

[panelcart]

Hi,

I asked the below question back in September. Any news about the update? Thanks

"Hi,

A+ contrib. Thank you very much!

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

Thanks again
Gavin"

[dhcernese]

Well since we're asking.. ..export by date range? If exported by date, orders should have their 'exported' flag set just as before.

I think you said that back in, oh, October 2007? Just poking fun!

[paddy100]

Hi there,
Downloaded the mod and installed it as per the instructions.... all I get is a blank page, no writting, no nothing!! ........ any thoughts as to why? Anyone else experienced this problem?

Here are the mods I have installed, as there might be a conflict

UK Zencart
Disable Registration
Capitalisation of fields
Add customers from admin
Admin notes
Admin Profiles
Edit Orders
Lightbox

Any help is greatly appreciated as from this thread it is exactly as I am looking for.

Many thanks

[pinixdesign]

My client is a florist so they need to export the billing information as well. Is there a way I could add this to this module? Or are there any plans on having that added as well.

Thank you for such a great module! It has been very helpful already!

- Karen

[gizmo_girl]

WOW! I just wanted to tell you this mod is so simple, yet FABULOUS! Exactly what I had been looking for. THANK YOU!!!

[gizmo_girl]

I just added 180 customers from my database to my stamps.com address book in under a minute. THIS MOD IS IMPRESSIVE!!!!! You are awesome, econcepts!!

[econcepts]

Glad you like it.

I am finishing up a new release here (just about complete) that I have been working on. It integrates a number of new features that have been requested over the past year including the ability to export based on a selected date range.

Watch for this new release in the coming week or so.