Missing Attachments and Requested Items

[matthew_magee1]

Hi community,

We've stumbled across this situation recently.

If I view a catalog item, fill in the appropriate fields, attach an item/picture, and then submit my order, I notice that the attachment will end up in the sc_req_item table per the sys_attachments table (see screenshot).

Now, some of our customers are opening a catalog item form, filling in the appropriate fields, adding the item to their cart, AND THEN attaching an item/picture. After they attach the item/picture, they are submitting their order. Well, when they do this, the attachment never makes it to sc_req_item.

A couple things have crossed my mind as far as a solution goes:

1. Hide/deactivate the attach button after the user has added the item to their cart. So only show the Attach button if the item has NOT been added their cart (not sure how this would be done)

2. Create a business rule that forces the attachment to the sc_req_item table (not sure how to do this)

3. Other???

Any thoughts/recommendations are greatly appreciated

[manikorada]

Mat,

In the case you have mentioned, the Attachments will be on the Request record as you have added the attachment to the entire Cart

[matthew_magee1]

Hi mani,

Thanks for the reply. I checked the applicable Request number associated with the Requested Item, but I do not see the attachment at the Request level. I've added the Related List 'Attachments' to the Request view but still don't see the attachment.

Any suggestions?

[LearnerSubho]

Hello Matthew,

I verified following scenarios :

1. User is filling all the required fields, adding attachments. Clicks 'Order Now'. -> Attachment is available on sc_req_item table i.e. with the RITM.

2. User is filling all the required fields. Clicks on 'Add to Cart'. Adding attachments on click of attachment button. Clicks Proceeds to checkout -> Attachment never gets attached with the RITM as the attachment is not added inside the catalog item. So, it stays in the 'sc_cart_item' table.

3. User is filling all the required fields. Clicks add to cart. Adding attachments on click of attachment button. Clicks Order now. -> Attachment is available with the 2nd RITM as user attached attachment with it.

Hope the information will help you.

Warm Regards,

Subhankar

[matthew_magee1]

Hi Subhankar-

Yes, your scenarios are correct.

I'm trying to fix #2 in your scenario.

Any suggestions?

Matthew