Find Jobs
Hire Freelancers

Basic PHP programming

$10-30 USD

Terminado
Publicado hace más de 9 años

$10-30 USD

Pagado a la entrega
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
ID del proyecto: 6820560

Información sobre el proyecto

6 propuestas
Proyecto remoto
Activo hace 9 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
A proposal has not yet been provided
$30 USD en 3 días
4,9 (7 comentarios)
3,2
3,2
6 freelancers están ofertando un promedio de $51 USD por este trabajo
Avatar del usuario
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 en 1 día
4,7 (165 comentarios)
7,1
7,1
Avatar del usuario
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 years. We are good at ERP, CRM, SAAS Model and Graphics designing and web designing using new design concepts. Our expert in designing website with using design concepts tweeter Boot Straping, HTML5, CSS3, Responsive design. I can design websites accordingly and get them done within short period of time. Let's begin the discussion as soon as so we can move and begin working on this immediately. I look forward to hearing from you soon, Regards,
$50 USD en 1 día
4,0 (24 comentarios)
5,6
5,6
Avatar del usuario
A proposal has not yet been provided
$30 USD en 30 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
Camarillo, United States
5,0
13
Forma de pago verificada
Miembro desde sept 10, 2008

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.