Customizing ProductCart - UpdatingCustom Search Fields Question v3.5Upgrade

Print Page | Close Window

UpdatingCustom Search Fields Question v3.5Upgrade

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Customizing ProductCart
Forum Description: Exchange messages with other users that are customizing ProductCart.
URL: https://forum.productcart.com/forum_posts.asp?TID=2791
Printed Date: 26-July-2025 at 7:14am
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: UpdatingCustom Search Fields Question v3.5Upgrade

Posted By: njessen42
Subject: UpdatingCustom Search Fields Question v3.5Upgrade
Date Posted: 11-June-2009 at 4:41pm

As of v3.1 we were using the three custom search fields available and updating them with a SQL query from a table imported into the database we created from Access (dbo.Product Cart).

This data went into these fields in the dbo.products table
custom1 ---Color
content1
custom2 ---Country
content2
custom3 ---Catalog Page Number
content3

Well since upgrading to version 3.5 there is a slight problem with that. Looks like all data was converted from the old fields into the new fields in different tables product cart uses. I have found all the information Early Impact provides about the new fields being used. Love the new custom search field look...
but it now seems a little more complicated to update/append.

Is anyone updating this not using the Admin control panel with some sort of query? If not what is the easiest way to update these fields through the import feature?

Any suggestions would be helpful. Here is the link to our advanced search and the huge list of searches we use. Over 1900 distinct idSearchData entries with 3 current idSearchFields.

http://shop.rings-things.com/cart/pc/search.asp - http://shop.rings-things.com/cart/pc/search.asp