Data Import

Import your Inventory into ArtCloud

Too much inventory to add one at a time? No problem, you can also import your inventory data from a spreadsheet!

Sometimes it makes sense to add inventory one item at a time, but if you're new to ArtCloud, you may want to import your inventory through a CSV upload. You also have the option to migrate your data from another system.

ArtCloud's Inventory import template

At ArtCloud, we use .csv files (Comma Separated Value - these are typically opened by spreadsheet editors like Microsoft Excel, Numbers for Mac, or Calc by LibreOffice) to import inventory, contacts, and invoices. In ArtCloud's importer, column titles determine where the data in that column will be assigned when it is imported. For example, if you'd like to designate a column of your CSV to populate a field that shows the date that you purchased or acquired an inventory item, you would change whatever column title in your CSV you would like to represent that data (perhaps in your system, it is called purchase_date) into acquisition_date. This article will go more into depth on this later, but for now, if you'd like to know what columns ArtCloud uses, you can download our pre-made Inventory Import Template to make importing to ArtCloud easier by navigating to your Settings and clicking on the Imports tab.

Screen Shot 2021-03-16 at 7.20.42 PM

NOTE: To learn how to use our Inventory Import Template, follow this helpful article.

How do I import inventory data?

To import your data, head over the Inventory tab and hit the Import button.

Screen Shot 2021-03-16 at 7.22.40 PM

From there, select New Import.

Screen Shot 2021-03-16 at 6.58.09 PM

Next, choose to import a CSV (Comma Separated Values, or a spreadsheet document).
Screen Shot 2021-03-16 at 7.13.52 PM

Then select the Inventory option.

Screen Shot 2021-03-16 at 7.20.13 PM

You'll then be prompted to pick a CSV file to import. You can either click on the large button with the arrow, or drag a file into the button.

Screen Shot 2021-03-16 at 7.25.15 PM

Next, you'll be taken to our Match Columns screen. As stated earlier, in ArtCloud, we have a list of fields that ArtCloud is able to accept as data. For example, if you'd like to designate a column of your CSV to populate a field that shows the date that you purchased or acquired an inventory item, you would scroll down to the acquisition_date field and match whatever column title in your CSV you would like to represent that data (perhaps in your system, it is called purchase_date). 

NOTE: Each custom field can only be assigned to an ArtCloud label once.

arrow_newInventory6

Unmatched columns (columns that either do not exist in your document or have not been assigned) are at the top of your page...

arrow_newInventory7

...while automatically matched columns (columns whose names happen to match the names of ArtCloud's field names) are at the bottom. Check these thoroughly before importing.

How do I import artwork images?

For new customers, ArtCloud's migration team will help you import your images. Once you've uploaded your .CSV file, contact support@artcld.com for next steps. Please note this service is only available for paying, active subscriptions. Only the first image import is complimentary; additional imports can be done for a fee. Contact us to get a quote.

Suggested Readings