Forums / General Questions / problems importing to mysql from .csv - products not showing

problems importing to mysql from .csv - products not showing

Locked

Results 1 to 2 of 2

This thread is locked. New replies are disabled.

22 Jan 2008, 3:09 PM

txmagnum

New Zenner

Join Date:: Dec 2007
Posts:: 17
Plugin Contributions:: 0

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?

29 Jan 2008, 4:23 PM

absolute

Totally Zenned

Join Date:: May 2005
Location:: Bath, Somerset
Posts:: 1,054
Plugin Contributions:: 2

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