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. :-)