Results 1 to 6 of 6
  1. #1
    Join Date
    Aug 2006
    Location
    North Carolina
    Posts
    279
    Plugin Contributions
    0

    Default Which MySQL table 'holds' the Product Links?

    Which MySQL table 'holds' the Product Links?

    I'm adding thousands of products by importing from my Filemaker database with a program called fmSQL Synch. It's all set up and working fine in my tests and I've even completed a massive attribute database that took almost a week to script and will contain hundreds of thousands of records. I'd like to link some products using the Product Link function in Zen-Cart, but I cannot locate the appropriate MySQL table that stores that info relationship. Does anyone know what table name holds this or 'how' it's stored?

    thanks,
    Jeff

  2. #2
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Which MySQL table 'holds' the Product Links?

    products_url field in the products_description table ... one record per product per language
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  3. #3
    Join Date
    Aug 2006
    Location
    North Carolina
    Posts
    279
    Plugin Contributions
    0

    Default Re: Which MySQL table 'holds' the Product Links?

    Oops.... wrong 'links'

    I meant to say: Linked Product (not URL links)

    I'd like to import critera to create Linked Products and I cannot find that table in MySQL to import my data to.

    thanks,
    Jeff

  4. #4
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Which MySQL table 'holds' the Product Links?

    the master id is set as master_categories_id in the products table. This denotes who's boss.

    All category-to-product relations ("links" as you call them) are in the many-to-many products_to_categories table.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  5. #5
    Join Date
    Aug 2006
    Location
    North Carolina
    Posts
    279
    Plugin Contributions
    0

    Default Re: Which MySQL table 'holds' the Product Links?

    Yes!! That's it and when I tested it by adding a new product link in the admin, it repopulated the MySQL with the ID repeated twice and a different category number on each of them.

    My only other question about this is this: If the master category is already set up in the Products table, does the same data need to be in Products to Categories also...along with the new Product Links? Or can the master links be eliminated in Products to Categories without any 'ill' effects

    thanks Jeff

  6. #6
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Which MySQL table 'holds' the Product Links?

    the products_to_categories records are required ... otherwise the master is considered invalid and you'll have mayhem when calculating prices esp for sales
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

 

 

Similar Threads

  1. MySQl and product table help
    By creativeembroidering in forum Setting Up Categories, Products, Attributes
    Replies: 1
    Last Post: 25 Nov 2011, 03:09 PM
  2. What file holds the shipping logic for Downloads
    By emaugust in forum Built-in Shipping and Payment Modules
    Replies: 1
    Last Post: 25 May 2009, 06:26 PM
  3. Which file is the one that holds the single product details page.
    By qm360 in forum Templates, Stylesheets, Page Layout
    Replies: 2
    Last Post: 10 Mar 2008, 07:31 PM
  4. Advice please! Which MySql and Which PHP
    By Daves Teddy in forum Installing on a Linux/Unix Server
    Replies: 13
    Last Post: 6 Nov 2006, 04:57 PM
  5. Which table is the Gift Certificate amount in?
    By libracorn in forum Managing Customers and Orders
    Replies: 2
    Last Post: 8 Jun 2006, 05:41 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