Em Andamento

Basic PHP programming

I am in need of some PHP programming with a little html work. I need a program that will allow me to keep my retail inventory updated on a daily basis and get inventory feeds from different manufacturers. I have a list of sku's that need their stocking levels updated through different csv files and need them to be combined to a particular format. I have included a run down on what I am trying to accomplish. Please IM me if things are not clear. I would like you to host what you have created for testing purposes using a mysql database.

Tables:

1. Source_1_Pricing

fields: sku , price

2. Source_2_Pricing

Fields: sku , price

3. Source_1_Stocking

Fields: sku , stk

4. Source_2_Stocking

Fields: sku , stk

5. In_az

Fields: sku

6. In_bc

Fields: sku

7. Out_bc

Fields: sku , stk

8. Out_az

Fields: sku , stk , price

Webpage—

Create basic webpage to be able to import the data to each of the tables 1,2,3,4,5,6. Separate buttons preferred and marked accordingly to table name. Imported as csv and the ‘choose file to upload’ method used. As each one is uploaded a timestamp for each import is displayed next to the import button stating “last import:” and remains present until a new file for that table is uploaded. (when a table is imported it is to be imported into a truncated table)

Function 1— (activated by button press labeled “Create BC data”)

If the sku values in In_bc match the sku values in Source_1_Stocking then copy Source_1_Stocking values of the matching sku along with the stk value to Out_bc.

B) If the sku values in In_bc match the sku values in Source_2_Stocking then copy Source_2_Stocking values of the matching sku along with the stk value to Out_bc.

Function 2 — (activated by button press labeled “Create AZ data”)

A) If the sku values in In_az match the sku values in Source_1_Stocking then copy Source_1_Stocking values of the matching sku along with the price value to Out_az.

B) If the sku values in In_az match the sku values in Source_2_Stocking then copy Source_2_Stocking values of the matching sku along with the stk value to Out_az.

C) Add the pricing from Source_1_Pricing and Source_2_Pricing to the Out_az table matching with the sku in Out_az

D) Create a button on the webpage to provide the export of the Out_az in a tab delimitated .txt file type keeping the field headers.

Function 3 — Missing Data Report (bc)

Create a report of skus that are present in the In-az and are not in the Source_1_Stocking or Source_2_Stocking. Processed by a button on the webpage and exported as a txt file

Function 4 — Missing Data Report (az)

Create a report of skus that are present in the In-bc and are not in the Source_1_Stocking or Source_2_Stocking. Processed by a button on the webpage and exported as a txt file

Function 5 — Missing Pricing Report (az)

Create a report of skus that do not have pricing associated with the sku values. Processed by a button on the webpage and exported as a txt file

Habilidades: HTML, PHP, Arquitetura de software

Ver mais: programming used, retail report format, report programming, programming data, programming method, php programming price, mysql php programming, method programming, html programming file, d programming, basic html programming, stocking, sku inventory, php programming, create webpage using html, basic php, php upload file csv, basic programming database, php table csv, stk, mysql import csv data, inventory list csv, missing database table, import csv mysql php, inventory report mysql php

Acerca do Empregador:
( 13 comentários ) Camarillo, United States

ID do Projeto: #6820560

Premiar a:

samuduranet

A proposal has not yet been provided

$30 USD em 3 dias
(5 Avaliações)
2.1

7 freelancers estão ofertando em média $48 para este trabalho

techwelfare

hi we could do it perfectly with accuracy, please let us know if you want to clarify in details.. if you want us to share our skill and previous work please initiate the chat by replying..

$59 USD em 1 dia
(83 Comentários)
6.5
sprextech

----------------------------------------------------------Please Consider on My BID---------------------------------------------------Hello Sir, I having has 10 + years experience of web site development. Expert in Cus Mais

$100 USD em 1 dia
(89 Comentários)
5.9
manirul26

6 years experience in html,css,JavaScript,Codeigniter,php,asp,net,c# Website Design and Software Development. we are developed 100% Customized software and web site. if you want i can show you our previous work.

$35 USD in 3 dias
(9 Comentários)
2.9
abhayendra

hi sir , i am expert web developer and designer 5+ exp in web development. we offer a batter web Developement Service by Cost and time some latest work listed below PHP , MYSQL , HTML, CSS http://pvplawtutorials Mais

$35 USD em 1 dia
(4 Comentários)
2.5
metalogics3

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I have Mais

$72 USD em 1 dia
(1 Comentário)
0.0
abhi03freelancer

A proposal has not yet been provided

$30 USD in 30 dias
(0 Comentários)
0.0
dishanimje

Hi there, I am expert PHP, MVC, Wordpress developer. I can assist you to get the job done within estimated time line. In my team 5 developers and 2 designers are working with me. We are professionals working since 3 Mais

$50 USD em 1 dia
(0 Comentários)
0.0