Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2007
    Posts
    17
    Plugin Contributions
    0

    Default problems importing to mysql from .csv - products not showing

    I ma importing my mySQL info from a .csv file and it goes through fine but when I go to my cart and test it out it does not show the new info. Do I need to do a reset or update of sorts?

  2. #2
    Join Date
    May 2005
    Location
    Bath, Somerset
    Posts
    1,053
    Plugin Contributions
    3

    Default Re: problems importing to mysql from .csv - products not showing

    When you import the products from a CSV into MySQL, which tables are you updating? There should be a record for the PRODUCTS table, which is the initial data. You then need to have some data imported into the PRODUCTS_DESCRIPTION table, which is where the name and description fields live. Finally, you need to tie the products to a category, which is done with a record in the PRODUCTS_TO_CATEGORIES table. Only when data is in all three of these tables, will your products show up.

    Can you confirm that all these tables have records in them?

    Absolute

 

 

Similar Threads

  1. Batch product updates, importing .csv to MySQL
    By jdw1979 in forum Setting Up Categories, Products, Attributes
    Replies: 10
    Last Post: 30 Apr 2011, 04:45 PM
  2. Replies: 2
    Last Post: 5 Feb 2011, 01:52 AM
  3. Need help importing customers database from csv file into mySQL
    By jeffmic in forum Managing Customers and Orders
    Replies: 18
    Last Post: 20 Jan 2008, 04:54 PM

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