0005791: oxfield2shop values are not removed when parent article is unassigned from shop

ID	Project	Category	View Status	Date Submitted	Last Update

0005791	OXID eShop (all versions)	4.01. Database handling	public	2014-06-16 14:45	2014-08-25 08:01

Reporter	tadas	Assigned To
Priority	normal	Severity	minor	Reproducibility	always
Status	resolved	Resolution	fixed
Product Version	4.8.6 / 5.1.6
Target Version	4.8.8 / 5.1.8	Fixed in Version	4.9.0_5.2.0_beta1

Summary	0005791: oxfield2shop values are not removed when parent article is unassigned from shop
Description	When article with variants is assigned to subshop and it's variant price is changed, oxfield2shop values are updated accordingly. However, once the parent article is unassigned from shop, oxfield2shop values still remain. After assigning the article to subshop again, it gets existing values from oxfield2shop.
Steps To Reproduce	1. Create subshop (without inheritance, set parent to main shop) 2. Assign an article with variants to this subshop 3. In subshop, change article variant price 4. Unassign the parent article 5. Check database oxfield2shop table, not removed entries should be there 6. Assign parent article again, it should have prices set previously.
Additional Information	It seems that it is heavily related to non active variants. They're probably the ones not removed from oxfield2shop upon parent unassignment.
Tags	Database, Variants

Theme	Azure
Browser	All
PHP Version	any
Database Version	any