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