All Collections
Using Trustana Platform
Product Management
Batch Product Import (CSV)
Batch Product Import (CSV)

Smart Product Importing - A smooth, effortless way to onboard and update large quantities of SKUs in one go using CSV

Updated over a week ago

Flow

Considerations

Item

Details

Maximum rows

2000 rows (SKUs)

File types supported

CSV (Comma Separated Values)

Sheets to Process

First Sheet only (1 table)

Attributes Supported

Selecting from Trustana Common Attributes is encouraged.

Users may create Custom Attributes (mapping screen) in case common attributes do not have a suitable match.

Saved Mapping

1 saved mapping from the first external file template used.
Auto-mapping will cross-check column headers (labels) against Trustana Common Attributes and Saved Mapping. Unrecognized labels will be sent to Artificial Intelligence for matching assistance against Trustana Common Attributes.

Main Product Identifier

TRSKU is the main product identifier
​(important for mass update)

Product Categories

Trustana currently uses Google category values for our common attribute ""Product Category"".
​

  • ❗Mapping the user's category headers to Trustana header ""Product Category"" will result in values not imported.

  • 🆗 Users can map their category and subcategory headers to custom attributes.

Image Import Support
(Cover Photo)

1 URL per cell. Following standard image requirements.

Notes:

  • Images within cells will not be imported.

  • ❗If the product already contains a cover photo, importing a different URL under 'Product Image' header will replace the existing image.

Video Import Support

Not available.

❗Adding a video URL under 'Product Image' header will cause the row to be skipped completely.

Language Support

  • Headers need to be in English for auto-mapping

  • 🆗 Headers in other languages can be mapped manually by the user

  • Cell content can be in any language (UTF-8)

Note: products imported will be saved at master level, not under a locale, nor translated as part of the process.

Issue Resolution

Data Checks:
​

  • Attribute Type check: checking values on user's file against configured Attribute types (string, number, dropdown, price, date, barcode, date-time)

  • Duplicate check: based on TRSKU

  • Empty cell check: suggest user's to enrich data

Issues encountered may be resolved on the screen or skipped.

Variant Group Support

Products imported may be added to Variant Groups after import, from 'Product List' page.

Preparation

This tool allows you to import product information from a spreadsheet. However, there are multiple spreadsheet formats out there.

The most widely used format on batch import tools is CSV (comma-separated values).

If your spreadsheet format is XLS or XLSX

These are the typical Excel spreadsheet formats, they support multiple sheets per file and media, formulas, and graphs.

To use our tool, you would need to convert this file type to CSV.

  1. Please make sure your product information table is on the first sheet of the file.
    ​

    For Example:

    This screenshot shows multiple sheets on the same file. Only the 'Products' sheet will be imported since it is the first sheet.
    ​

  2. Once the product table is on the first sheet, then you will need to 'Save As' and select 'CSV' which stands for comma-separated values. The file extension will be (your_filename).csv, so in the example below "Sample products.csv"
    ​


    ​
    ​

  3. Save it in a folder of your choice. You may want to have the file browser application open to simply drag and drop the file when ready.
    ​

If your spreadsheet format is Google Sheets


Once you are done editing your product import file in Google Sheets, you need to download it as CSV before proceeding with the import process:

  1. Open your spreadsheet in Google Sheets.
    ​

  2. Make your your product information table is on the first Sheet.
    ​

    For Example:

    This screenshot shows multiple sheets on the same file. Only the 'Products' sheet will be imported since it is the first sheet.

    This screenshot shows multiple sheets on the same file. Only the 'Products' sheet will be imported since it is the first sheet.
    ​

  3. Click File → Download → Comma Separated Values (.csv)

The file will be downloaded to your Downloads folder (or whichever folder you have configured as the download destination) and will be ready to use.

Importing New Products

Use cases: First import or subsequent import to add new products

Make sure you have your spreadsheet with product information ready on the first Sheet of a CSV file.

On the Homepage, click on the Product tab on the navigation panel to the left, expand and click 'All products'.

This will give you an overview of the products associated with your account.

  1. On the top right corner, click on 'Import Products'.
    ​

    Screenshot 2023-08-17 at 2.51.17 PM

  2. Under 'Upload File' is a file drag-and-drop area. You may:

    1. Drag your ready-to-import CSV file from your system's File Explorer application and drop it onto the light-grey shaded area.

    2. Click on 'Browse file' to open up your system's File Explorer to find and select your ready-to-import CSV file.

    3. In case the wrong file was uploaded, you may click 'Delete' and retry.

    4. The system will reject files in a different format than CSV (Comma Separated Values).
      ​

  3. Once the file has been uploaded, click 'Next' in the top right corner.

    1. Trustana smart product importing will attempt to detect the header row on the file. When successful, a tooltip will prompt you to Confirm.
      You may also manually click on the correct row's Radio Button under column 'A'.
      ​

    2. In case the suggestion is not accurate, please select the correct row where your headers are using the matching row's Radio Button under column 'A'.
      You may dismiss the tooltip by clicking 'Choose another row'.

  4. Once the header row has been selected, click 'Next' in the top right corner.

    1. Trustana smart product importing will attempt to automatically map your header labels to Trustana headers (Attribute names)

      1. Unmatched headers will display a red lining requiring your attention
        ​

      2. Refer to Resolving Mapping Issues to learn how to clear the issues.
        ​

  5. Once mapping has been confirmed, click 'Next' in the top right corner.

  6. On the 'Address Issues' screen, you may review all your data.

    1. By default, Trustana smart product importing will analyse your data for:
      ​

      1. Wrong Data Format: This is a mismatch between the data on your CSV and the attribute type on Trustana. For example, a Barcode attribute expects only numbers. If your 'Barcode' values contain text (ie: "BA193912329") it will be flagged as an issue.

        • You may choose to skip the row, which will not import the data, by removing the checked status on the left side check box.

        • You may choose to manually edit the values by clicking on the cell and manually editing the value to reformat it, or adapt it.

        • You may also choose to ignore the issue altogether. The importer will proceed and the value will be imported, and you may fix the error after the import has been completed from the Product List page.
          ​

      2. Duplicate values: Based on Trustana TRSKU ID, duplicated rows will be highlighted.

        • You may choose to skip the row, which will not import the data, by removing the checked status on the left side check box.
          ​

      3. Missing Values:

        • By system design, smart product importing will highlight empty cells. The number of issues may be large depending on your file, however, this is merely a suggestion and does not present any type of problem to the import process.

        • You may choose to manually add the appropriate values by clicking on the cell or ignore the issue altogether.
          ​

  7. Once data issues have been addressed, click 'Next' in the top right corner.
    ​
    The system will proceed to import your file's data according to the mapping, this cannot be undone as a batch, but individual products may be deleted at a later stage.
    ​

  8. A summary will display the import result statistics.
    ​
    Click 'Done' in the top right corner to navigate back to the Product List page and review your updated product information.
    ​


​

Importing to Update Existing Products


​Use case: Subsequent import to update all or specific product attributes (headers)


This process follows the same steps as Importing New Products.
​

However, to update existing products, each product (row) within the file needs to contain its unique TRSKU ID. This is a system-generated unique identifier.

We strongly recommend downloading your product information as CSV, and updating values directly on this CSV file.
​

Alternatively, this file also contains the TRSKU IDs under a column labelled 'Product ID'. If you are using a different file, please make sure the values under Product ID are present for the correct product, so Trustana smart product importing can recognize your existing products.
​

❗IMPORTANT: Not using TRSKU ID will result in duplicated products on your account. Using the wrong TRSKU ID will update the wrong product, or create a duplicate.



Mapping fields requires attention

  1. Trustana smart product importing will attempt to automatically map your header labels to Trustana headers (Attribute names)

    1. The default value 'Product ID' will be automatically mapped to 'TR SKU ID' and use its values as unique product identifier

    2. In case your external file also has the same header, but does not contain TR SKU ID values, please change the mapping accordingly.
      ​

      1. You may create a new Attribute to store your external system's product ID.

  2. Then, continue mapping with the remaining headers to Trustana headers.

    1. In case of Header Mapping Errors, please refer to Resolving Mapping Issues to learn how to clear the issues.

Importing New and Updating Existing Products


​Use case: Subsequent import to update all or specific product attributes (headers), plus adding new products to the account.


This process follows the same steps as Importing New Products.

However:

  • To update existing products, each product (row) within the file needs to contain its unique TRSKU ID. This is a system-generated unique identifier.

  • To create and import new products, make sure the header containing TR SKU ID does not have a value for all the new product (row) you wish to import.

We strongly recommend downloading your product information as CSV, and updating values directly on this CSV file.
​

Alternatively, this file also contains the TRSKU IDs under a column labelled 'Product ID'. If you are using a different file, please make sure the values under Product ID are present for the correct product, so Trustana smart product importing can recognize your existing products.
​

❗IMPORTANT: Not using TRSKU ID will result in duplicated products on your account.


Mapping fields requires attention

  1. Trustana smart product importing will attempt to automatically map your header labels to Trustana headers (Attribute names)

    1. The default value 'Product ID' will be automatically mapped to 'TR SKU ID' and use its values as unique product identifier

    2. In case your external file also has the same header, but does not contain TR SKU ID values, please change the mapping accordingly.
      ​

      1. You may create a new Attribute to store your external system's product ID.

    3. Rows with a valid TRSKU ID will update the existing product.

    4. Rows with the header value empty will create a new product on your Trustana account.

  2. Then, continue mapping with the remaining headers to Trustana headers.

    1. In case of Header Mapping Errors, please refer to Resolving Mapping Issues to learn how to clear the issues.

Resolving Mapping Issues

  1. Click on 'Select header', and proceed to find the appropriate match from Trustana's Common Attributes. You may type to shortlist dropdown options containing your text.
    ​
    ​Click on the dropdown option that best matches your header.

    • If a suitable Attribute is not found, you may also create a new attribute directly from this screen.
      Click on '+ Add new custom price' or '+ Add new attribute' for any other data type (text, number, dropdown, date)
      ​

    • Enter the Attribute Name, an internal description (optional) and the Attribute Type, and click 'Save'

    • Once created, find your new attribute using the search function and click on it to select it as a mapped header.
      ​

  2. You may choose to skip a header in case the information in this column is not relevant.
    ​For example, a header with the same value across all rows, or an external system-generated value like 'Update date'.
    ​

  3. On the right side, a navigation panel highlighting mapping issues is available for easier navigation.
    ​


    ​

    1. Click 'Go to error' as a shortcut and repeat steps on 4.ii
      ​

    2. Alternatively, click on 'Skip error' to skip importing the header and its related data.
      ​
      ​


      ​IMPORTANT: Skipping a header will remove the checkbox selection on the right, and flag the status icon with a yellow indicator. Any data under this column/header on your file will not be imported.


​

Did this answer your question?