Solved

Stock Item's Category

  • 24 April 2023
  • 9 replies
  • 168 views
B
Rank
Userlevel 4
Badge

Hi @everyone,

Is there a faster way I can update all each of my stock item’s category in Acumatica? We updated our Products directly in the Bigcommerce, a lot of them have changed their category and we want to update our Acumatica.

Not sure if this can be done through Import Scenario.

Thanks.

 

icon

Best answer by Naveen Boga 24 April 2023, 14:27

View original

9 replies

Naveen Boga
Rank
Userlevel 7
Badge +17

Hi @bernadeth58  Yes, we can update the Sales Categories using import scenarios.

Please find the Import Scenario for updating the Sales category for Stock Items below for reference.

 

 

Naveen B
Kandy Beatty
Rank
Userlevel 7
Badge +16

HI @bernadeth58 

Along with @Naveen Boga ‘s suggestion, here is an XML for that:

 

1 Attachment
Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.
B
Rank
Userlevel 4
Badge

Thank you @Naveen Boga and @kandybeatty49 :)

B
Rank
Userlevel 4
Badge

Hi @Naveen Boga , do you have idea on the error occurred while trying to import category?

 

I attached the excel file I used. 

1 Attachment
B
Rank
Userlevel 4
Badge

Hi @kandybeatty49 , did I miss something in my file? I encountered error. I attached my file here.

 

1 Attachment
B
Rank
Userlevel 4
Badge

Hi @Naveen Boga @kandybeatty49 this issue is resolved already.

Thank you.

Kandy Beatty
Rank
Userlevel 7
Badge +16

Hi @Naveen Boga @kandybeatty49 this issue is resolved already.

Thank you.

Hi @bernadeth58 

 

Can you share the fix for the Community?

Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.
B
Rank
Userlevel 4
Badge

Hi @kandybeatty49 I just changed the Category ID to Category description.

Kandy Beatty
Rank
Userlevel 7
Badge +16

Hi @kandybeatty49 I just changed the Category ID to Category description.

Nice! Thanks! 😀

Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.

Reply


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved