osCmax v2.5 User Manual
Results 1 to 8 of 8

Setting TAX CLASS to TAXABLE ITEM (ON ALL PRODUCTS)

This is a discussion on Setting TAX CLASS to TAXABLE ITEM (ON ALL PRODUCTS) within the osCmax v2 Customization/Mods forums, part of the osCmax v2.0 Forums category; Is there any fast way to set the tax class of all my products to TAXABLE ITEM? i have got ...

      
  1. 10-08-2008, 07:56 AM #1
    m2d^
    m2d^ is offline
    New Member
    Join Date
    May 2008
    Posts
    6
    Rep Power
    0

    Exclamation Setting TAX CLASS to TAXABLE ITEM (ON ALL PRODUCTS)

    Is there any fast way to set the tax class of all my products to TAXABLE ITEM?

    i have got over 10000 products but all have the tax class to non, any quick solution?

    Best Regards,

    Francis Doody
  2. 10-08-2008, 10:39 PM #2
    jpf
    jpf is offline
    osCMax Testing Team
    jpf's Avatar
    Join Date
    Sep 2003
    Location
    Manitoba, Canada
    Posts
    2,699
    Rep Power
    22

    Default Re: Setting TAX CLASS to TAXABLE ITEM (ON ALL PRODUCTS)

    3 options:

    SQL statement.
    Export/Import.
    Change/edit the non tax class to be a tax class.

    Last one would be easiest.
    JPF - osCMax Fourm Moderator - To contact, post on the forum or click here
    Try out our osCMax at: Live Catalog Demo
    Limited access Admin: Live Admin Demo
    Feel free to add products they way you want and then purchase them -=+=- Sorry nothing will be billed or shipped!
  3. 10-10-2008, 03:18 AM #3
    m2d^
    m2d^ is offline
    New Member
    Join Date
    May 2008
    Posts
    6
    Rep Power
    0

    Default Re: Setting TAX CLASS to TAXABLE ITEM (ON ALL PRODUCTS)

    thank you for your reply!

    can you guide me to make the non tax to be classed?

    Regards,

    Francis Doody
  4. 10-10-2008, 08:11 AM #4
    jpf
    jpf is offline
    osCMax Testing Team
    jpf's Avatar
    Join Date
    Sep 2003
    Location
    Manitoba, Canada
    Posts
    2,699
    Rep Power
    22

    Default Re: Setting TAX CLASS to TAXABLE ITEM (ON ALL PRODUCTS)

    In admin - Tax classes..... change name then setup taxes for that class.
    JPF - osCMax Fourm Moderator - To contact, post on the forum or click here
    Try out our osCMax at: Live Catalog Demo
    Limited access Admin: Live Admin Demo
    Feel free to add products they way you want and then purchase them -=+=- Sorry nothing will be billed or shipped!
  5. 10-11-2008, 12:17 PM #5
    m2d^
    m2d^ is offline
    New Member
    Join Date
    May 2008
    Posts
    6
    Rep Power
    0

    Default Re: Setting TAX CLASS to TAXABLE ITEM (ON ALL PRODUCTS)

    thank you for your sopport,
    all item are set to: none.

    there is 2 class:

    non taxable
    taxable

    on the products there is 3:
    --none--
    non taxable
    taxable

    whatever i do, makes no diference :X

    any solution?
  6. 10-12-2008, 10:16 PM #6
    jpf
    jpf is offline
    osCMax Testing Team
    jpf's Avatar
    Join Date
    Sep 2003
    Location
    Manitoba, Canada
    Posts
    2,699
    Rep Power
    22

    Default Re: Setting TAX CLASS to TAXABLE ITEM (ON ALL PRODUCTS)

    Before you do ANYTHING - BACKUP your database.....

    1 - Modify ONE product with the proper tax class.

    2 - Then export just the table "products" in phpmyadmin as a "SQL" file.

    You will get SOMETHING like:

    Code:
    ...
CREATE TABLE "products" (
  "products_id" int(11) NOT NULL,
  "products_quantity" int(4) NOT NULL,
  "products_model" varchar(12) default NULL,
  "products_image" varchar(64) default NULL,
  "products_price" decimal(15,4) NOT NULL,
  "products_date_added" datetime NOT NULL,
  "products_last_modified" datetime default NULL,
  "products_date_available" datetime default NULL,
  "products_weight" decimal(5,2) NOT NULL,
  "products_status" tinyint(1) NOT NULL,
  "products_tax_class_id" int(11) NOT NULL,
  "manufacturers_id" int(11) default NULL,
  "products_ordered" int(11) NOT NULL default '0',
  "products_ship_price" decimal(15,4) NOT NULL default '0.0000',
  "products_length" decimal(6,2) NOT NULL default '12.00',
  "products_width" decimal(6,2) NOT NULL default '12.00',
  "products_height" decimal(6,2) NOT NULL default '12.00',
  "products_ready_to_ship" int(1) NOT NULL default '0',
  PRIMARY KEY  ("products_id"),
  KEY "idx_products_date_added" ("products_date_added")
) AUTO_INCREMENT=31 ;

...

INSERT INTO `products` VALUES 
(3, 32, 'MG200MMS', 'matrox/mg200mms.gif', 299.9900, '2003-11-23 19:49:08', '2008-10-01 16:55:23', '0000-00-00 00:00:00', 23.00, 1, 1, 1, 0, 0.0000, 12.00, 12.00, 12.00, 0),
(4, 22, 'MG400-32MB', 'matrox/mg400-32mb.gif', 499.9900, '2003-11-23 19:49:09', '2008-10-01 16:55:23', '0000-00-00 00:00:00', 23.00, 1, 1, 1, 0, 0.0000, 12.00, 12.00, 12.00, 0),
(5, 2, 'MSIMPRO', 'ap_ups1000.gif', 49.9900, '2003-11-23 19:49:09', '2008-10-12 17:21:14', NULL, 7.00, 1, 1, 2, 0, 0.0000, 12.00, 12.00, 12.00, 0),
(6, 13, 'DVD-RPMK', 'dvd/replacement_killers.gif', 42.0000, '2003-11-23 19:49:09', '2008-10-01 16:55:23', '0000-00-00 00:00:00', 23.00, 1, 1, 3, 0, 0.0000, 12.00, 12.00, 12.00, 0),
(7, 17, 'DVD-BLDRNDC', 'dvd/blade_runner.gif', 35.9900, '2003-11-23 19:49:09', '2008-10-01 16:55:23', '0000-00-00 00:00:00', 7.00, 1, 1, 2, 0, 0.0000, 12.00, 12.00, 12.00, 0),
(8, 10, 'DVD-MATR', 'dvd/the_matrix.gif', 39.9900, '2003-11-23 19:49:09', '2008-10-01 16:55:23', '0000-00-00 00:00:00', 7.00, 1, 1, 2, 0, 0.0000, 12.00, 12.00, 12.00, 0),
(9, 10, 'DVD-YGEM', 'dvd/youve_got_mail.gif', 34.9900, '2003-11-23 19:49:09', '2008-10-01 16:55:23', '0000-00-00 00:00:00', 7.00, 1, 1, 2, 0, 0.0000, 12.00, 12.00, 12.00, 0),
(10, 10, 'DVD-ABUG', 'dvd/a_bugs_life.gif', 35.9900, '2003-11-23 19:49:09', '2008-10-01 16:55:23', '0000-00-00 00:00:00', 7.00, 1, 1, 2, 0, 0.0000, 12.00, 12.00, 12.00, 0),
(11, 10, 'DVD-UNSG', 'dvd/under_siege.gif', 29.9900, '2003-11-23 19:49:10', '2008-10-01 16:55:23', '0000-00-00 00:00:00', 7.00, 1, 1, 2, 0, 0.0000, 12.00, 12.00, 12.00, 0);
    3 - Open the file in a REAL TEXT editor (not Word or Notepad) - I suggest using something good like Notetab or Ultraedit.

    4 - Here comes the work.... copy all the "VALUES" into a NEW file - save it as say IMPORT.CSV (this extension is important).

    5 - replace all "^P(" with "^P" and all "),^P" with "^P" - (without the "")
    ALSO remove on the FIRST line the "(" at the beginning and on the LAST line at the end remove the ");"
    ie change from:
    Code:
    (3, 32, 'MG200MMS', 'matrox/mg200mms.gif', 299.9900, '2003-11-23 19:49:08', '2008-10-01 16:55:23', '0000-00-00 00:00:00', 23.00, 1, 1, 1, 0, 0.0000, 12.00, 12.00, 12.00, 0),
(4, 22, 'MG400-32MB', 'matrox/mg400-32mb.gif', 499.9900, '2003-11-23 19:49:09', '2008-10-01 16:55:23', '0000-00-00 00:00:00', 23.00, 1, 1, 1, 0, 0.0000, 12.00, 12.00, 12.00, 0),
(5, 2, 'MSIMPRO', 'ap_ups1000.gif', 49.9900, '2003-11-23 19:49:09', '2008-10-12 17:21:14', NULL, 7.00, 1, 1, 2, 0, 0.0000, 12.00, 12.00, 12.00, 0),
(6, 13, 'DVD-RPMK', 'dvd/replacement_killers.gif', 42.0000, '2003-11-23 19:49:09', '2008-10-01 16:55:23', '0000-00-00 00:00:00', 23.00, 1, 1, 3, 0, 0.0000, 12.00, 12.00, 12.00, 0),
(7, 17, 'DVD-BLDRNDC', 'dvd/blade_runner.gif', 35.9900, '2003-11-23 19:49:09', '2008-10-01 16:55:23', '0000-00-00 00:00:00', 7.00, 1, 1, 2, 0, 0.0000, 12.00, 12.00, 12.00, 0),
(8, 10, 'DVD-MATR', 'dvd/the_matrix.gif', 39.9900, '2003-11-23 19:49:09', '2008-10-01 16:55:23', '0000-00-00 00:00:00', 7.00, 1, 1, 2, 0, 0.0000, 12.00, 12.00, 12.00, 0),
(9, 10, 'DVD-YGEM', 'dvd/youve_got_mail.gif', 34.9900, '2003-11-23 19:49:09', '2008-10-01 16:55:23', '0000-00-00 00:00:00', 7.00, 1, 1, 2, 0, 0.0000, 12.00, 12.00, 12.00, 0),
(10, 10, 'DVD-ABUG', 'dvd/a_bugs_life.gif', 35.9900, '2003-11-23 19:49:09', '2008-10-01 16:55:23', '0000-00-00 00:00:00', 7.00, 1, 1, 2, 0, 0.0000, 12.00, 12.00, 12.00, 0),
(11, 10, 'DVD-UNSG', 'dvd/under_siege.gif', 29.9900, '2003-11-23 19:49:10', '2008-10-01 16:55:23', '0000-00-00 00:00:00', 7.00, 1, 1, 2, 0, 0.0000, 12.00, 12.00, 12.00, 0);
    to
    Code:
    3, 32, 'MG200MMS', 'matrox/mg200mms.gif', 299.9900, '2003-11-23 19:49:08', '2008-10-01 16:55:23', '0000-00-00 00:00:00', 23.00, 1, 1, 1, 0, 0.0000, 12.00, 12.00, 12.00, 0
4, 22, 'MG400-32MB', 'matrox/mg400-32mb.gif', 499.9900, '2003-11-23 19:49:09', '2008-10-01 16:55:23', '0000-00-00 00:00:00', 23.00, 1, 1, 1, 0, 0.0000, 12.00, 12.00, 12.00, 0
5, 2, 'MSIMPRO', 'ap_ups1000.gif', 49.9900, '2003-11-23 19:49:09', '2008-10-12 17:21:14', NULL, 7.00, 1, 1, 2, 0, 0.0000, 12.00, 12.00, 12.00, 0
6, 13, 'DVD-RPMK', 'dvd/replacement_killers.gif', 42.0000, '2003-11-23 19:49:09', '2008-10-01 16:55:23', '0000-00-00 00:00:00', 23.00, 1, 1, 3, 0, 0.0000, 12.00, 12.00, 12.00, 0
7, 17, 'DVD-BLDRNDC', 'dvd/blade_runner.gif', 35.9900, '2003-11-23 19:49:09', '2008-10-01 16:55:23', '0000-00-00 00:00:00', 7.00, 1, 1, 2, 0, 0.0000, 12.00, 12.00, 12.00, 0
8, 10, 'DVD-MATR', 'dvd/the_matrix.gif', 39.9900, '2003-11-23 19:49:09', '2008-10-01 16:55:23', '0000-00-00 00:00:00', 7.00, 1, 1, 2, 0, 0.0000, 12.00, 12.00, 12.00, 0
9, 10, 'DVD-YGEM', 'dvd/youve_got_mail.gif', 34.9900, '2003-11-23 19:49:09', '2008-10-01 16:55:23', '0000-00-00 00:00:00', 7.00, 1, 1, 2, 0, 0.0000, 12.00, 12.00, 12.00, 0
10, 10, 'DVD-ABUG', 'dvd/a_bugs_life.gif', 35.9900, '2003-11-23 19:49:09', '2008-10-01 16:55:23', '0000-00-00 00:00:00', 7.00, 1, 1, 2, 0, 0.0000, 12.00, 12.00, 12.00, 0
11, 10, 'DVD-UNSG', 'dvd/under_siege.gif', 29.9900, '2003-11-23 19:49:10', '2008-10-01 16:55:23', '0000-00-00 00:00:00', 7.00, 1, 1, 2, 0, 0.0000, 12.00, 12.00, 12.00, 0
    6 - Save.

    7 - IMPORT the CSV file into Excel or a spreadsheet as a CSV - Comma Separated Values file.

    8 - 11 column or "K" should be the "products_tax_class_id" for each item. Search for the item you changed in step 1. Copy that value in "K" to all items.

    9 - Save the CSV file.

    10 - OPEN the CSV in the text editor again.

    11 - replace all "^P" with "^P(" and all "^P" with "),^P" (without the "") - remove and single lines with JUST ( or ) on it. ALSO the FIRST line add a "(" at the beginning and on the LAST line change (or add) the end from ")," to ");"
    IE reversing everything from step 5.

    12 - COPY all values over top of the "VALUES" in your original SQL export file.

    13 - Save the SQL file as a new file ie: "updated.sql".

    14 - Import the SQL file into phpmyadmin.

    Done.


    OR .........

    SQL the change......

    In phpmyadmin - Run SQL query

    UPDATE 'name of-your-database'.'products' SET 'products_tax_class_id' = '2'

    Where "2" is the Proper tax class id....

    Good Luck!
    JPF - osCMax Fourm Moderator - To contact, post on the forum or click here
    Try out our osCMax at: Live Catalog Demo
    Limited access Admin: Live Admin Demo
    Feel free to add products they way you want and then purchase them -=+=- Sorry nothing will be billed or shipped!
  7. 10-13-2008, 10:16 AM #7
    m2d^
    m2d^ is offline
    New Member
    Join Date
    May 2008
    Posts
    6
    Rep Power
    0

    Default Re: Setting TAX CLASS to TAXABLE ITEM (ON ALL PRODUCTS)

    Thank you Thank You...

    the second method did it for me. and thats what i was looking for, a sql command to update the products.

    did i say thank you?

    THANKS!
  8. 10-13-2008, 06:04 PM #8
    jpf
    jpf is offline
    osCMax Testing Team
    jpf's Avatar
    Join Date
    Sep 2003
    Location
    Manitoba, Canada
    Posts
    2,699
    Rep Power
    22

    Default Re: Setting TAX CLASS to TAXABLE ITEM (ON ALL PRODUCTS)

    Quote Originally Posted by m2d^ View Post
    Thank you Thank You...

    the second method did it for me. and thats what i was looking for, a sql command to update the products.

    did i say thank you?

    THANKS!
    Better yet - click on my post on the "THANKS!" button!

    and your WELCOME!...
    JPF - osCMax Fourm Moderator - To contact, post on the forum or click here
    Try out our osCMax at: Live Catalog Demo
    Limited access Admin: Live Admin Demo
    Feel free to add products they way you want and then purchase them -=+=- Sorry nothing will be billed or shipped!
« user groups and product category | Submit button does not submit... »

Similar Threads

  1. New Products On Index Page On/Off Setting
    By michael_s in forum New osCommerce Contributions
    Replies: 0
    Last Post: 06-30-2008, 09:30 AM
  2. Taxable item: Net price & tax issues
    By brownjungle in forum osCMax v2 Features Discussion
    Replies: 1
    Last Post: 10-08-2006, 09:41 PM
  3. Changing default TAX class when adding new products
    By fuzzyphil in forum osCMax v1.7 General Mods Discussion
    Replies: 0
    Last Post: 07-28-2005, 10:42 PM
  4. Setting Sort Order for Products?
    By sheikyerbouti in forum osCommerce 2.2 Installation Help
    Replies: 6
    Last Post: 11-12-2003, 10:25 PM
  5. Please help! (setting tax rate for products)
    By sheikyerbouti in forum osCommerce 2.2 Modification Help
    Replies: 4
    Last Post: 10-22-2002, 04:32 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
  •  

Forum Rules