If you have your inventory listed in a spreadsheet, well done – you have a head start on getting your items added to your Studio account!  

We can help you import your existing information smoothly, if you can take a little time to ensure the headings in your spreadsheet match up with the headings in your new Ronati Studio account.  

We’ve provided a template with the headings, into which you can copy and paste your information, OR you can adjust your own spreadsheet to use our field names/headings.  

Below is a list of the field names/headings, with a brief description of each. 

Before we get started, a couple of important notes:  

1. Asterisks indicate fields with dropdown lists – your entry will need to match one of the options given. (This is necessary for features like sort and filter to work.) 
2. Case. Your entries will be imported exactly as they appear on your spreadsheet, so now is a good time to fix any capitalization issues (all CAPs, all lowercase, etc.) 
3. Consistency. Your information will be taken very literally, so keep your terms and your spelling consistent to avoid multiple categorizations of the same thing.
   

Example: midcentury modern, mid-century modern, and mid century modern. If you use all three of those spellings, you will wind up with three separate categories. Then when you try to sort, filter or search for midcentury modern items, the misspelled ones won’t show up. 

There are a lot of fields below! That’s because there are many Studio features built around organizing and sharing, which requires information. Don’t worry if you don’t have all or even most of the info: the title is the only field that’s required, and you can always add more later.  

If you have questions or need assistance, please reach out to us at  studiosupport@ronati.com

Basic Details  

1. Title. A name for your item that will help you recognize it among your other inventory. Tip: Use a name you would publicly use as a title to save time when listing your items online or creating tear sheets.
   
2. SKU/Stock Number. If you leave this blank, we will generate numbers for you based on your inventory settings in Studio. 
3. *Classification. Choose one of these options: Antiquity, Antique, Vintage, Made to order, OR Newly Manufactured.
   
4. *Category. There are many! Click here to see all our categories.
   
5. Description. A long or short description of your item. 
6. Condition. A simple statement/descriptor (excellent, fair, distressed, etc.)  
7. Condition Details. Any notes on damage, restoration needed, etc. 
8. Internal notes: any information just for you, meaning it won’t appear in the item info when you create tear sheets or share the item.  
   

Dimensions 

Note that there are fields for imperial (inches/ounces) and metric (centimeters/kilograms.) Be sure to put your numbers in the correct fields, especially because of the next point.  

Please provide only a number! (No symbols or unit abbreviations.) See Additional Dimensions for an alternate option.  

1. Height, width, depth, diameter, weight, length 
2. Tables only: table knee clearance  
3. Seating only: seat depth, seat height, seat back height, seat arm height, seat leg width 
4. Lighting only: lighting cord length 
5. Bracelets only: bracelet thickness, bracelet total carat weight 
6. *Rings only: ring carat weight, ring size (enter one of the following from the below options) 

1. Additional Dimensions. For anything else you may have to add OR if you wish to enter your dimensions as one line of information, e.g. 25”H  x 25”W x 25”D 
   

Style & History  

1. Origin. Which country the item was created/imported from.  
   
2. Style. Pick from our list of provided options OR enter your style as you wish it to show. 
   
3. Maker, Brand, and Designer. If you enter the person, company, or brand who made your item, that entry will be added to a dropdown menu that will appear for all future items, so be sure to get your spelling right! (See note above on consistency.)  
4. In the style of.  Same note as maker, brand, and designer.  
5. Mark/signature. This is a free-form field for noting any identifying marks.  
6. Year made (four digits)  
7. Circa or Exact? (in reference to the year you entered)  
8. *Era. This field has a dropdown list of date ranges. Choose one of these options:

1. Period. This is a free-form field for you to enter what you wish. Your entry will be added to a dropdown menu that will appear for all future items, so be sure to keep your spelling consistent! 

Colors & Materials  

1. Primary color. The dominant color (this field is limited to one color). 
2. Additional colors. List additional colors present in your item, separated by commas. 
   
3. Primary material. The dominant material (this field is limited to one material). 
   
4. Additional materials. List additional materials, separated by commas. 

Pricing & Quantity  

1. Currency. Use the 3-letter abbreviations e.g. USD, GBP, EUR. 
2. Retail Price. Your item’s asking price in numbers and decimals only. (No currency symbols.) 
3. Trade Price. If you offer discounts to members of the trade, the price you would accept. 
4. Cost Price. What you paid to acquire the item. (Used for calculating estimated profit margins; it’s only for you to view.)  
5. Restoration Costs. For calculating estimated profit margins.  
6. Other costs. Any additional cost such as shipping or storage that should be included when calculating your estimated profit margins.  
7. Vendor/source. The shop, seller, or place you acquired the item from. 
8. Purchase Date. (MMM, DD, YYYY) Can be helpful at tax time and recognizing items that have been in stock for a while. 
9. *Individual or Set. Choose from either Individual Item OR Set.  
10. Number of Items in Set. If you indicated the item is a set in the above field, you can note the number of pieces that are in the set. 
11. Available quantity. How many times can you sell this item you are documenting? 
1. For example, if you are selling 6 chairs as a set (one sale), you would enter “1” here.  

Location & Shipping  

1. Physical location. You can create your list of item locations through your account settings, after which you can sort and organize items by location. You can leave this blank for now and apply your locations later.
   
2. Location details. Physical location, which could be as described as shelf, aisle, row, room, box number, etc., to help you track down your item.
   
3. Shipping dimensions. if different from item dimensions: height, width, depth, weight.
   
4. Shipping notes. Note anything from packing notes to a preferred shipper.  

Listed On  

Any online marketplace(s) where your item is listed for sale. If there are several, separate by a comma. See the consistency note at the start: what you enter here will become part of your dropdown list for future items. 

Images  

After your items are imported, you can upload your images in Studio, which is the simplest route.  

If you wish to include images in the import, they will need to be uploaded to either Dropbox or Google Drive, and their links added to the spreadsheet, separated by commas. This will need to be done individually for each image on each item.  

First, upload your images to either Dropbox or Google Drive, then follow the steps below.  

For Dropbox:  

1. Hover over the image and select share 
2. Click Copy link then paste the link into a new browser window or Word document 
3. From the pasted link, change www.dropbox to ‘dl.dropboxusercontent’ as shown below:
   
1. 
   
4. Copy the new link with the edited “dl” URL and paste this link into your CSV file or our CSV template.  
5. Add a comma and paste in additional photo links for the item if needed. 

For Google Drive:  

1. Select the vertical ellipsis menu icon on the far right 
2. Select Share  
3. Under General access, select Anyone with the link from the dropdown  
4. Select Copy Link 
5. Paste the link into a new browser window or word document 
6. From the pasted link, add ‘usercontent’ between ‘drive’ and ‘Google’ as shown below:
1. 
   
7. Copy the new link and paste this link into your CSV file or our CSV template.  
8. Add a comma and paste in additional photo links for the item if needed.