Item Class Attributes - generic inquiry

AMAZING!!

Thank you @manikantad18 !

@manikantad18 , I have a followup question for you (I see that you have provided a lot of helpful information around attributes and imports :) ).

My ultimate goal with this inquiry is to make changes or delete the Attributes on the Item Classes with an import scenario.

I have a customer with 630 item classes and each one has up to 10 attributes on it.

I have been successful adding the attributes with an import scenario, but have not been successful with updating or deleting the Attributes from the Item class with an import scenario.

Do you have any suggestions or examples for updating and deleting?

Thank you!

Hi @donnadeskins55 I have sample Import scenario to Update the attribute in Items class. Please modify as needed

Thank you @manikantad18 !

I think I saw this example on another post and when I tried it, it behaves like it want’s to add a new ItemClass/Attribute rather than update it.

Here is what the Import looks like (I’m attempting to set the status to inactive so that I can delete a particular attribute):

 and this is the error I get when trying to run it:

@donnadeskins55 Hello, these errors may be linked to the fields in the data provider. I suggest checking the source fields for the data provider to see if the fields mentioned in the error message are marked as active. If they are, include the missing fields in the import scenario, or mark them as inactive if you decide you do not need them in the import scenario. I hope this helps with troubleshooting the error.

Hi @manikantad18 .

I have tried to follow the Get Item Class html file but am missing something.  Your guidance would be greatly appreciated.

I must be missing a table or a relations between tables or both.

@RoslynRule you probably don’t need this anymore, but since I just landed here looking for an answer, it is

itemClassID Equals entityClassID

CSAttributeGroup.EntityType  Equals ='PX.Objects.IN.InventoryItem'

@bmonaghan thank you that fixed my problem.

I am attempting to query a list of Stock Items that have a particular Attribute available to populate.  For example, I want to query all Stock Items that have the REVIC attribute available to them by virtue of the REVIC attribute being attached to certain Item Classes.  Below is ​@Manikanta Dhulipudi ‘s ‘Get Item Class’ GI which works wonderfully to see which Item Classes a particular Attribute is tied to.

However, I cannot figure out how to make the links work.  I cannot figure out how to use the ‘Get Item Class’ GI as a source in another GI.  When I attempt linking on ItemClassID, I get a ‘multi-part identifier could not be bound’ error message.

Any suggestions?

FYI, I renamed ‘Get Item Class’ GI to ‘Attributes by Item Class’, as shown in the screenshot below.

Item Class’ GI as a source in another GI.  When I attempt linking on ItemClassID, I get a ‘multi-part identifier could not be bound’ error message.

Any suggestions?

FYI, I renamed ‘Get Item Class’ GI to ‘Attributes by Item Class’, as shown in the screenshot below.

 

 

​@danielklumpp 

When I attempt the same thing, I get a slightly different capitalization on the Child Field.

GI attached, but you’ll need to change the Conditions tab to an attribute that exists for you.