Orders / Email

[4little1s]

How do I export into a spreadsheet a list of all my orders with the customers email addresses AND the products they have bought.

I can export their details, but struggling with working out how to export the stuff the ordered as well....any ideas / help appreicated.

Thanks

[4little1s]

Hmmm...guess its not easy then.

[guccij]

Hi Christianne

If you can't do it easily from within Actinic, then one possibility would be to use email parsing software. Assuming you are set up to receive a copy of the email order confirmation your customer gets, you can use the software to parse the email text (it also works for html emails) directly into a .csv file.

We have used Email2dB for years. It takes a bit of setting up but depending on the detail you set it to capture, it's good enough even for accounting purposes.

We use it for both accounting and marketing.

[pinbrook]

Marketing Menu, mailing lists

this allows you to filter on products

[Mike Hughes]

Excel can import the data you want straight from the Actinic database.

See http://community.actinic.com/showpos...83&postcount=4

Mike

[Jan]

You can also also easily export that information using my One Stop Order Processing product, you can find more details and a free trial here :

http://www.mole-end.biz/acatalog/Mul...r-Actinic.html

It allows you to choose the fields you to include in the export and then export to either CSV or excel spreadsheet.

Regards,

[4little1s]

OK thanks everyone, plenty for me to be getting on with.