topic Re: Error uploading fuse sheet in _Ask A Question for Item Management (IM)

Error uploading fuse sheet

niteishk — Fri, 05 Jul 2024 17:23:42 GMT

Hi Team,

While uploading fuse sheet we are getting below error.

GTIN	TM/Child
00070253898503

Error Code

Error Message

Attribute ID

SLTL6205

For item (00070253898503), attribute GTIN requires a valid 14 digit GTIN.

GTIN # 10070253498500 got uploaded correctly but retail UPC gives above error, please suggest.

Thank you.

Re: Error uploading fuse sheet

Julie — Fri, 05 Jul 2024 18:25:17 GMT

Hello @niteishk and thanks for reaching out!

When using Copy + Paste, that also copies the format of the values from where it was copied or it auto-selects when added in the file. If the format that is copied is "Number" when saving the file it removes the leading zeroes.

The format of the Load Sheet must be "Text", please update your file and reupload after verifying the Item ID for the Each has all 14 digits.

How to change the format in Excel:

1. Select the cell or range of cells that contains the numbers that you want to format as "Text". ( You can also select empty cells, and then enter numbers after you format the cells as "Text". Those numbers will be formatted as "Text".)

2. On the Home tab, in the "Number" group, click the arrow next to the "Number Format" box, and then click "Text". (If you don't see the "Text" option, use the scroll bar to scroll to the end of the list.)

If the above solution does not fix it, please provide me with the file that was used when uploading, thank you!

Re: Error uploading fuse sheet

niteishk — Mon, 08 Jul 2024 19:10:00 GMT

Hi Julie,

I have sent you the Fuse sheet through email, please review and suggest.

Thank you.

Nitesh Kumar

Re: Error uploading fuse sheet

Julie — Mon, 08 Jul 2024 19:58:49 GMT

Hello @niteishk I did not see an email come through from you.

I've attached the documentation on how you can upload the file in Item Management directly and I will be able to view what was uploaded. The steps on how to upload are at page 8: Documentation - FUSE Quick Sheets. Thank you!

Re: Error uploading fuse sheet

niteishk — Wed, 10 Jul 2024 14:00:43 GMT

Hi Julie,

If GTIN has wrong check digit, does 1WS prevents us from uploading data due to this? As in this case, retail upc # 00070253898503 shows having wrong check digit 3 instead of 1 when we checked this in gs1 check digit calculator.

Just wanted to know if 1WS is giving error of wrong 14 digit GTIN is due to this?

Thank you.

Re: Error uploading fuse sheet

Julie — Wed, 10 Jul 2024 14:25:06 GMT

Hello @niteishk, it's lovely to talk to you again.

Apologies, I calculated the Each based on Case GTIN 10070253498500 and it gave me this number 00070253498503, that is why I did not think it would be because of the check digit as they were both ending in 3.

You are correct, if the check digit is incorrect you would receive this error and would need to correct the GTIN in the FUSE before trying to upload it. Thank you and please let me know if further help is needed.

Re: Error uploading fuse sheet

MARKEDWARDS — Wed, 17 Jul 2024 14:14:24 GMT

Hello

When UPC code for one of my sizes/case pack changes and to avoid all unpublish/modify/publish steps, can I just export the Load Sheet (FUSE) and modify all the columns related to UPC code and import the file again? If that works, could you please specify which columns I should edit, and does that consider as published when I upload it?

I received an error of exclamation mark in the status and it says "DATA VALIDATION ERROR" and not able to open the link.

Thank you so much

Re: Error uploading fuse sheet

MARKEDWARDS — Wed, 17 Jul 2024 15:02:38 GMT

Hello again

I just changed "operation" column to ADD and new CA with all the child link added to the IM page under status of "completed" and event of "ITEM ADD" Is that ok to publish it to PI page? if yes, should I delist the previous incorrect style from PI page, or it doesn't matter?

Thank you again.

Re: Error uploading fuse sheet

Julie — Wed, 17 Jul 2024 19:37:16 GMT

Hello @MARKEDWARDS and thanks for the details.

I've attached the Documentation - FUSE Quick Sheets that will provide assistance in how to work with the FUSE file. Once you're done creating and linking your hierarchy in Item Management, you would need to publish and submit the item to Kroger for them to receive the data.

If they are no longer selling the old item, you can choose to withdraw/delete the publication, however, I would recommend verifying with them before removing any existing publication. Thank you!

Re: Error uploading fuse sheet

MARKEDWARDS — Fri, 19 Jul 2024 13:19:15 GMT

Thank you so much.

Re: Error uploading fuse sheet

MARKEDWARDS — Fri, 19 Jul 2024 13:38:50 GMT

I am also wondering if I could create one master excel sheet with both IM and PI data in it and import them in PI page? Or, I have to fill out IM excel sheet separately, publish it at IM page, and manipulate data in PI page after?

Thank you again for your response.

Re: Error uploading fuse sheet

Val — Fri, 19 Jul 2024 14:18:35 GMT

Hello @MARKEDWARDS and thank you for posting your question.

You would need to create separate master worksheets for Item Management and Product Introduction (also separate for Kroger and Albertsons) because the file formatting and attribute selection is different.

For Item Management, you can use this link as a starting point.

For Kroger and Albertsons, you may have both GDSN (items published through a Data Pool) and Non-GDSN (items created in their entirety in Product Introduction) items and need to use different templates for them.

For Kroger GDSN you can use this link as a great starting point, while for Non-GDSN you can use this link.

For Albertsons you can use this link for a walkthrough of the Spreadsheet Data Loader.

One important note is the file formatting for Item Management will change over time for the Load Sheet (FUSE) as Item Management versions are updated and as new GDSN requirements take effect, so older Load Sheets may no longer be supported. The file may still be of use for you as a reference file, though.

I hope this helps.

Please let us know if there is anything else we can help with.

Re: Error uploading fuse sheet

MARKEDWARDS — Tue, 23 Jul 2024 16:11:54 GMT

Hi

Could you please let me know how I can upload the excel sheet for IM in an order, bc they are not following the order of my excel sheet after upload, so I can parent them faster?

I followed the same format in "FS_Link" but seems like parenting is not working, could you please help me with that as well?

Thank you so much

Re: Error uploading fuse sheet

DanV — Tue, 23 Jul 2024 16:54:27 GMT

Thank you for reaching out to our customer community. Welcome.

The item links will only be successful if the item add is successful, be sure to check the Worklist after each FUSE upload to correct any validation errors

Re: Error uploading fuse sheet

MARKEDWARDS — Tue, 23 Jul 2024 19:51:21 GMT

Thank you so much for your response.
item links are successful, but they are not added in the same order as Excel sheet I create. Is there any way I can have CA followed by the all the child link in the same order I add them in the sheet to upload?
Your help is truly appreciated.

Re: Error uploading fuse sheet

DanV — Tue, 23 Jul 2024 20:46:33 GMT

Hi @MARKEDWARDS ,

I will check with our escalation teams on the order FUSE processes link request and will have an update for you tomorrow.

Re: Error uploading fuse sheet

MARKEDWARDS — Wed, 24 Jul 2024 13:21:22 GMT

Appreciate that 😊

Re: Error uploading fuse sheet

DanV — Wed, 24 Jul 2024 15:57:30 GMT

Hello @MARKEDWARDS

I did some additional testing in Item Management (testing done in our Pre-Production environment) and the linked GTINs are listed in GTIN numerical order.

Below is a screenshot of the hierarchy I tested, I linked GTIN 00614141990818 first then linked GTIN 00614141990801 second/below the first GTIN, after saving IM arranged the linked GTINs in numerical order:

FYI - there is no functional difference in the order the GTINs are listed when linked

Re: Error uploading fuse sheet

MARKEDWARDS — Thu, 25 Jul 2024 15:58:08 GMT

Thank you so much for clarification, and you're right there is no functional difference in this stage.
However, the question was more about when I upload the excel sheet to show up in the item list, but the items are not in the order I entered in the sheet. Do you think this is also because of GTIN numerical orders?

And, can I do the link attributes (hierarchy) in my sheet and appears with child GTIN while uploaded? because, I tried to do it by filling "imported" column as "Y" and "operation" column as "ADD" but still doesn't operate as parented when uploaded, and I have to do it on the 1WS to operate. Could you please help with that as well?

Appreciate it.