Can I change the Tax Class on all my products? (EasyPopulate set None)

17 Mar 2010, 4:46 PM

#1

msrwebmaster

New Zenner

Join Date:: Sep 2008
Location:: Calgary, AB
Posts:: 33
Plugin Contributions:: 0

Can I change the Tax Class on all my products? (EasyPopulate set None)

Zencart 1.3.8a
Easy Populate 1.2.5.4

The default of Easy Populate is currently to set my Tax Class: -none-

Is there a way to set all products on my store to use my Worldwide Tax Class?

Happily we're in Alberta so my tax is simply 5% to all items in my store.

Thanks in advance!

My Sewing Room
#148, 8228 Macleod Tr SE, Calgary, AB T2H 2B8
mysewingroom.ca

17 Mar 2010, 4:51 PM

#2

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,511
Plugin Contributions:: 176

Re: Can I change the Tax Class on all my products? (EasyPopulate set None)

http://www.zen-cart.com/forum/showthread.php?t=61896

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

17 Mar 2010, 5:10 PM

#3

msrwebmaster

New Zenner

Join Date:: Sep 2008
Location:: Calgary, AB
Posts:: 33
Plugin Contributions:: 0

Re: Can I change the Tax Class on all my products? (EasyPopulate set None)

Thanks for the reply.

To help other searches and save unnecessary hair loss:

Step.1

Admin>Configuration>Easy Populate

Upload/Download Prices Include Tax

Set this to True as I presume it will change any new products.

Step.2

Admin>Tools>Easy Populate

Download Complete tab-delimited .txt file to edit (Attributes Not Included)

Change all of the -none- listings to the tax class you've created and then just upload this newly revised document to your database with Easy Populate.

My Sewing Room
#148, 8228 Macleod Tr SE, Calgary, AB T2H 2B8
mysewingroom.ca

17 Mar 2010, 5:34 PM

#4

msrwebmaster

New Zenner

Join Date:: Sep 2008
Location:: Calgary, AB
Posts:: 33
Plugin Contributions:: 0

Re: Can I change the Tax Class on all my products? (EasyPopulate set None)

Perhaps I am incorrect with Step.1 as how would it know to use one tax class over another?

Step.2 works great I will need to add v_tax_class_title and my tax class to my excel document macro for future updates.

My Sewing Room
#148, 8228 Macleod Tr SE, Calgary, AB T2H 2B8
mysewingroom.ca

17 Mar 2010, 5:48 PM

#5

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,511
Plugin Contributions:: 176

Re: Can I change the Tax Class on all my products? (EasyPopulate set None)

Sorry, I don't use EP. But the link I posted earlier shows how to adjust existing records already in your database.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

17 Mar 2010, 8:29 PM

#6

msrwebmaster

New Zenner

Join Date:: Sep 2008
Location:: Calgary, AB
Posts:: 33
Plugin Contributions:: 0

Re: Can I change the Tax Class on all my products? (EasyPopulate set None)

Step.1

Admin>Configuration>Easy Populate

Upload/Download Prices Include Tax

Set this to True as I presume it will change any new products.

Don't do Step.1!

Ha, this changes all your prices to include tax. So when it comes to checkout it will subtract tax from your items and add them back in the Tax Subtotal.

My Sewing Room
#148, 8228 Macleod Tr SE, Calgary, AB T2H 2B8
mysewingroom.ca