I gang

OSCommerce ZIP+4 based tax rate upload

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 [url removed, login to view]

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

Færdigheder: Databehandling, PHP, Indkøbsvogne

Se mere: tax rate zip, oscommerce tax rates zip codes, oscommerce zip plus, update oscommerce 2.2 to 2.3.1, to get tax file number, structure stores, php codes list, oscommerce 2.2, five below, data structure type, csv codes, add state local taxes oscommerce, oscommerce zip file linux, oscommerce zip, tax rate 98001, oscommerce tax rates dont work, 98001 tax rate, oscommerce zip code, oscommerce local tax database, zip plus table, tax provider table zip, state tax rate 98001, tax rates based postal codes oscommerce, commerce determine tax rate use, freelance rates based zip code

Om arbejdsgiveren:
( 3 bedømmelser ) Renton, United States

Projekt-ID: #281764