FUSE Error - New Template

[vsantiago]

I’m reaching out regarding an issue I'm experiencing with the new Fuse upload template. I have a large number of GTINs that are not being linked to the correct parent GTINs. When modifying the GTINs, I am encountering the following errors:

1. For the child GTINs:

   • ERROR: 5000 Link already present
     The child item is showing as the parent item, and the child gtin is an old UPC/GTIN/Item ID. The Child GTIN that I uploaded as a new item, is linking to an old GTIN, making the old GTIN the parent. The child GTINs are showing an error that indicates a conflict. It seems like the child GTIN I’m trying to modify is already linked to another parent, or there’s an existing conflict when trying to update the GTIN (Item ID).

2. For the parent item or case pack GTIN:

   • 202: Invalid market group (United States)

   • IM:1631: Brand Name is required in the Marketing Message.
     The errors indicate issues with the market group and missing brand name in the marketing message, even though the data is properly filled in the template.

Would you be able to provide guidance on how to resolve these issues? Any advice or steps to fix the GTIN linking issue and address the errors related to the parent item would be greatly appreciated.

[Val_P]

Hello Vanessa (@vsantiago) and welcome to the customer community. Thanks for reaching out.

It looks like the items are already linked, that is why you are receiving the error under number 1. We can check further and assist if the issue persists and also have a look at the error under number 2. Can you please help us with one or a few GTIN(s) you may want us to have a look at? Thanks.

[vsantiago]

Hi Val,

Thanks so much for your reply and your willingness to take a closer look.

Here are a few examples of the GTIN conflicts I’m seeing:

Example 1:

• Parent GTIN: 20199147107407

• Incorrect Child GTIN currently linked: 00199147107403

• Correct Child GTIN that should be linked instead: 0019840895051

I uploaded a FUSE sheet with the following actions:

In FS_Item "Record Type: ITEM, Operation: ADD, and Import: N"

In FS_Link: I have the Operation as ADD, and Import as "NO"

In FS_Publication: I have the Operation as Republish and Import as Y. 

What would be the best way to fix this issue? I have hundreds of GTINS that are incorrect but assigned to parent GTINs already. 

Let me know what additional details you might need. I really appreciate the help in resolving these linking and validation issues!

[Val_P]

Thank you very much for the additional information provided, @vsantiago.

GTIN  20199147107407 is currently published (to 0838016003360 1WorldSync Content1 and to 0078742000008 Wal-Mart United States). If the Case was linked to the wrong consumer unit, you then need to withdraw all current publications of this Case, then wait 25 hours, next unlink the Case from the wrong Each and only then can you link the Case with the correct Each and Publish again to your intended retailer(s). 

Here is an article with more details about when you need to Withdraw a publication and wait the 25 hours: When Do I Have to Wait 25 Hours to Update My Item/Hierarchy?

It may also sometimes be easier and quicker to perform a single action - linking, unlinking or publishing - through the Item Management interface instead of FUSE as it is instant. That being said, if you have tens or hundreds of items to update, FUSE will be a more efficient use of your time.

A few more notes about using FUSE:

1.  You wrote the following" In FS_Item "Record Type: ITEM, Operation: ADD, and Import: N"

This is fine, but has the potential to lead to issues. As long as the items are already added, the Operation should be either Append or Modify instead of Add, please. Therefore, if you were to switch to Y instead of N and not update "Add", the upload would fail.

2. In FS_Link: I have the Operation as ADD, and Import as "NO"

Because the items are published, this would fail anyway, even if it were Yes instead of No. This is why the withdrawal and 25 hour wait are needed.

3. In FS_Publication: I have the Operation as Republish and Import as Y. 

Republishing should not in general cause any issues, however it also does not help in this case, as it only refreshes the incorrect hierarchy in the retailer's systems. Withdrawing and waiting the 25 hours are needed here as well.

Please let us know if this helped or if there is anything else we may assist with for this request. Thanks!

[vsantiago]

Hello Val, 

Sorry, this is my first time using FUSE.

On the Fuse sheet, I do not see withdraw, only "Republish, Add and Delete". 

When Withdrawing publications, Do I simply upload the FS_Publication Tab only, or do all tabs need to be included in the upload and if so, do they remain blank? 

If and when withdrawing from the FUSE sheet, will Operation be "Delete", and Import will be "Y"?

Thank you so much!

[Val_P · Accepted solution]

Hello @vsantiago and thank you for the follow-up. 

Withdrawing is the Item Management action needed, under the FS_Publication tab in FUSE it shows up as Delete, please. 

Because the FUSE sheet is a specially formated Excel file, when attempting to upload, our systems will check for the integrity of the file. Therefore keeping all tabs is important, otherwise the upload would fail.

You are correct - when Withdrawing, the Operation will be Delete and Import item? should be Yes, please. All other tabs in the file should have an Import item? selection of No, please. Thanks!