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 10-23-2024 13:06:12

polarize
Member
Registered: 11-15-2004
Posts: 302

Adding New User-Defined Columns in Inventory

Hello,

A while back we added User-Defined Columns in the Inventory table but can't seem to remember how and not coming up in the search in the forum.  Is there a procedure for this?

Thank you smile


Using Kryptronic K9! smile
Previous Versions:
ClickCartPro 8
ClickCartPro 7
ClickCartPro 6
ClickCartPro 5.1

Offline

 

#2 10-24-2024 08:50:34

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

Re: Adding New User-Defined Columns in Inventory

Use System / Database / Raw DB Admin.  Choose to 'Maintain' the 'ecom_inventory' table.  Add columns as you wish.


Nick Hendler

Offline

 

#3 10-24-2024 09:03:19

polarize
Member
Registered: 11-15-2004
Posts: 302

Re: Adding New User-Defined Columns in Inventory

Thank you for your reply Nick.  One more question..

Is there a setting for adding a column to default display each time the Inventory Items is opened in admin console so there is not a need to modify the search display every time we go in there?

Thanks Again


Using Kryptronic K9! smile
Previous Versions:
ClickCartPro 8
ClickCartPro 7
ClickCartPro 6
ClickCartPro 5.1

Offline

 

#4 10-28-2024 08:38:53

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

Re: Adding New User-Defined Columns in Inventory

If you haven't already added the column, when you do, choose true/1 for 'Guided Overview Display Indicator' and that will make it show in the primary list when managing inventory items.

If you already added it, when you added your new column, the software added an entry for it in the core_columndefs table.  Use Raw DB Admin to browse the core_columndefs table, locate that entry (cid will be ecom_inventory.yourcolumnname), choose to Update it, and set the value for cbackendlist as '1'.


Nick Hendler

Offline

 

#5 10-28-2024 08:54:45

polarize
Member
Registered: 11-15-2004
Posts: 302

Re: Adding New User-Defined Columns in Inventory

Thank you Nick! That worked perfectly smile


Using Kryptronic K9! smile
Previous Versions:
ClickCartPro 8
ClickCartPro 7
ClickCartPro 6
ClickCartPro 5.1

Offline

 

Board footer