Skip to main content
Answer

Import Scenario > Stock Item > Attributes

  • February 8, 2023
  • 10 replies
  • 1680 views

AndrewBGL
Pro I
Forum|alt.badge.img

Hello,

I am trying to import attributes for stock items in the fields Model # and UPC. I have not done this type of import so I need a little help.

 

I am trying to import into these two Attributes I have created.

 

Here is a screen shot of my mapping.

Attached is a .xml export of of import scenario.

 

Here is the error message I get:

One or more Attributes are not valid. An attempt to commit a bypassed row
 
Thanks

Best answer by AndrewBGL

 

Yes because you should only need one <Key: AttributeID> so the system deletes the one you are trying to add. I ran it in my demo with only one line for <Key: AttributeID> and it worked fine.
What version and build are you in? Could you send a screenshot of UPC attibute?

Hello,

Here is the UPC Attribute.

 

10 replies

riglesias
Acumatica Employee
Forum|alt.badge.img+2
  • Acumatica Employee
  • February 8, 2023

Hello @AndrewBGL ,

Can you try using the attribute’s description in the scenario mapping?
Like this:

 


If you still get an error, could you provide a screenshot showing how these attributes are setup? (Attribute type and values).

Hope this helps. 

 


AndrewBGL
Pro I
Forum|alt.badge.img
  • Author
  • Pro I
  • February 9, 2023

Hello @AndrewBGL ,

Can you try using the attribute’s description in the scenario mapping?
Like this:

 


If you still get an error, could you provide a screenshot showing how these attributes are setup? (Attribute type and values).

Hope this helps. 

 

Hello @riglesias ,

Attached is a screen shot of the attribute for Model.

 

 


AndrewBGL
Pro I
Forum|alt.badge.img
  • Author
  • Pro I
  • February 9, 2023

I was able to get the import to work, but the second attribute UPC didn't import.

Is it possible to import multiple attributes in a single import or do I need to break it into two imports.

 


riglesias
Acumatica Employee
Forum|alt.badge.img+2
  • Acumatica Employee
  • February 9, 2023

 

 

Hello @AndrewBGL 

I restored the scenario in my demo and it worked fine. I setup UPC attribute as a text attribute.
 

 

 

 

 

Is UPC attribute setup the same as MODEL (text type)?


AndrewBGL
Pro I
Forum|alt.badge.img
  • Author
  • Pro I
  • February 9, 2023

 

 

Hello @AndrewBGL 

I restored the scenario in my demo and it worked fine. I setup UPC attribute as a text attribute.
 

 

 

 

 

Is UPC attribute setup the same as MODEL (text type)?

Yes it is.


AndrewBGL
Pro I
Forum|alt.badge.img
  • Author
  • Pro I
  • February 9, 2023

Here is a screen shot of my mapping. I noticed when I try to add <Key: AttributeID> =[Answers.AttributeID] before UPC it gets deleted once I click off of it.

 


riglesias
Acumatica Employee
Forum|alt.badge.img+2
  • Acumatica Employee
  • February 9, 2023

Here is a screen shot of my mapping. I noticed when I try to add <Key: AttributeID> =[Answers.AttributeID] before UPC it gets deleted once I click off of it.

 

 

Yes because you should only need one <Key: AttributeID> so the system deletes the one you are trying to add. I ran it in my demo with only one line for <Key: AttributeID> and it worked fine.
What version and build are you in? Could you send a screenshot of UPC attibute?


AndrewBGL
Pro I
Forum|alt.badge.img
  • Author
  • Pro I
  • Answer
  • February 9, 2023

 

Yes because you should only need one <Key: AttributeID> so the system deletes the one you are trying to add. I ran it in my demo with only one line for <Key: AttributeID> and it worked fine.
What version and build are you in? Could you send a screenshot of UPC attibute?

Hello,

Here is the UPC Attribute.

 


AndrewBGL
Pro I
Forum|alt.badge.img
  • Author
  • Pro I
  • February 9, 2023

Also here is the updated .xml update


AndrewBGL
Pro I
Forum|alt.badge.img
  • Author
  • Pro I
  • February 9, 2023

Here is a screen shot of my mapping. I noticed when I try to add <Key: AttributeID> =[Answers.AttributeID] before UPC it gets deleted once I click off of it.

 

 

Yes because you should only need one <Key: AttributeID> so the system deletes the one you are trying to add. I ran it in my demo with only one line for <Key: AttributeID> and it worked fine.
What version and build are you in? Could you send a screenshot of UPC attibute?

Hello,

I force reloaded my pages and I was able to get the item updated. Thanks for your help!!!