|
Paul
|
Posted Wed 10 Aug 2011
|
|
Group: Administrators
Last Active: Tue 10 Sep 2024
Posts: 807,
Visits: 2,748
|
There are basically three options for removing data:
product related
order/customer related
session related
The product one will remove all product data, categories, versions, options, option groups, attributes etc. But there is no finer control to remove specific items, because these are all inter-related. So it is something to do before you start populating a store with your own data.
--
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
|
Yes, if you selected the type of data you want to clear, it will list down the whole tables that will be cleared if you proceed with the operation.
Attributes and option groups are considered under "Product Data"
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
Paul
|
Posted Wed 10 Aug 2011
|
|
Group: Administrators
Last Active: Tue 10 Sep 2024
Posts: 807,
Visits: 2,748
|
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
|
|
|
|
|
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
|
|
|
|
|
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)
|
|
|
|
|
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 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 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 ?
|
|
|
|