Zen Cart Logo
Forums / Managing Customers and Orders / Product id incorrect in database

Product id incorrect in database

Locked

Views: 1,463

Results 1 to 5 of 5
This thread is locked. New replies are disabled.
9 Aug 2006, 1:26 AM
#1
rgoetz avatar

rgoetz

New Zenner

Join Date:
Aug 2006
Posts:
36
Plugin Contributions:
0

Product id incorrect in database

Hi all,

I am having a strange thing happen. A customer orders product id 13 which requires a text attribute. This product was copied from product id 11, duplicated and revised.

When I download the database info, product 13 shows up as 11 with a wrong price. IN addition, the text attribute is no where to be found. BUT on the invoice the customer is charged the correct price and the text personalization shows up.

I've added adv. product manager, data manager, and easy populate installed.

Can you help me with this?

Thanks, Rhonda

9 Aug 2006, 4:16 AM
#2
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Product id incorrect in database

Did you import your products?

If you look at your database via phpMyAdmin at the products table ... does all of the information appear filled in for products_id 11 and products_id 13

Including the master_categories_id and products_price_sorter?

9 Aug 2006, 4:17 AM
#3
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Product id incorrect in database

Do you have an URL to this site?

9 Aug 2006, 10:13 AM
#4
rgoetz avatar

rgoetz

New Zenner

Join Date:
Aug 2006
Posts:
36
Plugin Contributions:
0

Re: Product id incorrect in database

As far as I can tell all are filled in except product model. I only have about 6 products.

the url is: http://www.stewsstripped.com/shop/index.php

Thanks,

Rhonda

9 Aug 2006, 10:53 AM
#5
rgoetz avatar

rgoetz

New Zenner

Join Date:
Aug 2006
Posts:
36
Plugin Contributions:
0

Re: Product id incorrect in database

I am running a query in navicat to get the data, maybe it is in my query. I need all the customer info + the product ordered+ the product attributes + order totals and order quantities.

I am using the orders, orders_product_attributes, and orders_product tables and grouping by customer id.

Is this causing the error?

I am new at this stuff and sometimes just take a shotgun to it!:ohmy:

Rhonda