topic Re: Food And Beverage Ingredient Information in _Ask A Question for Item Management (IM)

Food And Beverage Ingredient Information

Jezebel — Wed, 23 Apr 2025 21:15:59 GMT

Sysco is asking for us to populate the following attributes for the Country of origin.

countryCode, productActivityTypeCode, productActivityRegionDescription, countrySubdivisionCode.

When I try to do this and save, I get the following error.

"If there is more than one iteration of foodAndBevIngredient, then ingredientSequence and ingredientName must not be empty.
Grape Variety Code"

What does the grape variety have to do with anything, what am I doing wrong??

Re: Food And Beverage Ingredient Information

Jezebel — Wed, 23 Apr 2025 21:17:35 GMT

I meant to say, this is a seafood item, no grapes involved, 🙂

Re: Food And Beverage Ingredient Information

Maria — Wed, 23 Apr 2025 21:40:55 GMT

Hello @Jezebel , and thanks for continuing the use of the community.

To get rid of the error, please make sure the Ingredient Place of Activity related attributes are left blank on your item:

Instead, please populate the Country of Origin Code to fulfil the retailer's request:

Thank you and please let us know if you have other questions.

Re: Food And Beverage Ingredient Information

Jezebel — Wed, 23 Apr 2025 22:06:36 GMT

Thank you. Can you advise on where I can look up the Country Of Origin Subdivision Code, as well as what they are looking for in the Product Activity Region Description.

Re: Food And Beverage Ingredient Information

George_C — Thu, 24 Apr 2025 13:47:20 GMT

Hello @Jezebel, and thank you for utilizing our customer community.

Country Of Origin Subdivision Code and Product Activity Region Description are not required attributes, you could leave them blank. If we add any info under the foodAndBevIngredient, it will prompt the Grape variety error. The correct attribute for the country of origin needed is under Processing Information > Country of Origin > Country of Origin Code. Hope it helps.

Re: Food And Beverage Ingredient Information

Jezebel — Fri, 25 Apr 2025 20:46:10 GMT

I am only doing it because Sysco has required it. Below is exactly what they specified. Do you know if those "GDSN Field" numbers correspond to something I can look up? Do you think I am doing the wrong attributes?

GDSN Field: 2776 and 2777 importClassificationTypeCode(#2776) = HARMONIZED_TARIFF_SCHEDULE_OF_THE_US and importClassificationValue (#2777).

GDSN Field: 2799 productActivityTypeCode.

GDSN Field: (2797) productActivityRegionDescription

GDSN Field: 2801 countryCode (COA).

GDSN Field: 2802 countrySubdivisionCode(COA).

Still confused about what any of this has to do with grapes, LOL

Re: Food And Beverage Ingredient Information

Val — Mon, 28 Apr 2025 12:05:12 GMT

Hello @Jezebel, it is good chatting with you again.

As long as a retailer (Sysco in this case) is asking for specific attributes, you can then use the Item attributes sets search on your item page to locate and populate your attributes as required. For example:

GDSN Field: 2799 productActivityTypeCode

GDSN Field: (2797) productActivityRegionDescription

When looking for specific attributes, feel free to also use our Item Management Participant DIctionary here: Current IM Participant Dictionary (IMPD)

Having the attribute ID will be very useful as some attributes can be similar.

Please let us know if this helped or if there is anything else we may assist with for this request. Thank you and have a lovely day and week ahead!

Re: Food And Beverage Ingredient Information

WellsDataSync — Tue, 06 May 2025 18:35:46 GMT

Hello - I am working to support these attributes to Sysco via GDSN as well. Can you tell me what is typically populated in "Country Subdivision Code"? Are they looking for the word "State" or the actually name of the state (like "Iowa")?

Thanks!

Re: Food And Beverage Ingredient Information

Jezebel — Tue, 06 May 2025 20:29:21 GMT

As far as I have been able to figure out, they want the code from the List of ISO 3166 country codes. I am using the one on Wikipedia. You can click on the country you want and then lookup the subdivision code you want. So, for Washington State, USA the code is US and the subdivision is Washington State WA, US-WA. If you are looking for outside the USA you click on the link to the subdivision code for the country you need and I have been able to find what I needed as long as I have the address of the location.

Re: Food And Beverage Ingredient Information

Val — Tue, 06 May 2025 20:34:05 GMT

Hello @WellsDataSync and thank you for continuing the use of our Community.

Can you please let us know in which section you need to populate the attribute? It has slightly different definitions for the different sections where it can be added:

In the meantime you can also check the Current IM Participant Dictionary (IMPD) for the definitions of all attributes in Item Management.

Thank you and we are looking forward to more details so that we may assist further!

Re: Food And Beverage Ingredient Information

Jezebel — Tue, 06 May 2025 21:43:09 GMT

Correction, I believe they want the number associated with the country, not the letters, lookup in the same place but for my example it is 840-WA.

Re: Food And Beverage Ingredient Information

Ginny — Fri, 16 May 2025 16:58:35 GMT

We have also been asked by Sysco to complete the same codes. We send data via HTML and when I search for Product Activity Type Code in Item Attribute Sets, I get the message

I see a section labelled Processing Information that has the Country of Origin Code but does not have a field for Product Activity Type Code.

Please advise if Country of Origin is the in correct section and what steps we as an HTML user need to take to correct if Country of Origin is in the wrong section and what steps we need to take to add the Product Activity Type Code.

Thanks,

Ginny

Re: Food And Beverage Ingredient Information

Val — Fri, 16 May 2025 18:15:14 GMT

Hello @Ginny and thank you for reaching out to our customer community. Welcome.

To locate any attribute you are looking for on your items in Item Management, we recommend downloading the Item Management Participant Dictionary (Current IM Participant Dictionary) and checking the IM Playlist Attributes sheet for the specific information you are looking to add. For Product Activity Type Code you can use Food And Beverage Products or Most Popular, for example. For more details about Playlists, you can also check this Playlists Video.

Regarding your second question, yes, the Country of Origin Code attribute from your screenshot is where you can add the country of origin details for your items.

Please let us know if this helped or if there is anything else we may assist with for this request. Thank you and have a wonderful day and weekend ahead!

Re: Food And Beverage Ingredient Information

Ginny — Tue, 20 May 2025 13:55:36 GMT

Hi Val,

When we tried to add Product Activity Type Code in the Food and Beverage Ingredients section, we received an Error / Warning status message:

XML code used:

<Flex>

<![CDATA[<flex>

<r>

<r>

<r>

<a n="foodAndBevIngredient/ingredientPlaceOfActivity/productActivityDetails/productActivityTypeCode">LAST_PROCESSING</a>

</r>

</agm>

</r>

</agm>

</r>

We do not use or plan to use ingredient sequencing.

Please advise correction to XML code to add Product Activity Type Code without having to populate ingredientSequence and ingredientNames.

Thanks,

Ginny

Re: Food And Beverage Ingredient Information

Val — Tue, 20 May 2025 14:26:39 GMT

Hello @Ginny, thank you for continuing the use of the customer community and for the follow-up. Welcome back.

Please add the attribute under the Product Activity Details section and the Item Management or XML attribute name you are looking for is productActivityDetails/productActivityTypeCode. The full GDSN XML attribute name will be placeOfItemActivityModule/placeOfProductActivity/productActivityDetails/productActivityTypeCode and the attribute GDSN ID is 2799.

Here is an example from the Item Management user interface with the value added:

I hope this helps. Thank you.

Re: Food And Beverage Ingredient Information

eburger — Fri, 30 May 2025 13:12:57 GMT

Following up here on this communication strain. I too am having issues getting these COO requirements sync'd over to Sysco. I've followed everything above and nothing. What are the specifics here please? Exactly where does everything need to go because currently, nothing is happening.

Re: Food And Beverage Ingredient Information

CommunityLord_ — Fri, 30 May 2025 15:23:03 GMT

Hello @eburger

We will need more information about what you are referring to as "COO requirements".

Please attach some screenshots with the warnings/errors that you are encountering(please make sure you're including the GTIN).

Thanks,

Re: Food And Beverage Ingredient Information

Ginny — Fri, 30 May 2025 15:49:22 GMT

Hi Val,

Thans for your instructions, I now see the Product Activity Type Code in 1WorldSync

and in the Sysco portal.

Ginny

Re: Food And Beverage Ingredient Information

Maria — Mon, 02 Jun 2025 13:13:35 GMT

Hello @Ginny!

It was a pleasure! We're here to help. Please don't hesitate to get in touch if you have any questions or run into any difficulties.

Thank you!

Re: Food And Beverage Ingredient Information

CommunityJedi22 — Mon, 02 Jun 2025 16:27:53 GMT

Hello @eburger I am following up with you after the note from my colleague below. Can you share the example information and let us know how else we can help?