Back to Website
Product Documentation Operations Portal PIM Configure PIM Product Maintenance Updating Product Information Adding Resource Files to Products by Import

Operations PIM - Adding Resource Files to Products by Import

  1. Click "PIM"

    Resource files can be added to individual products or added to multiple products by importing. You can see product resources on commerce product pages, and also in the operations portal. To view product resources in the operations portal, navigate to "PIM"

  2. Choose "Products"

    Then choose "Products". In order to access and update “Products” you will need to be set up either as an “administrator” or a “superuser”, or have the roles of: “productView” and “productEdit”.

  3. Click "more details"

    For this example, we have searched on a product code, and we would like to view the product details by clicking the more details icon.

  4. Click "Public Files"

    Product resources can be viewed in the "Public Files" tab.

  5. View Public Files

    You can view any public files added to the product on this screen. Currently, we can see that there are no files added to this product. To add files by import, you will first need to prepare a spreadsheet for importing.

  6. Header Row

    The spreadsheet will need a list of product codes you would like to update, along with the required header row and data.

  7. "code" = product code

    The "code" column contains the product code. When importing data, the code is required as it is the identifying factor for matching information.

  8. "productCode" = product code

    The "productCode" column also contains the product code. When importing data, this data is also required in order for the import to run correctly.

  9. "type" = "media"

    The "type" column contains the file type. In this case, we are adding resource files which are considered "media" files. This column is also required in order for the import to run correctly.

  10. "fileOrder" = numerical value

    If you will be adding multiple files to a product, you can control the order of the files by inputing a numerical value in the "fileOrder" column. The lowest numbered file would appear first. This column is not required for importing data.

  11. "niceName" = file name

    The "niceName" column should include the name of your files as you would like them to appear to your customers. This column is required in order for the import to run correctly.

  12. "path" = file url

    The "path" column needs to include the full URL or path to your resource file. This column is required for the import to run correctly.

  13. Example spreadsheet

    Once you have entered the data that you would like to update, save your spreadsheet as .CSV file which is spreadsheet compatible and your file is ready to import. Be sure the spreadsheet you are using only contains the data that you would like to import.

  14. Click "System"

    To import the file, navigate to "System" in the operations portal.

  15. Choose "Customer Files"

    Choose "Customer Files". In order to access and edit Customer Files, you will need to have the role of: "administrator" or "superuser", or have the roles of: "customerFileView" and "customerFileEdit" along with "importEdit and "importView". These last two roles are needed for importing.

  16. Click "File"

    Click "File".

  17. Select "Import"

    Select "Import".

  18. Choose "Create & Update"

    For this import, you will want to choose the "Product Files: Create & Update" option. Once you select the option, you will be prompted to select a file to upload. Be sure to choose the correct file to import.

  19. Import message

    Once you click the import option, you will be prompted to choose and upload a file from your computer. Choose the .CSV file you would like to import. Please be sure that you select the correct file, as there are no rollbacks for imports. An import message will appear letting you know that the import file is in process and to check back in a few minutes for the imported data. If you are importing large amounts of data, it may take a short amount of time to complete. The import will continue to run in the background.

  20. Click "Preview on website"

    To view updated products you can search on products on the commerce site - or you can click the "Preview on website" icon on products in the operations portal.

  21. Click "Resources"

    Then scroll down, and click the "Resources" tab.

  22. View the added resources

    Users can now view the added resources.

  23. View Public Files

    You can also go back to the public files screen in the operations portal and view the files that have been added to products. In this example, you can now see that files have been added.

In this article