Forum Discussion

Experienced Cover User

2 years ago

Importing Items is doubling up and not updating exisiting items

I've been trying to import items and i want it to update the information i'm importing but it keeps saying it's imported with warnings but it duplicates the informtion. I'm wondering how MYOB kn...

Genreve_S

MYOB Moderator

Hi HDG,

Thanks for reaching out.

Thanks for reaching out. It is as gavin12345 has mentioned the changes would be connected to the item number only. If the item number of the item we are trying to update is different from the upload file then it would create new items. Also, import errors have codes that will point us to what we need to alter in the file to avoid it.

May I ask for the import error or screenshot of the error.

Feel free to let us know if you require any further assistance.

Cheers,

Genreve

HDG

Experienced Cover User

2 years ago

The errors are different each time i import the same file.

also how can you just import a file without all the blank spaces?

gavin12345
Ultimate User
2 years ago
Hi HDG

I suggest you spend some time reading Importing and Exporting from the Support Centre to ensure you are correctly preparing your import file. If after following the support article, errors continue, attach to the post the import file as well as the importlog.txt report. Someone might then be able to provide guidance.

Regards
Gavin
- HDG
  Experienced Cover User
  2 years ago
  I've realised there's another problem it will only allow 30 characters for an item description which is ludicrous. There's no way we can shorten a suppliers description of their items, why would it be only 30 characters? We have thousands of items and there's no way we are going through them individually to shorten them. So MYOB has truncated it now it makes no sense. It's enough we have to change the item number to fit 30 characters.
  
  CAVEVO90820P DBL CAV EVOLUTION FLUSH PULL 2040X820X90 DBL
  changed to
  CAVEVO90820P DBL CAV EVOLUTION FLUSH PULL 2040X
  - Celia_B
    MYOB Staff
    2 years ago
    Hi HDG,
    
    Thank you for your post and welcome to the Community Forum.
    
    In this matter, currently, MYOB does not allow you to increase the item character limit, this is how our software works now. I understand that this issue makes you upset and we do apologize for the inconvenience it has caused you. We recommend using the description field as it allows up to 255 characters.
    
    If you need further assistance, please feel free to post again and one of us will assist you.
    
    If my response has answered your enquiry, please click "Accept as Solution" to assist other users find this information.
    
    Best Regards,
    
    Cel