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...
TWO PART EITHER/OR QUESTION:
1. Has someone seen a decent basic shopping cart (PHPLIB?) that works
well, looks good, and is easy to use?
Something that will let us just add an item into a cart, remember a user
when they come back, show them their total with shipping, and insert that
info into our MySQL database?
In other words: If FreeTrade is best, what's 2nd best?
or...
2. Is it really possible to make FreeTrade flex to match our tables...?
#
# 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]
