Duplicate Products in SQL table

For general questions and discussions specific to the AbleCommerce 7.0 Asp.Net product.
Post Reply
Smurf
Ensign (ENS)
Ensign (ENS)
Posts: 20
Joined: Sat Oct 27, 2007 8:03 am

Duplicate Products in SQL table

Post by Smurf » Fri May 16, 2008 8:57 pm

I uploaded a small batch of products multiple times with Dataport, which created duplicates in AC7. I went into the Catalog Administration and deleted the duplicates and they no longer show in AC7.

I linked MS Access to the AC7 SQL database, and all the duplicate products are still showing in the table. is there a table/field that marks a product deleted?

User avatar
AbleMods
Master Yoda
Master Yoda
Posts: 5170
Joined: Wed Sep 26, 2007 5:47 am
Location: Fort Myers, Florida USA

Re: Duplicate Products in SQL table

Post by AbleMods » Sat May 17, 2008 9:40 am

What version are you running? This was a known issue in RC1/RC2 but resolved in RC3.
Joe Payne
AbleCommerce Custom Programming and Modules http://www.AbleMods.com/
AbleCommerce Hosting http://www.AbleModsHosting.com/
Precise Fishing and Hunting Time Tables http://www.Solunar.com

Smurf
Ensign (ENS)
Ensign (ENS)
Posts: 20
Joined: Sat Oct 27, 2007 8:03 am

Re: Duplicate Products in SQL table

Post by Smurf » Sat May 17, 2008 10:46 am

I am running RC3, but I think I did an update and not a clean install. I will reinstall and see if that takes care of it. :)

Post Reply