1001 Freelance Projects
Latest Projects from
Freelance Marketplaces
View Project
View this project in detail
(Note: you will be redirected to external marketplace)
Project title:
CRM for Commodity Trading
Posted by:
External project from PeoplePerHour
Started:
01-Jul-2025 10:20 GMT
Description:
I am a small business involved in physical commodity trading internationally.

This involves buying products, mostly FOB ( free on board, which is an incoterm ) from 1 geography, at a defined price, and selling it to cutomers globally on a CFR ( cost and freight ) to port basis using the global container freight market.
The inputs for the FOB price would be made by me by port of origin.
The inputs for the freight costs would need to be made either by me or by third party companies so may need to be restricted in some way. ( I guess this is to be done via Google Sheets )
Both of these inputs need to be able to be edited frequently ( daily ).

The CRM should be able to send bespoke/customised offers to individual customers, in certain regions in the world, based on information in the CRM ( name of buyer, company name, payment term, currency, product expected margin, finance and insurance cost ). The bespoke offer must include a price which is calculated from combining the inputs of FOB price, the freight , the expected margin and costs including a currency exchange rate drawn from the daily xe.com rate. There could also be a second element of 'freight insurance' but that will come at a later stage as a secondary part of the offer.
Each individual offers should have the option to include multiple products which would be customer dependent.

It should be possible to send these bespoke offers both via Email ( a formal offer ) and a much shorter more informal offer via Whatsapp to the customers.

The CRM should also be able to easily issue invoices to customers once a deal is agreed and provide a summary of the deals done each week on a Friday to me so that the payment deadlines can be tracked. It should also automatically send out a reminder to customers of the due date 2 days prior to that date.

The CRM should also be able to track purchases from suppliers, with their FOB or CFR costs and be allocated to sales orders. This allocation would be done either manually or automatically.

I currently run something basic from a spreadsheet but this now needs more integration and to become easier to use. I've shared an example of this spreadsheet.

1. CRM set up and customisation for international trading business. This will include customisation of:
- contact management module ( to include all fields required )
- product and pricing module ( allow bespoke offers, similar functionality to the current excel spreadsheet )
- deals module ( to track response to offers made on a weekly basis to customers and track history and sales record )
2. Invoicing integration with the CRM
- set up of invoicing functionality to enable instant invoice generation upon deal closure and connection with a purchase order to track margin from purchase order to sales order. ( this should feed into the customer tracking and performance )
3. Dashboard and reporting
- reports of deals closed weekly
- Contains customer information/ overviews including market share, where they are buying from, which products they purchase and which products they produce.
- A dashboard to scrape key metrics and display them, including ( Oil price, currencies ( USD/EURO/GBP ) ethylene price, energy prices, showing daily and monthly movements )
4. Automation and workflows
- automated sending of customised offers via email and WhatsApp
- payment reminder workflows triggered 2 days before due dates
5. Custom development
- for pricing calculation that combines FOB pricing, Freight costs, expected margin and cost
- inputs should not be restricted and allow changes to be made
- daily currency exchange rate e.g xe.com
- Freight Insurance (to come later)
This will feed into the automated, bespoke offers to customers.
6. WhatsApp integration
7. LinkedIn integration to gather specific leads and co-ordinate Linekdin outreach
Project ID:
3438775
Project category:
Project budget:
View this project in detail
(Note: you will be redirected to external marketplace)
Last Projects / Browse Projects
  Project Started
digital marketing
Category: Content Strategy, Google Analytics, Internet Marketing, Keyword Research, Link Building, Marketing, SEMrush, SEO
Budget: ₹12500 - ₹37500 INR
23 Dec 2025 11:03 GMT
Website Performance Optimization Expert
Category: Front End Design, JavaScript, MySQL, Performance Tuning, PHP, Web Development, Website Optimization, WordPress
Budget: ₹12500 - ₹37500 INR
23 Dec 2025 11:02 GMT
Bulk Messaging App Development
Category: API, API Development, Compliance, Excel, Facebook API, Mobile App Development, N8n, Software Documentation, Web Application, Web Development
Budget: ₹1500 - ₹12500 INR
23 Dec 2025 11:01 GMT
Full stack guy with experience in Laravel, php, Postgres db, python, STRIPE is A+ (october cms)
Category: Agile Development, API Development, Documentation, HTML, Laravel, MySQL, OctoberCMS, PHP, SEO, Web Development
Budget: ₹37500 - ₹75000 INR
23 Dec 2025 11:01 GMT
Publicar página neutral en Wikipedia
Category: Article Rewriting, Article Writing, Castilian Spanish Translator, Content Writing, Copy Editing, Editing, Research, Spanish Translator
Budget: €30 - €250 EUR
23 Dec 2025 10:58 GMT
Annual Revenue & Projection Spreadsheet Update
Category: Accounting, Data Analysis, Data Entry, Data Management, Excel, Finance, Financial Analysis, Financial Modeling
Budget: £5 - £10 GBP
23 Dec 2025 10:57 GMT
Madrid Bilingual On-Site IT Support
Category: Documentation, Helpdesk, IPad, IPhone, Microsoft Azure, Office 365, Technical Support, Troubleshooting
Budget: €10 - €50 EUR
23 Dec 2025 10:56 GMT
Figma Design into Next.js
Category: CSS, Figma, HTML, JavaScript, Next.js, SEO, Tailwind CSS, Web Design
Budget: $30 - $250 USD
23 Dec 2025 10:56 GMT
Zephyr RTOS RISC-V Port
Category: Arduino, Electronics, Embedded Systems, FPGA, Microcontroller, RTOS, SoC Design, Verilog / VHDL
Budget: ₹12500 - ₹37500 INR
23 Dec 2025 10:55 GMT
Realistic Fairytale Illustration -- 2
Category: 2D Drawing, 2D Game Art, Caricature & Cartoons, Concept Art, Digital Art, Graphic Design, Illustration, Photoshop, Visual Arts
Budget: ₹1500 - ₹12500 INR
23 Dec 2025 10:55 GMT
Vocal Remover & Lyric Auto-Sync Tool ( karaoke )
Category: Audio Editing, Audio Engineering, Audio Processing, Audio Production, Audio Services, Desktop Application, Music, Python, Software Development, Sound Design
Budget: $250 - $750 USD
23 Dec 2025 10:55 GMT
Modern Business Card PSD Design -- 2
Category: Adobe Creative Cloud, Adobe Illustrator, Branding, Business Card Design, Graphic Design, Logo Design, Photoshop, Print Design
Budget: $15 - $25 USD
23 Dec 2025 10:54 GMT
YouTube Ads: Soccer Coach Tool
Category: Advertising, Digital Marketing, Facebook Marketing, Internet Marketing, Lead Generation, YouTube Ads
Budget: $30 - $250 USD
23 Dec 2025 10:53 GMT
Fashion Event Sponsor Pack Design
Category: Adobe Illustrator, Adobe InDesign, Branding, Brochure Design, Graphic Design, Illustration, Marketing, Print Design
Budget: ₹12500 - ₹37500 INR
23 Dec 2025 10:52 GMT
Business Development Executive (Upwork Lead Generation & Client Acquisition)
Category: Account Management, Business Analysis, Business Consulting, Business Development, Business Strategy, CRM, Lead Generation, Marketing, Proposal Writing, Sales
Budget: ₹750 - ₹1250 INR
23 Dec 2025 10:52 GMT
Browse All Projects
Projects by Skills ...
android
ajax
asp
aspnet
cms
cpp
csharp
css
delphi
design
drupal
excel
facebook
flash
html
java
javascript
joomla
iphone
mysql
photoshop
php
python
ruby
seo
sql
sysadm
translate
typing
twitter
vbnet
xml
wordpress
writing
New!
Проекты на русском
(Projects in Russian)

Copyright © 2005-2025
1001 Freelance Projects