Ronati Importing Guide

Upload your gorgeous, one-of-a-kind pieces to Ronati; below is a guide to help you with importing your spreadsheet. If you need anything, we’ll be happy to help just, Contact Us.

Getting Started
  • You may download our Sample Spreadsheet for an example.
  • You can paste your data onto the sample sheet, or just use it as a guide to organize your spreadsheet.
  • Make sure all of your items have a category, subcategory and type that relate to Ronati categories. A full list of Ronati categories to appropriately label your pieces can be found under the categories section of this guide.
  • Make sure your tags and images columns have the data separated by commas. (Example: tag1,tag2,tag3; image1.jpg,image2.jpg). For images, you will want to list them in the order you wish for them to appear in. You may add up to (10) images and 13 tags for each item.
  • Fields that are required are noted on the sample spreadsheet. They include:
    • Title
    • Description
    • SKU or Catalog #
    • Category, Subcategory and Type
    • Style
    • Period
    • Origin
    • Maker/Brand (“unknown” is acceptable for this field)
    • Condition
    • Materials
    • Height, Width, and Depth
    • Price
    • Quantity
  • Any fields that are not marked as required are not necessary for importing your spreadsheet, but having that information for your item may be helpful when syncing your items to marketplaces.

  • Save your spreadsheet as a CSV file (comma delimited).
Image Requirements
  • You may add up to (10) images per product.
  • Images must be at least 768px and cannot exceed 1024px per image. To import your images you will need to save them in a compressed zip folder and list the individual image file names on your spreadsheet in the image column. You can find instructions on how to compress images under the “How to Save Specific File Types” section of this guide.
File types we support
  • CSV (Comma Separated Value) spreadsheets
  • Zipped image folders for images.
How to Save Specific File Types

Saving CSV files on Excel

  • Go to File > Save As.
  • If you’re using Excel 2007, click the Microsoft Office button image , and then click Save As.
  • The Save As dialog box appears
  • In the Save as type box, choose the text file format for the worksheet. For example, click CSV (Comma delimited).
  • Browse to the location where you want to save the new text file, and then click Save.

A dialog box appears, reminding you that only the current worksheet will be saved to the new file. If you are certain that the current worksheet is the one that you want to save as a text file, click OK. You can save other worksheets as separate text files by repeating this procedure for each worksheet.

A second dialog box appears, reminding you that your worksheet may contain features that are not supported by text file formats. If you are interested only in saving the worksheet data into the new text file, click Yes. If you are unsure and would like to know more about which Excel features are not supported by text file formats, click Help for more information.

For Sending Images to Zipped Folder

Windows:

  • Select the images (up to 10 per item) you would like to zip into one folder
  • Right click on the images and select “send to”
  • Select Compressed (zipped) folder
  • Right click on the new zipped folder and select, Rename. Name the folder an appropriate name so it is easily identifiable.

Mac:

  • Locate the items to zip in the Mac Finder (file system)
  • Right-click on a file, folder, or files you want to zip.
  • Select “Compress Items
  • Find the newly created .zip archive in the same directory.
  • Right-click on the zipped file and select “Rename 1 item”, name the folder something easily recognizable.
Import a Spreadsheet
  • On the top right of the Inventory Syndicator, click the Import button.

  • On the next screen, select the “Import a Spreadsheet” button

How would you like to import your inventory?

  • Click the spreadsheet upload button and browse for your CSV spreadsheet file.

    • Click the image upload button and browse for your zipped image file from your device.
    • Once your file names appear, click “Next”.

You will be directed to the mapping page to select the headers for your data.

Mapping your data to Ronati fields

The column headers from your spreadsheet will appear in the individual columns under ‘Your Column Title”. Two rows of your uploaded data will show as an example so you can be sure that you are labeling the fields correctly.

  • Use the drop down menu on the first column to select the correct data heading for the selected column. You can then click “Save” and move to the next column. For example, if your first column title is “images”, you will select “images” from the dropdown menu and continue through each column.
  • If you want to skip a column, select “Skip”, the information on your spreadsheet in that column will not be uploaded to your Ronati listing if you skip it.
  • If you accidently skipped or mislabeled a column, select “Edit” and select the appropriate header.
  • Continue until all columns have been headed.
  • Select “Next

Examples:

  • On your spreadsheet the price column is called “price point” or “cost”. When you come to that field, select “price” from the dropdown menu.
  • You have a field that does not correspond to a Ronati field such as “pattern”, select “skip” to skip that column. It will not be imported. *if you would like to incorporate details that do not correspond to a specific Ronati field, add them to your item description so your buyers can learn more about your piece.

Import Your Data

After clicking “next” on the mapping screen, you will confirm that you want to import your data. Clicking “import” will begin importing your spreadsheet. If you need to edit your column mapping you may click “back”.

Bulk Updating Existing Listings
  • On the top right of the Inventory Syndicator, click the Import button.

  • On the next screen, select the “Import a Spreadsheet” button

How would you like to import your inventory?

  • Click the spreadsheet upload button and browse for your CSV spreadsheet file.

    • If you are updating images, click the image upload button and browse for your zipped image file from your device.
    • Once your file names appear, click “Next”.

You will be directed to the mapping page to select the headers for your data.

Mapping your data to Ronati fields

The column headers from your spreadsheet will appear in the individual columns under ‘Your Column Title”. Two rows of your uploaded data will show as an example so you can be sure that you are labeling the fields correctly.

  • If the product exists on Ronati, the only required field is your SKU/Catalog # column. You may skip all other columns and only import the ones with updated information.
  • Use the drop down menu on the first column to select the correct data heading for the selected column. You can then click “Save” and move to the next column. For example, if your first column title is “images”, you will select “images” from the dropdown menu and continue through each column.
  • If you want to skip a column, select “Skip”, the information on your spreadsheet in that column will not be uploaded to your Ronati listing if you skip it.
  • If you accidently skipped or mislabeled a column, select “Edit” and select the appropriate header.
  • Continue until all columns have been headed.
  • Select “Next
  •  

Examples:

  • On your spreadsheet the price column is called “price point” or “cost”. When you come to that field, select “price” from the dropdown menu.
  • You have a field that does not correspond to a Ronati field such as “pattern”, select “skip” to skip that column. It will not be imported. *if you would like to incorporate details that do not correspond to a specific Ronati field, add them to your item description so your buyers can learn more about your piece.

Import Your Data

After clicking “next” on the mapping screen, you will confirm that you want to import your data. Clicking “import” will begin importing your spreadsheet. If you need to edit your column mapping you may click “back”.

Items not on a spreadsheet? Import from a Website

If your items are not listed on a spreadsheet but they are active on other marketplaces, let us know which of your connected marketplaces they are listed on and we can bring in the listing data for you.

  • On the top right of the Inventory Syndicator, click the Import button.

    • On the next screen, select the “From Another Website” button

How would you like to import your inventory?

You will then be redirected to a new page where you can tell us where to find your existing inventory on other websites you have connected to your eCommerce Manager.

  • Check the box(es) next to the site(s) your inventory is currently listed on. You may select multiple.
  • When you have completed, select “Import”. Please allow up to 7 business days for your Ronati Virtual Assistant to bring in your inventory.
  • If you have any questions or concerns, please Contact Us.
Ronati Categories

Ronati has a three level categorization structure, each of your items will need to be assigned a category, subcategory and type. You can expand each category below to see the available subcategories and types. See a missing category? Let us know!

(cat-subcat-type)

Periods

Below are a list of the periods available for labeling item age on Ronati. The period field is a required field on Ronati and most marketplaces.

  • 18th Century and Earlier
  • 19th Century
  • 20th Century
  • 21st Century
  • Early 20th Century
  • Mid 20th Century
  • Late 20th Century
  • 1900-1909
  • 1910-1919
  • 1920-1929
  • 1930-1939
  • 1940-1949
  • 1950-1959
  • 1960-1969
  • 1970-1979
  • 1980-1989
  • 1990-1999
  • Newly Manufactured
  • Made To Order

Request a Demo of the eCM

Questions? Call us at US +1 866 739 8343 or UK +44 (0) 8081 692399

Request a Marketplace

By submitting your information, you agree to our Terms of Use and Ronati Privacy, Cookie and GDPR Policy.