Export orders to Spreadsheet / Excel to email to suppliers

[panelcart]

I see. I hadn't had an official release date for the newest version (working on a few other mods currently), but this seems to be a pretty easy adjustment so I'll see what I can do .

Thanks, will wait desperately for the new release... w00t :)

[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.

[PattyGale]

When I export, no data is included. The column headers are there, but the data is completely empty. This occurs whether it's in test mode, or true export mode.

I have this same exact problem. When I look in Tools-ExportShippingOrderInformation, I can see al of my customer email in the list, but absolutely nothing else... there is no other information at all, and the "preview order details" image is missing from the files, too.

Should I redownload the zip and try to reinstall again? I am using the most recent zencart, too.

[econcepts]

I have this same exact problem. When I look in Tools-ExportShippingOrderInformation, I can see al of my customer email in the list, but absolutely nothing else... there is no other information at all, and the "preview order details" image is missing from the files, too.

Should I redownload the zip and try to reinstall again? I am using the most recent zencart, too.

Patty,

See if this solution works. There were a few people that said that no data was being exported and they narrowed it down to an element that referenced the ot shipping class.

See this entry and let me know if it works. These and others will be addressed in the next release.
http://www.zen-cart.com/forum/showpo...5&postcount=69

Dose that solve the issue?

[PattyGale]

fixed, edited shipping_export.php and delete AND ot.class = 'ot_shipping' and now works

He doesn't say what else he fixed or edited besides deleting the "AND ot.class....." but this still doesn't account for the missing .gif file for "preview order details"


No, it's still not working.

[supersnow]

Hi great module. It was easy to install and great to use. The only thing I am confused with is the order total. Does this include taxes? And can we have the tax amount as an additional field. Because this would be awesome to use as a quick tool for that too!

Can you let me know how I can add the tax amount to the additional fields?

Thanks again for a great module!

[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???

[supersnow]

Hi great module. It was easy to install and great to use. The only thing I am confused with is the order total. Does this include taxes? And can we have the tax amount as an additional field. Because this would be awesome to use as a quick tool for that too!

Can you let me know how I can add the tax amount to the additional fields?

Thanks again for a great module!

Does anyone know how to add the order_tax as an additional field to export?

Please someone help

[Boby55]

Great Mod!!!

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