Hi all,
I would like to create a web-based application (PHP and MySQL) to control data about companies, persons and offers that have been made for these persons (at those companies).
The offers that will be made for the persons will be in both Word as Excel being Word the written offer (that later will be exported to PDF to send to the customer as non-editable) and Excel an overview of the offer with quantities, name of the product, salesprices, purchaseprices, margins, etc...
The goal of the Excel-sheets is that from another Excel-sheet, a query will run to discover all outstanding offers from all customers so an always up to date funnel can easily be made for the Salesmanager.
I've discussed this yesterday with the person that will create this website for me and he told me the webbrowser cannot automatically create, open or save a Word or Excel-file on a specific place. He will always ask for OPEN or SAVE AS... and I only want those files to be saved and opened (for editing) automatically in the correct directories. For example for customer X I want this offer automatically be placed in C:\customers\X and called x0801.xls (08: year, 01: first offer for this year). The next offer should get the name x0802.xls, etc...
The same for other customers in other folders: C:\customers\Y\y0801.xls etc...
Anyone an idea on how we can solve this?
Many thanks in advance!
Nico
5 1108
Hi all,
I would like to create a web-based application (PHP and MySQL) to control data about companies, persons and offers that have been made for these persons (at those companies).
The offers that will be made for the persons will be in both Word as Excel being Word the written offer (that later will be exported to PDF to send to the customer as non-editable) and Excel an overview of the offer with quantities, name of the product, salesprices, purchaseprices, margins, etc...
The goal of the Excel-sheets is that from another Excel-sheet, a query will run to discover all outstanding offers from all customers so an always up to date funnel can easily be made for the Salesmanager.
I've discussed this yesterday with the person that will create this website for me and he told me the webbrowser cannot automatically create, open or save a Word or Excel-file on a specific place. He will always ask for OPEN or SAVE AS... and I only want those files to be saved and opened (for editing) automatically in the correct directories. For example for customer X I want this offer automatically be placed in C:\customers\X and called x0801.xls (08: year, 01: first offer for this year). The next offer should get the name x0802.xls, etc...
The same for other customers in other folders: C:\customers\Y\y0801.xls etc...
Anyone an idea on how we can solve this?
Many thanks in advance!
Nico
Why use Word and Excel? Why can't your developer store this in a database, and develop a web application per your requirements.
It seems you're working like the 90's.
With a custom web application (or open source, don't know your entire process) You manage customers, offers, letters/emails sent to them. It can create a page where they can see their offer from you (can be secured)
My advice? quit expecting miracles from mediocre web developer and consult a real one who can sit down with you on your needs and developer an efficient, extensible, cost effective solution.
Good luck.
Why use Word and Excel? Why can't your developer store this in a database, and develop a web application per your requirements.
It seems you're working like the 90's.
With a custom web application (or open source, don't know your entire process) You manage customers, offers, letters/emails sent to them. It can create a page where they can see their offer from you (can be secured)
My advice? quit expecting miracles from mediocre web developer and consult a real one who can sit down with you on your needs and developer an efficient, extensible, cost effective solution.
Good luck.
Amen to that ma brother!
Hi,
To be honest about the Excel and Word-thought: I started from this idea because I was using such a self-developed CRM-tool at my previous employer and this worked very well for me there. Over there it worked fine, since they had a template Excel and Word-offer with all products and services in there and it was adapted each week by an internal sales with the new prices from the suppliers. After that, it was very easy for the external sales if they had to make an offer for their customers: they only had to copy-paste a block of Word / Excel in the specific Word / Excel-offer for that customer and it was ready.
For my new employer it's far more complex, since we offer a lot more products from a lot more suppliers and we don't have an internal sales that can update the "template xls or doc-offer" (or database) on a regular base.
This is how they work now:
- Customer sends a mail to us to receive prices about a product (can be all formats)
- We send this request to our supplier(s)
- They send us a response (can be a response on the mail of the customer, can be in xls, can be pdf, word, ...)
- We send this response to the customer with the end-user prices
- They confirm if they want us to order it
- And then the manual process starts again...
I'm thinking about a faster way of working in this proces and was thinking to give the suppliers access to our webpages to fill out the request of the customers in our database, but I'm afraid they might not be willing to do this 'extra work' for them that could save us time.
Do you have any ideas on how we could optimize?
I'm very willing to give up the Word/Excel-idea if you could give me some good alternatives.
Thanks,
Nico
Hi,
To be honest about the Excel and Word-thought: I started from this idea because I was using such a self-developed CRM-tool at my previous employer and this worked very well for me there. Over there it worked fine, since they had a template Excel and Word-offer with all products and services in there and it was adapted each week by an internal sales with the new prices from the suppliers. After that, it was very easy for the external sales if they had to make an offer for their customers: they only had to copy-paste a block of Word / Excel in the specific Word / Excel-offer for that customer and it was ready.
For my new employer it's far more complex, since we offer a lot more products from a lot more suppliers and we don't have an internal sales that can update the "template xls or doc-offer" (or database) on a regular base.
This is how they work now:
- Customer sends a mail to us to receive prices about a product (can be all formats)
- We send this request to our supplier(s)
- They send us a response (can be a response on the mail of the customer, can be in xls, can be pdf, word, ...)
- We send this response to the customer with the end-user prices
- They confirm if they want us to order it
- And then the manual process starts again...
I'm thinking about a faster way of working in this proces and was thinking to give the suppliers access to our webpages to fill out the request of the customers in our database, but I'm afraid they might not be willing to do this 'extra work' for them that could save us time.
Do you have any ideas on how we could optimize?
I'm very willing to give up the Word/Excel-idea if you could give me some good alternatives.
Thanks,
Nico
Oh pfft!!! this is easy peasy!!
You have a program that keeps track of all these orders for you. I believe their called o... let me see:
Quotes/Estimates -> Orders -> Invoices!!!
Part of everybody business that sells a product or service.
Develop an application that you can enter requests into. and collect information such as Customer Info, and Product(s) Info.
Ideally you wanna get your customers to "fill this out" on your site or an easy to use interface (request) form. So they can request even without email. If they choose to email, Past their email yourself and create this request yourself.
The requests will of course go into a database where the supplier can get them in two ways.
1. They can be emailed to them (they'll like the fact that its now more uniform)
2. They can log in and see this site and all the requests and reply to them.
Once this reply is recieved, either via email or better, they use your site, the status of the process changes to "Quote Recieved"
From your interface you should be able to sort, search, on all these requests in one easy interface.
You go in, Choose to show all the ones that have a "Quote Recieved" status. You mark up the price (or change the price in the message) and email it back to the customer.
----------------------------------------------
Alot of vendors already do this. They have a customer side, they have an internal side (what you see) and they have a supplier side (what the vendor sees)
Ingram Micro, Synnex, Tech Data, CDW. Customers either, log on, call or email requests that get responses.
Ideally you have your products online and customers with a log in can go online and see the prices and products without wasting a rep's time.
They can also see the quotes, orders they've placed, status of them and their previous history.
If this is right up your alley, i would Definetly google for already made products. if its expensive have a developer build a "mini" version to save costs.
Ask the other experts about how much time a mini-version of what i just talked about would take IN BILLABLE HOURS. I won't say anything cuz i'll always low-ball it.
If you know the average hours it would take, you can then shop around for a developer.
Good luck!
Oh pfft!!! this is easy peasy!!
You have a program that keeps track of all these orders for you. I believe their called o... let me see:
Quotes/Estimates -> Orders -> Invoices!!!
Part of everybody business that sells a product or service.
Develop an application that you can enter requests into. and collect information such as Customer Info, and Product(s) Info.
Ideally you wanna get your customers to "fill this out" on your site or an easy to use interface (request) form. So they can request even without email. If they choose to email, Past their email yourself and create this request yourself.
The requests will of course go into a database where the supplier can get them in two ways.
1. They can be emailed to them (they'll like the fact that its now more uniform)
2. They can log in and see this site and all the requests and reply to them.
Once this reply is recieved, either via email or better, they use your site, the status of the process changes to "Quote Recieved"
From your interface you should be able to sort, search, on all these requests in one easy interface.
You go in, Choose to show all the ones that have a "Quote Recieved" status. You mark up the price (or change the price in the message) and email it back to the customer.
----------------------------------------------
Alot of vendors already do this. They have a customer side, they have an internal side (what you see) and they have a supplier side (what the vendor sees)
Ingram Micro, Synnex, Tech Data, CDW. Customers either, log on, call or email requests that get responses.
Ideally you have your products online and customers with a log in can go online and see the prices and products without wasting a rep's time.
They can also see the quotes, orders they've placed, status of them and their previous history.
If this is right up your alley, i would Definetly google for already made products. if its expensive have a developer build a "mini" version to save costs.
Ask the other experts about how much time a mini-version of what i just talked about would take IN BILLABLE HOURS. I won't say anything cuz i'll always low-ball it.
If you know the average hours it would take, you can then shop around for a developer.
Good luck!
Great feedback, thanks a lot! I'll give it a thought how we could handle this for my current project. We can't really make the webshop, because we are only resellers of a lot of products, impossible to keep an up to date database of all of the products we can sell. But however, thanks for your comments!
Nico
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Jasper |
last post by:
I have a noob problem that is fairly expansive. Let me preface it by
saying that I'm a beginning programmer and am using the game I'm
writing as a learn-as-I-go tool. I'm trying to make a...
|
by: rdh |
last post by:
Hi all,
I am in process of developing a Server in C++ supporting multiple
protocols. The server will be exposing various functionalities, and the
clients can communicate over any of the...
|
by: Yeongja_Choi |
last post by:
How Dare Could America Industrial Property Office Be In Conspiracy With
Jungang International Patent Office To Make An Extravagant
International Crime ?
Currently a Korean party now holds the...
|
by: deko |
last post by:
Is there any reason, other than the distributable Access runtime, to use
Office XP developer?
I tried installing it on my system, but apparently I need to install/update
a bunch of components -...
|
by: Richard |
last post by:
Office Addins are easy in .NET. Try this from Visual
Studio's main menu:
File
New Project
"Other Projects"
Extensibility Projects
Shared Addin
Run the wizard and you're off...
|
by: Hari Shankar V |
last post by:
Dear all
I am a windows application developer. I want to add office like command
bars, toolbars or menubars in my application. Please tell me which component
i need to include to achieve this. i...
|
by: psinyc |
last post by:
has anyone ever intergrated Office products (word, excel,
powerpoint, etc.) into an ASP.NET web application (run in
ie).
This is a major question mark in a project I have begun
development on....
|
by: Mike |
last post by:
Hi,
I don't know the MS Office products that well, but I once worked on a project involving VB6 and MS Word. At that time, we were able to use the Word Object Model in our VB6 project to do some...
|
by: fiona |
last post by:
Divelements release fully featured Office 2007 style Ribbon control
Major component suite designed to mimic the advanced user interface
features of Microsoft Office 2007
Dorset, United Kingdom -...
|
by: =?Utf-8?B?SmVmZiBD?= |
last post by:
I am already at the 3rd tier of MS and they cannot figure this out yet..
Bought Office 2007 Small Business Upgrade. Install completed the first time
(only), yet each time you start Outlook, Word or...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
| |