Find Jobs
Hire Freelancers

Clothing store needs automatic inventory email reports based on Excel spreadsheet date fields - open to bidding

$30-250 USD

Cerrado
Publicado hace más de 7 años

$30-250 USD

Pagado a la entrega
I work for a consignment clothing store. We would like to receive email reports based on values on an Excel spreadsheet. We need to know when to markdown certain items, and when to remove old items from the online store, so we are hoping that if the item information (SKU, date listed, date sold, original price, markdown price, etc.) is in an Excel spreadsheet, you could create a simple program that will email us a report to tell us which items to markdown and which items to remove from the online store based on the Date Listed and Date Sold fields. So, for example, if our policy is to mark down items after 60 days, we want to be automatically notified via an email report which items have been listed for 60 days and what the markdown price should be so that we can quickly and easily identify and markdown the items
ID del proyecto: 11062549

Información sobre el proyecto

30 propuestas
Proyecto remoto
Activo hace 8 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
30 freelancers están ofertando un promedio de $145 USD por este trabajo
Avatar del usuario
I can do exactly what you need. I'm a computer science professional with a PhD degree and extensive experience in Excel data handling and automation using macros and VBA. I've done a lot of similar work. Please see reviews on my profile. It would be my pleasure to do your project. Please have a look at some Excel projects I've done: https://www.freelancer.com/projects/Excel/Build-Excel-reports-dashboard/ https://www.freelancer.com/jobs/php/Need-excel-plugin-convert-USD/ https://www.freelancer.com/jobs/Excel/Need-covert-very-large-dat/ https://www.freelancer.com/jobs/Excel-Mathematics/Convert-math-proofs-Excel-formulas/
$150 USD en 3 días
4,8 (208 comentarios)
7,3
7,3
Avatar del usuario
I am an experienced programmer, with more than 10 years of experience. I understand exactly what you need. I promise you will be satisfied with my work. Thank you for your trust.
$110 USD en 3 días
5,0 (47 comentarios)
6,4
6,4
Avatar del usuario
Hey, Can you share the spreadsheet with some dummy data and also some rules (like the one you already mentioned)? Also, is this spreadsheet located on a remote server or it will be there on user's computer? I can write a macro that will send emails to one or more users based on the conditions specified. I have done several similar macros as you would see in my work history and can assure you of excellent quality work. Please drop a note to me if you would like me to work on this project and we may discuss the next steps. Thanks and Regards, Rishi
$155 USD en 5 días
4,9 (127 comentarios)
6,6
6,6
Avatar del usuario
Hello, this is Sourabh Gupta from New Delhi. I am an advanced VBA programmer. I read your description. What I could understand is that you need a macro for sending an email to you which would contain certain list of products based on some criteria. We can easily do that via VBA which can be used for sending mails. Do contact me once, we can discuss the details over chat. Regards Sourabh Gupta
$49 USD en 1 día
5,0 (154 comentarios)
6,2
6,2
Avatar del usuario
I have good expertise in Excel and MS Access. Excel - automation using macro, formulas, data comparison, data validation, data consolidation into one sheet, bringing graphs and summary using click of a button. MS Access - Design user entry forms, build business logic required and bring up reports. Used them extensively. I could design the system in either of these. MS Access would be more user friendly interms of screen inputs. Same via Excel can be implemented to get the SKU, Item description, date listed etc, depending on the criterion you wanted can list all items that meet the criteria and that could be mailed as well.
$30 USD en 2 días
4,6 (53 comentarios)
6,2
6,2
Avatar del usuario
VI am a postgraduate in finance (MBA) with more than 5 years of experience having expertise in Excel and VBA. Currently working in an MNC Analytical company on a large financial model including dashboards and presentations to board for a leading US bank. I can help you with your current requirement as well as any further requirement with low cost of work. I can deliver the work in lesser time than others while maintaining the superior quality of work.
$200 USD en 3 días
4,9 (47 comentarios)
5,8
5,8
Avatar del usuario
Hello, I have been working as freelancer since last ~ 3 years,prior to this was working with a MNC as an Sr. Software Professional. The project is Product based development and integration of the product with various already existing Products and processes.. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applications -- Expert on C# using .NET framework using Visual Studio 2012 and 2013 -- Expert in ASP.NET,MVC -- Expert in VB.NET using VS2012/VS2013 -- WPF and Windows Forms Application I have experience in all the above areas and during my project work I have completed all of the above tasks. As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. Delivering best & Customer satisfaction is the key for any individual and I always worked keeping these things during project execution. Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Abhinov
$155 USD en 8 días
4,9 (66 comentarios)
5,6
5,6
Avatar del usuario
I have the expertise in Excel & scripting in VBA and can do this task, quickly and accurately, as per specification. Ready to start work immediately.
$155 USD en 3 días
4,6 (70 comentarios)
5,4
5,4
Avatar del usuario
Hi There, Greetings for the day, i have 5+ years of experience in excel vba and vb.net, i have worked on many end to end projects and had developed application to email reports from excel based on the requirements. i can automate the process for you and can schedule it using VBS. Thanks.
$66 USD en 3 días
4,9 (29 comentarios)
4,6
4,6
Avatar del usuario
I have over 9 years of experience Excel and Access VBA. I have developed several Tools, Automation, Dashboard, Database CRM and Online Tools using various technologies. I have done a similar project using VBA.
$100 USD en 5 días
4,9 (14 comentarios)
4,2
4,2
Avatar del usuario
Let's start work with great accuracy and within time deadlines .My aim is to satisfy my client by my WORK,Thanks.
$30 USD en 3 días
4,9 (18 comentarios)
3,9
3,9
Avatar del usuario
Good afternoon. I am a very experienced Excel developer with skills in the automation of processes, such as e-mail delivery. I have multiple custom built solutions that do basically the same kind of task that you require, and it would be pleasure to do the same for you. Please feel free to reach out if you wish to discuss further. Cheers, Tim Norton
$122 USD en 3 días
5,0 (7 comentarios)
3,7
3,7
Avatar del usuario
Hi, I can help you get this done. Excel VBA would be okay for sending email alert. I have developed email alert funtions on VB6 and .Net. Similar function can be implemented on VBA. Should you be interested, I will be happy to start working with you asap.
$30 USD en 1 día
5,0 (6 comentarios)
3,6
3,6
Avatar del usuario
Understand you want email from an Excel Sheet maintained offline. Excel will initiate email through linked outlook mail ID. I have developed such system in past. I am Mechanical Engineer, proficient in Excel Macro, Pivot Table/charts with slicer, dashboard, functions and formulas. About Myself Good Day!. Let me introduce myself for building your confidence in me. Worked at Sr. position with experience of marketing, Service, Production and IT Excel Expert Group Member Access Expert Group Member Proficient in Google Sheet Worked on Macro, VB, Pivot, User Form, Google Sheets Proficiency in Office tools, SAP, AutoCAD, 3DMax, Coral, Qualification- Mechanical Engineer Available on Skype Some Projects: Developed complete ERP system for Marketing in DB4 (earlier to Access) SAP implementation as Key Coordinator Community Survey (Near 10 Million Data compilation) in Excel Industrial Project Report in Excel Multilingual Kazien Sheet in Excel with VB Offer Preparation in Access Project Planner in Excel Very Large Database Analysis Completed few Contests at Freelancer For Details of my Work 1. Please see my profile 2. Please see Services offered by me. If you initiate dialog, I can submit samples of my work. It will be pleasure working for you. I believe in Customer Delight.
$100 USD en 3 días
3,9 (9 comentarios)
3,6
3,6
Avatar del usuario
hi there, i am full stack developer and can develop your automatic notification system based on email alerts. we can discuss the details over chat. i have prior related experience. regards
$250 USD en 10 días
5,0 (1 comentario)
2,0
2,0
Avatar del usuario
I am interested in this task, here is my profile Education- Masters in Computers Skills - ASP.NET, MVC, EF, C#, VB.NET, SQL Server, WCF, WPF, XML, Cr Reports Experience- 12 Yrs as Developer, Tech Lead, Tech Manager I am very good at .Net Windows and Web applications development
$222 USD en 3 días
5,0 (1 comentario)
1,8
1,8
Avatar del usuario
Hi there, I am a full-time freelancer here at home. I have lots of free time today, so I can guarantee full focus and well productivity for my work. Let me help, count on me :) Have a Great Day!
$30 USD en 1 día
5,0 (1 comentario)
1,1
1,1
Avatar del usuario
You can check my skill sets and previous projects sample pictures in my profile page. Now I've joined hands with one of my friend, who is also equally skilled in VBA macro and automation. We do automated, user friendly, simple yet powerful macro coded file to ease customer work. For example, customers 1 full day (8 hours) manual work is completed in 20 mins using macro. Same another customer daily 4-5 hours regular vlookup, index/match etc work is now completed within 1 minute using our simple yet powerful macro snippet. Try us to explore a great experience.
$150 USD en 3 días
5,0 (1 comentario)
0,7
0,7
Avatar del usuario
Hello, I am interested in this job. I am a new freelancer. But I am reliable for works. So you can use me for this work. I always hungry for new lesson. Hopefully I will get a good reply from you. Best regards, Sajjad.
$170 USD en 5 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Send me sample ...I will do the same as u require..and u will received notification through me via email
$155 USD en 3 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
Nashville, United States
5,0
1
Miembro desde jul 19, 2016

Verificación del cliente

Otros trabajos de este cliente

Design project
$10-30 USD
¡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.