Ronati Importing Guide

• 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.

• CSV (Comma Separated Value) spreadsheets
• Zipped image folders for images.

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.

• 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”

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”.

• 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”
•  

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”.

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 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)

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