cancel
Showing results for 
Search instead for 
Did you mean: 

Is my tax table too large for magento to handle? 41,000 lines

SOLVED

Is my tax table too large for magento to handle? 41,000 lines

I am based in the US and we are having to report now to almost every state for sales and pay taxes etc... I have created a tax table for magento1 CE based on the tables from here: https://www.avalara.com/taxrates/en/download-tax-tables.html

 

I have formatted the data to work with M1 format and combined all the tables in to one file as well. 

 

After combining everything and formatting the data, there are almost 41,000 lines in the file. Is this going to be a problem, make things slow, or make M1 crash? I was hoping to get someone with some experience on this before trying it. Of course, the store would be backed up prior to the upload.

 

Thank you for any input, it is GREATLY appreciated.

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Is my tax table too large for magento to handle? 41,000 lines

Hello @niktronix ,

 

Yes, It's acceptable. 

 

--
If my answer is useful, please Accept as Solution & give Kudos

View solution in original post

4 REPLIES 4

Re: Is my tax table too large for magento to handle? 41,000 lines

Hello @niktronix ,

 

I don't think so it takes too much time. It only request one time query on checkout page. If you still want to check how much time that required then enable profile by below link

https://inchoo.net/magento/keeping-your-magento-fit-with-built-in-profiler/

 

 

--
If my answer is useful, please Accept as Solution & give Kudos

Re: Is my tax table too large for magento to handle? 41,000 lines

@gelanivishal 

I am confused by your answer just a little as you said, "I don't think so it takes too much time."

 

Do you mean that the size is acceptable?

 

 

Re: Is my tax table too large for magento to handle? 41,000 lines

Hello @niktronix ,

 

Yes, It's acceptable. 

 

--
If my answer is useful, please Accept as Solution & give Kudos

Re: Is my tax table too large for magento to handle? 41,000 lines

Thank you very much for your assistance, it is very much appreciated.