Skip to main content

Import products

Import up to 500 products at once via spreadsheet.

Samantha Schurr avatar
Written by Samantha Schurr
Updated this week

This article is specifically about Rheaply’s inventory management app (root.rheaply.com) and may not be relevant if your organization is not using that functionality.

Use a CSV template to add up to 500 products and one item variant per product, all at once. Perfect for an initial product upload or a warehouse that may have limited wifi.

If you already have your inventory organized in a spreadsheet or need to create one while offline, you can save time by importing products to Rheaply in bulk. This workflow allows you to import up to 500 products at once, each with a single item variant. You can add more items after importing.

Tip: Collaborating with others on your import? Make sure everyone reads the field instructions, which are included in the first row of the template.


This article is helpful if:

  • You have a spreadsheet with NEW products that you need to add to your inventory.

  • You need a way to do offline inventorying (either due to poor internet/wifi or you’re using a third-party fixed asset auditor).

Important:

  • Title and Category are required fields to import.

  • To add images via URL, links must be publicly accessible.

  • Import is only for new products, not editing existing ones.

  • Your progress will be saved in your browser (until your cache is cleared).

Who can do this?

Viewer

Creator

Editor

Admin

Global Admin

Import products

Where is it done?

Click the plus (+) icon in the top right, then click Import products


Import products

  1. Click the + icon and select Import products

  2. Open the template

  3. Add your product data or copy it in from another spreadsheet

  4. Use the tips in the first row to format data correctly

    1. Optional: For each product, include one item variant—more can be added later. At the end of the template you’ll see item fields for status, quantity, and condition which you can include in your import. Once you upload your CSV you will be able to include the required location field as well (not importable).

  5. Save your sheet as a .CSV

  6. Return to the platform and upload the file

  7. Correct any errors flagged in the review step

  8. Use Bulk actions to edit data if needed

  9. Click Submit to create your products and items

Tip: Use a tag like MMDDYY Initials to track your imports. After import, search that tag to quickly find and edit the products.


Note on importing item variants

If you have 100 identical chairs in two locations (30 in A, 70 in B), upload all 100 as one variant. After the import, bulk-edit 30 to update their location.


Including photos

You can add photos to your product import by pasting public image URLs in the “Images/Photos” column. Learn how to generate public URLs for your images: https://support.rheaply.com/en/articles/11593271-create-public-photo-urls-for-product-imports.

If you can’t use public URLs, contact support by emailing help@rheaply.com.


Field definitions

Product title *

Add a title for your product, something easily recognizable by your team. Include the brand and any identifiable features.

Example: "Herman Miller Aeron Chair Black"

Category *

Select the appropriate category for the product from the dropdown.

Category will be required in order to create products, but is not required for the upload.

Images

If you have an image URL, you can paste it here.

The URL needs to be publicly accessible (this means no private images, Google Drive URLs etc.).

If you have images directly in your spreadsheet or are unable to provide a link please reach out to help@rheaply.com and we can help get your photos uploaded.

Description

Add an overall description of the product. Include information like SKU # or Quote #.

Example: "Wooden table top for conference room."

Manufacturer

Select one option using the dropdown below.

Example: "Herman Miller"

Replacement cost

Enter an estimate of the cost to replace this item with an equivalent new item available on the market today.

Example: "$500"

Weight

Enter a positive numerical value. If no unit is selected, pounds will be used by default.

Example: "45"

Weight unit

Select an option using the dropdown below. Pounds will be used by default if a value has been entered in the cell to the left.

Example: "Kilograms"

Length

Enter a positive numerical value. If no unit is selected, inches will be used by default.

Example: "51"

Length unit

Select one option using the dropdown below. Inches will be used by default if a value has been entered in the cell to the left.

Example: "Feet"

Width

Enter a positive numerical value. If no unit is selected, inches will be used by default.

Example: "48"

Width unit

Select one option using the dropdown below. Inches will be used by default if a value has been entered in the cell to the left.

Example: "Yards"

Height

Enter a positive numerical value. If no unit is selected, inches will be used by default.

Example: "30"

Height unit

Select an option using the dropdown below. Inches will be used by default if a value has been entered in the cell to the left.

Example: "Meters"

Materials

Select one or many options from the attribute list. Separate each material with a comma.

Example: "Wood, Metal"

Colors

Select one or many options from the attribute list. Separate each color with a comma.

Example: "Green, Blue"

Fabrics

Select one or many options from the attribute list. Separate each fabric with a comma.

Example: "Leather, Cotton"

Finishes

Select one or many options from the attribute list. Separate each finish with a comma.

Example: "Coated, Natural"

Uses

Select one or many options from the attribute list. Separate each use with a comma.

Example: "Conference room, Lobby"

Product areas

Select one or many options from the attribute list. Separate each product area with a comma.

Example: "Childcare, Labs"

Tags

Type the tags you want to attach to the product. Separate each tag with a comma.

Example: "New cafe, For decommission"

Performance

Select an option using the dropdown below.

Example: "High"

Warranty length

Enter a positive numerical value. If no unit is selected, years will be used by default.

Example: "12"

Warranty length unit

Select an option using the dropdown below. Years will be used by default if a value has been entered in the cell to the left.

Example: "Months"

Count per item

If your product is often packaged with more than one object, specify the count of those objects. Leave this field blank if unknown.

Example: A box of 100 nails has "100" count per item

Note

Additional information, recommendations, care instructions, etc.

Example: "Suitable for big and tall individuals. Spot clean only."

Did this answer your question?