Bulk upload lists for set up

Bulk upload lists for set up

Bulk Upload is a simple and fast way of uploading information to your Lightyear account. You can make use of Bulk Upload in the following areas of Lightyear:
  • Accounting Software (For Adept, MYOB Desktop, Pronto, Sage and Sun Systems)
    • Supplier Cards
    • GL Codes
    • Tax Rates
    • Tracking Categories
  • Inventory Supplier Cards
  • Product List
Uploads are done through a basic CSV file, which can be generated using practically any spreadsheet application.

Using Bulk Upload

Note that the process for uploading to a Price List is slightly different. See this Price Checker article.

Head into any of the above sections of the app, and you'll now see the following option

This example, as you can imagine, is taken from the Product List, but it will be similar for all other areas. Here you'll see a description of what can be uploaded, and what columns are needed within the CSV file to be uploaded. When creating your CSV, pay attention to what columns are required as the upload will fail if Lightyear detects too many or two few columns.

Once you have your CSV populated with the data you want to upload, select the Choose File button, locate the file on your computer and select Upload.

After selecting Upload, you'll be asked if your CSV contains a Header Row, so just select Yes or No as appropriate. If the top row of your CSV is populated with (as an example) Product Code,  Product Description and Unit Price in the first 3 cells, instead of actual product data, then this would be a header row.

You'll then be asked to select the format of your CSV. Some areas of the app allow you to upload data in different formats, so select the correct one for your CSV. After hitting confirm, the upload will begin and within a few seconds, your lovely data will be imported to your Lightyear account.


    Check out release notes for Q2 2021

      • Related Articles

      • Price Checker

        This is a step-by-step guide to setting up Price Lists in Lightyear to enable the Price Checker feature. The Price Checker notifies you when a supplier's on-invoice price differs from the loaded agreed price. Using Price Checker What is it? One of ...
      • Step 2: Set your default tax rates

        Set Default Tax Rates Now you've connected your accounting software, here's a quick but significant step - make sure you don't skip this one! Your preferred settings here will save you a lot of time later from coding each line item individually on ...
      • Inventory Tab

        Inventory Tab Lightyear allows you to send data to external Inventory, Point of Sale or ERP systems.  It does this by adding an inventory tab and providing you with the “Add to Inventory” button in Panel 2. The inventory tab will not be visible when ...
      • Step 8: Tell your Suppliers what to do

        FOR VENUE/STORES/DEPARTMENTS Once your staff have been brought up to speed to the changes re Lightyear, you should now start asking your suppliers to email your bills to your @lightyear.cloud account. No-one particularly likes change, but from the ...
      • Step 3: Send a document into Lightyear

        Here, we'll take you through how to get your first bills into Lightyear and then what to do with them. Use the table of contents above to skip ahead to the section you need. Alternatively, you can watch this video: Get your first bill in from ...