201 Advanced: Item Management Mass Upload with the Load Sheet (FUSE) Workshop

[CommunityJedi22]

Please see the attached deck for the training webinar Item Management Mass Upload with
the Load Sheet (FUSE) Workshop.  You can learn more about this training opportunity in our Events Calendar.

Please see below and ask questions in the comments area.

[aciura]

Hi, how can i sing up for the training 

[George_C]

Hi @aciura, Thank you for reaching out to our customer community.  Welcome.

For training and webinars, I can recommend checking the https://community.1worldsync.com/t5/Events-Calendar/eb-p/EventsCalendar, as we would have one coming up tomorrow the 22nd, and another in February. 

[WellsDataSync]

Hello, when using the FUSE load sheet, is it possible to only enter in information for a single attribute and still be able to upload? Or do all attributes need to be filled out every time you upload?

[ana_neamtu]

Hello, @WellsDataSync , and welcome back to our Customer Community!

The APPEND operation will ignore attributes that are left blank, hence you can provide only the new values for the fields that need to change when using this operation under the FS_Item tab.

However, there are mandatory columns that need to be listed in order for the upload to work. In addition to the first three columns, fields such as Information Provider GLN, Item Type, Item ID, Target Market(VV) will also have to be provided for the upload to succeed.

Hope this helps! Please don't hesitate to let us know if you have additional questions.

[MARKEDWARDS]

I have another question, also, I need to know how can I add CA (casepacks) to my recent upload. I tried Append and Modify and non is working, how can I add it and make hierarchy work? they didn't add in the beginning and doesn't work no matter whatever method I use.

[ana_neamtu]

Hello, @MARKEDWARDS,

It’s good chatting with you again.

Please use the ADD operation under the FS_Item tab to create the CASE GTINs.

We noticed that the previous ADD you tried failed with the error message below:
2954 : For Country of Sale Code (targetMarketCountryCode) (US), if Irregularly Configured Non-GTIN Pallet Indicator (isNonGTINLogisticsUnitPackedIrregularly) equals "FALSE" or is not used, then Count of This Specific Item in a Non-GTIN Pallet (quantityOfTradeItemsPerPallet) must equal Number of Layers per Non-GTIN Pallet (quantityOfLayersPerPallet) multiplied by Number of Units per Layer in a Non-GTIN Pallet (quantityOfTradeItemsPerPalletLayer).

The error refers to column DRO > Count of This Specific Item in a Non-GTIN Logistic Unit/NonGTIN Pallet Quantity, which should be equal to the Ti * Hi, so to 19 * 8 (columns DRK and DRM), but which is currently set to 1. Please make the necessary adjustments, then upload the file. Kindly check the WORKLIST after the upload is processed to see the status of the ITEM ADD operations.

We recommend this post for more information on the error received and this document for information on how to check the status of the FUSE upload after it has been processed.

Please don't hesitate to let us know if you have additional questions.

[MARKEDWARDS]

Thank you for your response. I just updated the sheet and it's working, however I wanted to know is this the new update? As it is so new to us and we were always using "1" instead of "152". Thank you so much.

Also I'm trying to upload sheet to product introduction page and I'm receiving this error "

• PI8226 : Data was found on spreadsheet row 35, however, no record type was found. This data will not be processed." 
  
  But the corresponding rows have value. Could you please advise what is wrong based on the screenshot of the error and my sheet? Thank you so much  

[George_C]

Hello, @MARKEDWARDS, and welcome back to our Customer Community!

As this inquiry requires more troubleshooting, we will create a ticket and send an email to you, and you can reply to the ticket with the spreadsheet so we can check and help further. 

[MARKEDWARDS]

Hi, I hope you are good. Just a quick follow up on my question above. Thank you.

[ana_neamtu]

Hello, @MARKEDWARDS,

It’s good chatting with you again.

Regarding your question on the 2954 IM Validation error we discussed, "is this a new update":
Yes, this is a new validation implemented with the new IM large release that happended last weekend. You can check all new validations by filtering the IM Participant Dictionary, IM validations tab, column J by 3/10/2025. The document needed is at the link below:
https://community.1worldsync.com/t5/IM-Participant-Dictionary/Current-IM-Participant-Dictionary-IMPD...

For more information on the Large release, please access this link:
https://community.1worldsync.com/t5/IM-Large-Release-Information/ct-p/IMLargeReleaseInfo

Regarding the issue you've been having with uploading the SDL in VIP:
I have just resent the support team's email via ticket CXTECH-83973. Kindly reply to the email with the SDL file attached so that the team can look into the issue.

Thank you

[MARKEDWARDS]

Hi Community,

I have faced a problem with the Kroger family (class number) for the screenshot below, and I changed them to 988 instead of 950 and clicked submit again. Do you think that would be the solution? cause the customer can't yet see the styles on their end. Do you think that's because I had to unpublish and publish it again? It's now on "retailer" level, so there isn't much I can do right now. Could you please urgently help? Thank you so much

[Val_P]

Hello @MARKEDWARDS, it’s good chatting with you again. Welcome back.

I can see some successfully submitted heirarchies yesterday to Kroger like 00622793840825 (IMF 2825197) and 00622793792551 (IMF 2822742), so updating the Class as the retailer requested is working. You can find an IMF number in the Comments section of the Hierarchy Data Page, once assigned. Sometimes even if a submission is still In Process Retailer (as is the case here), it can still receive an IMF number before the status is updated to Complete.

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

[MARKEDWARDS]

Thanks for your response, however I have still the same issue with 00622793840818, could you please help transmit this and they will fix the kroger family class number on their end? It's urgent and I tried to submit this with both 988 and 959 , none worked and it says this submitted but without any IMF number. Could you please advise? Thank you very much.

[Val_P]

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

For item 00622793840818 Kroger was initially advising it needs to be submitted as Class 988, which you have already corrected, so no further action is required on your side for the Class. The more recent review message reads "Item found in submitted status", therefore it may be a duplicate submission and need to be Rejected by Kroger before you can submit again and they can assign an IMF. 

In this case we recommend contacting Kroger to either confirm the exact issue or request them to Reject the submission that created the duplicate and you can then resubmit successfully. You can reach the Kroger Supplier Engagement Group at 844 277 6165 VIP Opt 1 and  ITEMMDMVIP@KROGER.COM.

Also, we recommend opening a new topic in our community whenever you come across a new issue (unless you find an already existing topic that deals with that issue) so that it is easier to track as this topic is for Item Management and for FUSE.

Please let us know if this helped or if there is anything else we may assist with for this request and we would be delighted to. Thank you!

[MARKEDWARDS]

Hi,

I hope you are doing good. I am recently facing an issue when do master upload, although nothing has changed from my end, kroger team are receiving my casepacks as "Shipper" instead of "Case" and I was wondering if some setting in FUSE sheet has changed without further notice. As an example I had issue with style 84325J with IMF code of: 2856344

I would be thankful if you could help since non of my styles are going through.

[Val_P]

Hello @MARKEDWARDS, thank you for continuing the use of our customer community. Welcome back.

Here is an article explaining how to designate an item as a Shipper for Kroger (it may also be added as a Case and show up as a Shipper on their end): How to Corner - Designating a Shipper in VIP

In a nutshell, the attributes taken into consideration are these:

We recommend going through the article if the item should not show up as a Shipper for Kroger and, if needed, making the changes and resubmitting from Product Introduction. Thanks!

[MARKEDWARDS]

Thanks for the answer, however, there is no where in my sheet or in the website that I chose "shipper" or ever changed the process of uploading my FUSE sheet. But I'm receiving this message from Kroger recently. Did anything change from 1WS behalf in terms of uploading FUSE sheet? My type for case in chosen as "case" and can't figure out what does this recent problem come from. Could you please check my uploaded sheet, or the PI page to see what is wrong?

Thanks so much again.

[Val_P]

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

As far as we know there was no update for Kroger for this process. Please check the link from my previous post as that explains how and why "Cases" can also show up as "Shippers" for Kroger, depending on the values added for the 3 attributes in the screenshot I added and the article covers. Thank you.

[MARKEDWARDS]

As far as I understood from the article, everything looks fine from my side but the case shows as "shipper" for an unknown reason, could you help how I can get more specific help regarding my recent styles that are facing issue?

Thank you!

[Val_P]

Hello @MARKEDWARDS and thank you for the follow-up, the additional information is much appreciated.

Is the GTIN you are having issues with 00622793793374, please? If so, we noticed this is still In Process Retailer, therefore it is up to Kroger to either accept the item or reject. For this item, we can confirm it should not show up as a Shipper in Kroger's systems as none of the 3 attributes in the screenshot above match the Shipper requirements.

If the issue persists we recommend reaching out to the Kroger Supplier Engagement Group or your Kroger Category Manager. Thanks.

[MARKEDWARDS]

Hi

Thank you for your support. I have question regarding the last step before submitting the style. I was wondering how I can fill up information in the FUZEIT so it automatically fills up the information regarding date and distribution center and shipping info so it will fill up automatically and submit the style? I couldn't find the relevant page, and would be thankful if you could help me with that. Thank you so much.

[Val_P]

Hello @MARKEDWARDS, it's great chatting with you again.

If you are referring to using Excel for Kroger and/or Albertsons, it can be done for Kroger only, using the Spreadsheet Data Loader. We have two guides for GDSN Kroger Quick Sheets for GDSN Spreadsheet Data Loader and for NonGDSN Kroger Quick Sheets for Non-GDSN Spreadsheet Data Loader information providers. 

Our recommendation is to download an item you have already fully submitted to Kroger and use that as a template for the Hierarchy Data Information for the new items.

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

[MARKEDWARDS]

Hi Community,
I have a question regarding my current situation. I have recently realized that I have to choose "Shipper" as "Display Type" or it won't work from the customer side. So they rejected my styles and I changed the display type, saved, validated and submitted again. But I didn't receive any message for the last update as you can see in the attachment. I have few questions regarding that as kroger can't see the styles on their side:

1- should I republish and do the entire PI step again? And if not, Should I change "Kroger Item Submission Reason Code" from "New Item" for the submission to take place?

2- how can I get the new IMF code?

3- Where in my fuse sheet I can fix this for the future purposes?


Thank you so much,

 

[Val_P]

Hello, @MARKEDWARDS, it's great chatting with you again. Welcome back to our customer community.

The "Display Type" from Product Introduction is not a GDSN attribute. For Kroger, it can be added in Product Introduction directly, please. Whenever you need to check if an attribute is GDSN or not, you can use the Kroger Attribute Sheet:

Once your company is transitioned to the Kroger API, you will be able to find and add the attribute in Item Management by using the Kroger Playlist, but this is once you are no longer using Product Introduction at all for Kroger only:

1. No need to Republish from Item Management please, I can see it is currently submitted in Product Introduction and awaiting an update from Kroger.

2. Once Kroger reviews the information, if they find no issues with the current setup, they will assign an IMF which you can find on the Hierarchy Data Page under Comments:

3. As this is not a GDSN attribute, this should not be updated in Item Management currently please, but only after you are transitioned to the Kroger API process and use Item Management exclusively to add information for Kroger and no longer use Product Introduction.

Thanks!

[MARKEDWARDS]

Thank you so much for your response.

However, kroger notified us that they can't see any of the styles I resubmitted yesterday on their end and they are asking for IMF code.

In case it didn't show up, is there any other way to resubmit them?
after this problem is solved, I can setup a meeting to discuss about API.

Thank you again

[MARKEDWARDS]

Please let me know as this is an emergency and the customer is setting them up manually.

Thank you so much,

[Val_P]

Hello @MARKEDWARDS, thank you for the follow-up and we are sorry to hear about the issue encountered. We have been in contact with Kroger throughout the day and been notified that there is a lag on CICs being sent from their GLN. We hope this will be rectified very shortly and your items can be reviewed and set up as intended. Thanks!

[Val_P]

Hello @MARKEDWARDS, thank you for your time and patience while sorting this out. Kroger has returned to us advising everything has in the meantime been rectified and item information should be flowing through as intended now and over the past couple of hours. Thanks!

[MARKEDWARDS]

Thank you so much for the help.