automatic price calculation through purchaseprice/cost of good

€30-250 EUR

Cancelled

Posted

almost 8 years ago

€30-250 EUR

Paid on delivery

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")))))))))))

Project ID: 11172033

About the project

19 proposals

Remote project

Active 8 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

19 freelancers are bidding on average €171 EUR for this job

@shinemonkey212

Flag of 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 in 3 days

5.0

(112 reviews)

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 in 10 days

5.0

(135 reviews)

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 in 3 days

5.0

(102 reviews)

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 in 5 days

4.8

(218 reviews)

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 in 3 days

4.7

(8 reviews)

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 in 2 days

4.3

(8 reviews)

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 in 3 days