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

We have a Mysql current database holding:


Article groups (categories)



(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)



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


[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



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)



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.


[login to view URL]






[login to view URL]





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



Ready written queries for future ajax requests.


[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


[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.

Skills: HTML, Javascript, MySQL, PHP, Software Architecture

See more: 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

About the Employer:
( 1 review ) Lidköping, Sweden

Project ID: #19675652

Awarded to:


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 More

$300 USD in 7 days
(35 Reviews)

16 freelancers are bidding on average $504 for this job


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 More

$500 USD in 10 days
(58 Reviews)

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] More

$500 USD in 7 days
(169 Reviews)

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 More

$500 USD in 7 days
(53 Reviews)

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 More

$444 USD in 10 days
(44 Reviews)

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 More

$500 USD in 7 days
(71 Reviews)

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 More

$500 USD in 15 days
(136 Reviews)

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 More

$750 USD in 7 days
(79 Reviews)

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 More

$350 USD in 7 days
(31 Reviews)

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 More

$524 USD in 10 days
(47 Reviews)

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 More

$555 USD in 10 days
(31 Reviews)

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 More

$555 USD in 10 days
(8 Reviews)
$555 USD in 10 days
(6 Reviews)

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

$305 USD in 3 days
(1 Review)

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 in 14 days
(0 Reviews)

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 More

$555 USD in 20 days
(0 Reviews)