topic Re: Export Item Report Eaches in _Ask A Question for Item Management (IM)

Export Item Report Eaches

sbrewster — Fri, 14 Apr 2023 20:32:18 GMT

Good afternoon all,

I am trying to do an export of all items published to a specific customer along with the eaches, but I can't figure out how to add the eaches to my report it seems to only export the case.

Re: Export Item Report Eaches

CommunityJedi22 — Fri, 14 Apr 2023 20:37:08 GMT

Hello, @sbrewster I took a look at your most recent export, pulled teh first GTIN and when I searched by it I see it has no Each attached to it:

Re: Export Item Report Eaches

sbrewster — Fri, 28 Apr 2023 17:30:06 GMT

Hi @CommunityJedi22 I know that one doesn't have one, but this one does:

10018195902006

are you able to take a look at this one?

Re: Export Item Report Eaches

JustinW — Fri, 28 Apr 2023 21:01:07 GMT

Hello. What information are you looking for in the export? The FS_Link tab will show a list of both the Parent and associated Child GTIN along with the quantity of the child item in the parent.

Re: Export Item Report Eaches

sbrewster — Fri, 28 Apr 2023 21:04:25 GMT

I am looking to export a list of cases and eaches in order to do a mass update rather than go into each item individually. Essentially i am trying to use the fuse tool.

Re: Export Item Report Eaches

CommunityJedi22 — Mon, 01 May 2023 13:23:04 GMT

Hello @sbrewster and thanks for the details. I went into example GTIN 10018195902006 and exported it for you. Can you check back in an hour or so in your IM Message Center to download the export and confirm you see the linked items as well?

Re: Export Item Report Eaches

sbrewster — Tue, 12 Sep 2023 20:02:25 GMT

Hello, I was never able to see this extract. However, I am running into this issue again. I am trying to do an export of items published to one of our customers, and I would like to include the links as well.

Re: Export Item Report Eaches

jcharles — Tue, 12 Sep 2023 20:21:22 GMT

Hello!

The way I would do this is first use the Publications report to see what you have published there. You can then drop those GTIN numbers into an export of items which would include the linked GTIN.

Does this sound like what you need?

Re: Export Item Report Eaches

sbrewster — Tue, 12 Sep 2023 20:23:57 GMT

I am able to gather a list, but I am unable to extract the linked items attributes, which is what I need.

Re: Export Item Report Eaches

jcharles — Tue, 12 Sep 2023 20:46:15 GMT

If you pull your list from Excel you can load a large number of items into the Item ID field. The extract should show the attributes of the items. We can also drop those into the field for an extract.

Re: Export Item Report Eaches

sbrewster — Tue, 12 Sep 2023 20:56:06 GMT

Okay, so you're saying I have to use the FS_Link tab on the file I downloaded and put those into the item ID field? there is no way to extract from this search:

Re: Export Item Report Eaches

jcharles — Wed, 13 Sep 2023 14:08:35 GMT

Hello,

Yes, you can drop those each into the Search Item ID field, and will provide an extract for those items.