|
toomuchpresha
|
Posted Fri 17 Dec 2010
|
|
Group: Forum Members
Last Active: Thu 12 May 2016
Posts: 50,
Visits: 86
|
Does anyone know how to delete option groups and attributes?
The default option groups dont have a delete option
Thanks
H4 Interactive is a North Wales based Web Design and Development Agency specialising in e-commerce systems and content managed websites
|
|
|
|
|
Mohammad
|
Posted Sun 19 Dec 2010
|
|
Group: Administrators
Last Active: Sun 27 Sep 2015
Posts: 115,
Visits: 706
|
Hi,
Option Groups and Attributes non of them has the delete option in the released versions of kartris, as they could be linked to different products.
The only way you can do the delete is to do it manually from the database (several tables need to be affected), but its not recommend, as it could break something else.
Will think about having this option in the future.
Mohammad
|
|
|
|
|
JohnH
|
Posted Mon 8 Aug 2011
|
|
Group: Forum Members
Last Active: Fri 26 Aug 2011
Posts: 12,
Visits: 560
|
Can you tell us which tables need updating ?
|
|
|
|
|
Mohammad
|
Posted Mon 8 Aug 2011
|
|
Group: Administrators
Last Active: Sun 27 Sep 2015
Posts: 115,
Visits: 706
|
The below tables should be affected in deleting OptionGroups:
tblKartrisOptionGroups
tblKartrisOptions
tblKartrisProductOptionGroupLink
tblKartrisProductOptionLink
tblKartrisVersionOptionLink
tblKartrisLanguageElements - this is very critical table, be careful when you delete records from this.
I would recommend to update the option groups/options rather than deleting them.
|
|
|
|
|
JohnH
|
Posted Tue 9 Aug 2011
|
|
Group: Forum Members
Last Active: Fri 26 Aug 2011
Posts: 12,
Visits: 560
|
Is there a database diagram available ?
|
|
|
|
|
Mohammad
|
Posted Tue 9 Aug 2011
|
|
Group: Administrators
Last Active: Sun 27 Sep 2015
Posts: 115,
Visits: 706
|
Sorry a diagram is not available, but if you want to clear the options' related data, then the delete should be in the following order:
- tblKartrisVersionOptionLink
- tblKartrisProductOptionGroupLink
- tblKartrisProductOptionLink
- tblKartrisBasketOptionValues
- tblKartrisOptions
- tblKartrisOptionGroups
- tblKartrisLanguageElements (where LE_TypeID = 5 OR LE_TypeID = 6)
And to clear the attributes' related data, then the delete should be in the following order:
- tblKartrisAttributeValues
- tblKartrisAttributes
- tblKartrisLanguageElements (where LE_TypeID = 4 OR LE_TypeID = 14)
|
|
|
|
|
toomuchpresha
|
Posted Wed 10 Aug 2011
|
|
Group: Forum Members
Last Active: Thu 12 May 2016
Posts: 50,
Visits: 86
|
Hi Guys,
It still seems weird that we cannot delete option groups. I have built about 10 websites in Kartris so far and none of them have anything to do with PC's or I.T.
One of them is furniture and they only use 2 options groups. This means that they have to see these pre set option groups in their system. This is confusing.
Is there any particular reason why there is no delete button?
H4 Interactive is a North Wales based Web Design and Development Agency specialising in e-commerce systems and content managed websites
|
|
|
|
|
Paul
|
Posted Wed 10 Aug 2011
|
|
Group: Administrators
Last Active: Fri 15 Sep 2023
Posts: 806,
Visits: 2,737
|
The original reason was that deleting groups that were in use was a complex process as the routine would have to check whether the options were in use in any products and then either flag a warning or proceed to remove those options while leaving the products behind.
But it will definitely be in v1.4 - it's on the list.
--
If my post solves your issue, can you 'Mark as Answer' so it's easier for other users to find in future.
If you would like to be informed of new features, new releases, developments and occasional special bonuses, please sign up to our mailing list: http://bit.ly/19sKMZb
|
|
|
|
|
Mohammad
|
Posted Wed 10 Aug 2011
|
|
Group: Administrators
Last Active: Sun 27 Sep 2015
Posts: 115,
Visits: 706
|
The data came with kartris package are just samples, I'm not sure why you kept them in your newly built websites.
If you want to start building a new website, there is a 'clear data' feature in the back-end "DB Admin" page, which is used to clear all existing products, sessions and/or orders data from kartris, so you can start over building your site from scratch with suitable data instead of modifying the sample data came along with kartris package.
|
|
|
|
|
toomuchpresha
|
Posted Wed 10 Aug 2011
|
|
Group: Forum Members
Last Active: Thu 12 May 2016
Posts: 50,
Visits: 86
|
Ah thats great! Will this all remove any attributes and option groups?
H4 Interactive is a North Wales based Web Design and Development Agency specialising in e-commerce systems and content managed websites
|
|
|
|