Import prices for multiple model numbers
As mentioned before, you can import a file to manage prices by style code (model number) instead of the colorway code (article number), so prices for styles with different colorways can be managed easily with this feature.
Notes:
- Importing prices by model numbers can only be done if the catalog has the “Apply Price by Style” option activated.
- You can only import prices for “Editable” price groups.
- If the “External Change Management” flag is activated and at least one article is locked, you cannot import prices and the following message appears when you click the Import button:
![](http://20.71.170.41/wp-content/uploads/2021/06/UA-change-management-msg-1.jpg)
This flag and the link in the message are all managed by the Trasix Support Team.
- Depending on the catalog configuration, the number of decimals for prices is validated, so for example, you cannot enter a price with 3 decimals if the catalog is configured to 2 decimals, and an error within the Excel sheet to inform you so.
Make sure to have the prices listed in an Excel sheet with the following columns: Model Number, Price Group 1, Price Group 2 and so on as shown in the below example:
![](http://20.71.170.41/wp-content/uploads/2021/07/import-prices-by-style-template.jpg)
To import a file with prices, follow these steps:
- Click the Import button, the following window appears:
![](http://20.71.170.41/wp-content/uploads/2021/06/import-articles-window-1.jpg)
- Click Select to browse for the file you want to import,
- Select the file then click Open, the name of the file you selected appears in its field,
- Click Next, the following window appears:
![](http://20.71.170.41/wp-content/uploads/2021/07/import-price-by-style-2.jpg)
You can click Back to return to the previous window.
- Select the sheet you want from the dropdown list in case your Excel file contains more than one sheet,
- Click Next, the following window appears:
![](https://guides.trasix.one/wp-content/uploads/2022/01/prices-mapping-tab-1024x534.jpg)
- Select the column of the sheet that matches each field, you can search for the field you want using the search field, then click Next, the following window appears:
![](http://20.71.170.41/wp-content/uploads/2021/06/import-articles-window-5.jpg)
- Click the radio button next to the import method, either all rows or rows that match certain criteria, a validation window appears informing you if records are valid or not, if not, you need to fix the sheet then import the file again,
- Click Next, the following window appears:
![](http://20.71.170.41/wp-content/uploads/2021/07/import-price-by-style-4-1024x496.jpg)
The validation window shows the status of the import process, the total number of valid rows, and the total number of invalid and skipped rows. The above example shows that all the rows are valid.
- Click Next, the following window appears:
![](http://20.71.170.41/wp-content/uploads/2021/07/import-price-by-style-9-1024x457.jpg)
- Enter the reason for the price change, if you want,
- Click Submit, the progress is displayed,
- Wait until the job is finished, then refresh the page, prices are imported.
Notes:
- If any of the articles of a model number you are updating are locked and the “External Change Management” flag is not activated, change will not take effect on any of the articles with this model number, and a change request is created. For more information, refer to “Change management“.
- If changes are not reflected on the page, refresh the browser by pressing F5.
- If any of the records are invalid, you can skip them by clicking the checkbox next to Skip invalid rows as shown in the below example:
![](https://guides.trasix.one/wp-content/uploads/2021/09/skip-invalid-rows-t1-1024x565.jpg)
The Next button is activated, and you can import the valid rows.