Browse
 
Tools
Rss Categories

Importing Invoices From StudioPlus's Desktop Spectra Software*

Overview

This tutorial will show you how to export your clients from StudioPlus to a CSV file and then import that file into StudioCloud.

Limitations

  • StudioPlus does not support exporting out the individual items in an invoice in a computer readable for format so the invoice will not contain the individual items in it. However, it will contain the total and balance due as well as all of the items listed below.

How to Export Invoices From StudioPlus Spectra

  • Overview
    • The following instructions will export out the invoices from StudioPlus Spectra.
  • Instructions
    • Go to the invoices section in StudioPlus
      • Instructions on exporting out the first file
        • Click the "Column Chooser" button.
        • Click the "Uncheck All" button
        • Manually select the the following rows. Pro-Tip: If you use the arrows on your keyboard and the spacebar you can quickly move between rows and select a row with the spacebar.
          • Clients - Client Number
          • Invoices - Approximate Delivery Date
          • Invoices - Custom 1
          • Invoices - Custom Date 1
          • Invoices - Date Record Posted
          • Invoices - Delivered Date
          • Invoices - Description
          • Invoices - Discount Amount
          • Invoices - Invoice Classification
          • Invoices - Invoice Date
          • Invoices - Invoice Number
          • Invoices - Invoice Status
          • Invoices - Invoice Total
          • Invoices - Invoice Type
          • Invoices - Modified Date
          • Invoices - Non-taxable Total
          • Invoices - Notify Notes
          • Invoices - Open Balance
          • Invoices - Payment Due Date
          • Invoices - Payment Total
          • Invoices - Payments Pending Total
          • Invoices - Pose Selected
          • Invoices - Posting Date
          • Invoices - Sales Representative
          • Invoices - Sales Tax Location
          • Invoices - Shipping Address City
          • Invoices - Shipping Address Country
          • Invoices - Shipping Address Line 1
          • Invoices - Shipping Address Line 2
          • Invoices - Shipping Address Name
          • Invoices - Shipping Address State
          • Invoices - Shipping Address Zip
          • Invoices - Shipping Amount
          • Invoices - Status Due Date
          • Invoices - Subtotal
          • Invoices - Tax 1 (Canadian)
          • Invoices - Tax 2 (Canadian)
          • Invoices - Tax Amount
          • Invoices - Tax Location 2 (Canadian)
          • Invoices - Tax Rate
          • Invoices - Tax Rate 2 (Canadian)
          • Invoices - Tax Total
          • Invoices - Web Order
          • Invoices - Web Order Number
        • Click the "Ok" button
        • Click the "Export To Excel Button and save the file with the name "Invoices 1.xls"
        • If StudioCloud is importing the data for you please email the file to support@studiocloud.com. If you are importing the data yourself continue on to the step below.
        • Instructions on how to convert the excel file to csv
          • Once this file has been exported open it in excel and click the "Save As" button.
          • Change the Save as type: to be CSV (Comma delimited) and save the file

How to Import Invoices from StudioPlus

Note: StudioCloud does not provide support for the import process below unless you pay for Studiocloud to import the data for you. The following blog post explains why. http://blog.studiocloud.com/2015/02/importing-data-into-studiocloud.html

  1. Open StudioCloud and log in
  2. Click on the Point of Sale icon.
  3. Click on the Options menubar
  4. Click on the Import menu item
  5. Click the "Import Invoices Directly To Cloud" menu item
  6. In the Import Invoices window do the following
  7. Select the Import Options menu
  8. Select the "Import Invoices From StudioPlus CSV Files"
  9. Find your exported StudioPlus CSV Files