Forums / General Questions / Product detail pages won't load after importing with easy populate

Product detail pages won't load after importing with easy populate

Locked

Views: 1,934

Results 1 to 5 of 5
This thread is locked. New replies are disabled.
22 Nov 2007, 5:13 AM
#1
humdaddy avatar

humdaddy

New Zenner

Join Date:
Nov 2007
Posts:
66
Plugin Contributions:
0

Product detail pages won't load after importing with easy populate

Can anyone give me a hand here. I've been using EZ Populate to populate my database and for some reason all of a sudden my product detail pages won't load. my main menu works fine - the submenus work fine but when you want to look at a particular item I get the error page.

my website is www.tacticalsporting.com The product images are not loaded yet and the site is not live but you have access for the moment. Any help would be appreciated befoe i end up reinstalling the whole thing.

Thanks,
Jason

22 Nov 2007, 7:40 AM
#2
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: Product detail pages won't load after importing with easy populate

Your import seems to have skipped an important field ... your products don't have a valid products_type setting. The products_type field in your products table needs to have a value in it that matches a value in the product_types table.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

12 May 2008, 7:28 AM
#3
slash74 avatar

slash74

New Zenner

Join Date:
Jul 2006
Posts:
29
Plugin Contributions:
0

Re: Product detail pages won't load after importing with easy populate

DrByte:

Your import seems to have skipped an important field ... your products don't have a valid products_type setting. The products_type field in your products table needs to have a value in it that matches a value in the product_types table.

Hi DrByte,

:frusty:Knockin my head against a brick wall here.
Could you please advise a little further, as i have been experiencing the same problem, are you saying to place v_products_type in a column in the spreadsheet?
Plus, if so, can these fields be empty, or do i have to place values against each product?

12 May 2008, 9:52 AM
#5
kuroi avatar

kuroi

Totally Zenned

Join Date:
Apr 2006
Location:
London, UK
Posts:
10,475
Plugin Contributions:
11

Re: Product detail pages won't load after importing with easy populate

Slash74:

are you saying to place v_products_type in a column in the spreadsheet? Plus, if so, can these fields be empty, or do i have to place values against each product?I'm afraid that it's exactly as DrByte said. You need this field and you need to say which product type is applicable to each product (tip - it's usually "1"), otherwise the product_info page doesn't know which display routine to use.

Kuroi Web Design and Development | Twitter

(Questions answered in the forum only - so that any forum member can benefit - not by personal message)