Auto quote script

Closed Posted 8 months ago Paid on delivery
Closed Paid on delivery

I need a script to automatically generate and email quotes to customers based on their inbound quote requests.

The script should:

Continuously check an inbox for new emails requesting quotes. It should parse the email body to extract:

SKU code (always a 6 digit number)

Quantity (could be expressed as qty, pcs, mtr, units, etc)

Use the SKU code to lookup the matching product details in a CSV database/spreadsheet. The database contains at minimum:

SKU code

Product name

Unit price

Weight

Build a quote table containing:

SKU code

Product name

Quantity requested

Unit price

Line total (quantity x unit price)

Weight per unit

Total weight for the line item (weight per unit x quantity)

Add a grand total and grand weight total for the full quote at the bottom of the table.

Populate an email template with the formatted quote table and totals.

Email the quote back to the customer who requested it.

So in summary, the script would:

Continuously check for new quote request emails

Extract key details like SKU code and quantity

Lookup product data by SKU code

Build a formatted quote table

Populate and send quote email back to customer

This allows me to automatically generate and send quotes based on incoming email requests.

For implementation, I'm thinking:

Python for main logic

CSV file for product database

SMTP library for sending emails

Jinja templates for email body

PHP Software Architecture JavaScript MySQL Excel

Project ID: #37166956

About the project

76 proposals Remote project Active 7 mos ago

76 freelancers are bidding on average $577 for this job

ahmadayaz

Thank you for considering my proposal. I am confident in my ability to develop a script that meets your requirements using Python as the main programming language. We will utilize the CSV file format for the product da More

$675 USD in 5 days
(305 Reviews)
8.7
AwaisChaudhry

Hi Good evening , I have read the brief details on your job listing . I see you have been looking for someone experienced with Script Development. Its been 8 years since I have been working on freelancer.com, I have 9 More

$750 USD in 7 days
(146 Reviews)
8.7
OutsourceMan

Hi there! My name is Raman and I'm part of the team at CnELIndia. You contacted us about needing a script to automatically generate and email quotes to customers based on their inbound quote requests. With 18+ years of More

$500 USD in 7 days
(574 Reviews)
8.9
schoudhary1553

Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are look More

$500 USD in 7 days
(663 Reviews)
8.6
helmot

Hello! My name is Vahid and I am a fulltime freelancer specializing in AI, Programming, Database, Big Data and Web Development. I have a masters degree in AI and have worked on a lot of projects in AI/ML, Blockchain an More

$500 USD in 7 days
(205 Reviews)
8.2
liveexperts123

Hi there,I'm biddin on your project "Auto quote script" I have read your project description and i'm an expert in Python and machine learning therefore i can do this project for you perfectly.I still have a few questio More

$750 USD in 1 day
(96 Reviews)
7.9
livegoodlife

Hello there, I am experienced in web scraping and to build script or a windows desktop application by using python. I am also experienced in large data scraping from the given website, by pass IP, Captcha, and anti bo More

$300 USD in 7 days
(306 Reviews)
7.9
lkhelladi

Hello, I'd be glad to develop the Python script for automatic quote generation and sending. Looking forward to chat with you soon for more details. Best regards.

$550 USD in 4 days
(178 Reviews)
8.0
divumanocha

Hello, Greetings! I have read your project description and am confident that I can complete this project to your satisfaction. However, I do have a few queries. Please leave a message in the chat so that we can discus More

$700 USD in 8 days
(108 Reviews)
7.4
Rekhathakur

Hello there! My name is Rekha and I'm a senior Web Developer with over 8+ years of experience in web development. I understand you need a script to automatically generate and email quotes to customers based on their More

$750 USD in 17 days
(91 Reviews)
7.4
NayaPakistan

Hey Richard H., My name is Muhammad and I am excited to offer my services as a freelancer for your auto quote script project. With 10+ years of experience in PHP, Laravel, and React.js, I have the skills necessary to More

$505 USD in 3 days
(438 Reviews)
7.4
ayesha0124

Hello, I believe i can help u with getting this job done as i have the great knowledge of JavaScript, MySQL, Excel, Software Architecture and PHP. I have working experience of several years on this platform. So please More

$750 USD in 7 days
(23 Reviews)
6.7
Shikha510

Hi there! I understand you are looking for a script that will automatically generate and send quotes based on incoming quote requests. With my experience in Python, CSV file database, SMTP library and Jinja templates, More

$750 USD in 7 days
(21 Reviews)
6.2
scriptzguru

Hi there! My name is Chakravarthy and I'm excited to be your Auto Quote Script developer for this project. With over 10 years of experience in software development, I am confident that I can provide the best solution f More

$350 USD in 7 days
(78 Reviews)
6.3
sonus21

Hello! I hope you're well. I'm a seasoned Python developer based in India with over 12 years of experience, specializing in python. Would you like to have an automatic quote generator that can automatically generate a More

$300 USD in 14 days
(34 Reviews)
5.8
Nehag510

I'm Neha, a full stack developer with expertise in Node, Express, Angular, React and more. I have worked on projects such as auto quote script and am confident that I can deliver a quality solution that meets your need More

$600 USD in 8 days
(19 Reviews)
5.6
AmazingEngr76386

Hello there! My name is Adnan Gohar and I am an experienced and results-driven professional with extensive knowledge in project management, strategic planning, marketing, data analysis and software architecture. I unde More

$500 USD in 7 days
(16 Reviews)
5.8
worksoft

Hi, I am an experienced python developer. I can develop this script to read & parse emails & send back quotes. I can start today. Thank you.

$750 USD in 10 days
(36 Reviews)
5.7
Demenntor

Dear Client, I hope this message finds you well. I'm excited about the opportunity to create a script that automates your quote generation and email process based on inbound requests. Once we've discussed your specif More

$700 USD in 7 days
(34 Reviews)
5.2
devbaloni1983

I have more than 15 years’ experienced in Development. As I am expert, I can build it according to your requirements. Because I have a lot of the experiences about these fields, I can build your project as soon as po More

$250 USD in 7 days
(42 Reviews)
5.5