I'm having issues uploading excel files to the items list.

  • 1
  • Question
  • Updated 1 year ago
  • Answered
No errors in the data - I've only changed the description, cost and item name of a number of products yet they do not update in the items list when it is re-uploaded. Have tried .csv and various excel file formats. Any ideas?
Photo of Blair Wickham

Blair Wickham

  • 80 Points 75 badge 2x thumb
  • frustrated

Posted 1 year ago

  • 1
Photo of Kevin Russell

Kevin Russell, Accredited Partner

  • 35,092 Points 20k badge 2x thumb
Have you looked at the qbwin.log file?
Photo of Blair Wickham

Blair Wickham

  • 80 Points 75 badge 2x thumb
Hi Kevin - no, can you please tell me how to find that?
Photo of Gillian

Gillian, Accredited Partner

  • 690 Points 500 badge 2x thumb

Hi Blair,

you cannot change an item name - this is the constant that Reckon needs, A change to the name will want to create a new item. Also if the items you are trying to import are inventory items you MUST include the type - Inventory Part.

see how that goes

In fact you need the type column to be part of the import - so make sure you get that right for YOUR item type otherwise new items will be created.

Remember to backup before importing!!

Gillian

(Edited)