automatic price calculation through purchaseprice/cost of good

€30-250 EUR

Dibatalkan

Dibuat

hampir 8 tahun yang lalu

€30-250 EUR

Dibayar ketika dikirim

We want a system that we can import all the purchaseprice/cost of good for each product and after that shop can calculate automatic prices for each role base user/group/customer. Example the code of the calculating in excel: Customer [login to view URL] =ALS(A3="";"";ALS(A3<0;"Input Error! Please Enter value between 0 to 120";ALS(A3<=2;(A3*1,05+2)*1,21;ALS(A3<=4,99;(A3*1,05+2)*1,21;ALS(A3<=10;(A3*1,05+2)*1,21;ALS(A3<=15;(A3*1,05+2)*1,21;ALS(A3<=25;(A3*1,05+1)*1,21;ALS(A3<=45;(A3*1,05)*1,21;ALS(A3<=70;(A3*1,05)*1,21;ALS(A3<=85;(A3*1,05)*1,2;ALS(A3<=120;(A3*1,05)*1,21;"Input Error! Please Enter value between 0 to 120"))))))))))) Customer [login to view URL] =ALS(A3="";"";ALS(A3<0;"Input Error! Please Enter value between 0 to 120";ALS(A3<=2;(A3*1,08+2)*1,21;ALS(A3<=4,99;(A3*1,08+2)*1,21;ALS(A3<=10;(A3*1,08+2)*1,21;ALS(A3<=15;(A3*1,08+2)*1,21;ALS(A3<=25;(A3*1,08+1)*1,21;ALS(A3<=45;(A3*1,08)*1,21;ALS(A3<=70;(A3*1,08)*1,21;ALS(A3<=85;(A3*1,08)*1,2;ALS(A3<=120;(A3*1,08)*1,21;"Input Error! Please Enter value between 0 to 120"))))))))))) Customer [login to view URL] SHOPS =ALS(A3="";"";ALS(A3<0;"Input Error! Please Enter value between 0 to 120";ALS(A3<=2;(A3*1,1+2)*1,21;ALS(A3<=4,99;(A3*1,1+2)*1,21;ALS(A3<=10;(A3*1,1+2)*1,21;ALS(A3<=15;(A3*1,1+2)*1,21;ALS(A3<=25;(A3*1,1+1)*1,21;ALS(A3<=45;(A3*1,1)*1,21;ALS(A3<=70;(A3*1,1)*1,21;ALS(A3<=85;(A3*1,1)*1,2;ALS(A3<=120;(A3*1,1)*1,21;"Input Error! Please Enter value between 0 to 120"))))))))))) Customer [login to view URL] WEBSHOP CUSTOMERS =ALS(A3="";"";ALS(A3<0;"Input Error! Please Enter value between 0 to 120";ALS(A3<=2;(A3*1,35+2)*1,21;ALS(A3<=4,99;(A3*1,35+2)*1,21;ALS(A3<=10;(A3*1,35+2+2)*1,21;ALS(A3<=15;(A3*1,38+2)*1,21;ALS(A3<=25;(A3*1,37+1)*1,21;ALS(A3<=45;(A3*1,36)*1,21+2;ALS(A3<=70;(A3*1,33+4)*1,21;ALS(A3<=85;(A3*1,27)*1,2+6;ALS(A3<=120;(A3*1,3)*1,21+2;"Input Error! Please Enter value between 0 to 120")))))))))))

ID Proyek: 11172033

Tentang proyek

19 proposal

Proyek remot

Aktif 8 tahun yang lalu

Ingin menghasilkan uang?

Alamat email

Keuntungan menawar di Freelancer

Tentukan anggaran dan garis waktu Anda

Dapatkan bayaran atas pekerjaan Anda

Uraikan proposal Anda

Gratis mendaftar dan menawar pekerjaan

19 freelancer menawar dengan rata-rata €171 EUR untuk pekerjaan ini

@shinemonkey212

Bendera LAO PEOPLE'S DEMOCRATIC REPUBLIC

Nice project! I have a great deal of experience in woocommerce and wordpress. Let's discuss for more detail. Thank you!

€222 EUR dalam 3 hari

5,0

(112 ulasan)

7,3

@freshonsolutions

Hello, I have developed many plugins as adons of woocommerce. you can check feedback of some those jobs for custom plugins I have developed here on freelancer jobs. Let's discuss the requirements in details and then I can get started on that. I am sure that I will not disappoint you. Talk soon, Thanks.

€166 EUR dalam 10 hari

5,0

(135 ulasan)

7,2

@SHIHABSHARAR

Hello there !! I have read your requirements for the task and i'm interested in your project . If you want to discuss further about the requirement in more details it would be really helpful for me to understand. In the meantime i can show you some of my projects too.Thanks.

€250 EUR dalam 3 hari

5,0

(102 ulasan)

6,6

@RITESHBATHWAL

Hello Sir, I have read your requirement and its clear that there is a price calculation matrix/rules for different user roles. Below is my plan to do this job: 1. I will create a plugin which will provide you an admin screen where you can upload an excel sheet of cost price of all products to import the prices into the database. 2. This screen will also allow you to configure price calculation rules for different users based on their roles. 3. The price calculation rule will be applied to the products on the front end when user places the order, based on their role. I just have one doubt that how the pricing rule actually works, what is the varible A3 and what is ALS mean in the pirice calculation rule. Once we contact, I can clarify the same. Please contact, sure solution will be provided as I have done similar tasks several times on woocomemrce.

€120 EUR dalam 5 hari

4,8

(218 ulasan)

6,8

@FIBIN

Hi I am interested to work for your project . I am an expert in excel and VBA Programming in Excel. I have experience working on lot of Excel based projects. I will make sure that I deliver you the best with 100% accuracy in minimum time . Pay me only if you are 100% satisfied with my work, after project delivery. I am interested to work for your project. Please give me a chance. I have handled many projects involving data manipulation handling, business solutions, Excel automated dashboards, Report Generation and Excel Applications. If you offer me your project, I can start immediately and deliver the job within 2 days after testing (QA) . I guarantee 100% accuracy for my deliverable. I do hope you'll give me the honorable chance to work with you and help me with making my mark on freelancer.com. I will take your project as the priority job and will complete your work in minimum time with 100% commitment. Thanks Fibin

€75 EUR dalam 3 hari

4,7

(8 ulasan)

4,0

@surekash7096

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.

€100 EUR dalam 2 hari

4,3

(8 ulasan)

3,2

@chetan2006

Hi I got your concept of calculations which you defined in description as per excel formulas but I have an query that this calculations should be set to backend or at frontend as per user logged in checking system..

€155 EUR dalam 3 hari