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!