Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2016
    Location
    London
    Posts
    258
    Plugin Contributions
    0

    Default Where are all the catalogs and products stored?

    Where are all the catalogs and products stored?

    I thought these were in the sql but it appears they are not.

    I see the product images are in images so where are the products stored?

  2. #2
    Join Date
    Jan 2004
    Location
    N of San Antonio TX
    Posts
    9,106
    Plugin Contributions
    11

    Default Re: Where are all the catalogs and products stored?

    All categories are stored in the categories table.

    All products are stored in the products table.

    All product attributes are stored in the products_attributes table.

    That being said, it has been stated before that these tables MAY OR MAY NOT have a prefix.

    If all your tables start with ####_ followed by the name of a table, the characters in the #### are your table prefix.

    More info at https://docs.zen-cart.com/user/first...s-zen-cart-use

  3. #3
    Join Date
    Jul 2012
    Posts
    16,718
    Plugin Contributions
    17

    Default Re: Where are all the catalogs and products stored?

    Minor correction. In the example of ####_, all 5 characters in that example make up the prefix not just the 4 #s. E.g. define('DB_PREFIX', '####_');
    The underscore as a "divider" (if a prefix is used) can make things easier to manipulate in the future if needed.
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

  4. #4
    Join Date
    Jan 2004
    Location
    N of San Antonio TX
    Posts
    9,106
    Plugin Contributions
    11

    Default Re: Where are all the catalogs and products stored?

    You are correct, of course.

  5. #5
    Join Date
    Jul 2012
    Posts
    16,718
    Plugin Contributions
    17

    Default Re: Where are all the catalogs and products stored?

    Quote Originally Posted by dbltoe View Post
    You are correct, of course.
    And you are as ever helping and helpful.
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

 

 

Similar Threads

  1. Where are the "values" of the attributes stored in a session?
    By MrNoBrainer in forum Managing Customers and Orders
    Replies: 2
    Last Post: 26 Apr 2011, 07:27 PM
  2. How can I change the width where all the products are listed?
    By sharontan in forum Setting Up Categories, Products, Attributes
    Replies: 15
    Last Post: 20 Nov 2010, 03:53 PM
  3. Where are the descriptions stored?
    By panzico in forum General Questions
    Replies: 6
    Last Post: 2 Oct 2008, 04:14 PM
  4. Where are the demo products stored?
    By Nipple in forum General Questions
    Replies: 3
    Last Post: 11 May 2008, 10:59 PM
  5. Where are EZ Pages Stored
    By Petzlifedirect.com in forum General Questions
    Replies: 10
    Last Post: 19 Mar 2007, 05:31 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