Forum Discussion

_Conrad's avatar
_Conrad
Contributing User
5 years ago
Solved

Bulk import of item codes

HI,   When i try to bulk import description changes to the item codes I get the below message. Can you please advise workaround?    Error -4077: You have sales for this item.   It will not let ...
  • Steven_M's avatar
    Steven_M
    5 years ago

    Hi _Conrad 

     

    Just testing the export and import of items having the Item Description being updated as part of that import. With my AccountRight 2019.4 company file it did work as expected and updated those records.

     

    The only thing that I know that would make the item description not import would be if the field contained non-alpha-numeric characters. 

_Conrad's avatar
_Conrad
Contributing User

t  Account Right Plus AU 2019.4.0

Steven_M's avatar
Steven_M
Former Staff
5 years ago

Hi _Conrad 

 

Thank you for confirming that information

 

I've arranged for the necessary script to be run over the company file. I do recommend closing down and reopening the company file before attempting that import again.

 

Do let us know how you get on and if you require further assistance.

  • _Conrad's avatar
    _Conrad
    Contributing User
    5 years ago

    Hi, I have rerun import and there are no errors. However none of the descriptions have changed as expected? So whilst import did work, the records did not update. 

     

    I have selected "Updated existing Data" as well

    • _Conrad's avatar
      _Conrad
      Contributing User
      5 years ago

      When I import a file to include description changes, there are no changes to the item details. There are no errors upon import. Is there a bug with this feature? Are we able to change descriptions using the import function?

    • Steven_M's avatar
      Steven_M
      Former Staff
      5 years ago

      Hi _Conrad 

       

      What exactly are you updating with that import? The reason I ask this is that some clients do get confused with Item Name and Description. Item Name being the value that appears in the Profile tab of the Item whereas the Description appears in the Item Details tab>>Notes section.


      As such, if you have accidentally edited and imported the Description this would have updated the description of the item, not the Item Name. This does mean that when going to the Item Information window for that item the Item Name would not have updated whereas the Description has been updated. 

      • _Conrad's avatar
        _Conrad
        Contributing User
        5 years ago

        I am trying to update the item description (yes I am aware that this is on the Item Details tab. I have two columns, item number and item description. Once I import the file there are no errors, however no changes have been made to the item description