OSCommerce ZIP+4 based tax rate upload

OSCommerce ZIP+4 based tax rate upload is project number 281764 posted at GetAFreelancer.com. Click here to post your own project.

Closed
(Selected Service Provider yourssincerely)

Status:	Closed
Budget:	$30-250
Created:	07/03/2008 at 3:46 EDT
Bidding Ends:	07/07/2008 at 3:46 EDT
Project Creator:	jzender   Buyer Rating: (No Feedback Yet)
Description:	OSCommerce admin user shall be able to upload a CSV file via an admin page and data will get posted automatically into stores database. Deliverables include: 1. create php page in admin side that allows upload of a zip file via browse button that allows the user to browse the local file structure or type in the path and file name in a editable file 2. below a selection list shall show description of tax_class_ids (table: tax_class – show all tax_class_title:tax_class_combination) 3. below a selection list shall show description of tax_zone_ids (table: geo_zones – show all geo_zone_name:geo_zone_description) 4. below a upload button shall be shown that triggers the actual upload. file format is as follows Field Name TYPE Description ZIP Varchar(5) Five-digit zip code PLUS4 Varchar(4) four-digit zip code extension CODE Varchar(4) Location code number STATE Decimal 7.4 State rate LOCAL Decimal 7.4 Local rate (For location codes in RTA areas, includes RTA rate) TOT_RATE Decimal 7.4 Combined state and local rates EFF_START Datetime YYYY-MM-DD 00:00:00 Rate effective start date EFF_END Datetime YYYY-MM-DD 23:59:59 Rate expiration date Sample data: 98001 0 1700 0.065 0.025 0.09 20080701 20080930 98001 1000 1700 0.065 0.025 0.09 20080701 20080930 98001 1001 1700 0.065 0.025 0.09 20080701 20080930 98001 1002 1700 0.065 0.025 0.09 20080701 20080930 98001 1003 1700 0.065 0.025 0.09 20080701 20080930 98001 1004 1700 0.065 0.025 0.09 20080701 20080930 98001 1005 1700 0.065 0.025 0.09 20080701 20080930 98001 1006 1700 0.065 0.025 0.09 20080701 20080930 98001 1007 1700 0.065 0.025 0.09 20080701 20080930 98001 1008 1700 0.065 0.025 0.09 20080701 20080930 98001 1009 1700 0.065 0.025 0.09 20080701 20080930 98001 1010 1700 0.065 0.025 0.09 20080701 20080930 98001 1011 1700 0.065 0.025 0.09 20080701 20080930 98001 1012 1700 0.065 0.025 0.09 20080701 20080930 Full file at http://dor.wa.gov/downloads/Add_Data/ZIP4Q308E.zip once file is uploaded, unzip and parse file into table: tax-rates as follows Tax_rates_id <unique ID> Tax_zone_id <geo_zone_id> based on user selection in selection list Tax_class_id <tax_class_id> based on user selection in selection list Tax_priority “0” Tax_rate <LOCAL field> Tax-description “^”<ZIP>”-“<PLUS4>”^county tax” (e.g. ^98123-1234^county tax Last_modified <update with time when updated> Date_added <add when created> Overwrite existing tax_rate_ids based on “^”<ZIP>”-“<PLUS4>”^ in tax description field 5. upon import show status message with number of rows in uploaded file and number of rows successfully imported 6. in case of error state error condition as part of status message. 7. delete uploaded file after import deliverable must include all source code and usage rights
Job Type:	Data Processing OsCommerce PHP
Database:	MySQL
Operating system:	Linux
Bid count:	4
Average bid:	N/A