Đã Hủy

Store Finder. Cron toExport from mysql database to XML

Like many businesses who publish a “where to buy” part of their website I want a ‘Garden Store Finder’ to drive traffic to my site and improve search engine ratings.

Part I. EXPORT MYSQL TO XML

I have an existing sugarCRM database with approximately 2,100 garden store records. I want a cron* built that will export selected fields from all records in ‘leads’ into XML, unless the record is marked for DoNotPublish. The subject data is business contact information (business name, phone number, address, URL, etc, plus a brief description in a textbox.)

*In addition to the the cron, I should be able to execute this export on demand.

Resulting XML is to be stored on a publicly accessible portion of the website and should be visible to search engines. It will be stored in sugarCRM’s parent directory. The sugarCRM and its database is for internal use and should NOT be visible to any website vistors.

Part II. Build webpage with search dialog and results table.

The search dialog will be at the top of the page and will remain even after results are displayed in the table. Search options will include (1) by phone area code, (2) by city and state, and (3) within a distance in miles (selected by dropdown) of a specific zip (postal) code.

Additionally, two checkboxes will filter the results – (1) Show only businesses that carry our product or all businesses, and (2) show garden stores only or show all stores.

This page should include CSS to allow us to change the background, table, borders, and font, to match the rest of our site. Colors to initially be set to black background with green text.

Part III. SEO

Ensure that page is set up to rate highly for the following searches:

“Growshop”, “Find growstore”, “Find growshop”, “Find local growshop”, “Hydroponics store”.

Ensure that the XML data is visible to seach engines. E.g. if “ABC Hydroponics” is searched on google, our site should be displayed “ABC Hydroponics: Gardenstore Finder by Resin-X”

Your input on this project and SEO is welcome.

Please read the project first and write the word "Understood". Also write your steps and suggestions to complete the project with a short description of what you understood.

Kỹ năng: MySQL, Thiết kế trang web, XML

Xem thêm: cron mysql export xml, write xml code website, within subject design, want find part business, traffic demand, sugarcrm design, seo export business, seo export, publish website google, product database design, mysql city state database, first seach, cron design, build green, plus google local, mysql top, css store, steps product design, xml export, store business, set store, resin product, mysql dropdown, mysql database design, google plus first page

Về Bên Thuê:
( 91 nhận xét ) Cairo, Egypt

Mã Dự Án: #1678524

1 freelancer đang chào giá trung bình $120 cho công việc này

Und7O6D4R

Custom Software Development - <b><i>Removed by Admin</i></b>

$120 USD trong 1 ngày
(0 Đánh Giá)
0.0