SERVER script update. xls file and magento CUSTOM integration

Closed

Take my customer xls file and import it into the magento database via a custom written server script program. It will do this once an hour based on a file that exists in the specified folder. Each time the file is queried it will analyze if a customer exists or not. If the customer does not exist, it will then create an account for the client in Magento. Then it will add generate a username and password and email that to the client along with the standard autoresponder welcome email.

Take my inventory xls file and import it into the Magento database via a custom written server script program. It will do this once an hour based on a file that exists in the specified folder. If an item exists, it will not add the item to the database but only update specific fields : quantity, class, price. If an item does NOT exist it will add it with full description and all other available fields that need to be imported to successfully add it to the website.

All relevant fields required will be explained but keep in mind that over 50% of the fields in each file will not be needed into the final import.

(customer file needs only grab their general contact information as well as their "tier" of client and their login information for the website they want).

(inventory file will have only about 30% of those fields needed)

Attached are the 2 xls files that need to be converted.

[url removed, login to view] is the inventory structure file and [url removed, login to view] is the customer database file.

Skills: Database Administration, MySQL, PHP, Software Architecture, Website Design

See more: autoresponder script php, xls, magento database, magento custom, client update required, grab website file, import files folder, customer email required magento, tier magento, update database email, inventory update, class custom php, inventory script magento, php add item php magento, inventory script php, php price update script, welcome script, add tier price magento, email database update, script inventory php, magento import customer database, import autoresponder, update inventory, contact import script, database update required

Project ID: #4859112

12 freelancers are bidding on average $362 for this job

srinichal

I can deliver the script to your specs

$263 USD in 6 days
(96 Reviews)
7.1
ranganathp

Can help... I am an Expert...

$695 USD in 15 days
(29 Reviews)
6.4
techwelfare

hi we could do it perfectly with accuracy, please let us know if you want any clarification. please check inbox for our previous work.

$572 USD in 16 days
(59 Reviews)
6.1
Alexod

I can do it

$144 USD in 3 days
(18 Reviews)
5.9
kiutisuperking

I can help you do it perfectly. I have more than 4 years work with Magento. Hope we'll work together, thanks!

$315 USD in 6 days
(66 Reviews)
5.8
miniric3

Kia ora! Mulvays.com are a NZ based web and software design company who have seen you here on the freelance market and are really excited about working with you and treating you to the full service, professional experi More

$618 USD in 15 days
(6 Reviews)
5.3
rsen75

i'm 14+ years experienced with API(JSON/REST) integration knowledge, ready to start work

$315 USD in 8 days
(19 Reviews)
4.8
shomratkutub

I have experience with your project requirements , check pm.

$144 USD in 6 days
(4 Reviews)
3.6
sutapatiwari86

Dear Client, We have been through the details of your project. We can do this job very easily and as per your requirement. We have experts with us who can finish your job with in time frame and to the quality as per More

$618 USD in 10 days
(2 Reviews)
2.7
webdevit

magento/php team

$360 USD in 5 days
(6 Reviews)
2.6
valokothabozana

i have good hand with frees witch stuffs so we can easily complete your project give a chance to proved it

$144 USD in 5 days
(3 Reviews)
2.6
jasminery

Is it a reposted project? What's going with the older post?

$175 USD in 3 days
(1 Review)
1.7
websanityhk

Please check PM.

$140 USD in 3 days
(1 Review)
1.1
inovacaotech

Hi Please Check PM.

$125 USD in 3 days
(0 Reviews)
0.0
VgnsBABPwPHc

We are freelance software developers. If you contact us, we can give a quote and we can discuss further details of the project. w w w . so l ve r . i o

$155 USD in 3 days
(0 Reviews)
0.0