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, Attache, MYOB Desktop, Pronto, Sage and Sun Systems)
    • Supplier Cards
    • GL Codes
    • Tax Rates
    • Tracking Categories
  • Inventory Supplier Cards
  • Product List
  • Suppliers - full information can be found here.
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 our
    to stay up to date

      • Related Articles

      • Uploading Products - Products Catalog and Price Checker

        This is a step-by-step guide to uploading Products in Lightyear. There's a multitude of benefits in doing so. You can use this as part of the initial supplier set up to automate line item coding, create your Product Catalogue in PO's so items can ...
      • Bulk Supplier Upload

        Similar to how the Product List, GL Code, Supplier Cards, etc. bulk upload works, users can use a CSV to quickly create all Suppliers within Lightyear. The CSV needs to follow a specified layout, as some columns are required, and others need to ...
      • 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 (or if you wanted, a simple spreadsheet). It does this by adding an inventory tab and providing you with the “Add to Inventory” button in Panel 2. The ...
      • Setting Supplier Card Country Codes

        In Supplier Cards, Lightyear can import the Country Codes from your Accountancy Software. There are instances where some Accountancy Software don't store the Country Code, or the Country Code they store is different from Lightyear, e.g. GBR vs GB, ...