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

problems importing to mysql from .csv - products not showing

Locked

Views: 1,623

Results 1 to 2 of 2
This thread is locked. New replies are disabled.
22 Jan 2008, 3:09 PM
#1
txmagnum avatar

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
#2
absolute avatar

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

Back, after a 4 year absence! Did you miss me?
Absolute Web Solutions Ltd
Interested in our work? Take a look at one of our sites - The Tech Store