Large file upload and database modification for an existing Wordpress website

Lezárva Kiadva: 5 évvel ezelőtt Kiszállításkor fizetve
Lezárva Kiszállításkor fizetve

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

Projektazonosító: #17252538

A projektről

43 ajánlat Távolról teljesíthető projekt Utoljára aktív: 5 évvel ezelőtt

43 szabadúszó tett átlagosan 205$ összegű árajánlatot erre a munkára

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 Továbbiak

$222 USD 3 napon belül
(316 vélemény)
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 Továbbiak

$150 USD 1 napon belül
(352 vélemény)
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, Továbbiak

$166 USD 3 napon belül
(180 vélemény)
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 Továbbiak

$250 USD 5 napon belül
(258 vélemény)
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 Továbbiak

$222 USD 7 napon belül
(142 vélemény)
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 Továbbiak

$250 USD 8 napon belül
(60 vélemény)
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 Továbbiak

$100 USD 3 napon belül
(32 vélemény)
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 Továbbiak

$166 USD 10 napon belül
(19 vélemény)
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 Továbbiak

$500 USD 6 napon belül
(8 vélemény)
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 Továbbiak

$160 USD 3 napon belül
(21 vélemény)
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. Továbbiak

$200 USD 3 napon belül
(11 vélemény)
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 Továbbiak

$30 USD 3 napon belül
(0 vélemény)
0.0