Start a conversation

Products stuck in incremental ProductFeed

Overview

You are facing products are exporting in the incremental ProductFeed with a delete instruction and this has been processed in downstream applications.

Solution

This can be resolved by removing the entries in the registry table to allow ProductFeed to return the entries without the Delete record type. It should be done in the DB by our Customer Support team. Please create a support ticket with the description of the issue and attach the ProductFeed response XML file.

create table sup.zd2744389_product_register as
select * from xdi_180416_registry.ff_product_register
where (season || sty_num || sty_qual || sty_code) in ('1FXAWWPS97148286900');
delete 
from xdi_180416_registry.ff_product_register
where (season || sty_num || sty_qual || sty_code) in ('1FXAWWPS97148286900')

Testing

The next ProductFeed request should now return the entry without the Delete record type.

Choose files or drag and drop files
Was this article helpful?
Yes
No
  1. Priyanka Bhotika

  2. Posted 21 days ago
  3. Updated 5 days ago

Comments