osCommerce and osCMax shopping cart software forums

Shopping Cart Software

osCommerce with teeth!

 

Sales tax by county in California

This is a discussion on Sales tax by county in California within the osCommerce 2.2 Modification Help forums, part of the osCommerce 2.2 Forums category; I am sure we're not the first and only people trying to accomplish this. The built-in tax module can handle ...



Find us on Facebook
Go Back   osCommerce and osCMax shopping cart software forums > osCommerce 2.2 Forums > osCommerce 2.2 Modification Help

Sales tax by county in California Sales tax by county in California

Connect with Facebook Register FAQDonate Members List Calendar Mark Forums Read


Closed Thread

 

LinkBack Thread Tools
  #1  
Old 10-01-2008, 09:21 AM
Lurker
  
Join Date: Oct 2008
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
concept27 is on a distinguished road
Default Sales tax by county in California
I am sure we're not the first and only people trying to accomplish this. The built-in tax module can handle in-state and out-of-state tax pretty well. The problem is, we have different sales tax rates in different counties in California. I have looked in several forums and was unable to find anything created to handle this. Any suggestions anyone? This is what we are trying to accomplish:

Our Store = based in California, Los Angeles County =Tax rate 8.25%
Orders from Los Angeles County = charge 8.25%
Orders from all other California Counties = charge their respective rate
Order from the rest of the US = no tax

Thank you in advance.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #2  
Old 10-02-2008, 12:34 AM
jpf's Avatar
jpf jpf is offline
Moderator

  
Join Date: Sep 2003
Location: Manitoba, Canada
Posts: 2,681
Thanks: 12
Thanked 214 Times in 196 Posts
Rep Power: 20
jpf has much to be proud ofjpf has much to be proud ofjpf has much to be proud ofjpf has much to be proud ofjpf has much to be proud ofjpf has much to be proud ofjpf has much to be proud ofjpf has much to be proud ofjpf has much to be proud of
Default Re: Sales tax by county in California
Use zones - and such as running this SQL:
(Note - this removes any existing tax setup)
BACKUP YOUR SQL FIRST!!!!
Code:
###############Geo_Zones###########
# Clears anything in tables...
DROP TABLE IF EXISTS geo_zones;
CREATE TABLE geo_zones (
  geo_zone_id int NOT NULL auto_increment,
  geo_zone_name varchar(32) NOT NULL,
  geo_zone_description varchar(255) NOT NULL,
  last_modified datetime,
  date_added datetime NOT NULL,
  PRIMARY KEY (geo_zone_id)
);

# (geo_zone_id, geo_zone_name, geo_zone_description, last_modified, date_added)
INSERT INTO geo_zones VALUES (1, 'Alameda, CA Tax Zone', 'California Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO geo_zones VALUES (2, 'Alpine, CA Tax Zone', 'California Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO geo_zones VALUES (3, 'Amador, CA Tax Zone', 'California Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO geo_zones VALUES (4, 'Butte, CA Tax Zone', 'California Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO geo_zones VALUES (5, 'Calavera, CA Tax Zone', 'California Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO geo_zones VALUES (6, 'Colusa, CA Tax Zone', 'California Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO geo_zones VALUES (7, 'Contra Costa, CA Tax Zone', 'California Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO geo_zones VALUES (8, 'Del Norte, CA Tax Zone', 'California Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO geo_zones VALUES (9, 'El Dorado, CA Tax Zone', 'California Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO geo_zones VALUES (10, 'Fresno, CA Tax Zone', 'California Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO geo_zones VALUES (11, 'Glenn, CA Tax Zone', 'California Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO geo_zones VALUES (12, 'Humboldt, CA Tax Zone', 'California Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO geo_zones VALUES (13, 'Imperial, CA Tax Zone', 'California Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO geo_zones VALUES (14, 'Inyo, CA Tax Zone', 'California Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO geo_zones VALUES (15, 'Kern, CA Tax Zone', 'California Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO geo_zones VALUES (16, 'Kings, CA Tax Zone', 'California Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO geo_zones VALUES (17, 'Lake, CA Tax Zone', 'California Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO geo_zones VALUES (18, 'Lassen, CA Tax Zone', 'California Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO geo_zones VALUES (19, 'Los Angeles, CA Tax Zone', 'California Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO geo_zones VALUES (20, 'Madera, CA Tax Zone', 'California Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO geo_zones VALUES (21, 'Marin, CA Tax Zone', 'California Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO geo_zones VALUES (22, 'Mariposa, CA Tax Zone', 'California Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO geo_zones VALUES (23, 'Mendocino, CA Tax Zone', 'California Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO geo_zones VALUES (24, 'Merced, CA Tax Zone', 'California Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO geo_zones VALUES (25, 'Modoc, CA Tax Zone', 'California Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO geo_zones VALUES (26, 'Mono, CA Tax Zone', 'California Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO geo_zones VALUES (27, 'Monterey, CA Tax Zone', 'California Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO geo_zones VALUES (28, 'Napa, CA Tax Zone', 'California Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO geo_zones VALUES (29, 'Nevada, CA Tax Zone', 'California Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO geo_zones VALUES (30, 'Orange, CA Tax Zone', 'California Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO geo_zones VALUES (31, 'Placer, CA Tax Zone', 'California Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO geo_zones VALUES (32, 'Plumas, CA Tax Zone', 'California Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO geo_zones VALUES (33, 'Riverside, CA Tax Zone', 'California Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO geo_zones VALUES (34, 'Sacramento, CA Tax Zone', 'California Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO geo_zones VALUES (35, 'San Benito, CA Tax Zone', 'California Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO geo_zones VALUES (36, 'San Bernadino, CA Tax Zone', 'California Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO geo_zones VALUES (37, 'San Diego, CA Tax Zone', 'California Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO geo_zones VALUES (38, 'San Francisco, CA Tax Zone', 'California Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO geo_zones VALUES (39, 'San Joaquin, CA Tax Zone', 'California Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO geo_zones VALUES (40, 'San Luis Obispo, CA Tax Zone', 'California Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO geo_zones VALUES (41, 'San Mateo, CA Tax Zone', 'California Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO geo_zones VALUES (42, 'Santa Barbara, CA Tax Zone', 'California Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO geo_zones VALUES (43, 'Santa Clara, CA Tax Zone', 'California Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO geo_zones VALUES (44, 'Shasta, CA Tax Zone', 'California Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO geo_zones VALUES (45, 'Sierra, CA Tax Zone', 'California Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO geo_zones VALUES (46, 'Siskiyou, CA Tax Zone', 'California Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO geo_zones VALUES (47, 'Solano, CA Tax Zone', 'California Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO geo_zones VALUES (48, 'Sonoma, CA Tax Zone', 'California Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO geo_zones VALUES (49, 'Stanislaus, CA Tax Zone', 'California Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO geo_zones VALUES (50, 'Sutter, CA Tax Zone', 'California Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO geo_zones VALUES (51, 'Tehama, CA Tax Zone', 'California Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO geo_zones VALUES (52, 'Trinity, CA Tax Zone', 'California Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO geo_zones VALUES (53, 'Tulare, CA Tax Zone', 'California Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO geo_zones VALUES (54, 'Tuolumne, CA Tax Zone', 'California Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO geo_zones VALUES (55, 'Ventura, CA Tax Zone', 'California Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO geo_zones VALUES (56, 'Yolo, CA Tax Zone', 'California Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO geo_zones VALUES (57, 'Yuba, CA Tax Zone', 'California Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO geo_zones VALUES (58, 'Santa Cruz, CA Tax Zone', 'California Sales Tax', NULL, '0000-00-00 00:00:00');

###############Tax_Class###########
# Clears anything in tables...
DROP TABLE IF EXISTS tax_class;
CREATE TABLE tax_class (
  tax_class_id int NOT NULL auto_increment,
  tax_class_title varchar(32) NOT NULL,
  tax_class_description varchar(255) NOT NULL,
  last_modified datetime NULL,
  date_added datetime NOT NULL,
  PRIMARY KEY (tax_class_id)
);

INSERT INTO tax_class VALUES (1, 'Taxable Goods', 'The following types of products are included non-food, services, etc', NULL, '0000-00-00 00:00:00');

###############Tax_Rates###########
# Clears anything in tables...
DROP TABLE IF EXISTS tax_rates;
CREATE TABLE tax_rates (
  tax_rates_id int NOT NULL auto_increment,
  tax_zone_id int NOT NULL,
  tax_class_id int NOT NULL,
  tax_priority int(5) DEFAULT 1,
  tax_rate decimal(7,4) NOT NULL,
  tax_description varchar(255) NOT NULL,
  last_modified datetime NULL,
  date_added datetime NOT NULL,
  PRIMARY KEY (tax_rates_id)
);

# (tax_rates_id, tax_zone_id, tax_class_id, tax_priority, tax_rate, tax_description, last_modified, date_added)
INSERT INTO tax_rates VALUES (1, 1, 1, 1, '8.2500', '8.25% CA Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO tax_rates VALUES (2, 2, 1, 1, '7.2500', '7.25% CA Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO tax_rates VALUES (3, 3, 1, 1, '7.2500', '7.25% CA Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO tax_rates VALUES (4, 4, 1, 1, '7.2500', '7.25% CA Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO tax_rates VALUES (5, 5, 1, 1, '7.2500', '7.25% CA Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO tax_rates VALUES (6, 6, 1, 1, '7.2500', '7.25% CA Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO tax_rates VALUES (7, 7, 1, 1, '8.2500', '8.25% CA Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO tax_rates VALUES (8, 8, 1, 1, '7.2500', '7.25% CA Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO tax_rates VALUES (9, 9, 1, 1, '7.2500', '7.25% CA Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO tax_rates VALUES (10, 10, 1, 1, '7.8750', '7.875% CA Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO tax_rates VALUES (11, 11, 1, 1, '7.2500', '7.25% CA Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO tax_rates VALUES (12, 12, 1, 1, '7.2500', '7.25% CA Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO tax_rates VALUES (13, 13, 1, 1, '7.7500', '7.75% CA Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO tax_rates VALUES (14, 14, 1, 1, '7.7500', '7.75% CA Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO tax_rates VALUES (15, 15, 1, 1, '7.2500', '7.25% CA Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO tax_rates VALUES (16, 16, 1, 1, '7.2500', '7.25% CA Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO tax_rates VALUES (17, 17, 1, 1, '7.2500', '7.25% CA Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO tax_rates VALUES (18, 18, 1, 1, '7.2500', '7.25% CA Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO tax_rates VALUES (19, 19, 1, 1, '8.2500', '8.25% CA Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO tax_rates VALUES (20, 20, 1, 1, '7.7500', '7.75% CA Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO tax_rates VALUES (21, 21, 1, 1, '7.2500', '7.25% CA Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO tax_rates VALUES (22, 22, 1, 1, '7.7500', '7.75% CA Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO tax_rates VALUES (23, 23, 1, 1, '7.2500', '7.25% CA Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO tax_rates VALUES (24, 24, 1, 1, '7.2500', '7.25% CA Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO tax_rates VALUES (25, 25, 1, 1, '7.2500', '7.25% CA Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO tax_rates VALUES (26, 26, 1, 1, '7.2500', '7.25% CA Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO tax_rates VALUES (27, 27, 1, 1, '7.2500', '7.25% CA Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO tax_rates VALUES (28, 28, 1, 1, '7.7500', '7.75% CA Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO tax_rates VALUES (29, 29, 1, 1, '7.3750', '7.375% CA Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO tax_rates VALUES (30, 30, 1, 1, '7.7500', '7.75% CA Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO tax_rates VALUES (31, 31, 1, 1, '7.2500', '7.25% CA Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO tax_rates VALUES (32, 32, 1, 1, '7.2500', '7.25% CA Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO tax_rates VALUES (33, 33, 1, 1, '7.7500', '7.75% CA Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO tax_rates VALUES (34, 34, 1, 1, '7.7500', '7.75% CA Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO tax_rates VALUES (35, 35, 1, 1, '7.2500', '7.25% CA Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO tax_rates VALUES (36, 36, 1, 1, '7.7500', '7.75% CA Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO tax_rates VALUES (37, 37, 1, 1, '7.7500', '7.75% CA Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO tax_rates VALUES (38, 38, 1, 1, '8.5000', '8.50% CA Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO tax_rates VALUES (39, 39, 1, 1, '7.7500', '7.75% CA Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO tax_rates VALUES (40, 40, 1, 1, '7.2500', '7.25% CA Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO tax_rates VALUES (41, 41, 1, 1, '8.2500', '8.25% CA Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO tax_rates VALUES (42, 42, 1, 1, '7.7500', '7.75% CA Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO tax_rates VALUES (43, 43, 1, 1, '8.2500', '8.25% CA Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO tax_rates VALUES (44, 44, 1, 1, '8.0000', '8.00% CA Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO tax_rates VALUES (45, 45, 1, 1, '7.2500', '7.25% CA Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO tax_rates VALUES (46, 46, 1, 1, '7.2500', '7.25% CA Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO tax_rates VALUES (47, 47, 1, 1, '7.2500', '7.25% CA Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO tax_rates VALUES (48, 48, 1, 1, '7.3750', '7.375% CA Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO tax_rates VALUES (49, 49, 1, 1, '7.5000', '7.50% CA Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO tax_rates VALUES (50, 50, 1, 1, '7.3750', '7.375% CA Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO tax_rates VALUES (51, 51, 1, 1, '7.2500', '7.25% CA Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO tax_rates VALUES (52, 52, 1, 1, '7.2500', '7.25% CA Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO tax_rates VALUES (53, 53, 1, 1, '7.2500', '7.25% CA Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO tax_rates VALUES (54, 54, 1, 1, '7.2500', '7.25% CA Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO tax_rates VALUES (55, 55, 1, 1, '7.2500', '7.25% CA Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO tax_rates VALUES (56, 56, 1, 1, '7.2500', '7.25% CA Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO tax_rates VALUES (57, 57, 1, 1, '7.2500', '7.25% CA Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO tax_rates VALUES (58, 58, 1, 1, '7.2500', '7.25% CA Sales Tax', NULL, '0000-00-00 00:00:00');
INSERT INTO tax_rates VALUES (59, 59, 1, 1, '7.2500', '7.25% CA Sales Tax', NULL, '0000-00-00 00:00:00');

###############zones###########
# remove single (12,223,'CA','California')
DELETE FROM zones WHERE zones.zone_id = 12;

# Add new zones
# (zone_id, zone_country_id, zone_code, zone_name)
INSERT INTO zones VALUES (182, 223, 'CA', 'Alameda County, CA');
INSERT INTO zones VALUES (183, 223, 'CA', 'Alpine County, CA');
INSERT INTO zones VALUES (184, 223, 'CA', 'Amador County, CA');
INSERT INTO zones VALUES (185, 223, 'CA', 'Butte County, CA');
INSERT INTO zones VALUES (186, 223, 'CA', 'Calavera County, CA');
INSERT INTO zones VALUES (187, 223, 'CA', 'Colusa County, CA');
INSERT INTO zones VALUES (188, 223, 'CA', 'Contra Costa County, CA');
INSERT INTO zones VALUES (189, 223, 'CA', 'Del Norte County, CA');
INSERT INTO zones VALUES (190, 223, 'CA', 'El Dorado County, CA');
INSERT INTO zones VALUES (191, 223, 'CA', 'Fresno County, CA');
INSERT INTO zones VALUES (192, 223, 'CA', 'Glenn County, CA');
INSERT INTO zones VALUES (193, 223, 'CA', 'Humboldt County, CA');
INSERT INTO zones VALUES (194, 223, 'CA', 'Imperial County, CA');
INSERT INTO zones VALUES (195, 223, 'CA', 'Inyo County, CA');
INSERT INTO zones VALUES (196, 223, 'CA', 'Kern County, CA');
INSERT INTO zones VALUES (197, 223, 'CA', 'Kings County, CA');
INSERT INTO zones VALUES (198, 223, 'CA', 'Lake County, CA');
INSERT INTO zones VALUES (199, 223, 'CA', 'Lassen County, CA');
INSERT INTO zones VALUES (200, 223, 'CA', 'Los Angeles County, CA');
INSERT INTO zones VALUES (201, 223, 'CA', 'Madera County, CA');
INSERT INTO zones VALUES (202, 223, 'CA', 'Marin County, CA');
INSERT INTO zones VALUES (203, 223, 'CA', 'Mariposa County, CA');
INSERT INTO zones VALUES (204, 223, 'CA', 'Mendocino County, CA');
INSERT INTO zones VALUES (205, 223, 'CA', 'Merced County, CA');
INSERT INTO zones VALUES (206, 223, 'CA', 'Modoc County, CA');
INSERT INTO zones VALUES (207, 223, 'CA', 'Mono County, CA');
INSERT INTO zones VALUES (208, 223, 'CA', 'Monterey County, CA');
INSERT INTO zones VALUES (209, 223, 'CA', 'Napa County, CA');
INSERT INTO zones VALUES (210, 223, 'CA', 'Nevada County, CA');
INSERT INTO zones VALUES (211, 223, 'CA', 'Orange County, CA');
INSERT INTO zones VALUES (212, 223, 'CA', 'Placer County, CA');
INSERT INTO zones VALUES (213, 223, 'CA', 'Plumas County, CA');
INSERT INTO zones VALUES (214, 223, 'CA', 'Riverside County, CA');
INSERT INTO zones VALUES (215, 223, 'CA', 'Sacramento County, CA');
INSERT INTO zones VALUES (216, 223, 'CA', 'San Benito County, CA');
INSERT INTO zones VALUES (217, 223, 'CA', 'San Bernadino County, CA');
INSERT INTO zones VALUES (218, 223, 'CA', 'San Diego County, CA');
INSERT INTO zones VALUES (219, 223, 'CA', 'San Francisco County, CA');
INSERT INTO zones VALUES (220, 223, 'CA', 'San Joaquin County, CA');
INSERT INTO zones VALUES (221, 223, 'CA', 'San Luis Obispo County, CA');
INSERT INTO zones VALUES (222, 223, 'CA', 'San Mateo County, CA');
INSERT INTO zones VALUES (223, 223, 'CA', 'Santa Barbara County, CA');
INSERT INTO zones VALUES (224, 223, 'CA', 'Santa Clara County, CA');
INSERT INTO zones VALUES (225, 223, 'CA', 'Shasta County, CA');
INSERT INTO zones VALUES (226, 223, 'CA', 'Sierra County, CA');
INSERT INTO zones VALUES (227, 223, 'CA', 'Siskiyou County, CA');
INSERT INTO zones VALUES (228, 223, 'CA', 'Solano County, CA');
INSERT INTO zones VALUES (229, 223, 'CA', 'Sonoma County, CA');
INSERT INTO zones VALUES (230, 223, 'CA', 'Stanislaus County, CA');
INSERT INTO zones VALUES (231, 223, 'CA', 'Sutter County, CA');
INSERT INTO zones VALUES (232, 223, 'CA', 'Tehama County, CA');
INSERT INTO zones VALUES (233, 223, 'CA', 'Trinity County, CA');
INSERT INTO zones VALUES (234, 223, 'CA', 'Tulare County, CA');
INSERT INTO zones VALUES (235, 223, 'CA', 'Tuolumne County, CA');
INSERT INTO zones VALUES (236, 223, 'CA', 'Ventura County, CA');
INSERT INTO zones VALUES (237, 223, 'CA', 'Yolo County, CA');
INSERT INTO zones VALUES (238, 223, 'CA', 'Yuba County, CA');
INSERT INTO zones VALUES (239, 223, 'CA', 'Santa Cruz County, CA');


###############zones_to_geo_zones###########
# Clears anything in tables...
DROP TABLE IF EXISTS zones_to_geo_zones;
CREATE TABLE zones_to_geo_zones (
  association_id int NOT NULL auto_increment,
  zone_country_id int NOT NULL,
  zone_id int NULL,
  geo_zone_id int NULL,
  last_modified datetime NULL,
  date_added datetime NOT NULL,
  PRIMARY KEY (association_id),
  KEY idx_zones_to_geo_zones_country_id (zone_country_id)
);


# (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added)
INSERT INTO zones_to_geo_zones VALUES (1, 223, 182, 1, NULL, '0000-00-00 00:00:00');
INSERT INTO zones_to_geo_zones VALUES (2, 223, 183, 2, NULL, '0000-00-00 00:00:00');
INSERT INTO zones_to_geo_zones VALUES (3, 223, 184, 3, NULL, '0000-00-00 00:00:00');
INSERT INTO zones_to_geo_zones VALUES (4, 223, 185, 4, NULL, '0000-00-00 00:00:00');
INSERT INTO zones_to_geo_zones VALUES (5, 223, 186, 5, NULL, '0000-00-00 00:00:00');
INSERT INTO zones_to_geo_zones VALUES (6, 223, 187, 6, NULL, '0000-00-00 00:00:00');
INSERT INTO zones_to_geo_zones VALUES (7, 223, 188, 7, NULL, '0000-00-00 00:00:00');
INSERT INTO zones_to_geo_zones VALUES (8, 223, 189, 8, NULL, '0000-00-00 00:00:00');
INSERT INTO zones_to_geo_zones VALUES (9, 223, 190, 9, NULL, '0000-00-00 00:00:00');
INSERT INTO zones_to_geo_zones VALUES (10, 223, 191, 10, NULL, '0000-00-00 00:00:00');
INSERT INTO zones_to_geo_zones VALUES (11, 223, 192, 11, NULL, '0000-00-00 00:00:00');
INSERT INTO zones_to_geo_zones VALUES (12, 223, 193, 12, NULL, '0000-00-00 00:00:00');
INSERT INTO zones_to_geo_zones VALUES (13, 223, 194, 13, NULL, '0000-00-00 00:00:00');
INSERT INTO zones_to_geo_zones VALUES (14, 223, 195, 14, NULL, '0000-00-00 00:00:00');
INSERT INTO zones_to_geo_zones VALUES (15, 223, 196, 15, NULL, '0000-00-00 00:00:00');
INSERT INTO zones_to_geo_zones VALUES (16, 223, 197, 16, NULL, '0000-00-00 00:00:00');
INSERT INTO zones_to_geo_zones VALUES (17, 223, 198, 17, NULL, '0000-00-00 00:00:00');
INSERT INTO zones_to_geo_zones VALUES (18, 223, 199, 18, NULL, '0000-00-00 00:00:00');
INSERT INTO zones_to_geo_zones VALUES (19, 223, 200, 19, NULL, '0000-00-00 00:00:00');
INSERT INTO zones_to_geo_zones VALUES (20, 223, 201, 20, NULL, '0000-00-00 00:00:00');
INSERT INTO zones_to_geo_zones VALUES (21, 223, 202, 21, NULL, '0000-00-00 00:00:00');
INSERT INTO zones_to_geo_zones VALUES (22, 223, 203, 22, NULL, '0000-00-00 00:00:00');
INSERT INTO zones_to_geo_zones VALUES (23, 223, 204, 23, NULL, '0000-00-00 00:00:00');
INSERT INTO zones_to_geo_zones VALUES (24, 223, 205, 24, NULL, '0000-00-00 00:00:00');
INSERT INTO zones_to_geo_zones VALUES (25, 223, 206, 25, NULL, '0000-00-00 00:00:00');
INSERT INTO zones_to_geo_zones VALUES (26, 223, 207, 26, NULL, '0000-00-00 00:00:00');
INSERT INTO zones_to_geo_zones VALUES (27, 223, 208, 27, NULL, '0000-00-00 00:00:00');
INSERT INTO zones_to_geo_zones VALUES (28, 223, 209, 28, NULL, '0000-00-00 00:00:00');
INSERT INTO zones_to_geo_zones VALUES (29, 223, 210, 29, NULL, '0000-00-00 00:00:00');
INSERT INTO zones_to_geo_zones VALUES (30, 223, 211, 30, NULL, '0000-00-00 00:00:00');
INSERT INTO zones_to_geo_zones VALUES (31, 223, 212, 31, NULL, '0000-00-00 00:00:00');
INSERT INTO zones_to_geo_zones VALUES (32, 223, 213, 32, NULL, '0000-00-00 00:00:00');
INSERT INTO zones_to_geo_zones VALUES (33, 223, 214, 33, NULL, '0000-00-00 00:00:00');
INSERT INTO zones_to_geo_zones VALUES (34, 223, 215, 34, NULL, '0000-00-00 00:00:00');
INSERT INTO zones_to_geo_zones VALUES (35, 223, 216, 35, NULL, '0000-00-00 00:00:00');
INSERT INTO zones_to_geo_zones VALUES (36, 223, 217, 36, NULL, '0000-00-00 00:00:00');
INSERT INTO zones_to_geo_zones VALUES (37, 223, 218, 37, NULL, '0000-00-00 00:00:00');
INSERT INTO zones_to_geo_zones VALUES (38, 223, 219, 38, NULL, '0000-00-00 00:00:00');
INSERT INTO zones_to_geo_zones VALUES (39, 223, 220, 39, NULL, '0000-00-00 00:00:00');
INSERT INTO zones_to_geo_zones VALUES (40, 223, 221, 40, NULL, '0000-00-00 00:00:00');
INSERT INTO zones_to_geo_zones VALUES (41, 223, 222, 41, NULL, '0000-00-00 00:00:00');
INSERT INTO zones_to_geo_zones VALUES (42, 223, 223, 42, NULL, '0000-00-00 00:00:00');
INSERT INTO zones_to_geo_zones VALUES (43, 223, 224, 43, NULL, '0000-00-00 00:00:00');
INSERT INTO zones_to_geo_zones VALUES (44, 223, 225, 44, NULL, '0000-00-00 00:00:00');
INSERT INTO zones_to_geo_zones VALUES (45, 223, 226, 45, NULL, '0000-00-00 00:00:00');
INSERT INTO zones_to_geo_zones VALUES (46, 223, 227, 46, NULL, '0000-00-00 00:00:00');
INSERT INTO zones_to_geo_zones VALUES (47, 223, 228, 47, NULL, '0000-00-00 00:00:00');
INSERT INTO zones_to_geo_zones VALUES (48, 223, 229, 48, NULL, '0000-00-00 00:00:00');
INSERT INTO zones_to_geo_zones VALUES (49, 223, 230, 49, NULL, '0000-00-00 00:00:00');
INSERT INTO zones_to_geo_zones VALUES (50, 223, 231, 50, NULL, '0000-00-00 00:00:00');
INSERT INTO zones_to_geo_zones VALUES (51, 223, 232, 51, NULL, '0000-00-00 00:00:00');
INSERT INTO zones_to_geo_zones VALUES (52, 223, 233, 52, NULL, '0000-00-00 00:00:00');
INSERT INTO zones_to_geo_zones VALUES (53, 223, 234, 53, NULL, '0000-00-00 00:00:00');
INSERT INTO zones_to_geo_zones VALUES (54, 223, 235, 54, NULL, '0000-00-00 00:00:00');
INSERT INTO zones_to_geo_zones VALUES (55, 223, 236, 55, NULL, '0000-00-00 00:00:00');
INSERT INTO zones_to_geo_zones VALUES (56, 223, 237, 56, NULL, '0000-00-00 00:00:00');
INSERT INTO zones_to_geo_zones VALUES (57, 223, 238, 57, NULL, '0000-00-00 00:00:00');
INSERT INTO zones_to_geo_zones VALUES (58, 223, 239, 58, NULL, '0000-00-00 00:00:00');
INSERT INTO zones_to_geo_zones VALUES (59, 223, 240, 59, NULL, '0000-00-00 00:00:00');
Change your ENGLISH.PHP file:
PHP Code:
define('ENTRY_STATE', 'State/Province:'); 
to
PHP Code:
define('ENTRY_STATE', 'County/State/Province:'); 
There are OTHER modification possable - but this is a SIMPLE database only option.
Note: you have to verify county tax amount.....
__________________
JPF - osCMax Fourm Moderator - To contact, post on the forum or click here
Try out our osCMax at: Live Catalog Demo
Limited access Admin: Live Admin Demo
Feel free to add products they way you want and then purchase them -=+=- Sorry nothing will be billed or shipped!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #3  
Old 10-02-2008, 09:25 AM
Lurker
  
Join Date: Oct 2008
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
concept27 is on a distinguished road
Default Re: Sales tax by county in California
Dude...you ROCK!!! Let me get crackin' on this right now. I'll post if this worked. Thank you sooo much for this quick fix.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Closed Thread

« how to replace oscommerce image | How to add more pictures for one product »
Thread Tools

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
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads

Thread Thread Starter Forum Replies Last Post
OHIO OH Sales Tax By County michael_s New osCommerce Contributions 1 11-10-2008 03:20 PM
OHIO OH Sales Tax By County michael_s New osCommerce Contributions 0 04-23-2007 10:13 AM
County Sales Tax by Zip Code michael_s New osCommerce Contributions 0 03-27-2007 09:11 PM
Desperate for Help! County Sales Tax marcygiff osCommerce 2.2 Modification Help 1 01-19-2007 11:03 AM
California Sales Tax - Ugh draeseke osCommerce 2.2 Modification Help 3 08-17-2003 08:45 AM


All times are GMT -8. The time now is 05:48 PM.

osCMax Home - Site Map - Top

Powered by vBulletin®
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
SEO by vBSEO
Copyright 2009 osCMax
Inactive Reminders By Icora Web Design