How to set all product tax categories the same?

  • Posts: 121
  • Thank you received: 7
12 years 2 months ago #65364

I only have one tax category and I'd like all products to be part of it (the 'default tax category'). Is there a way to change this in batch for all products? And perhaps a way to make it so all new products are a member of that tax category?

Please Log in or Create an account to join the conversation.

  • Posts: 2334
  • Thank you received: 403
12 years 2 months ago #65404

Hi Jeremynsl,

Theoretically the tax category should be selected by default when you create a new product. Is this category published?

Please Log in or Create an account to join the conversation.

  • Posts: 121
  • Thank you received: 7
12 years 1 month ago #66702

Hi eliot,

The category is published and works fine when I set it manually on a product - its the 'default' tax category. All of the products are set to 'none' however.

Could this be because I imported my products from a text file? I did not fill in anything for the tax category in the text file... Well, regardless I still need to set all the categories to 'default' tax category in batch somehow now.

Please Log in or Create an account to join the conversation.

  • Posts: 82818
  • Thank you received: 13362
  • MODERATOR
12 years 1 month ago #66962

Ah yes, if you don't set the category tax id in your CSV, no tax category will be applied to your products.

You should add a product_tax_id column in your CSV with the id of the tax category and reimport and that will set it.

Please Log in or Create an account to join the conversation.

  • Posts: 121
  • Thank you received: 7
12 years 1 month ago #67010

Ok. I actually added it using the text input field... I didn't save the text I imported. Do I need to type out all the product names in order to overwrite there settings? I can't see any way to just use the product ID.

ie. I could use the text input field like:
product_id,tax_category_id
1,1
2,1
3,1
etc.

Is it possible?

Please Log in or Create an account to join the conversation.

  • Posts: 121
  • Thank you received: 7
12 years 1 month ago #67062

I just updated all the products manually one at a time ;) I'll be more careful next time when importing products!

I do think it might be good to have product id as one of the import target categories though, in a future version.

Please Log in or Create an account to join the conversation.

  • Posts: 82818
  • Thank you received: 13362
  • MODERATOR
12 years 1 month ago #67157

You can't do it with the product_id but you can do it with the product_code:

product_code,tax_category_id
my_prod1,1
my_prod2,1
my_prod3,1
etc.

Please Log in or Create an account to join the conversation.

  • Posts: 121
  • Thank you received: 7
12 years 1 month ago #67446

Yes, I saw that but the nice thing about product id is that you don't have to copy and paste product codes. If you have 50 products, then your product ids range from 1-50 - no need to know there code or names.

Please Log in or Create an account to join the conversation.

Time to create page: 0.073 seconds
Powered by Kunena Forum