Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2008
    Posts
    14
    Plugin Contributions
    0

    Default Inserting a product directly in to the database

    Hi,
    I'm trying to insert a product using a direct query with a program that will connect remotely to my database, I know the table where I have to insert the row to add the product but how do I insert the description? How can I get the product id of the product I just inserted so that I can insert the description after? Thanks for your help.

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

    Default Re: Inserting a product directly in to the database

    Unless you are willing to figure out ALL the 10 - 14 table entries that are required with a new product, you are better off using the admin.

    Many before you have tried with little success.

  3. #3
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,761
    Plugin Contributions
    9

    Default Re: Inserting a product directly in to the database

    Or get - learn and use easy populate module available in the downloads section
    Zen-Venom Get Bitten

  4. #4
    Join Date
    Apr 2008
    Posts
    14
    Plugin Contributions
    0

    Default Re: Inserting a product directly in to the database

    I was able to make function correctly. The three tables you need to modify are products, products_description and products_to_categories, assuming that you already have the categories created.

  5. #5
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,761
    Plugin Contributions
    9

    Default Re: Inserting a product directly in to the database

    I was able to make function correctly. The three tables you need to modify are products, products_description and products_to_categories, assuming that you already have the categories created.
    There are additional tables and indexed relationships and especially if the product has attributes
    Zen-Venom Get Bitten

 

 

Similar Threads

  1. v139h Group pricing: how to show the discounted price directly in the product page?
    By ilmarchez in forum Templates, Stylesheets, Page Layout
    Replies: 1
    Last Post: 20 May 2015, 11:04 PM
  2. Problem inserting DOCUMENT-GENERAL product Type (DATABASE)
    By JLA in forum Upgrading from 1.3.x to 1.3.9
    Replies: 3
    Last Post: 13 May 2010, 11:05 PM
  3. Adding the Shopping Cart Contents Directly On The Product Listing Page
    By watzursn in forum Templates, Stylesheets, Page Layout
    Replies: 6
    Last Post: 12 Sep 2008, 12:18 AM
  4. Adding a class directly to the product imgae anchor tag.
    By sonicparke in forum Templates, Stylesheets, Page Layout
    Replies: 5
    Last Post: 15 Aug 2006, 03:46 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