Closed

CUSTOM server script to convert xls file to magento upload ready file.

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 Management

See more: convert a file, autoresponder script php, xls, magento update 18 to 2, magento database, convert database program, php upload xls file database, grab website file, import files folder, customer email required magento, tier magento, class convert, create folder upload php, class custom php, inventory script magento, php add item php magento, inventory script php, php price update script, welcome script, upload xls file magento, server inventory software, file upload script magento, convert custom php magento, add tier price magento, script inventory php

About the Employer:
( 19 reviews ) Aurora, Canada

Project ID: #4856992

7 freelancers are bidding on average $235 for this job

gachomeo

Dear Sir, Expert import/export csv from/to database here. Regards

$277 USD in 10 days
(11 Reviews)
4.5
tuhindo82

Dear I have just seen your Job posting and upon reading thoroughly, I felt strongly that I would be the most qualified contractor for your project. I have vast experience in IT / project management / business plan a More

$277 USD in 15 days
(13 Reviews)
4.1
shomratkutub

The jinee of The Magic Lamp of Aladin is here as DEVELOPER to handle your project, check PM..

$200 USD in 3 days
(4 Reviews)
3.6
elboukharimu

I can help you please check your Inbox.

$180 USD in 3 days
(7 Reviews)
3.6
bmartynvw

Can do this for you

$350 USD in 12 days
(4 Reviews)
2.8
jasminery

You should enable the Magento API for this purpose. So, the server side will utilize the API as well for either checking and creating customer, or exporting the inventory.

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

Read your project description. We have a professional website developing team with your required features. Let me know if you are interested.

$226 USD in 12 days
(1 Review)
0.0
lancerCoder10

I'm well known with magento and office products. See me PM.

$160 USD in 2 days
(0 Reviews)
0.0