Apparel Add-on - This item no longer exist in the database

Print Page | Close Window

This item no longer exist in the database - errors

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart Add-on's
Forum Name: Apparel Add-on
Forum Description: All topics concerning the use of the Apparel Add-on
URL: https://forum.productcart.com/forum_posts.asp?TID=2499
Printed Date: 21-November-2024 at 6:22pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: This item no longer exist in the database - errors

Posted By: mattribbit
Subject: This item no longer exist in the database - errors
Date Posted: 20-February-2009 at 5:03pm

When using the Apparel Add-on, all sub-products will display the message "This item no longer exist in the database." when trying to Add to Shopping Bag a product.

- The settings are such that if it item is out of stock, the drop downs are not supposed to appear. But the dropdowns do appear--they are in plenty of stock.

-If I check the sub-products to be "disregard stock", no dice. I still get the error.

-Not sure if it is relevant once an item is flagged as being an apparel product, but I edited the inventory settings such that "disregard stock is checked"--no dice. I also tried the opposite be adding dozens of stock... still get the error.

I've searched for this issue and do not see any information in Google, wiki.earlyimpact.com, or this forum.

Please help!

Thanks~

Replies:

Posted By: intour
Date Posted: 22-February-2009 at 4:49am

Hi and welcome !

Can you please clarify your problem.

If I understand it your apparel productcs are appearing in your storefront when there is no stock available but if you click on that product you get the "item no longer exists" message?

It sounds to me like a settings issue but I'd need more information.

Nigel

-------------
http://www.innerview.co.uk - Innerview
Productcart Platinum Reseller
Web Design/Hosting/Virtual Tours

Posted By: mattribbit
Date Posted: 22-February-2009 at 1:30pm

Hi,

Thanks for offering to look. A lot of us have tried to fix it but we can't--so with luck you might be the one with the magic answer :)

Here is an apparel product that does not work: http://www.danadavis.com/store/pc/viewPrd.asp?idproduct=228&idcategory=7

Try to add it to the cart and you cannot. All regular product you can add to the cart.

We are running ProductCart v3.51a .

From what I can tell, we are doing everything correct and following the procedures to set up the apparel product correctly. It doesn't seem that complicated. I've never seen anyone with this issue before, so hopefully it's something simple I'm overlooking.

In my initial post I listed some of the strategies I used to set up the apparel product. By all accounts it seems to be set up correctly in the admin tool.

Thanks!

Posted By: intour
Date Posted: 22-February-2009 at 2:29pm

The message you are getting suggests the sub product was not created properly.

Can you see it when you search for the master product and click on sub-products?

Another quick question - are you using the standard version of productcart or BTO?

Nigel

-------------
http://www.innerview.co.uk - Innerview
Productcart Platinum Reseller
Web Design/Hosting/Virtual Tours

Posted By: mattribbit
Date Posted: 22-February-2009 at 2:43pm

I am using ProductCart v3.51a . I think it is standard and not BTO, but how can I tell for sure? This is a project I inherited and was not originally involved in the purchasing.

I can see the product when I search for it, open it up, then click "View sub-products". They look fine in the sub-products view, all sub-products have items in stock, they have sub-product ids, unique SKUs, and all are active.

When originally creating the sub-products... I tried all variants "Add New," "Update," and "Replace". They all seem to create sub-products just fine, except for the fact that we can't add them in the cart at all.

Thanks

Posted By: Greg Dinger
Date Posted: 22-February-2009 at 2:52pm

v3.51a indicates it's standard PC + apparel mod.

Matt, do you know if the store is altered at all, other than header/footer/css changes?

-------------
GreyBeard Design Group

Certified ProductCart Developer

Web Design/Development/Hosting

http://tinyurl.com/5c8t4t" rel="nofollow - Add-Ons & Custom Code |

Posted By: intour
Date Posted: 22-February-2009 at 3:37pm

Do you know if your version of productcart was purchased earlier and then upgraded to version 3.5. I'm wondering if your apparel add-on files are up to date?

If you have followed all the instructions correctly it should work fine so I can only guess something isn't right in one of the files.

Nigel

-------------
http://www.innerview.co.uk - Innerview
Productcart Platinum Reseller
Web Design/Hosting/Virtual Tours

Posted By: mattribbit
Date Posted: 23-February-2009 at 12:40pm

Hi,

Eventually got this fixed.

The answer, in case anyone wants to know, is that the developer before me apparently had customized the "viewPrdL.asp" page to hide the SKU. The proper way is to hide the SKU in the "Other Settings" tab in the control panel.

Thanks for everyone's help!

Posted By: intour
Date Posted: 23-February-2009 at 3:49pm

Great to hear - glad you got it sorted.

Those type of problems can be very frustrating.

Nigel

-------------
http://www.innerview.co.uk - Innerview
Productcart Platinum Reseller
Web Design/Hosting/Virtual Tours

Posted By: Greg Dinger
Date Posted: 23-February-2009 at 3:55pm

Yeah, inheriting someone else's work can be a great challenge. Good luck with the project.

-------------
GreyBeard Design Group

Certified ProductCart Developer

Web Design/Development/Hosting

http://tinyurl.com/5c8t4t" rel="nofollow - Add-Ons & Custom Code |

Posted By: cartman
Date Posted: 07-April-2009 at 4:30am

I am also recieving same error on apparel-add on products.

When using the Apparel Add-on, all sub-products will display the message "This item no longer exist in the database." when trying to Add to Shopping Bag a product.

This after upgrading to ProductCart v3.51a apparel on 2-27-09 version.
I have tried to create a new apparel product. still problem.
Also have deleted and recreated all subproducts.
I have not edited the viewprd.asp page.

Posted By: ProductCart
Date Posted: 07-April-2009 at 10:43am

Please open a support ticket. This is not a problem that we are aware of. It might be that you are not using the correct file set.

-------------
The ProductCart Team

Home of ProductCart http://www.productcart.com" rel="nofollow - shopping cart software