Re: [phpwscommerce-devel] DB Beta

[Verdon V. <ve...@ve...>]

Just a couple quick comments...

1) very general - with phpws 1.x heading towards support for different  
databases, I believe there could be problems with the length of some  
table names in the future - might be good to prepare for that now

2) products table - in regards to taxes, I don't think just a taxable  
yes/no flag will be enough - as a Canadian, I have to deal with some  
very complex tax scenarios. Many carts I've looked at just aren't up to  
the task. One that is (though it can be complex to set-up the first  
time) is zen-cart - http://www.zen-cart.com

zencart uses a combination of tax zones, tax classes, and tax rates to  
determine the tax implications of any purchase. For instance, I might  
have a product which is a book which uses the special tax class for  
books, which depending on the zone that the shipping address falls into  
may be charged a tax rate for GST or a different tax rate for HST.  
Another product which is a widget uses the tax class for general  
taxable merchandise, which depending on the zone that the shipping  
address falls into may be charged a combined tax rate for PST and GST,  
or a single HST tax rate.

This post on the zen-cart forums is a tutorial for setting up such  
complex scenarios in zen-cart, that might provide some food for  
thought.
http://www.zen-cart.com/modules/ipb/index.php? 
showtopic=6344&st=0&#entry38336

Regards,
verdon


On 22-Feb-06, at 12:18 PM, Ken Nordquist wrote:

> Ok guys...  here is the link to the beta db for phpwscommerce.  I  
> included foreign key constraints which will help protect unintended  
> changes and deletions of records...  I am picking up where Wendall  
> left off on the products class...  I should be able to kick it out by  
> Monday for everyone's perusal.  Feedback on the db stuff is welcome  
> and solicited.
>
> Ken
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc. Do you grep through log  
> files
> for problems?  Stop!  Download the new AJAX search engine that makes
> searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
> http://sel.as-us.falkag.net/sel? 
> cmd=lnk&kid=103432&bid=230486&dat=121642
> _______________________________________________
> phpwsCommerce-devel mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwscommerce-devel
>
>