Custom Data Exports

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   We sell for bridal and formal salons so report sales by item each month. 

We need the order details delimited so that the quantity, sku, item title, sales price are already parsed. Delimiting this information would also give us a clean download of orders with multiple sales. 

I'd be very interested in other ideas how to get this raw data into our spreadsheet reports every month. 

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
scarlettscloset Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 12-August-2006 Location: United States Status: Offline Points: 0	Post Options Post Reply Quote scarlettscloset Report Post Thanks(0) Quote Reply Topic: Custom Data Exports Posted: 24-February-2008 at 12:39pm
	We sell for bridal and formal salons so report sales by item each month. We need the order details delimited so that the quantity, sku, item title, sales price are already parsed. Delimiting this information would also give us a clean download of orders with multiple sales. I'd be very interested in other ideas how to get this raw data into our spreadsheet reports every month.
	Scarlett

Hamish Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group Joined: 12-October-2006 Location: United Kingdom Status: Offline Points: 56	Post Options Post Reply Quote Hamish Report Post Thanks(0) Quote Reply Posted: 18-March-2008 at 11:40am
	HI Scarlett, Can you clarify what you mean by parsed in this case - Do you mean filtered? Do you mean the order details separated out into a more suitable format for your use? Have you investigated the XML export of order information? I suspect the detail in that will be both very complete & well structured (as is all XML). I'll be looking into the XML side of things myself in a week or two.