Export orders to Spreadsheet / Excel to email to suppliers

[econcepts]

hey econcepts

sounds like you have just what i need to link with our shipping people, would it be ok if you could let me have the export module you have

thanks buddy :)

I sent it over in a PM to you a few days ago. Check your Private Message box. It should be there.

[noa]

Hi econcepts.

I was just finding that kind of mod you made.

Can I use your mod too?

[econcepts]

Hi econcepts.

I was just finding that kind of mod you made.

Can I use your mod too?

Not a problem. I didn't realize that so many users were looking for it. Let me put together an "official" contribution and I'll upload to the Zen site as well as send you a copy.

If you are versed in PHP, I could send you my altered file and you could mess with it to get it to do what you need. Just let me know.

[jessiebags]

I also need a mod like this ... I need to export order information in csv for my stamps.com program ... can I have the mod too? please?

[econcepts]

I also need a mod like this ... I need to export order information in csv for my stamps.com program ... can I have the mod too? please?

Yes, I am finishing up a full package to upload to the forums here. I didn't realize there was such a demand. It should be available in the coming days.

[thaiceman]

I am also looking for a mod like this, can I use it too?..
From the way it sounds it should make integrating UPS WorldShip, Fedex Ship Manager, and Endicia's DAZzle into my website a breeze.

[birdoasis]

Do you have to send an excel spreadsheet? I usually email each order to my distributer if I don't normally stock the item. So why not have the order emails simply bcc the order to distributer?


JP

[yongkoom]

I could sure use this mod as well.
Be sure to let us know when you release it to the public.
Or, if you feel like sending it to me in the meantime that would be nice too.

Thanks!

[BWB]

econcepts Your ZC Export to CVS is really great. I have one problem though. I need the Order Product Attributes to be in their own field as these get exported to a Mail Merge Word Doc and I have no way to parse the fields/data as it is contained in one field. Any suggestions or help? Too, I have tried the export from MySQL/MyPHP but since I get multiple records for each product it is no good. Again, any help or suggestions appreciated.

[econcepts]

econcepts Your ZC Export to CVS is really great. I have one problem though. I need the Order Product Attributes to be in their own field as these get exported to a Mail Merge Word Doc and I have no way to parse the fields/data as it is contained in one field. Any suggestions or help? Too, I have tried the export from MySQL/MyPHP but since I get multiple records for each product it is no good. Again, any help or suggestions appreciated.

The original version had each attribute in individual columns, but that didn't work well because the resulting export file had an indifferent number of columns which made it virtually impossible to import into anything else (as the standards were messed up).

So that idea went out the window early on, and in place of it was the concept of adding it all to one row, but delimiting it with a "pipe" [ | ].

That allows those who need to have each item separated out to use the pipe in that last field to determine where to make your breaks. It also allows the rest to not have the imports thrown off by mis matching column numbers from record to record.

If you want to get one order per row, you have to select that option before export. If you want 1 product per row, you need to select that. You may want to take a look at the read me file for more information.

In short, you have the option to export either one product per row, or one order per row from within the admin. Just make sure you choose the one that fits your needs.