Jump to content

Importing Items


PaisleyPosey

Recommended Posts

  • 10 months later...

I have imported bank statements via a CSV but had a few problems when trying to match the fields, however I managed to sort it.

Now I am trying to import an item list from a supplier using a CSV I created by copying the field headings exactly and copy/pasting data from a spreadsheet the supplier sent me. When I try to import it and am asked to match the headings, there are no options to choose from the headings from the CSV file!!! All it says is 'Click to assign' but clicking does nothing!!! HELP PLEASE?!

Link to comment
Share on other sites

  • 3 weeks later...

I had this problem too. If you are using Excel, make sure there is only one tab in the workbook. When I deleted the blank tabs the 'Click to assign' values worked. Also, if you name the columns the same as the suggested columns it matches them for you automatically.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...