Concluído

Serials Number SQL/PHP DB - VERY URGENT

Hello,

I need to have done this project urgently (at least first "beta" within 3 days) so please apply ONLY if you can do it fast

I need to have a DB (sql would be perfect) where trough a webpage (php) i will be able to save serials number from products I sell.

I do wholeasales of HDD/SSD, everytime I get like 5000, 10000 serials number (in csv or xls) for one article for each transaction and I need to save those serials into a DB with the following informations;

Serials

Model

Supplier Name

Purchase Order No.

Date of purchasing

Client Name

Invoice No.

Date of sale

I do not need to load the invoice or the po, but just the references (po numbers etc..).

Those information, once stored I need to have the possibility to enquire the DB to check those serials for RMA purposes.

I make an example;

I receive from my clients, list with S/N which they claim to have bought from us where I need to open RMA (defect units...).

I need to have the possibility to enquire the DB with a list and the DB will have to show me the following for every serial no. I input;

1)Serial No. is present in db? Y/N

if YES, I need to get the full infos of the transaction, so:

Serials

Model

Supplier Name

Purchase Order No.

Date of purchasing

Client Name

Invoice No.

Date of sale

2) In case the serial is not present in the DB (in this case client sent to the wrong supplier) I need the report show exactly WHICH serials are not present into the list.

Please only SERIOUS and FAST developer. Fast Job means Fast Payment.

Thanks

Habilidades: Programação de Banco de Dados, MySQL, PHP, SQL

Veja mais: tsql select random rows, select random rows mysql, select random rows sql server, sql query to find duplicate rows in a table, select n random rows sql, sql find duplicates in one column, sql random sample by group, select random rows sql oracle, sql php flash mp3 player, tour management sql php web, auto job number generator php, generate number automatically php, download upload sql php, csv update sql php, rss sql php hour, sql php ebay clone, image sql php, increment number sql export routine, sql php hire, user registration sql php

Acerca do Empregador:
( 0 comentários ) Caslano, Switzerland

ID do Projeto: #19737576

Concedido a:

ankasky

i can do it fast. write me for more details. Hi, nice to see your project description. I am developer/designer with more than 5 years of experience with solid technical skills. My technical skills are: - PHP , HTML , Mais

$100 USD em 1 dia
(84 Comentários)
5.8

33 freelancers estão ofertando em média $164 para esse trabalho

uhjk

Hello, project description seems clear. I can show you beta in 24 hours - then complete in 48 hours. If you send me sample csv, would be perfect (for import purpose).

$250 USD in 2 dias
(813 Comentários)
8.2
coolguyinus2004

PHP/MYSQL expert developr here. Do you already have a domain and MYSQL support on it ? Then i can do this project in 1 day approx. Also you need to clarify few things here. You said "I do wholeasales of HDD/SSD, every Mais

$300 USD em 1 dia
(350 Comentários)
7.7
liangjongai

Hi, dear! I checked your project description and I've understood the requirement. I've a lot of experience of jobs like those. In our team there are developers for mobile, web and desktop and designer so we can prov Mais

$250 USD em 1 dia
(265 Comentários)
7.8
ravichedwal

Hi there, can launch in three days beta version bid only for beta version full project amount is different. Very good in Database managenment already managing lot of originationa data. I am a Sr. Developer with 10+ ye Mais

$250 USD in 3 dias
(103 Comentários)
7.4
karunakartiwari

Hi, Greeting for the day, Hope you are doing well 10+ Years of Experience in custom website development like Intranet application, web directory, online community, online E-Commerce Portal, online connecting consumer a Mais

$200 USD in 3 dias
(166 Comentários)
7.2
markninja

Hello, I will develop the DB (sql would be perfect) where trough a webpage (php) i will be able to save serials number from products I sell but I have questions which I want you to answer. I’d really like to work wit Mais

$140 USD in 4 dias
(85 Comentários)
6.9
polarjin2017

Hello? Nice to meet you. I am excited to work with you on this project. I am ready to start work immediately. Here are my working result for php, mysql, api integration, ajax, jquery etc. [login to view URL] Mais

$155 USD in 3 dias
(89 Comentários)
6.7
altarsft

Hello sir,, i am ready to work on your project , lets discuss the work in more detail on chat , we have experience and expertise in php and all its frameworks, mysql angularjs, nodejs, html, bootstrap please check the Mais

$188 USD in 3 dias
(66 Comentários)
6.6
programac

Howdy xhidex! Thanks for sharing the idea "Serials Number SQL/PHP DB - VERY URGENT". I'm so much interested in this idea and definitely want to get involve. Kindly reply me to figure out further details about this pr Mais

$135 USD in 5 dias
(143 Comentários)
6.3
Mickelson

Greetings. I'm very happy to have a chance of bidding your project. I am an excellent PHP & SQL developer in this industry. If we work together, I will satisfy you fully. Please give me 10 minutes of yours and I can fi Mais

$177 USD in 3 dias
(59 Comentários)
6.1
jinxing4

Dear Sir. I am interested in your project. I'm senior PHP, SQL, Javascript developer. I assure, I will do my best to work with you on your project to present the best possible outcome for you and your customers. I w Mais

$150 USD in 3 dias
(63 Comentários)
5.4
BorisMonday2018

Hello, How are you? I hope you are fine. I have saw your descriptions what you want. I would like to work for your project if you want. I have over 5 years of experiences on the development of website. I am ready to s Mais

$200 USD in 2 dias
(48 Comentários)
5.9
xinglong717

Hi Dear. I read your description carefully and am very interesting in your project. I can start right now and can do it perfectly. If you hire me, I will do my best for your job and you can get the best results. Lookin Mais

$140 USD in 7 dias
(59 Comentários)
5.5
sudesharora0111

Hi, I Would like to work for you on this project to have your database ready for serial numbers and have a page where you can search on the basis of serial number and get the details. I will provide an option to to upl Mais

$200 USD in 2 dias
(16 Comentários)
4.5
BestService222

Hi There, I am interested in your project. No worry your project. If you give me an opportunity to discuss further then I will do my best for you As I am a full-stack freelancer, I am sure that I can work with you Mais

$177 USD in 3 dias
(8 Comentários)
4.2
star314

Hi,Dear I read your project . I am an expert in web design and web development. i have ever been similar project with your project We have a team of web developers who have designed and developed many websites for o Mais

$150 USD in 3 dias
(8 Comentários)
3.4
MHassanBedor

Hi, I read project description. I'm experienced in PHP and SQL, I believe I can do this project. Looking forward to work with you. Regards

$120 USD in 3 dias
(8 Comentários)
3.4
AlexanderPGR

Hi, Dear How are you doing? I am very interested in your project. I am always ready for you. I wish you contact me as soon as possible. Let us discuss your project on chat in detail. Thanks for your regards.

$120 USD in 2 dias
(4 Comentários)
3.0
jayantavkumar

If you are ok then I can take this project to help you database side as I am an architect on database. But I don't have experience on PHP. Let me know if you are ok. I can assure you that I will give you best quality w Mais

$110 USD in 2 dias
(6 Comentários)
2.7
sergeyprince

Hello. I looked carefully at your posts. i have a history of developing a website with using framework such as Wordpress, Codeigniter, nodejs, angularjs, pure php, html, mysql, ajax, javascript for 6 years and i can Mais

$100 USD in 3 dias
(9 Comentários)
2.6