Importing inventory items bulk update for inactive items

Question

Hi&nbsp;I have a client who wants to make a large number of inventory items inactive.&nbsp; We have exported the items from AccountRight.&nbsp; We have opened the TXT file in Excel and the client has put a Y next to those he wants to make inactive.&nbsp; When I import these items and select the option to update existing data, about 2000 of these items wont update as there are sales on file for these items.&nbsp;&nbsp;&nbsp;We can mark them inactive individually through MYOB by selecting that "yes we know there are sales on file, and we're ok with that" but the import file just bounces the items.&nbsp; Is there any way around this?&nbsp; I know the client is not going to be happy that he has spent a significant amount of time doing a tidy up in excel, only for about 1/4 of the items he has marked, to not update.&nbsp;help!&nbsp;Thanks

betabiz · Answer

Oh&nbsp; I now see a bunch of threads for error -4077 - which is also my problem.&nbsp;Can you run a script on my file also please?&nbsp;s/n&nbsp; 2800file ID #1file is online&nbsp;thanks

princess_r · Answer

Hi Betabiz,
&nbsp;
Thanks for reaching out.
&nbsp;
I've successfully applied the fix to your file. Before attempting to import items again, please log out and then log back in.
&nbsp;
Feel free to let me know if you need any further assistance.
&nbsp;
If my response has answered your inquiry, please click "Accept as Solution" to help other users find this information.
&nbsp;
Cheers,
Princess

cmrbs · Answer

I know this is old, but I am having this same issue with the same error code, as well as-

Error -7: Item Number may not be more than 30 characters

Warning 401: Invalid character for inactive checkbox import; status not changed to inactive.

Can I please have help rectifying this?

Thank you.

earl_hd · Answer

Hi CMRBS,The error occurs because the required format for Item Numbers when importing is 30 characters, alphanumeric. If they are longer than 30 characters or have special characters, that could be preventing the import. Additionally, you'll need to find the error in their import file.&nbsp;Please refer to our Help article -&nbsp;Import and export fields&nbsp;for more information on that topic.&nbsp;
If the issue persists, this may need further assistance on the back end. You can reach them on Live Chat via our virtual assistant at &nbsp;MOCA or by submitting a support case via &nbsp;http://myaccount.myob.com/.Regards,Earl

cmrbs · Answer

Thank you. Am I able to just fix the -4077 errors? They are the majority of the errors that come up.

Forum Discussion

Importing inventory items bulk update for inactive items

Looking for something else?

Related content

Inventory Import Problems

Inventory Report - Showing Inactive Items

Importing Item Sales with Non Inventoried Items

Imported items are shown as inactive

Importing Supplier Card File to make Status Inactive

Import costs added to inventory

Inventory

Accounts Showing as Inactive after Importing from another Company