Results 1 to 7 of 7
  1. #1
    Join Date
    Jul 2006
    Posts
    83
    Plugin Contributions
    0

    Default Adding a tax class to a Category

    I am missing something in setting up taxes and I am making a plea for help. Below are the configuration settings checklist.

    I am able to assign a tax definition to Shipping and that value is taxed.

    What I am struggling on is... I have ZenCart attached to a Photo Gallery (Gallery2/G2). Each photo creates a product. That all works. What I am trying to figure out is how assign a tax rate to a Category, so that each product/photo that is added to a category is automatically assigned a tax class.

    I can go in to each photo, aka Product/item individually and assign a tax class and taxes are calculated during checkout. All that works A-ok. What I am struggling with is... how to assign a tax class to a Category. I have tried to nest (if that is the right word) the Photo Category under an Item Type for General Products which has a default tax rate assigned to it. I believe it is referred to as a sub-category. But it is not assigning a tax class to each new item that is created. From everything I have read, this is how to go about it.

    Sooooooo... I'm missing something because from all that I have researched, this is the approach, yes? Can anyone help me with how to assign a tax class to a Category so new products assigned to that Category will acquire the tax class by default?

    tia



    What are your store settings for these set to?
    Admin->Configuration->My Store
    a. Country/Zone USA
    b. Basis of Product Tax Billing
    c. Basis of Shipping Tax Shipping
    d. Display Prices With Tax False
    e. Display Prices With Tax-Admin False


    2. What Zone Definitions have you created?
    Admin->Locations/Taxes->Zones Definitions

    CO (colorado)


    3. Inside each of those zone definitions, what country/zone combinations have been selected?
    Admin->Locations/Taxes->Zones Definitions, click on "Details" button for each zone

    United State/Colorado


    4. What tax classes do you have?
    Admin->Locations/Taxes->Tax Classes

    Taxable Goods


    5. What tax rates have you created?
    Admin->Locations/Taxes->Tax Rates

    CO Tax 7.4%


    6. What tax class have you associated with your products?
    Admin->Catalog->Categories/Products->click on a product to edit it

    1


    7. What tax class have you associated with each of your shipping modules?
    Admin->Modules->Shipping

    none


    Running ZenCart 1.3.9
    No Add-ons

  2. #2
    Join Date
    Jul 2006
    Posts
    83
    Plugin Contributions
    0

    Default Re: Adding a tax class to a Category

    Ok, let me try to explain it this way, simpler. I have followed the instructions to add a default tax to a Category. My problem is when I go to Edit Layout for the particular Category (photos), the Layout screen is blank. There is no place for me to add the default tax ID number.

    So, I go to Catalogue/Item Types, and click on Edit for the Product - Photos type (since Edit layout is blank). I reassign the Item Type under the drop down

    "This item type should be considered a sub-type of"

    And I assign it to Product General which does have a correct default tax ID assigned to it. I then add products to the Photo category which has been nested under Product General, but the tax is still not being added.

    Help anyone? I keep staring at screens and searching for ideas hoping something will unfold... but am stumped.

    Help?

  3. #3
    Join Date
    Jul 2006
    Posts
    83
    Plugin Contributions
    0

    Default Re: Adding a tax class to a Category

    Anyone?

  4. #4
    Join Date
    Jul 2006
    Posts
    83
    Plugin Contributions
    0

    Default Re: Adding a tax class to a Category

    No one has any ideas?

  5. #5
    Join Date
    Jun 2005
    Location
    Cumbria, UK
    Posts
    10,262
    Plugin Contributions
    3

    Default Re: Adding a tax class to a Category

    Quote Originally Posted by drhiii View Post
    No one has any ideas?
    Doesn't look like it, I'm afraid...

    However... I doubt this is possible... or if it is, it will require some very nifty code, and you will probably have to hire someone to do it for you.

    The way the program is structured is that it (rightfully) assumes taxes are related to PRODUCTS, which are then associated with other factors, such as geographical locations (zones).

    A CATEGORY is not something that can be sold, or have a monetary value associated with it.

    Your solution will more than likely be a piece of code that firstly identifies a CATEGORY, but STILL applies tax classes to the products within it. A functionally possible procedure... but probably a bit complicated to code... especially if you want a nice "interface" in the admin panel to make appropriate selections.
    19 years a Zencart User

  6. #6
    Join Date
    Jul 2006
    Posts
    83
    Plugin Contributions
    0

    Default Re: Adding a tax class to a Category

    Thank you for the response. Got kind of lonely out there.

    A year or so ago I come at this and was able to accomplish this by 'copying' atributes to a Category but today I it is not replicating the way I thought I had done. Maybe I am nuts, but I recall getting this to work and was hoping someone would land on the solution. Your explanation is of course correct... maybe I was imagining this before. Hmmm.

    Anyway, thank you for your response. Not so lonely out there now.

  7. #7
    Join Date
    Sep 2011
    Location
    Minnesota, whine country, where the grapes suffer
    Posts
    4
    Plugin Contributions
    0

    Default Re: Adding a tax class to a Category

    I have the same problem.

    Here's my solution. Use PHPpanel and dump the table zen_products_to_categories to an CSV file and open it in excel

    Then go into your admin->categories and drill down to the lowest level sub category that has products where you want to change their tax_class ... write down that category ID #

    copy all product IDs from the spread sheet that have that matching category/sub-category #

    in excel create something like Concatenate("Update zen_products Set products_tax_class_id = <your new id here> where products_id =", <excel cell # of ID>)
    copy that columm
    Paste into an excel query in phpadmin where that table is open into the query window

    <GO>

    sloppy... but it works

 

 

Similar Threads

  1. Replies: 3
    Last Post: 18 Jan 2014, 12:24 AM
  2. Sales Tax is being added to all items regardless of tax class
    By sparrish in forum Currencies & Sales Taxes, VAT, GST, etc.
    Replies: 1
    Last Post: 17 Oct 2008, 05:48 PM
  3. Tax Class
    By beth99 in forum General Questions
    Replies: 5
    Last Post: 12 Nov 2006, 03:57 PM
  4. tax added even when tax class = none?
    By zoreli in forum Currencies & Sales Taxes, VAT, GST, etc.
    Replies: 6
    Last Post: 18 Sep 2006, 07:53 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR