Closed

Large file upload and database modification for an existing Wordpress website

Background

We have an existing website built on Wordpress that is used as a product search engine.

There are 1,300,000 products held in the database.

Users visit the site to check the latest price of a products. These prices products fluctuate daily.

Issue

The administrator keeps an excel spreadsheet of these prices and has to currently update the prices manually which is a time consuming process.

Requirement

• Create a new page on the wordpress website

• This page should have a file upload box

• This file upload box should only accept .xls or .xlsx files

• This file upload box should only accept correctly formatted files.

• On upload any product data that has an existing entry in the existing product database should be overwritten with the new data and price.

o Products are compared by the “Product column” in the spreadsheet

• Any products already in the database that do not appear on the spreadsheet should remain unaltered.

• There could be 250,000 products on any spreadsheet to be uploaded at the same time.

• The upload shouldn’t time out or cause any load related issues on the server.

• Any issues with the upload should be handled with a user friendly error message.

• If the upload is to take some time there should be an indication of this for the user.

If you require any further details please ask.

Sample upload spreadsheet attached.

Skills: Excel, HTML, MySQL, PHP, WordPress

See more: large file upload process progress bar php, large file upload php script, ajax large file upload, how to create a file upload form in wordpress, custom file upload in wordpress, wordpress file upload plugin for admin, wordpress backend file upload plugin, wordpress file upload form, wordpress frontend file upload, wordpress plugin file upload tutorial, free file upload form wordpress, php, mysql, css, html, wordpress, excel, node.js, angular.js, wordpress plugin

About the Employer:
( 1 review ) Batley, United Kingdom

Project ID: #17252538

45 freelancers are bidding on average $202 for this job

ahmadayaz

Hello Sir! I am experienced WordPress developer and programmer, I am well versed with WordPress custom themes and plugin modifications.I have read your description thoroughly I have some technical questions to discuss More

$222 USD in 3 days
(241 Reviews)
7.9
tarunmehan

Hello, I am ready to help you on an immediate basis to make amendments in your existing Wordpress website. I have reviewed the attached documents and it's something feasible for me to develop. I will improve Des More

$250 USD in 5 days
(75 Reviews)
7.3
rexzetsolutions

i am expert in wordpress, i see the csv is too large but using just some tricks we can easily make it uploadable on site, if you see my reviews u will see sevearl projects that almost similar to yours and i get 5 stars More

$150 USD in 1 day
(321 Reviews)
7.1
$210 USD in 5 days
(65 Reviews)
6.8
SBITServices

Hello Frano, I have read your description clearly and understood your requirement. I have 5 years experience in word press and developed nearly 350 websites. I agree that can complete task with high quality and More

$300 USD in 3 days
(319 Reviews)
7.2
raisdhaka

Hello, First, please migrate your site from WordPress. This huge number of product with WordPress might be issue in near future. Now, regarding the work. I can build you a check and upload option from xls to mysql More

$250 USD in 5 days
(205 Reviews)
6.8
$133 USD in 0 days
(227 Reviews)
6.5
$444 USD in 3 days
(255 Reviews)
6.6
maamekal

Hi there!! Greetings of the day. As you mention in the description I can create the same code that will fulfill your requirement. CMS's like Wordpress, Open Cart. ✔ Server-side Programming Core PHP, More

$166 USD in 3 days
(135 Reviews)
6.8
junkyfunky

Hello, I've read your project description and I want to tell you that I can create large database and do modification for an existing WordPress website for you as per your requirements . Lets have a quick chat to More

$244 USD in 3 days
(115 Reviews)
6.6
bestit4u

Hi I am very,very interested in your project My name is Shan Bin and I'm a Chinese developer. I have 6 years of web development experience such this projects. I am a highly skilled developer in full stack web develo More

$155 USD in 3 days
(81 Reviews)
6.8
webperfection123

Hi There, I can upload Large file and do database modification for your existing Wordpress website for you according to your requirements i can work on it.I have read your job description and assure you that I am More

$200 USD in 2 days
(129 Reviews)
6.5
TechNamrata09

Hey There, I have gone through your project description for modification in an existing Wordpress website. Please share details of existing website. I'm a PHP expert worked on many sites in technologies like More

$188 USD in 4 days
(31 Reviews)
6.0
umernaeemucp

Hi,, i can do work according to your requirements my recent works: [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] http://warmc More

$133 USD in 3 days
(41 Reviews)
5.8
dynamiccreator

Understood your requirements and I am database expert and have extensive knowledge of WordPress development I will create an admin plugin for admin to upload that xls file. The file will upload in a perfect manner that More

$222 USD in 7 days
(127 Reviews)
6.0
STPLSRM

Hello, This is a massive data and will require time since it won't be only solved by creating a page. Queries need to be changed and also that will not be sufficient and other alternatives will also be applied. We h More

$155 USD in 3 days
(6 Reviews)
5.7
radimosve

Hi!. I am available right now, how are you? I am interested in your project and would like to discuss the project with you. I always deliver on time and on budget feel free to check my feedbacks and portfolio. I unde More

$250 USD in 8 days
(55 Reviews)
5.6
bdeinexture

I have worked on largest E-commerce marketplace called [login to view URL], Me and my team had developed iOS Cloud Suite Inventory/Chat/date import/date export for this client, Also Converted this website from Word More

$750 USD in 5 days
(9 Reviews)
5.6
sitwebsolution

Dear Sir/Madam, How are you today? We are from S IT Solution, we're already skilled and experienced with your Desired skills. If you Consider us to full fill y More

$100 USD in 3 days
(28 Reviews)
5.0
davinder0279

Hello I can assist you with web development tasks. kindly share details of the project. I have been working in this field from last 5 years. Here are few suggestions to get started: -> I will provide you moc More

$222 USD in 3 days
(14 Reviews)
5.1