How do I upload my inventory from a spreadsheet?

At the top right of the eCommerce Manager, click the “Import” button.

Then, select “Import from Spreadsheet.”

Click the “Spreadsheet Upload” button and select the spreadsheet file from your device.

Click the “Image Upload” button and select your zipped image file.

Once your file names appears,  you can select the SKU or catalog # column from the list of spreadsheet headers.

Then, click “Start an Import”.

Once redirected to the mapping page, you can select the headers for your data.

Mapping your data to Ronati

The column headers appear in your spreadsheet. Two rows of your uploaded data appear as an example so that you can check that the labeling is correct.

Use the drop-down menu in the first column to select the relevant data header. Click “Save” and move to the next column.

Examples:

On your spreadsheet, the price column is called “price point” or “cost”. On that field, select “price” from the drop-down menu.

If you have a field, such as “refurbishing cost”, that does not exist in the drop-down menu, select “skip” to skip that column. It will not be imported.

*If you would like to add details that do not correspond to a Ronati field, you can include them in your item description.

If you want to skip a column from your spreadsheet, select “Skip.” The information from that column will not be uploaded to your Ronati listing.

If you accidentally skip or mislabel a column, click “Edit” and select the appropriate header.

Continue until all columns have been headed.

If you need to start over or upload a new spreadsheet, you can select “Start Over”.

When you are ready to import, select “Next.”

On the following page, click “Import”. You are redirected to your listings page, where you can see all of your products.

Error Page - If your spreadsheet contains errors

If your spreadsheet file contains any errors, you are redirected to a live, editable spreadsheet page.

This page features only the rows of your spreadsheet that contain errors. All other items on the sheet are successfully imported.

Each field that contains an error is highlighted in red for you to edit.

If you wish to delete an item, click the “delete” button on that row, or, if you would like to delete all rows select “discard all”

Select “Import” to finish adding the items to your inventory. When finished, you are redirected to your listing dashboard.

If you wish to stop editing and return later, simply navigate away from the page and Ronati will save your changes. A light red banner at the top of the dashboard sends you back to edit your draft.

Other resources:  Importing Guide