ProductCart Shopping Cart Software Forums : Link to product SKU https://forum.productcart.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sun, 05 Apr 2026 23:47:43 +0000 Sun, 26 Feb 2012 21:06:56 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://forum.productcart.com/RSS_post_feed.asp?TID=5014 <![CDATA[ProductCart Shopping Cart Software Forums]]> https://forum.productcart.com/forum_images/pc_logo_50.png https://forum.productcart.com/ <![CDATA[Link to product SKU : Let&#039;s take this off-forum....]]> https://forum.productcart.com/link-to-product-sku_topic5014_post19172.html#19172 Author: Greg Dinger
Subject: 5014
Posted: 26-February-2012 at 9:06pm

Let's take this off-forum.  Please e-mail me at my site. 

]]> Sun, 26 Feb 2012 21:06:56 +0000 https://forum.productcart.com/link-to-product-sku_topic5014_post19172.html#19172 <![CDATA[Link to product SKU : Wanted an opinion on which would...]]> https://forum.productcart.com/link-to-product-sku_topic5014_post19171.html#19171 Author: amscompanies
Subject: 5014
Posted: 26-February-2012 at 9:02pm

Wanted an opinion on which would be easier and I think you have just given me the answer :) How much would you charge to do that ?]]> Sun, 26 Feb 2012 21:02:55 +0000 https://forum.productcart.com/link-to-product-sku_topic5014_post19171.html#19171 <![CDATA[Link to product SKU : idProduct is an auto-increment...]]> https://forum.productcart.com/link-to-product-sku_topic5014_post19170.html#19170 Author: Greg Dinger
Subject: 5014
Posted: 26-February-2012 at 9:00pm

idProduct is an auto-increment integer field.  As such, starting at 1, you would have to alter the database to support your proposed idea.  The consequences of this are significant as it pertains to all of the product admin stuff.  Why do that when the above solution can be done by a competent programmer in less than an hour.]]> Sun, 26 Feb 2012 21:00:18 +0000 https://forum.productcart.com/link-to-product-sku_topic5014_post19170.html#19170 <![CDATA[Link to product SKU : The alterantive would be when...]]> https://forum.productcart.com/link-to-product-sku_topic5014_post19169.html#19169 Author: amscompanies
Subject: 5014
Posted: 26-February-2012 at 8:53pm

The alterantive would be when I import it uses the SKU as productID, which do you think would be better ?
 
I certainly won't have any duplicate SKU's
]]> Sun, 26 Feb 2012 20:53:26 +0000 https://forum.productcart.com/link-to-product-sku_topic5014_post19169.html#19169 <![CDATA[Link to product SKU : viewPrd.asp relies upon idProduct,...]]> https://forum.productcart.com/link-to-product-sku_topic5014_post19168.html#19168 Author: Greg Dinger
Subject: 5014
Posted: 26-February-2012 at 8:47pm

viewPrd.asp relies upon idProduct, which is the record ID associated with the product record in the products table.
 
To do what you want would require an additional function.  Add code to viewPrdCode.asp that queries the product record based on SKU. (Make sure you adhere to no duplicate SKU numbers.)
 
Then at the top of the logic in viewPrd.asp, you have to test for SKU being present in the querystring.  If non-blank, call your new function to return the idProduct associated with that SKU, and the rest of viewPrd.asp can then run in otherwise unaltered form.
]]> Sun, 26 Feb 2012 20:47:41 +0000 https://forum.productcart.com/link-to-product-sku_topic5014_post19168.html#19168 <![CDATA[Link to product SKU : How can I link to a product based...]]> https://forum.productcart.com/link-to-product-sku_topic5014_post19167.html#19167 Author: amscompanies
Subject: 5014
Posted: 26-February-2012 at 8:35pm

How can I link to a product based on it's SKU ?
 
For example
 
http://www.programmehut.com/store/pc/viewPrd.asp?SKU=3453452
]]> Sun, 26 Feb 2012 20:35:28 +0000 https://forum.productcart.com/link-to-product-sku_topic5014_post19167.html#19167