Results 1 to 3 of 3

Hybrid View

  1. #1
    Join Date
    Feb 2010
    Posts
    140
    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
    20,024
    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
    140
    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. v151 How to stop users entering comma's into address fields
    By petsupplies4u in forum General Questions
    Replies: 5
    Last Post: 7 Nov 2013, 07:02 AM
  2. v139h Enter item numbers directly into cart
    By mmwilcox in forum General Questions
    Replies: 1
    Last Post: 18 Feb 2012, 06:47 PM
  3. steps on entering database info
    By ebaobao in forum Upgrading to 1.5.x
    Replies: 6
    Last Post: 30 Jul 2011, 07:28 PM
  4. 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
  5. How do I add a free product into customer's shopping cart directly
    By spf in forum Setting Up Categories, Products, Attributes
    Replies: 1
    Last Post: 21 Dec 2007, 05:31 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