In Progress

Creating a backend Mysql for an xml file

Hi

I have a [url removed, login to view] file with me. It contains the following information

1. Sale price of products

2. Weight of the products

3. Category of the products

4. Postage Charges for the products to different countries which would also differ with weights.

There are totally 223 locations or countries for which I have to manually enter the postages rates.

For eg: for location1(USA)

<range from="0" to="500" carriername="DHL" >[url removed, login to view]</range>

<range from="501" to="1000" carriername="DHL" >[url removed, login to view]</range>

<range from="1001" to="1500" carriername="DHL" >[url removed, login to view]</range>

<range from="1501" to="2000" carriername="DHL" >[url removed, login to view]</range>

And this will continue till 1,00,000. All these number are in gms. Depending on the products and place selected by customers, the postage is calculated.

Problem:

The Problem is that I have to enter all these manually and I have done it. When there is a change in the rates by the carrier agency, the problem arises. I will have to manually modify all the rates for all the 223 countries in the xml file. What I want is to have a backend mysql database for these ranges(weights) and rates, so that whenever there is an increase of 2% or 5% or 10%, I can just change the percent(can be + or -) in the mysql database and these postal charges should get automatically recalculated and appear in the xml file. Sometimes there can be change in rates for only few locations too.I have attached the xml file. Please have a look at it . I want this to be done in 2-3 days time.

Skills: MySQL, PHP, XML

See more: xml backend mysql, backend xml, mysql xml, backend, 501 , 1500 mysql, xml file appear, xml enter, backend database, postal database, countries xml file, mysql backend, manually done products, mysql modify, price change products, modify xml automatically, dhl xml php, php mysql backend, database backend, backend php xml, xml mysql 2011, please attached file, mysql problem, php dhl xml, dhl php xml

About the Employer:
( 1 review ) Puttaparti, India

Project ID: #1139346

10 freelancers are bidding on average $84 for this job

Dunkoh

Lets do this! See PMB

$70 USD in 2 days
(109 Reviews)
6.9
rajawi9999

please check PM

$70 USD in 2 days
(147 Reviews)
6.5
stdhtelkom

Hi. I can help you with warranty. Thanks, Steve

$200 USD in 4 days
(25 Reviews)
6.1
hiukim

Hi, Please check PMB.

$80 USD in 3 days
(40 Reviews)
5.5
valleysoftware

Kindly see PMB.

$50 USD in 1 day
(34 Reviews)
5.1
freelancer0101

Please read my message I can do this..thanks

$50 USD in 2 days
(11 Reviews)
4.4
tehnicsmart

Hello, view PMB

$50 USD in 0 days
(12 Reviews)
3.7
hemi

Please check PMB for more details. Thanks

$40 USD in 1 day
(2 Reviews)
2.0
satyapalgarhwal

ready to work with u

$50 USD in 0 days
(0 Reviews)
1.8
citor

Kindly Check PM.

$180 USD in 3 days
(1 Review)
0.0