[SOLVED] price calculator
July 21, 2018 at 9:45 am #7343
I created the calculator with all options for my product, as you can see here in my website : https://ledpartners.fr/produit/led-back/
But i dont understand how to edit the excel sheet to make price change for each new option chosen
Can you please help me to edit the excel to make the prices i want ? You can see in the excel attached all the prices i want for each criteria
Thanks a lot !!July 23, 2018 at 8:12 am #7349
If I go to this link (ledpartners.fr/produit/led-back/) I see the message “Ce site est en cours de construction…”
Can you send the access to your website to this email (https://altoswebsolutions.com/contact-us).
AT519July 23, 2018 at 3:58 pm #7348
I’m sending you my version of your calculator (sheet: Paul_version)
– How can you calculate “TEXTE”?
– How can you calculate the final price?
I suggest to you to change your list fields, for example to this:
name field: POSE PAR NOS TECHNICIENS
labels items: Non Merci, Oui
value items: 0, 600
AT519July 23, 2018 at 5:28 pm #7347
Thanks for your answer. As i tried to explain in my excel :), TEXT is the possibility for the user to enter the text he wants to create (we sell LED SIGNS). So
TEXT = HAUTEUR*number of letters entered by the user
TOTAL PRICE = the sum of all the options + (HAUTEUR*number of letters entered by the user)
for example, if user enters in text field : google (6 carhacters)
and for HAUTEUR he entered : 5 (so 50€)
TEXT : 50*6=300€
and if all other options cost 600€
then TOTAL PRICE = 600€ + 300€
is that more clear ?
I dont understand in the excel you sent me why there is various tabs and where i am supposed the label and value items you mention above…can you please send me the exact excel please or give me an example ?
Thanks a lot !!July 24, 2018 at 1:26 pm #7346
Okay I understood.
I’m sending you the calculator.
In this file excel you will find 2 sheets:
[li]”Calculator” is what you will import in your calculator plugin.
[li]”Criteria” is your old “Calculator” sheet with some modifies. I added to columns “Type” (type of the input field) and “Special” (It means you have to modify your fields). [attachment=270]calculator2.xls[/attachment]I wrote lower in the the same sheet how you can create those “special” fields.[/li]
Let us know if you have more questions.
AT519July 24, 2018 at 2:02 pm #7345
Thanks for your answer !
I had to make some edits in the calculator sheet you gave me (total price formula was wrong and i did not understand why default options were not 0). You can see the changes in the excel attached in RED.
can you tell me please if its all ok ? i did not know how to pick the cells at the second step for example the difference PRICE and TOTAL PRICE (please see screenshot attached)…
also, how can i put that that minimum HAUTEUR is 5 and that user gets an error message when he enters a number below 5 ?
I added a field called POIDS (WEIGHT in english) because i need the weight calculated to fix the shipping price later.
The weight is ONE LETTER (in TEXT field) = 1 Kg
But i DONT need this field to appear in the front end, so please tell me how it can be taken into account though…
finally where can i translate the words in english to french ? please see screenshot attached
and i put with css code a way to hide image in cart page (see screenshot attached), so that product info can be shown better but it does not help…how can i do please ?
thanks for your help !July 25, 2018 at 2:13 pm #7344
thanks for your answer !
about translations, when i activate the plugin mentioned in your post, it makes my website down (please see screenshot)…so what do i have to do ?
finally about weight, it is variable i guess, as one letter entered in “ENTREZ VOTRE TEXTE” field = 1 KG
i put it in excel sheet and put “overwrite woocommerce weight” in calculator, but it is not working….
what else do i have to do please ?
- You must be logged in to reply to this topic.