Large file upload and database modification for an existing Wordpress website

Closed Posted 5 years ago Paid on delivery
Closed Paid on delivery

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.

Excel HTML MySQL PHP WordPress

Project ID: #17252538

About the project

43 proposals Remote project Active 5 years ago

43 freelancers are bidding on average $205 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
(316 Reviews)
8.6
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
(352 Reviews)
7.4
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
(180 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
(258 Reviews)
7.0
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
(142 Reviews)
6.4
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
(60 Reviews)
5.8
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
(32 Reviews)
5.2
fahadalee

We are a team of Developers with diversified tech platform experiences especially WordPress and we are quite capable to deliver on the work requirements you have highlighted. We are already assisting some clients in More

$166 USD in 10 days
(19 Reviews)
4.9
Helpfulinsight

//**WE CAN DO THIS AS PER YOUR NEED **// Hello Sir / Mam, Greetings, Thank you for giving us opportunity to send our proposal on your project. I have gone through the complete requirement of your posted job. We ha More

$500 USD in 6 days
(8 Reviews)
3.9
jayantbyad

Hello, Hope you are doing good. I have gone through your project description and I READ YOUR ISSUE, ALL REQUIREMENT POINTS, AND XLS FIE before proceeding ahead I must brief you about myself that I have over 6 yea More

$160 USD in 3 days
(21 Reviews)
4.2
seamantopcoder

Hi there. Your suggestion is very interesting for me and I have many experiences about it. To see my these skills, please visit www.czbitcoin.com. Building it, I implemented large file upload by using wordpress. More

$200 USD in 3 days
(11 Reviews)
4.0
jimmydallas9

Hi My name is Jimmy and I would love to work with you on your project, as I am totally free right now and I have 100% of time available, I would be able to work diligently on your project, and give you the utmost sat More

$30 USD in 3 days
(0 Reviews)
0.0