My SellerDeck Account | Newsletter | Free Trial

Community and Knowledge Base

  #1  
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
  #2  
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,928
Thanks: 161
Thanked 150 Times in 137 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
  #3  
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,731
Thanks: 85
Thanked 90 Times in 73 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
Reply With Quote
  #4  
Old 12-Jul-2017, 04:28 PM
Andy@codepath's Avatar
Andy@codepath Andy@codepath is offline
Developers
Join Date: Apr 2004
Full Name: Andy Barrow
Posts: 146
Thanks: 33
Thanked 33 Times in 29 Posts
This plug-in will do that for you Jo, if you don't want to get into the raw data.
__________________
Andy Barrow
http://www.codepath.biz
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)
  #5  
Old 14-Jul-2017, 10:18 AM
Jan's Avatar
Jan Jan is offline
Administrator
Join Date: Dec 2002
Full Name: Jan Strassen
Posts: 5,312
Thanks: 127
Thanked 123 Times in 108 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)
Reply


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 06:06 PM.


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