automatic price calculation through purchaseprice/cost of good

€30-250 EUR

Abgesagt

Veröffentlicht

vor mehr als 7 Jahren

€30-250 EUR

Bezahlt bei Lieferung

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

Projekt-ID: 11172033

Über das Projekt

19 Vorschläge

Remote Projekt

Aktiv vor 8 Jahren

Möchten Sie etwas Geld verdienen?

E-Mail-Adresse

Vorteile einer Ausschreibung auf Freelancer

Legen Sie Ihr Budget und Ihren Zeitrahmen fest

Für Ihre Arbeit bezahlt werden

Skizzieren Sie Ihren Vorschlag

Sie können sich kostenlos anmelden und auf Aufträge bieten

19 Freelancer bieten im Durchschnitt €171 EUR für diesen Auftrag

@shinemonkey212

Flagge von 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 Tagen

5,0

(112 Bewertungen)

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 Tagen

5,0

(135 Bewertungen)

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 Tagen

5,0

(102 Bewertungen)

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 Tagen

4,8

(218 Bewertungen)

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 Tagen

4,7

(8 Bewertungen)

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 Tagen

4,3

(8 Bewertungen)

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 Tagen