Завершено

System for adding Customers Articles Suppliers and CSV import articles PHP/MYSQL

We have a Mysql current database holding:

Articles

Article groups (categories)

Suppliers

Customers

(more tables need to be added for doing this project, you are free to create the tables you like and also add columns to current tables)

1.

--

We want simple gui for edit/list/add in ALL this four tables. All fields should be editable.

This should be in three separate files for each table

e.g.

[login to view URL] - list all articles, possibility to open for change or delete

[login to view URL] - edit / change article

[login to view URL] - do the MySQL operations, post back to [login to view URL] with success or fail

2.

--

In the customer edit gui it should be possible to add special prices for the customer on the separate articles(fixed special price or percent discount) or on article groups(percent discount). Necessary tables should be created of your choice.

- Each customer could have special prices on unlimited special prices

- When entering the articleno or articlegroupno it should be an ajax request getting that it is a correct articleno/articlegroupno and fetch the name from article/articlegroup table.

- Simple example is found here: [login to view URL] (the form you will create should be more basic in design - only plain html)

3.

--

CSV / tab delimited import of articles from supplier:

We want a system that can read csv/tab delimited text files holding article price and info.

- each supplier has a discount file holding a %-discount for each discount group. It could be in either csv or tab delimited text.

- each supplier also has a pricelist with articleno, discountgroup, and more fields.

- on import articles should be updated if existed or added if not.

- each article could have more than one supplier. The articleno is the same on all suppliers. But all suppliers do not have all articles. Cheapest purchase price and supplier should be in the table articles.

- simple gui in html/php should be created to create import filters for each suppliers telling which column in discountfile holds discountgroupno,discountpercent

in this gui you should also decide which column in csv/tab delimited pricelist should be imported to which database column. It should also be possible to use fixed fields if pricelist not hold the info.

- if pricefile not contain a certain field it should be kept as it is, no overwriting.

- the pricelist could contain up to 200.000 articles.

- the import could be started from the supplier site or from an automatic request. e.g. [login to view URL]

- a table should hold all the supplier’s prices on each article.

Example:

[login to view URL]

----------------

discountgroupno;discountpercent

AA01;10

BB02;50

CC03;20

[login to view URL]

articleno;name;unit;discountgroup;listprice

A1;Banana;KG;AA01;100

A2;Apple;KG;AA01;1000

A3;Orange;KG;BB02;200

The purchase price for Banana is 90, Apple is 900, Orange is 100.

4.

--

Ready written queries for future ajax requests.

e.g.

[login to view URL]

should output:

-All the fields from article table

-current customer price, considering article discounts

-current % discount considering article discounts or article group discounts

eg.

[login to view URL]

should output:

-All the fields from article table

-current supplier purchace price

General project guidelines:

---------------------------

- GUIs should be simple but functional, containing html forms, submits etc. Design will be added later. As little javascript/ajax as possible.

- PHP version is 5.6.24.

- No php framework should be used, only plain php.

- Mysql should be used (not MySQL).

- Current Table/column names are in Swedish, but are well commented, and straight forward.

- Current database structure should be kept, but adding new columns and tables is possible.

- New table/column names should be in English or Swedish.

- Example of files and database will be posted.

- All code should be well commented in English.

Квалификация: HTML, Javascript, MySQL, PHP, Архитектура ПО

Показать больше how to read csv file in php and store in mysql, export csv file in php mysql, upload csv file in php example, mysql import csv command line, php generate excel file from mysql, import csv file into mysql using php demo, export data from mysql table to csv file using php, import excel to mysql using php download, howto export data csv excel format php mysql, csv oscommerce articles, joomla mass import articles, import articles jooml, import articles blogger joomla, upload csv file table php mysql, csv import mit php script, csv duplicate row php mysql, prestashop import products php mysql script, csv upload script php mysql, import csv joomla articles, import data excel mysql code project

О работодателе:
( 0 отзыв(-а, -ов) ) Lidköping, Sweden

ID проекта: #19675652

Поручен:

logos106

Hello, there I am very interested in this job and ready to get started now. Why not calling me so that we can move on for quality work? I have many experiences and good enough at data manipulation and export / imp Больше

$300 USD за 7 дней(-я)
(14 отзывов(-а))
5.0

21 фрилансеров(-а) в среднем готовы выполнить эту работу за $498

hiretechexperts

Sure, can create System for adding Customers Articles Suppliers with CSV import , but need to clear some points. So please send me a text message whenever you have some time to discuss about the project. At present I Больше

$500 USD за 10 дней(-я)
(52 отзывов(-а))
7.7
polarjin2017

Hello? Nice to meet you. I am excited to work with you on this project. I am ready to start work immediately. So I think I can help you if you want. Here are my working result for php, mysql and ajax [login to view URL] Больше

$500 USD за 7 дней(-я)
(129 отзывов(-а))
7.0
YuKai7777

Hello. I have read your job description and am very interested in your Mysql hosting project. I have worked on many projects developing UI/UX, responsive design for web & mobile and I have expert-level experience of HT Больше

$500 USD за 7 дней(-я)
(44 отзывов(-а))
6.5
alexwmsoft

100% Completion Rate and 5 Stars Hi, there. My name is Lee, and I am an experienced web developer. I read your job description, and I am interested in your project. I have 6+ years of experiences in developing Больше

$444 USD за 10 дней(-я)
(29 отзывов(-а))
6.1
rwebexe

I can help you to setup or modify e-commerce site for your products, and also make customizations as per your needs And i will add several payment methods for your customer if you have specific in mind than lmk i wil Больше

$524 USD за 10 дней(-я)
(43 отзывов(-а))
6.4
chandankandar007

Hi dear How are You ? My self Chandan kandar . your private senior software devloper. firstly i trying to say that i am a full stack deloper with full time giveen here ,so there no job in my hand otherside . so i am Больше

$350 USD за 7 дней(-я)
(26 отзывов(-а))
6.4
schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl Больше

$750 USD за 7 дней(-я)
(73 отзывов(-а))
6.4
adampohp79

Hi. thanks for your posting. I'm very happy to have a chance of bidding your project. I have experience in development of the projects like yours If you hire me, I'll do my best for your project and finish greatly in a Больше

$500 USD за 7 дней(-я)
(54 отзывов(-а))
6.1
techplusintl

Hi there, Greetings from TechPlus! I've reviewed requirements & ready to develop System for adding Customers Articles Suppliers and CSV import articles PHP/MYSQL. 5+ Years Expertise in : CMS (Wordpress, Magen Больше

$500 USD за 15 дней(-я)
(97 отзывов(-а))
6.1
Topman123

Dear,manager! Thanks for visiting my proposal. I have read your job description very carefully. It becomes a question of what you are asking for. I will briefly introduce my career, convinced that I can finish it on Больше

$555 USD за 10 дней(-я)
(25 отзывов(-а))
5.7
AndreiPPB

Hello. I'm very interested your project. The most important thing for me is the client's satisfaction, good result, and high quality. I'm very talented Web developer. if you assign to me this project, you can get Больше

$500 USD за 10 дней(-я)
(12 отзывов(-а))
4.7
bluebear1888

Hi I can do it Don't worry about your Porject. If you hire me I will work as soon as and if you dont satisfy about this result I will refund the money Thank you

$555 USD за 10 дней(-я)
(31 отзывов(-а))
4.8
RiHCh

I am experienced php developer and web designer with the depth knowledge related to MySQL,Laravel,WordPress, CodeIgniter, MSSQL,JSON,JAVASCRIPT,AJAX,XML,jQuery,CSS,HTML5,MongoDB with the integration of web technologies Больше

$500 USD за 7 дней(-я)
(9 отзывов(-а))
4.3
shenji108

Hello I just checked your requirements in detail within 20mins it's too long:)) anyway, all pages are needed CRUD now. also, I should make a relationship between customers and articles. It is easy for me Больше

$555 USD за 10 дней(-я)
(8 отзывов(-а))
3.8
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 Больше

$350 USD за 3 дней(-я)
(9 отзывов(-а))
2.4
$555 USD за 10 дней(-я)
(5 отзывов(-а))
2.5
jinxueqiong0910

Hello I am a experienced Web Developer.(+6 years) I am really interested in your project and even I've done similar works before. When I was a student, I started Web Developed only based on PHP. But with time, no Больше

$500 USD за 10 дней(-я)
(1 отзыв)
2.0
jervyna18

Hi I'm Kevin from Philippines, VMWare Certified Professional since 2017 ([login to view URL]), I' am also knowledgeable in Linux Administration, Scripting Больше

$305 USD за 3 дней(-я)
(0 отзывов(-а))
0.0
muzhobert

I am choosing that time because I want to be sure that what I deliver to you is quality work and for the money, it's worth the time. Trust me you won't regret your trust. Thanks a lot in advance

$666 USD за 14 дней(-я)
(0 отзывов(-а))
0.0
fseedat7

I already have a base project set up with a great UI and templates. I am using Slim PHP framework. I will ensure that the logic classes will have full unit tests. I will work with lots of dedication. Relevant Skills a Больше

$555 USD за 20 дней(-я)
(0 отзывов(-а))
0.0