I'm wondering if i can just do this or not .. did not gave it a try bcz i'm afraid this should not crash my server.
For defining table rate shipping, weight vs Destination, I do have 12,000 ZIP Codes, with each one having at least two shipping prices
Weight – 0-500grams – $1 – $3 (depending upon the zip/postal code)
Weight – 500-1000grams – $3 – $4.5 (depending upon the zip/postal code)
So is it just doable to have 24,000 rows in csv file and update them in database ?
P.S. I thought of defining state name with * in picodes and then having expictly those pincodes that have different shipping rules, but It doesnt seems doable, as State isnt a required option at checkout page, neither Indian States have a dropdown built in.
How can i achieve defining postal code based shipping without hurting magento database or performance .
edit 1:
Created list of states in db, but state filter can only reduce the csv rows to upto 7-8k not less than that.. looking for another level of filter .
EDIT 2
As per the Marius Suggestion, Tried updating some 1K Records at once and it works perfect.
I guess when i upload another csv sheet it should update the existing records, or append the new ones. 🙂
Best Answer
My opinion is to use the default table rates shipping method.
Even if you get 24k rows, it's not like all of them will be loaded at once.
There is a select made based on the values you enter in the checkout and you only get one row.
Searching in 24k rows is not that bad.
The highest number of records I got so far for the table rates is somewhere around 10k and the website runs smoothly.