My Sellerdeck Account | Free Trial

Sellerdeck Community & Knowledge Base

Old 12-Jul-2017, 10:52 AM
Jo@apartyshop's Avatar
Jo@apartyshop Jo@apartyshop is offline
Registered User
Join Date: Oct 2007
Full Name: Peter
Posts: 123
Thanks: 65
Thanked 2 Times in 2 Posts
Extract Customer Data

I'm running V12.0.4 OCUC

I wanted to extract customer data from completed orders; Name, Email, Address

Anyone care to give me an idiots guide?
( as i'm sure i'm missing something glaringly obvious )
Reply With Quote
Old 12-Jul-2017, 12:00 PM
guccij guccij is offline
Registered User
Join Date: Feb 2008
Full Name: Jules
Posts: 1,974
Thanks: 187
Thanked 160 Times in 146 Posts
I use a third party - Email2DB now known as ThinkAutomation. It also extracts the products ordered, the VAT etc.

There's also Arclab Inbox2DB which we use to populate our certificates of posting.
Reply With Quote
Old 12-Jul-2017, 02:49 PM
chris ashdown's Avatar
chris ashdown chris ashdown is offline
Registered User
Join Date: Dec 2002
Full Name: Chris Ashdown
Posts: 2,749
Thanks: 90
Thanked 97 Times in 76 Posts
I normally make a copy of the database, then open it using access and open the Person file

Dont play with the live database
Chris Ashdown
Reply With Quote
Old 12-Jul-2017, 04:28 PM
Andy@codepath's Avatar
Andy@codepath Andy@codepath is offline
Join Date: Apr 2004
Full Name: Andy Barrow
Posts: 147
Thanks: 35
Thanked 34 Times in 30 Posts
This plug-in will do that for you Jo, if you don't want to get into the raw data.
Andy Barrow
T: 0161 870 6355

Accredited Sellerdeck development partners since 2004.
Data import / export and catalog management plug-ins.
Reply With Quote
The Following User Says Thank You to Andy@codepath For This Useful Post:
brucet (19-Jul-2017)
Old 14-Jul-2017, 10:18 AM
Jan's Avatar
Jan Jan is offline
Join Date: Dec 2002
Full Name: Jan Strassen
Posts: 5,319
Thanks: 130
Thanked 126 Times in 111 Posts
Hi Jo,

You can use the mailing list feature in Sellerdeck to do this, it's Marketing / Mailing lists - you can choose the orders that you want to export with a number of filters - date, status etc. It's a nice way to do it because each customer will only be included in the list once, even if they have ordered more than once.

Kind regards,
Jan Strassen, Mole End Software - Plugins and Reports for Actinic V4 to V11, Sellerdeck V11 to V2016, Sellerdeck Cloud
Visit our facebook page for the latest news and special offers from Mole End

Top Quality Integrated label paper for Actinic and Sellerdeck

A4 Paper with one or two peel off labels, free reports available for our customers
Product Mash for Sellerdeck
Link to Google Shopping and other channels, increase sales traffic, prices from £29.95
Multichannel order processing
Process Actinic, Sellerdeck, Amazon, Ebay, Playtrade orders with a single program, low cost lite version now available from £19.95
Reply With Quote
The Following User Says Thank You to Jan For This Useful Post:
brucet (19-Jul-2017)

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

All times are GMT. The time now is 01:26 PM.

Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.