Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2010
    Posts
    142
    Plugin Contributions
    0

    Default Entering products directly into database

    Hi am trying to enter products directly into the database as I have
    thousands to populate.

    From what I gather there are 3 tables a that contain information
    relating to products :

    products
    products_description
    products_to_categories

    If have made local versions of these tables to get the relevant
    field information and run a script to populate each field with the
    information I require taking from a different table.

    I am using my own product_ids and wont be adding products through
    the add product script within zencart.

    I am looking to insert my own unique product ids and do not want zen cart to assign ones.

    Or would it be better if I add new table rows with myproduct id
    Last edited by neit; 10 Feb 2010 at 04:34 PM.

  2. #2
    Join Date
    Feb 2005
    Location
    Lansing, Michigan USA
    Posts
    19,479
    Plugin Contributions
    3

    Default Re: Entering products directly into database

    Have you looked at Easy Populate in the Free Software Add Ons?

  3. #3
    Join Date
    Feb 2010
    Posts
    142
    Plugin Contributions
    0

    Default Re: Entering products directly into database

    nevermind its working as expected just that its removing the leading zeros that I need to keep so this more a mysql issue than a zen cart issue.

 

 

Similar Threads

  1. Can search for products, but not directly navigate to them
    By razziewillers in forum Setting Up Categories, Products, Attributes
    Replies: 3
    Last Post: 20 Dec 2009, 01:34 AM
  2. Inserting a product directly in to the database
    By ryudice in forum Templates, Stylesheets, Page Layout
    Replies: 4
    Last Post: 4 May 2008, 10:15 PM
  3. Problem entering products
    By mjcrabill in forum Setting Up Categories, Products, Attributes
    Replies: 8
    Last Post: 2 Apr 2008, 06:58 AM
  4. Products image linking directly to products url
    By duffster2004 in forum Setting Up Categories, Products, Attributes
    Replies: 2
    Last Post: 17 May 2006, 07:19 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
  •