When we receive a notification from Merch team that certain items have been turned off for Dropship, do the following
Run the queries below by replacing the VPNs from teh email
Select top 10 * from Attunity_RPro_Web.dbo.PIM_PRODUCT_INFO where VENDOR_PRODUCT_ID in ('LXAIR25-CHCDOL','LXPROCT25-15BKGY','PLYRVPRO25-7PBNV')
select * from Attunity_RPro_Web.dbo.PIM_PRODUCT_INFO where product_id in ('4015379304','4015380108','4016170301')
select * from Attunity_RPro_Web.dbo.OMS_INVENTORY_INFO where SKU in ('4015379304','4015380108','4016170301') and QUANTITY <> 0
Ensure the last query gives no result
Ensure teh Inventory matches in OD as well and no location has inventory
Then respond with the following
We have noted the change and confirm all the inventory is in sync for these 2 items across RPRO, OD and SFCC