x Want to participate? Join the group to interact
New

Thank you for adding this item to Sage City Ideas Hub.  Open for voting.

Allow spreadsheet import of Country of Origin codes from spreadsheet to update stock item records

With Brexit having arrived we now need to add country of origin codes to our invoices for customs reasons.

We have recently done bulk spreadsheet import updates of commodity codes and net weights using the stock item import spreadsheet functionality.

Unfortunately, it doesn't seem possible to bulk update country of origin codes for stock items using the spreadsheet import function.

This means we will have to manually add country of origin codes to individual stock items which will be a very time consuiming process (We have thousands of stock items).

Please make updating of country of origin code field a function of the stock item import spreadsheet.

Thanks,

Alex Boudry
Parents Comment Children
  • in reply to Dave Lithauer

    Dave, we found a workaround.are going to use one of the "Analysis fields" that you can upload to and name it "Country of origin" - then 

  • in reply to Alex Boudry
    Dave, we found a workaround. We are going to use one of the "Analysis fields" that you can upload to and name it "Country of origin". We can then pull this field into our invoices and in theory we should get country of origin on our invoices. One thing to ensure is that you key the correct country of origin codes in, as it is a free text field it will allow you to input any text. If the code is wrong it could create issues for shipments. Good luck, and I hope SAGE implement the upload of proper country of origin data into the proper field ASAP.

*Community Hub is the new name for Sage City