Formatting your inventory import spreadsheet

lennartlennart Posts: 1Moderator, Lightspeed Staff moderator
Hey everyone,

What do you think of our documentation on how to format your Inventory Import List?

Do you feel like everything is explained clearly enough?

And what can we do to improve this process and make it as easy as possible?

You can find our help pages for this topic on the following links:

Thank you in advance for your feedback!
Lennart Van den Bossche
Import Specialist
Support Specialist

Lightspeed HQ


  • MOSCMOSC Posts: 10Member
    Hi Lennart,

    While I appreciate the CSV import function and use it frequently, I do have a suggestion to address your question, "And what can we do to improve this process and make it as easy as possible?"

    I recommend standardizing the column headers we get from a product EXPORT table (for example "Manufact. SKU") with the headers we must use in columns for a product IMPORT table (using the same example, "Manufacturer SKU").

    If the field in the column has the same meaning and significance in both cases, then the column header should be the same, whether in an export or an import. 

    Forcing the user to adjust a column header to send a table back to the system it came from is an unnecessary hassle and makes LS development look inconsistent and a bit unprofessional.


  • 2943milstid2943milstid Posts: 2Member

    Is there a way to import "live" inventory data thru Googlesheets from Vendors?

  • sethpsethp Posts: 1Member

    I00% agree with MOSC. It would be great if I could download Inventory data Make some edits and Upload the fixed file. It is really hard to make edits to a large number of products at once if you go through the GUI. Just let me make whatever edits I want in the import

Sign In or Register to comment.