Welcome to the Second Life Forums Archive

These forums are CLOSED. Please visit the new forums HERE

Customer Database
Arcady Farslider
La Conejita Designs
Join date: 2 Sep 2009
Posts: 10
11-15-2009 12:13
Can anyone help me out. I want to be able to track the people who buy stuff in my clothing store. A simple database that allows for customer names, email address , the product and date they bought and a field for notes.

I need it as simple as possible. It is so sad...I can design a dress, make the prims, do some amazing things in photoshop, compile and bake it, adjust everything and make some very nice product photos....but can't make a simple database....

Please..can SOMEONE help me?
_____________________
arcadyfarslider@yahoo.com
Ceka Cianci
SuperPremiumExcaliburAcc#
Join date: 31 Jul 2006
Posts: 4,489
11-15-2009 12:41
just make a copy of transaction records..

Whats the name of your store anyways so i know?
_____________________


Free Your Mind
http://www.flickr.com/photos/ceka_cianci/
Joshooah Lovenkraft
Just Joshin'
Join date: 28 Dec 2007
Posts: 1,376
11-15-2009 12:41
You can just download your transaction history and add your own fields to an excel spreadsheet for extra information you might want to keep. I'm not sure if that is too simple or you want something more than that.
_____________________


Hello Avatard - Your Emporium of Fun Stuff
In-world: http://slurl.com/secondlife/Fordham/178/19/63
Xstreet: https://www.xstreetsl.com/modules.php?name=Marketplace&MerchantID=103499
Benski Trenkins
Free speech for the dumb
Join date: 23 Feb 2008
Posts: 547
11-15-2009 12:47
That's how I do it too, DL and put it in my own Excel Sheet.
Data like email isn't available, but then again, you really need that? I don't
_____________________


RezzVendor: http://slurl.com/secondlife/Creative%20Hearts/56/104/23
Priya Blaisdale
Registered User
Join date: 28 Jul 2008
Posts: 53
Some of the vendor machines help..
11-15-2009 12:51
Alika has excellant reports, so does Hippo...
spinster Voom
Registered User
Join date: 14 Jun 2007
Posts: 1,069
11-15-2009 13:12
From: Arcady Farslider
...I can design a dress, make the prims, do some amazing things in photoshop, compile and bake it, adjust everything and make some very nice product photos....

That's lovely, and I can see the point of a database, but I doubt I would buy anything which required me to submit my email address.
_____________________
From: Rioko Bamaisin
Grunting is hard:(
ElQ Homewood
Sleeps Professionally
Join date: 25 Apr 2007
Posts: 280
11-15-2009 13:21
Yeah, I don't see anybody giving up their email address unless you were offering coupons or a newsletter or something they might want emailed. Personally, I have my sales info in a MySQL database.
Arcady Farslider
La Conejita Designs
Join date: 2 Sep 2009
Posts: 10
11-15-2009 14:51
My store is La Conejita Designs. We have a request for offline email for product updates for those that want it. I am finding about a 20% rate on emails. I have transactions downloaded, I also have a notification script that sends me an email for every item purchased...

I have excel, but NO idea how to use it...I can do magic in photoshop, but excel is a mystery.

I'll try to cobble something together. Thank you.

Oh..and my slurl is http://slurl.com/secondlife/Harlman/97/178/29/

We specialize in risque gowns and clothing.

https://www.xstreetsl.com/modules.php?name=Marketplace&MerchantID=422982
_____________________
arcadyfarslider@yahoo.com
Isablan Neva
Mystic
Join date: 27 Nov 2004
Posts: 2,907
11-15-2009 21:04
The simplest thing to do is download your transactions each month. Put a calendar reminder into your email/calendar program that pops up on the last day of every month and download your transactions for the month into Excel.

I name mine SL Transactions (month) (year)

SL Transactions Oct 09


There are free tutorials for learning Excel here:

http://www.baycongroup.com/el0.htm

http://www.youtube.com/results?search_query=excel+tutorial&search_type=&aq=0&oq=excel+t

http://people.usd.edu/~bwjames/tut/excel/
_____________________

http://slurl.com/secondlife/TheBotanicalGardens/207/30/420/
Damanios Thetan
looking in
Join date: 6 Mar 2004
Posts: 992
11-15-2009 22:09
On that note, does anybody have some kind of nifty transactions xml to sql importer script?
And a nice backend system for statistical data on sales based on that (my)sql database?

If so, send me a PM/IM, maybe interested...
If not, would anybody be interested ;)

OT: for basic sales registration, use excel, as suggested. (Good for monthly/running totals and average sales numbers)
For sending updates/notices to customers, either use an in world group, or a system like subscribe-o-matic (which is free for first 500 customers)
_____________________