Create program to automate calculation of profit of sales

Đã Đóng Đã đăng vào 5 năm trước Thanh toán khi bàn giao
Đã Đóng Thanh toán khi bàn giao

Requirement :

Please download the files to understand the project , there is a video file to explain my requirement

[login to view URL]

You can also watch the video via youtube

[login to view URL]

I need a program to automate the calculation of my profit for website I am selling on.

website Shopee

In shopee , I am able to download file of orders (refer order file folder)

I need the program to calculate the profit by performing the following

[login to view URL] the Total Released Amount – from the settlement file (settlement file folder, column K value(there should be somewhere I can change the column in case the website changed the Total Released Amount to another column)

[login to view URL] the total order cost –

- Program has to have an excel database (refer to database folder) that stores which value to refer to in the [login to view URL] in order to calculate the total order cost

Example of the program interface

The program will first go to database to match the the product name and product variation to see if value has been set , if not found then will prompt screen for buyer to select the matching value in the [login to view URL] to set.

[login to view URL] gross profit and net profit

THERE SHOULD BE BE SOMEWHERE I CAN CHANGE THE COLUMN TO REFER TO AS SHOPEE CHANGES THE COLUMN POSITION NOW AND THEN

Gross Profit= Products' Price Paid by Buyer (MYR) (Column G)-Total Order Cost (Column AC)

Nett Profit =Total Released Amount(Column AB)-Total Order Cost(Column AC)

The columns of Products' Price Paid by Buyer (MYR) ,Total Order Cost,Total Released Amount,Total Order Cost- The columns location may change , please have a file/somewhere where I can change the column variable

Excel MySQL PHP Kiến trúc phần mềm Visual Basic

ID dự án: #18263713

Về dự án

8 đề xuất Dự án từ xa 5 năm trước đang mở

8 freelancer chào giá trung bình$109 cho công việc này

schoudhary1553

Hello, Hope you are doing well. I can help with you in your project Create program to automate calculation of profit of sales. I can assure you the quality job. I have good experience in Excel, MySQL, PHP, Sof Thêm

$200 AUD trong 5 ngày
(330 Nhận xét)
7.8
surekash7096

I have the expertise in Excel and the experience in creating applications using macros. I can build the spreadsheet as per your requirements quickly and accurately as per your requirements.

$30 AUD trong 1 ngày
(69 Nhận xét)
5.4
EtherealCode

Hello.. How are you? I am an expert developer and able to do this work, I checked the video and read the job details carefully. I am sure I will do it. Can you please share more details for it. Looking forward Thêm

$250 AUD trong 6 ngày
(2 Nhận xét)
3.9
dataexplorer

"Hi Dear, I’m an efficient data entry worker. I’m familiar with Google docs spreadsheet and I’ve experienced about collecting data from websites and enter into Excel and Google docs spreadsheet. I would love to tell Thêm

$50 AUD trong 3 ngày
(17 Nhận xét)
3.9
MasterKym

Hello, I am a statistician and R programmer. I have read your project description and here is an approach I can suggest for you. So since the sales data is present on the website, it is possible to twist things. It is Thêm

$166 AUD trong 10 ngày
(5 Nhận xét)
2.9
JadavSaikrishna

Hi, I can do this project easily because I have been developing and making the changes in Excel applications using VBA and SQL from last 6 years. I got appreciations from clients like British Petroleum and Wipro T Thêm

$50 AUD trong 3 ngày
(2 Nhận xét)
1.3
Ravbot

Hello Sir... Hope you doing well, I read your project description so please come for technical discussion and we understand the negotiate cost, timeline then we move proceed further, also i show my past work during Thêm

$25 AUD trong 1 ngày
(3 Nhận xét)
0.9