automatic price calculation through purchaseprice/cost of good

€30-250 EUR

Скасований

Опублікований

almost 8 years ago

€30-250 EUR

Оплачується при отриманні

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 проекту: 11172033

Про проект

19 пропозицій(-ї)

Дистанційний проект

Активність 8 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни

Отримайте гроші за свою роботу

Опишіть свою пропозицію

Реєстрація та подання заявок у проекти є безкоштовними

19 фрілансерів(-и) готові виконати цю роботу у середньому за €171 EUR

@shinemonkey212

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

€222 EUR за 3 дні(-в)

5,0

(112 відгуки(-ів))

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 за 10 дні(-в)

5,0

(135 відгуки(-ів))

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 за 3 дні(-в)

5,0

(102 відгуки(-ів))

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 за 5 дні(-в)

4,8

(218 відгуки(-ів))

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 за 3 дні(-в)

4,7

(8 відгуки(-ів))

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 за 2 дні(-в)

4,3

(8 відгуки(-ів))

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 за 3 дні(-в)