Find Jobs
Hire Freelancers

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

$30-250 USD

Closed
Posted over 10 years ago

$30-250 USD

Paid on delivery
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. [login to view URL] is the inventory structure file and [login to view URL] is the customer database file.
Project ID: 4856992

About the project

6 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
6 freelancers are bidding on average $237 USD for this job
User Avatar
Can do this for you
$350 USD in 12 days
4.9 (40 reviews)
7.3
7.3
User Avatar
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
5.0 (46 reviews)
5.9
5.9
User Avatar
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 and analysis / plan and website management job. Understanding how valuable an education is, I am serving Pacific Pharmaceuticals Limited as a Sr. Executive (MIS), toward earning my Masters of Business Administration (MBA) and B. Sc Computer Science. I am 100% able to do your project. Sincerely, Tarikul Islam
$277 USD in 15 days
5.0 (9 reviews)
5.6
5.6
User Avatar
Dear Sir, Expert import/export csv from/to database here. Regards
$277 USD in 10 days
5.0 (23 reviews)
5.4
5.4
User Avatar
I can help you please check your Inbox.
$180 USD in 3 days
4.9 (35 reviews)
5.3
5.3
User Avatar
I'm well known with magento and office products. See me PM.
$160 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of CANADA
Aurora, Canada
5.0
24
Payment method verified
Member since Jul 3, 2013

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.