Using ProductCart - Any restrictions on SKU characters

Print Page | Close Window

Any restrictions on SKU characters

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Using ProductCart
Forum Description: Running your store with ProductCart
URL: https://forum.productcart.com/forum_posts.asp?TID=4964
Printed Date: 07-March-2025 at 2:18am
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Any restrictions on SKU characters

Posted By: lhuggins
Subject: Any restrictions on SKU characters
Date Posted: 31-January-2012 at 1:56pm

Are there any restrictions on the characters used in SKU field? I am getting weird results, PC tell me a SKU is a duplicate but a search does not show a duplicate, weird results in BTO conflict management using that SKU (bto item). I have deleted, purged and reentered and still weird results "12" 250C FG (1/2)" (SKU # less quotation marks) and ones similar to this.

Replies:

Posted By: Guests
Date Posted: 01-February-2012 at 12:30am

Hi,
Just by taking a quick look here it looks like maybe your sku is possibly being truncated in the sql query. I tested this in PC4 BTO and I see your issue. Try using the following example SKU. I'm pretty sure this has been taken care of in newer versions of Productcart. For the rest of your sku's try adding the second quote where needed and you should be o.k.

12"" 250C FG (1/2)

Let me know if that works for you.

Posted By: lhuggins
Date Posted: 01-February-2012 at 4:35pm

Kelly, thank you as far as I can tell that fixed the problem. By the way I have ProductCart v4.5bcm (should be the newest version).