I REGRET THE WORDING OF MY LAST POST. It's stupid to post another "hey
what's a good shopping cart?!?" message. PLEASE READ THIS ONE INSTEAD...
-=-
I'm sorry to say I *might* not be able to use FreeTrade for CD Baby. I've
been trying. Believe me. I really like the people that made it, and I
like this helpful Email list.
BUT - Our system is set up SO differently, and we've already spent a ton of
time and money setting up PHP administration locally to deal with all our
tables as they are, so...
Is it really possible to make FreeTrade flex to match our
tables...? [[SEE BELOW]]
Is it possible to just use SOME features of FreeTrade (ex: the cart, but
not the coupons. Skip the product administration?)
Thanks!
Derek Sivers
www.cdbaby.com
#
# Table structure for table 'albums'
# OUR PRODUCT INFO:
CREATE TABLE albums (
albumcode varchar(32) DEFAULT '' NOT NULL,
albumname varchar(64) DEFAULT '' NOT NULL,
artistname varchar(64),
mp3link varchar(64),
url varchar(64),
notes text,
listprice float(8,2),
babyprice float(8,2),
instock tinyint(4),
format tinyint(4) DEFAULT '1',
trythis varchar(64),
active enum('0','1') DEFAULT '1',
category1 tinyint(3) unsigned,
category2 tinyint(3) unsigned,
category3 tinyint(3) unsigned,
soundlike varchar(255),
style varchar(255),
yr varchar(4),
copyowner varchar(64),
spinecode varchar(48),
barcode varchar(16),
reclabel varchar(64),
member_of_group tinyint(3) unsigned,
css varchar(32) DEFAULT 'default.css',
review_url varchar(64),
reviewcat tinyint(3) unsigned,
color1 varchar(7) DEFAULT '003163',
color2 varchar(7) DEFAULT '9c3131',
color3 varchar(7) DEFAULT '31639c' NOT NULL,
hits int(10) unsigned DEFAULT '0',
metakeywords varchar(255),
metadesc text,
KEY albumcode_idx (albumcode),
KEY albumname_idx (albumname),
UNIQUE albumcode_unq (albumcode),
KEY albumcode (albumcode),
PRIMARY KEY (albumcode)
);
# Table structure for table 'albums_off'
# INTER-OFFICE PRODUCT INFO:
CREATE TABLE albums_off (
albumcode varchar(32) DEFAULT '' NOT NULL,
contactid smallint(5) unsigned DEFAULT '0' NOT NULL,
items_sold smallint(6) DEFAULT '0',
items_received smallint(5) unsigned,
paid enum('0','1') DEFAULT '0',
carepack_sent enum('0','1') DEFAULT '0',
spoke_phone varchar(32),
comment varchar(255),
date_added timestamp(14),
who_added varchar(32) DEFAULT 'test',
our_desc varchar(255),
UNIQUE albumcode_unq (albumcode),
KEY albumcode (albumcode),
KEY contactid (contactid),
KEY albumcode_idx (albumcode)
);
# Table structure for table 'clientinfo'
# OUR CLIENTS (whose items we sell)
CREATE TABLE clientinfo (
uid smallint(5) unsigned DEFAULT '0' NOT NULL auto_increment,
firstname varchar(32),
lastname varchar(32),
username varchar(20) DEFAULT '' NOT NULL,
password varchar(25) DEFAULT '' NOT NULL,
address varchar(64),
city varchar(24),
state_province char(2),
postalcode varchar(12),
country varchar(24),
company_name varchar(48),
work_phone varchar(18),
home_phone varchar(18),
email varchar(48),
referred_by varchar(48),
notes varchar(255),
perms varchar(32) DEFAULT 'artist',
PRIMARY KEY (uid),
UNIQUE logname_unq (username),
KEY username_idx (username)
);
#
# Table structure for table 'customers'
# CUSTOMER INFO
CREATE TABLE customers (
uid smallint(5) unsigned DEFAULT '0' NOT NULL auto_increment,
email varchar(48),
name varchar(48),
addr1 varchar(64),
addr2 varchar(64),
city varchar(24),
state varchar(10),
zip varchar(12),
country varchar(24),
phone varchar(18),
misc varchar(18),
date_added timestamp(14),
notes varchar(255),
KEY userid (uid)
);
#
# Table structure for table 'invoices'
# ORDERS:
CREATE TABLE invoices (
invid smallint(6) unsigned DEFAULT '0' NOT NULL auto_increment,
uid smallint(5),
cartid varchar(10),
order_date timestamp(14),
ship_date date,
tax_rate smallint(3),
tax smallint(3),
shipcost smallint(3),
total smallint(4),
ccname varchar(32),
cctype varchar(10),
ccnum varchar(20),
ccexp varchar(5),
ccauth varchar(26),
cctrans varchar(26),
ship_name varchar(32),
addr1 varchar(64),
addr2 varchar(64),
city varchar(24),
state char(2),
zip varchar(12),
country varchar(24),
referred_by varchar(48),
ship_inst varchar(255),
notes varchar(255),
KEY invid (invid)
);
#
# Table structure for table 'lineitems'
# SHOPPING CART ITEMS:
CREATE TABLE lineitems (
lineid int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
invid smallint(6),
albumcode varchar(32),
quantity smallint(3),
price smallint(4),
linedate date,
description varchar(32),
KEY lineid (lineid)
);
Derek Sivers, CD Baby
18 Juniper Lane, Woodstock NY 12498
(914)679-0150 | [EMAIL PROTECTED]
www.cdbaby.com | www.cdbaby.net
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Site: http://www.working-dogs.com/freetrade/
Problems?: [EMAIL PROTECTED]
