Skip to main content

Data Import System

Import inventory into consignR from a CSV file, review suggested matches, and confirm what gets added to your store.

Before You Get Started

Prepare your inventory as a CSV file. Native Excel files (.XLSX or .XLS) aren’t supported. If your inventory is in Excel or Google Sheets, export it as CSV UTF-8 before uploading.

Files can be up to 100 MB, and one import supports up to 25,000 rows. Split larger files into separate imports.

Only admins and managers can access imports. Only admins can create new store locations.

1. Starting your import

Open Inventory and click Import in the top right.

You can also access imports in Settings, under the Data tab click on Imports.

Press New Import and upload your Items CSV and, if needed, a Sellers CSV. If you upload separate Items and Sellers files, you'll have to select the column in each file that connects an item to its seller, such as a seller ID or email address.

Once consignR finishes reading a file, you’ll see its row and column counts. Choose each file's role from the drop-down menu on the right.

2. Review your columns

ConsignR automatically suggests matches between your file’s columns and consignR fields, such as product titles and brands.

The To do section at the top of the page highlights questions that need your input. Select Decide beside a question to review your options.

Depending on your file, these questions may include:

  • Which rows are one product? Choose how rows should be grouped into products.

  • How should rows with no owner be treated? Choose what happens to items without ownership information.

  • Is commission your store’s share or the seller’s share? Clarify what the numbers in your file represent.

You’ll be directed to the Needs a decision tab to review columns that require your input. Confirm or change the suggested matches, and answer any related questions in the To do section above.

You can switch to All columns to review every column or Not imported to check which columns are excluded. The number beside each tab shows how many columns it contains.

Tips:

  • Yellow flags information to review, but a manual decision isn’t always required.

  • Red means a decision or correction is needed for the affected data to import. Read the message beside each indicator for details.

  • The markers beside values help explain where changes came from

    • Hollow dot: An automatic match made by consignR.

    • Filled dot: A change you made.

    • Purple sparkle: A suggestion from consignR AI.

3. Review statuses and sales channels

In Settings, choose how statuses from your file should translate into consignR statuses.

Select a default status for rows with a blank status. If a status value remains undecided, its affected rows cannot import.

Next review the Sales Channel switches. Channels start off so make sure to turn on the channels you want to use for the imported items.

Sales channel selections apply in bulk to the items in this import. If you’d prefer to decide later, leave all channels off and continue. Your items will import without being listed on a sales channel, and you can assign channels per product or item afterward.

4. Manage Users

In Users, review the sellers identified from your mapped ownership information.

For each seller, you can match them to an existing user, choose to create a new seller, or assign their items to your store. Use Needs a decision to find unresolved matches.

If rows have no owner, choose how they should be handled. consignR does not choose an owner for you.

New sellers selected during review are added when you confirm the import.

5. Assign Locations

In Locations, review where your items will be stored.

A Store Location is a physical site, such as a shop or warehouse. A location is a spot inside it, such as a bin or shelf.

Match the values in your file to existing locations or choose to create them. If you create a new store location, complete the required address and phone information.

Rows without a location can use the selected store location’s Default location. If the required store location remains undecided, the affected rows cannot import.

Tip: New store locations save immediately, even before you confirm the inventory import.

6. Review Templates and Products

In Templates, review the template matches and suggestions, then choose the template that fits each product.

You can also edit the templates, including their options and values, such as size and condition. Available options vary by template, so check the item values after choosing one.

This is where you prepare your templates. You’ll apply them to products in the next section, Products.

In Products, review shared information, including product titles, templates, and grouping. Choose a template using the dropdown arrow in the Template column, click a suggestion to apply it to that product, or select Accept all suggestions to apply suggestions in bulk.

Use search, filters, and sorting to find products. Select Columns to choose which fields are visible, or Full screen for more room to review. You can also select multiple rows at once to make changes together.

7. Review Individual Items

In Items, review row-level details such as ownership, location, price, quantity, and option values.

Use Needs a fix to find rows that require attention. Search, filters, sorting, and bulk actions can help you work through larger imports.

If an item’s value isn’t included in its assigned template such as a missing size, you can add the value where available, choose an existing value, or accept a suitable AI suggestion.

Review suggestions individually or use Accept all suggestions to apply them in bulk. Review any remaining flags afterward.

Check Ready and the items that need a fix before continuing. Unresolved rows may be left out when you confirm the import.

If you don’t want to import an item, open the three-dot menu on its row and select Leave out. You can review excluded rows under Left out.

8. Confirm Your Import

Review the confirmation to check how many rows are ready and what will be left out.

You can import ready rows while leaving unresolved rows out. At least one row must be ready, and consignR must finish checking your changes before you can begin.

Confirm the import to add the ready inventory items and selected new sellers.

9. The Results

When the import finishes, review the totals for imported items, new products, new sellers, and rows left out.

Select View items or View products to open inventory associated with the import. You can return to its results later from Imports in Settings.

If unresolved or failed rows are available to download, select Download rows, correct them, and start a new import.

Final Tips:

  • Use the available Undo control to reverse a change while reviewing your import.

  • Select Full screen for more room to review and edit your data.

  • Select the question mark (?) icon where available for guidance about the section you’re reviewing.

Did this answer your question?