My Sellerdeck Account | Free Trial

Sellerdeck Community and Knowledge Base

Sellerdeck Community is now HTTPS by default. If your browser usually keeps you logged in, you may need to login again.
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's Avatar
guccij guccij is offline
Registered User
Join Date: Feb 2008
Full Name: Jules
Posts: 1,969
Thanks: 184
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,748
Thanks: 90
Thanked 95 Times in 75 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,318
Thanks: 129
Thanked 125 Times in 110 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 03:24 PM.

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