If this is your first visit, check our documentation. To post, register or login.
Forums / General Questions / New products not being added to products to categories table

New products not being added to products to categories table

Locked

Started by delia on 30 Mar 2010, 2:04 PM · Views: 1,373

Results 1 to 5 of 5
This thread is locked. New replies are disabled.
30 Mar 2010, 2:04 PM
#1
delia avatar

delia

Totally Zenned

Join Date:
May 2006
Location:
Gardiner, Maine
Posts:
2,383
Plugin Contributions:
7

New products not being added to products to categories table

This is a highly modified cart that I inherited. The product is getting added to the products table but not to the products to categories table. I can't find what file that happens in to check it or the insert query.

Most of the modifications are on the cart side not the admin in case that makes any difference.

Any help will be appreciated.

ah, this probably happens in update_product.php?

The full-time Zen Cart Guru. WizTech4ZC.com
New template for 2.0 viewable here: 2.0 Demo

30 Mar 2010, 2:39 PM
#2
kuroi avatar

kuroi

Totally Zenned

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

Re: New products not being added to products to categories table

In an unmodified cart it's written to the database at about line 82 of the admin/includes/modules/update_product.php file.

But it's not quite that simple. You'll need to check that the data is properly collected by the relevant product type's collect_info file, not lost by the preview_info file and that there's not a custom update_product file for the product type getting in the way.

Kuroi Web Design and Development | Twitter

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

30 Mar 2010, 2:57 PM
#3
delia avatar

delia

Totally Zenned

Join Date:
May 2006
Location:
Gardiner, Maine
Posts:
2,383
Plugin Contributions:
7

Re: New products not being added to products to categories table

map pricing is installed for this so I guess that's where I start.

What a mess.

Thanks, need a sounding board this morning!

The full-time Zen Cart Guru. WizTech4ZC.com
New template for 2.0 viewable here: 2.0 Demo

30 Mar 2010, 3:25 PM
#4
delia avatar

delia

Totally Zenned

Join Date:
May 2006
Location:
Gardiner, Maine
Posts:
2,383
Plugin Contributions:
7

Re: New products not being added to products to categories table

well, that didn't work. Reverted those files back to default.

The other problem I've found is the auto increment not being correct on the tables and that was causing the categories not to be created correctly.

That's now fixed. Can you think of anything else that could be affecting this?

The full-time Zen Cart Guru. WizTech4ZC.com
New template for 2.0 viewable here: 2.0 Demo

30 Mar 2010, 3:28 PM
#5
delia avatar

delia

Totally Zenned

Join Date:
May 2006
Location:
Gardiner, Maine
Posts:
2,383
Plugin Contributions:
7

Re: New products not being added to products to categories table

well, that didn't work. Reverted those files back to default.

The other problem I've found is the auto increment not being correct on the tables and that was causing the categories not to be created correctly.

That's now fixed. Can you think of anything else that could be affecting this?

Now I just realized that it is not putting the product id into the products-to-categories table but it is putting an entry.

The full-time Zen Cart Guru. WizTech4ZC.com
New template for 2.0 viewable here: 2.0 Demo