Developer forum

Forum » Development » Variant relations after delete variantoption

Variant relations after delete variantoption

E-mail notifications
Martijn Bokhove
Reply
Posted on 06/09/2011 10:06:50
Hi

A webshop from our customer shows products that are not visible in the Admin.
After searching for the problem, it seems that there are products in the database with variantoptions where the variantoption ore variantgroup no longer excists.

Localy I did some tests with the newest version (19.2.5.0) and discovered this:
- Removing a VariantOption removes the VariantOption in EcomVariantOptions and the relation with the product in EcomVariantOptionsProductRelation. Although it not removes the product with the Variant in the EcomProducts table, so there still is product with this Variant in the EcomProducts table.
- Checking out the checkbox from a Variant on the productdetailpage in the Admin and save the product. This removes the relation with the product in EcomVariantOptionsProductRelation. Although it not removes the product with the Variant in the EcomProducts table, so there still is product with this Variant in the EcomProducts table.

The result in all cases, is the frontend still showing the product, but it's unable to see the product(variant) in the Admin.
To remove the product(variant) from EcomProducts table, we have to delete it manually.

Could there be something wrong in our settings, that leave's the Variants in the EcomProducts table?

Gr
Martijn


Replies

 
Imar Spaanjaars Dynamicweb Employee
Imar Spaanjaars
Posted on 06/09/2011 23:10:14
Reply
Could this be related to your custom import tool? I've never seen this happen in the API, but I've seen it when my own code starts adding or deleting stuff without keeping the integrity in mind.....

Imar
 
Martijn Bokhove
Posted on 12/09/2011 08:31:23
Reply

Could this be related to your custom import tool? I've never seen this happen in the API, but I've seen it when my own code starts adding or deleting stuff without keeping the integrity in mind.....

Imar
Hi Imar

Our first customer has a custom import tool.
The second (Oosterik) doesn't have an import tool, products are added by hand. The variant(option)s I added en deleted where some new testdata.
The problem is that were filtering out the 'lost' products frontend, so the customer won't see them. But the filtering still sees this products, so the filteroptions ain't always correct.

Gr
Martijn
 
Imar Spaanjaars Dynamicweb Employee
Imar Spaanjaars
Posted on 12/09/2011 09:04:05
Reply
Hi Martijn,

I forwarded this to someone at DW DK to look into.

Thanks,

Imar
 
Nicolai Høeg Pedersen
Posted on 12/09/2011 10:50:22
Reply
We are now looking into if it is a bug in the API.
 
Merethe Nielsen
Posted on 12/09/2011 10:53:09
Reply

Can you give us an URL to the solution with the problem?

Maybe we need a copy of the site to investigate this, but lets get the URL for a start.

Thanks,
Merethe

QA Engineer, Dynamicweb.

 
Martijn Bokhove
Posted on 12/09/2011 13:51:42
Reply

Can you give us an URL to the solution with the problem?

Maybe we need a copy of the site to investigate this, but lets get the URL for a start.

Thanks,
Merethe

QA Engineer, Dynamicweb.

Hi Merethe

I took a complete blank solution to see if I could reproduce the problem there.
The URL of the project is here: http://dwvarianttest.staging2.innovadis.com

In the frontend there is a product "PRODUKT1 3" which is not findable anymore in the Admin.

In this case I made a VariantGroup 'Test 1' with 3 variantoptions.
I added the variantoptions to Produkt 1 and changed the name from the Variants.

After that I removed VariantOption 3 from VariantGroup 'Test 1'.
In the backend the product with Variantoption 3 (Produkt1 3) is not visible, in the frontend it still is visible.

Martijn
 
Merethe Nielsen
Posted on 13/09/2011 11:02:03
Reply

Hi again

I have tried to reproduce the same on the solution, that you provided. Check attached swf-video.

Maybe I do it in a different way?

It looks weird, that your product1, 1 1, 1 2 and 1 3 have the same url and are listed in the product list:

http://dwvarianttest.staging2.innovadis.com/en-US/Products.aspx?ProductID=PROD1

Are you able to reproduce it with a new product - and maybe create a video? (e.g use JING)

/Merethe

 

 
Merethe Nielsen
Posted on 16/09/2011 10:36:40
Reply

Hi Martijn

Are you able to make a video that shows how you reproduce it on your test site?

Kind regards,
Merethe

 
Rob Lohmann
Posted on 27/09/2011 08:51:45
Reply
 Hi Merethe,

Sorry for the late response. Martijn is on vacation, i'll make a video to reproduce the issue on the test website.

Kind regards,
Rob
 
Rob Lohmann
Posted on 27/09/2011 16:07:05
Reply
 Hi Merethe,

I won't be able to make the video today due to other things which need to go first. I'll keep you updated and i'll try and post it tomorrow.

Sorry for the inconvenience.

Kind regards,
Rob
 
Rob Lohmann
Posted on 28/09/2011 16:56:41
Reply
Hi Merethe,

Attached you'll see a screencapture of how we're able to reproduce this issue.The customer is doing it the same way, he just disables the checkbox of a productvariant when editing products.

I hope it's more clear now else please let us know.

Kind regards,
Rob
 
Rob Lohmann
Posted on 21/10/2011 09:10:38
Reply
 Hi Merethe,

Do you already have any news regarding this issue?
 
Morten Snedker
Posted on 24/10/2011 10:13:59
Reply
 Hi folks,

I've fixed the bug (item 7230). Fix will be available with next service release. Until then you may download the specific assembly here: http://dl.dropbox.com/u/175230/dw/Dynamicweb.Integration.zip.

Unzip and place DLL in the \bin folder of the solution. If you do not have access to the folder, let me know which solution, and I'll put it there for you (given that it is Hostnordic hosted).

Please let me know if it fixes you problem!


Regards

Morten Snedker



 
Martijn Bokhove
Posted on 01/11/2011 10:39:34
Reply
Hi Morten

I've downloaded the latest version with the fix, but it seems the problem is still there.
As attachment there is a PDF with my actions and comments to reproduce the steps.

Please let me know if the document is enough information at this moment.

Gr.
Martijn
 
Morten Snedker
Posted on 01/11/2011 11:12:30
Reply
 Hi Marijn,

Copy that. That is a bug in the backend functionality, and has been registered as bug #7400.

Regards /Snedker

 

You must be logged in to post in the forum