Kryptronic Software Support Forum

You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.

#1 02-02-2010 18:35:02

goski
Member
Registered: 09-27-2005
Posts: 115

Added column to ecom_prodoptionsel table

I've added a column to the ecom_prodoptionsel table and now I would like to display it in the product options dropdown list.  How do I display the value of my new column?

Offline

 

#2 02-02-2010 19:58:56

dh783
Member
From: Avondale, Arizona
Registered: 04-06-2005
Posts: 6233
Website

Re: Added column to ecom_prodoptionsel table

If you want the information in a new column you created then your going to have to find where the information from that database is used and insert it into the pulled array and then create a display for that new field. Product options are basically pulled/built in the ECOM_Prod/ECOM_Prod.php script.

What does the new column do or hold?

John

Last edited by dh783 (02-02-2010 20:32:33)

Offline

 

#3 02-02-2010 20:49:55

goski
Member
Registered: 09-27-2005
Posts: 115

Re: Added column to ecom_prodoptionsel table

The column will be used to hold the minimum quantity that can be order based on the option selected.  So, the product is golf balls that will be imprinted.  If you order a Personalized imprint (text only), the minimum quantity is 2 dozen, if you order a Logo imprint the quantity is 12 dozen, if you order a double logo imprint the quantity is 24 dozen.

I would like the customer to see the minimum quantity along with the upcharge (which already is displayed).  Eventually, I want the minimum quantity to populate the quantity box but I'll deal with that later.

Offline

 

#4 02-03-2010 15:53:14

goski
Member
Registered: 09-27-2005
Posts: 115

Re: Added column to ecom_prodoptionsel table

The post at https://forum.kryptronic.com/viewtopic.php?id=26329 seems very similar to my post.  Casimiro does not want to display one of the columns from the ecom_prodoptionsel table and I want to display a column that I added to the table. 

An explanation of how to manipulate the ecom_prodoptionsel display would be helpful.

Offline

 

#5 02-10-2010 12:44:10

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19798
Website

Re: Added column to ecom_prodoptionsel table

You need to edit /private/apps/ecom/ECOM_Prod/ECOM_Prod.php.  Look in the prodloadopt() function.


Nick Hendler

Offline

 

Board footer