In Progress

Creating a backend Mysql for an xml file


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" >23.00</range>

<range from="501" to="1000" carriername="DHL" >29.00</range>

<range from="1001" to="1500" carriername="DHL" >35.00</range>

<range from="1501" to="2000" carriername="DHL" >41.00</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.


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.

If you are unable to view the .xml file, I have attached a pdf of the same.Kindly go through that

Skills: MySQL, PHP, XML

See more: xml backend mysql, backend xml, mysql xml, hi 5 usa, 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

About the Employer:
( 1 review ) Puttaparti, India

Project ID: #1139346

10 freelancers are bidding on average $84 for this job


Lets do this! See PMB

$70 USD in 2 days
(109 Reviews)

please check PM

$70 USD in 2 days
(147 Reviews)

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

$200 USD in 4 days
(25 Reviews)

Hi, Please check PMB.

$80 USD in 3 days
(40 Reviews)

Kindly see PMB.

$50 USD in 1 day
(34 Reviews)

Please read my message I can do this..thanks

$50 USD in 2 days
(11 Reviews)

Hello, view PMB

$50 USD in 0 days
(12 Reviews)

Please check PMB for more details. Thanks

$40 USD in 1 day
(2 Reviews)

ready to work with u

$50 USD in 0 days
(0 Reviews)

Kindly Check PM.

$180 USD in 3 days
(1 Review)