Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2011
    Location
    Toronto, Ontario, Canada
    Posts
    290
    Plugin Contributions
    0

    Default Where is the category/product stored?

    Are they stored in database? Why I couldn't see them in my database tables?

    And how the ID is generated? it seems category and product can have same ID.

    Thanks.

  2. #2
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    10,304
    Plugin Contributions
    125

    Default Re: Where is the category/product stored in zen cart?

    Category and product *can* have the same id because they are separate things.

    They are stored in tables - the product id is in the table "products," and the category id(s) for each product, is in the table products_to_categories. The categories themselves are stored in the table "categories." If you use phpMyAdmin to examine your database, you can look at all these tables.
    That Software Guy. My Store: Zen Cart Support
    Available for hire - See my ad in Services
    Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
    Do you benefit from Zen Cart? Then please support the project.

  3. #3
    Join Date
    Sep 2018
    Location
    Texas
    Posts
    32
    Plugin Contributions
    0

    Default Re: Where is the category/product stored in zen cart?

    Quote Originally Posted by swguy View Post
    Category and product *can* have the same id because they are separate things.

    They are stored in tables - the product id is in the table "products," and the category id(s) for each product, is in the table products_to_categories. The categories themselves are stored in the table "categories." If you use phpMyAdmin to examine your database, you can look at all these tables.
    I looked in my database. I do have the catagories listed but do not have folder called "Products" The last folder in the list is "newsletter".
    It seems the tables are listed alphabetically and stops t the N.

    The site is working except for Special tabs no working..

    Any clue what is happening with the database display?

  4. #4
    Join Date
    Aug 2005
    Location
    Vic, Oz
    Posts
    1,905
    Plugin Contributions
    5

    Default Re: Where is the category/product stored in zen cart?

    I assume you are using phpmyadmin?
    You are only looking at the first of 3 pages of tables.
    Scroll to the top and click on the "next" page

  5. #5
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    10,304
    Plugin Contributions
    125

    Default Re: Where is the category/product stored in zen cart?

    Quote Originally Posted by gilby View Post
    I assume you are using phpmyadmin?
    You are only looking at the first of 3 pages of tables.
    Scroll to the top and click on the "next" page
    Gilby is correct - the list of tables is just being paginated. Your site would not work if it were missing the tables after Newsletter.
    That Software Guy. My Store: Zen Cart Support
    Available for hire - See my ad in Services
    Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
    Do you benefit from Zen Cart? Then please support the project.

 

 

Similar Threads

  1. Where is the product image location stored?
    By pstarling in forum General Questions
    Replies: 3
    Last Post: 8 Jul 2010, 06:51 PM
  2. Where is product information stored?
    By 5tar5hine in forum General Questions
    Replies: 4
    Last Post: 11 Nov 2009, 10:29 PM
  3. Where is the database stored?
    By daz59 in forum General Questions
    Replies: 1
    Last Post: 27 Jul 2009, 12:52 PM
  4. Where is the catalog stored
    By darktowerhobbies in forum Templates, Stylesheets, Page Layout
    Replies: 2
    Last Post: 12 Feb 2008, 06:41 AM
  5. Where is the product info etc actually stored!
    By Gooseman in forum General Questions
    Replies: 2
    Last Post: 24 Jul 2006, 11:55 AM

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