Update an excel file using PHP and MSSQL DB

$10 USD

Imekamilika

Imechapishwa

about 5 years ago

$10 USD

Kulipwa wakati wa kufikishwa

Hello, I would like to have a script created which updates an imported excel file with data from a MSSQL DB. Here's how the flow will be like. 1. Go to the website with the PHP script. 2. Upload the excel sheet. 3. This excel sheet contains SKU, stock quantity and some other data. 4. On the backend the SKU from the excel file is used to look up for that SKU corresponding stock quantity in the DB. If the SKU doesn't exist in the database it should return back the old value and notify through an error message that SKU #xxxxxx wasn't found in DB. 5. The new stock quantity is updated in the excel sheet. 6. 2 new updated excel sheets should be ready for download. One with the SKUs that have been updated successfully and the other one with the SKUs that had errors. (The excel sheet/format and everything should stay the same or they won't be accepted by the platform i'm uploading to.) This excel sheet will contains hundreds of SKUs. Each SKU is on a separate row. NOTE: Some SKUs will contain leading zeros and should be used exactly as is. Attached is an example of how the excel sheet looks like.

Excel

MySQL

PHP

Software Architecture

SQL

Kitambulisho cha mradi: 18741318

Kuhusu mradi

5 mapendekezo

Mradi wa mbali

Inatumika 5 yrs ago

Unatafuta kupata pesa?

Barua pepe

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa

Pata malipo kwa kazi yako

Eleza pendekezo lako

Ni bure kujiandikisha na kutoa zabuni kwa kazi

Imetolewa kwa:

@alihassan321

I am working on latest web technologies for more than 5 yrs. I have extensive experience in developing. My goal is to achieve client's satisfaction. Ready for your work. Thanks

$20 USD ndani ya siku 2

5.0

(25 hakiki)

4.9

5 wafanyakazi huru wana zabuni kwa wastani $24 USD kwa kazi hii

@umairmalik10

Hi,I've read the points of how to prepare new 2 files and what's functionality needed for it. I can create that required script. I need to see that DB from where I've to compare SKU of files and I'm good to start working. Thanks!

$45 USD ndani ya siku 1

4.9

(49 hakiki)

5.3

@iusmanadil

Greetings, Hi, First of all, I want to introduce my self I am Senior Full Stack Website Developer, having 6 years of experience in Website Development and Designing. I have extensive knowledge of Core PHP and it's frameworks (Laravel, CodeIgniter, Symfony Zend, CI, Cake-PHP), JS and it's Frameworks (React, Angular, Express, Backbone, Express, Node, Moment, Vue, Typescript), WordPress, Shopify, Magento, Ajax, HTML5, CSS3, jQuery, MySQL, and Bootstrap. I have understood your requirements with the Excel work and I have this type of work before so I have a good idea about this job. With great experience, skills and extensive knowledge in all the mentioned technologies and requirements, I firmly believe I am the great fit for this job. I am very much interested in your project and want to get it started right away. Please share further detail of the project, and feel free to ask any questions you might have. Looking forward to working with you. Many Thanks Usman Adil

$25 USD ndani ya siku 10

4.8

(17 hakiki)

4.4

@pachanipratik

My strengths include responsibility and punctuality. Whether it is a small or big project, I will always be aware that they are highly important to the client and I work at 200% I'm available on the computer for 15 hours a day and can dedicate 60+ hours a week. Client satisfaction is our top most priority and this is the hallmark of our success. We believe in respecting our clients, understanding their needs and living up to their expectations. By maintaining high standard of ethics in our work values, we deliver great business and optimized services.

$15 USD ndani ya siku 10