maxmumford
Forum Replies Created
-
Forum: Everything else WordPress
In reply to: Can't reply or edit my support postAll done, here’s the new post:
https://wordpress.org/support/topic/permission-denied-on-adminphp-1?replies=0#post-8211674
So you can close the other one.
Thanks very much for your help 🙂
Forum: Everything else WordPress
In reply to: Can't reply or edit my support postAhh ok thanks for removing it. Are you able to give me edit access so I can remove my email address and fix the code formatting?
Forum: Plugins
In reply to: [Weight Based Shipping for WooCommerce] Generating 1000 rules with a scriptHi guys,
Sorry for the late reply, I’ve been swamped, and this project unfortunately has been put on indefinite hold… Feel free to fork and modify the script though.
Good luck
MaxForum: Plugins
In reply to: [Weight Based Shipping for WooCommerce] Generating 1000 rules with a scriptAh I see. Thanks for your help.
In case anybody in the future sees this thread and decides to go the same route, feel free to use my import script found on github here:
https://github.com/maxmumford/woocommerce-weight-shipping-import
It’s very slow but does the job…
Max
Forum: Plugins
In reply to: [Weight Based Shipping for WooCommerce] Generating 1000 rules with a scriptHello,
Sorry for the late reply; I was working on other parts of the site.
With 1200 rules it takes about 7 seconds on a slow testing sever to perform the shipping calculation on the checkout page. Once reduced to 600 it took 5 seconds, which will be too slow in production once concurrent users visit the site.
I’ll take a look into using the fedex API instead, otherwise I’ll create a custom plugin. Am I right in thinking the main performance limitation for this plugin is the fact that the rules are saved as wp_options and aren’t in their own table?
Cheers
Max.Forum: Plugins
In reply to: [Weight Based Shipping for WooCommerce] Generating 1000 rules with a scriptHello,
Unfortunately the rates do not increase at a set step each kg – each kg becomes cheaper and cheaper the larger the order becomes. I.e. 1kg is £1, 2kg is £2, 3kg is £2.90 and so on. For this reason I can’t just use the step field.
Here are the first 8 rows from the rates table (total of 141 rows):
Weight,A,B,C,D,E,F,H,R,S,T,U,V,W 0.5,11.03,20.95,25.34,32.04,38.22,21.22,11.03,10.25,10.25,13.22,14.76,19.71,10.25 1,12.07,23.21,26.02,36.01,38.22,23.63,12.07,10.25,10.25,13.22,14.76,21.66,10.25 1.5,13.1,25.46,29.24,39.97,38.22,26.05,13.1,10.25,10.25,13.22,14.76,23.6,10.25 2,14.14,27.72,32.46,43.92,40.74,28.46,14.14,10.25,10.25,13.22,14.76,25.55,10.25 2.5,15.18,29.97,35.68,47.88,44.69,30.87,15.18,10.25,10.25,13.22,14.76,27.5,10.25 3,15.77,31.69,37.54,50.55,48.08,31.68,15.77,10.25,10.25,13.22,14.76,28.63,10.25 3.5,16.36,33.41,39.38,53.3,51.18,33.24,16.36,10.25,10.25,13.22,14.76,29.76,10.25 4,16.95,35.14,41.22,56.05,54.27,34.79,16.95,10.25,10.25,13.22,14.76,30.89,10.25Each letter indicates a zone, which is a collection of countries. With one rule per country and weight bracket I will need 1833 rules to achieve this. Unless you can think of a better way?
In the meantime I will do some performance testing to get an idea of how efficient it will be.
Cheers
Max.