Product Documentation
Product Documentation
If you have configured your attribute order by "Category Order", you will need to update the attributes in that filter category with the desired "Order". This can be done manually, by using the attribute grid, or by import. In this documentation we will be covering how to update attribute order by import.
In order to do this, you will need to navigate to "PIM" in the operations portal.
Select "Attributes". In order to access and update “Attributes” and update data by import, you will need to be set up either as an “administrator” or a “superuser”, or have the roles of: “facetGroupView”, “facetGroupEdit”, and "importView".
Click on the "Show/Hide" icon to choose the columns you would like to add to your grid.
In order to update the attribute order by import, you will want to add the "Code", "Filter Category", and "Order" columns to your screen - along with any other columns that will be helpful. You can include other columns that you would like to export and update by importing. In this instance, we are also going to choose the "Name".
Before exporting, you can also limit the data being exported by selecting the filter category you would like to update. Since we want to update the "Type" attributes, we want to use the "Code" column to filter on "fg_type_".
Click "File".
Select the Export option. This export will have the needed header row and data that will be used for importing data back into the system when using the "Attribute" screen.
You can choose to name your export by clicking into the field and typing to update the name.
Click "Save" to save the file to your computer. If you are exporting a large amount of data, it may take a small amount of time to complete the export. The file will download and save to your computer.
You can see in this sample export that we have the header row that is needed to import data, and also the exported data from the attribute grid.
The "facetGroupCode" column contains the filter category code, ie: fg_type. We do not need to update this data with this import.
The "code" column contains the attribute code. When importing product data, the code is required as it is the identifying factor for matching information.
The "name" column contains the name of the attribute - while not required for importing, it can be a helpful reference when updating data. You can also make any needed updates to the names, and update with this import if needed. If you do not wish to update the "name" data, then just remove the column before importing - or you can add an extra character to the name header, and the column will not update with the import.
The "categoryOrder" column is for the value of the attribute order. The lowest value is "0". The lower the order value, the higher the attribute will be placed. You control the order of the attributes by entering a numerical value.
Enter the values you would like to use to update your attribute order. Once you have updated the export, be sure to save 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 update by import. If you remove data from a cell, the data imported into the system will be blank for that field on that filter category.
To import the data, click "File".
Select the import option.
Since we only want to update the attribute order at this time, choose "Update Only".
Once you click "Update Only", 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.
Once the import has finished, navigate to your commerce site, and if needed reload your page. The "Type" attributes should now be custom ordered based on the values you imported.
