Remove product from all categories (XML -> DW provider)

Martin Skov Nielsen

Posted on 20/03/2014 08:46:59

My problem is that I can't get the import job to remove all categories from a product...

<Item ItemNo="10210" ShopID="SHOP1" LanguageCode="LANG2" VariantCode="" Description="Product is described here" Description2="" Unit="S" UnitPrice="0.00" Inventory="85.00" ExtendedDescription="tekst fra feltet ExtendDescription udlæst fra Ax" AXDispQty="10" AXTestFieldProduct="Test produkt">
      <Prices>
        <Price Currency="EUR">0.00</Price>
        <Price Currency="SEK">0.00</Price>
      </Prices>
      <Category No="41" />
    </Item>

If I then remove

<Category No="41" />

I would expect that it was removed from the product during import... but it's not. Updating it works fine however.

Anyone ever faced this issue before or knows how to troubleshoot it?

Replies

Morten Snedker

Posted on 23/04/2014 10:59:12

Hi Martin,

Sorry for the late response, but:

Are you running DW 8.4?
Have you set the "Remove missing rows" from the destination settings?

If so, it ought to work...

Regards /Snedker

Martin Skov Nielsen

Posted on 23/04/2014 13:17:54

Yes.

Running 8.4.0.16 and the remove missing rows is set :-/

Morten Snedker

Posted on 23/04/2014 13:18:54

And which provider are you using for destination?

/Snedker

Martin Skov Nielsen

Posted on 24/04/2014 09:31:21

It's a dynamicweb provider. Because the ecom provider can't handle import of groups/group relations

Morten Snedker

Posted on 24/04/2014 10:05:04

The whole idea of the Ecom Provider is to facilitate data in and out of Ecom. So I guarantee you that it handles group relations. Dynamicweb will instantly send you three bottles of red wine if it does not handle the mentionend import, using the Ecom Provider. ;-)

So, I strongly recommend using the Ecom Provider for import/export to Ecom. Take a look at http://vimeo.com/album/2042889/video/47652121, and let me know if things are clearing up...

Regards /Snedker

Martin Skov Nielsen

Posted on 24/04/2014 10:21:17

I don't see how I should map the group relations with the ecom provider?

Morten Snedker

Posted on 24/04/2014 10:42:06

Maybe you'll see it in the link I provided....

The documentation for this module is actually quite good: http://developer.dynamicweb-cms.com/documentation/for-developers/data-integration/providers/ecom-provider.aspx

/snedker

Morten Snedker

Posted on 24/04/2014 10:53:54

PS: As such, there is nothing wrong using the Dynamicweb Provider. The advantage is better performance. The downside is the required knowledge of the tables used for Ecom.

The advantage of using the Ecom Provider is Ecom-specific settings for the destination and simplicity, since logic is blackboxed in the Ecom Provider.

/Snedker

Martin Skov Nielsen

Posted on 24/04/2014 11:00:05

Ya almost... except... it didn't work...

Attached an image first shop is with the DW provider, second with ecom:

Morten Snedker

Posted on 24/04/2014 11:39:59

Using Ecom Provider:

If no parent groupID is given, the group will be nested below the shop. So information on parent ID is missing or otherwise misplaced.

Here is a simple example of importing groups, and also shows the removal og extinct groups: http://screencast.com/t/Szk63RPi

/Snedker

Morten Snedker

Posted on 24/04/2014 11:56:13

Oh...it seems that there is a bug when removing rows from some Ecom tables, when using the Dynamicweb Provider. I'll investigate and get back on that particular one...

The group relations are removed ok, but the groups themselves are not. Same may go for group-product-relations.

Martin Skov Nielsen

Posted on 25/04/2014 08:34:44

Ok - that looks likely :)

You must be logged in to post in the forum

Developer forum

Remove product from all categories (XML -> DW provider)

Replies