VP-ASP :: Shopping Cart Software

Shopping Cart Software Solutions for anywhere in the World

US/Canada(Toll Free): +1 888 587 2278
Europe/UK: +44 (020) 7193 9408
Australia/New Zealand: +61 3 9016 4497

VP-Cart StoreFront Customer Forum

Home | Profile | Register | Active Topics | Members | Search | FAQ
Save Password
Forgot your Password?

 All Forums
 VPCart Forum
 Add product unique product name
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

VP-ASP New User

82 Posts

Posted - April 03 2006 :  18:06:40  Show Profile  Reply with Quote
Does anyone have an easy way to check that a product name is unique? So as not to enter duplicate products?

Edited by - saki on April 03 2006 18:07:17

Senior Member

United Kingdom
1898 Posts

Posted - April 04 2006 :  04:05:51  Show Profile  Visit devshb's Homepage  Reply with Quote
there are a few ways of doing that, one is to add a unique index to it (not advised because of the way that new products get created; it physically creates the record before setting the values to your form's values), another way is to add a check to the asp page where you edit/add products.

the best/easiest way is probably just for you to run a manual check every now and then to check any duplicates. for that, go into "Advanced Query" and type in:

select cname,count(*) from products group by cname having count(*)>1

that'll give you a list of any duplicate product names.

Simon Barnaby
[email protected]
Web Design, Online Marketing and VPASP addons
Go to Top of Page

VP-ASP New User

82 Posts

Posted - April 04 2006 :  09:25:08  Show Profile  Reply with Quote
Thanks Simon,

The "best" way for this client would be to do the check as entry was happening so the duplicate would not be created and they did not waste time entering all the info. They wanted two things actually:
1.)To be assured the product didn't exist. (There are thousands of them)and 2.)a spell checker.

I think those are two good suggestions for VPASP.

A function to check field uniqueness would be ideal. The challenge for me was when to do the check. Ideally it would be right after the product NAME was entered, (product name is actually a part number in this store) so they knew if that product was being entered again.

This is where I was looking for suggestions or help.
Go to Top of Page


4282 Posts

Posted - April 05 2006 :  03:24:21  Show Profile  Visit support's Homepage  Reply with Quote
While we do not have a way to check for duplicate product names you can add a spell checker to your browser by installing either MSN task bar or the Google task bar which is what we use.

This allows you to spell check the fields in your page to ensure everything is correct.


VP-ASP Support
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000