Search Knowledge Base by Keyword

Can you see a way to combine these into a smaller number of rules?

In this guide, we will help you understand how you can combine a huge set of shipping rules and import it into the WooCommerce Table Rate Shipping Pro Plugin. Read below to know more about it.

Customer:
I’ve checked out your demo site before purchase, and I know that Shipping Pro can do this table as 4800 individual rules. Will that causes a significant slowdown at checkout? Can you see a way to combine these into a smaller number of rules?


Support:
You will not have any issue with 4800 rules. Could you please provide us the complete table using which we can analyze the rules and let you know if something can be shortened. The current CSV file has only two rules.

Note: The only hindrance that you may have, is the PHP post issue which limits the number of rules that can be added to one page. However, this should not be a concern for you as you can upload the rules in CSV format using the button “Import CSV” in plugin settings page.


Customer:
I have sent you a file with four sheets, 1200 rules each. Again, can this number be reduced or, is there a script that could convert this spreadsheet to the import layout?


Support:
In the sheet provided, we assume the columns 1,2,3,4,5,6,7,8,9,..120 are weights.
Considering Apex, K2, Sherpa, and Clip strips are products/product categories.
There are some ways you can combine the rules:
–  Rows 2&4&7, 3&6,  8&10, 9&11 for Apex seem identical. So one set of rule for 2,4,7 will do keeping postcode as 00000-12000,33001-35000,83001-88000.
-Similarly, in every sheet, there are rules which are identical. You can club them to write one set of rules for similar postcode ranges.
Also,
Unfortunately, we do not have any script to convert this spreadsheet to the import layout. The best way you can configure is to create one rule in Shipping Pro, exporting that into CSV and then manually create rest of the rules in the CSV.
Hope that was clear!


Customer:
No, those are quantities, not weights. Can it be done with quantities?


Support:
Even if they are quantities, the approach remains the same as mentioned in our previous reply. In the Based on the field you need to opt for the option “Item” and in the min-max item count, you need to set the range of items. We suggest you try creating some rules in demo version and check if it suits your business case.

Last Updated On September 21, 2018