Need urgent WP/Woocomerce help

[supereek]

I have a pain in the ass client for who I am creating a WooCommerce shop.
He sells Article Editing services online.

The problem comes with the pricing. He has sent me an Excel sheet with pricing + delivery time options.

Example: Product = Standard Editing Service

Amount of words	Price for 24 hour delivery	Price for 36 hour delivery	Price for 48 hour delivery
1-50	5	5	4
51-100	7	6	5
100-150	10	9	8
and so on until f#ck!ng 12000 WORDS!

So each product has like 300 own price variations. I know this is doable with WooCommerce Product variations with A LOT of data entry, but the issue becomes that once you are on the product page, when you click on the variations drop-down you end up with an endless scroll-down list to choose from.

He wants an input-field on the product page where the client has to ENTER the amount of words, and the calculation should be done automatically for it. It's NOT a static variation I can use a math formula for as his prices seem random/self-invented.

How do I approach this? I already tried some conditional fields plugins, but I can't seem to get the pricing and front-end view as required.

 

[Evoxt]

I am thinking of a variation plugins that separate 4 of them into 4 different categories. But 12000 looks like there will be too much category in each selection.
You might need to custom code this then, I don't think there is any plugin that can cater to this need.

Charge your customer more xD

 

[davids355]

Why don’t you tell him it’s not logical doing it this way and instead to do, for example, 50 word increments and then a quantity. So if you want 500 words it’s 10 x 50 word pack, and then you select delivery time.

Sometimes the solution for a client is that it needs to be done differently.

 

[GridPanel]

Export the spreadsheet as a CSV and write a small function to open it and pull out the shipping prices then overwrite them in the woocommerce shipping totals hook?

 

[supereek]

Why don’t you tell him it’s not logical doing it this way and instead to do, for example, 50 word increments and then a quantity. So if you want 500 words it’s 10 x 50 word pack, and then you select delivery time.

Sometimes the solution for a client is that it needs to be done differently.

Makes sense and I will talk with him about it. Any ideas about the price reduction how this should work? For example 50 words = $5, but 5K words should have a reduced price because of the bulkier order.
I was thinking on some kind of conditional plugin but haven't found a proper one yet.

 

[davids355]

Maybe woo dynamic pricing in conjunction with the above?

https://docs.woocommerce.com/document/woocommerce-dynamic-pricing/#section-6
Looks like with bulk categories you can provide discounts when quantities are within specified brackets.