Skip to main content
All CollectionsEXPANDO APP GuideWorking with Products
📈 Bulk Editing of Upper and Lower Limits in Autopricer Using CSV
📈 Bulk Editing of Upper and Lower Limits in Autopricer Using CSV
Updated over 4 months ago

🔒 Values that you manually edit in the APP or via a CSV file will be locked and will no longer correspond to the global settings of the Autopricer. If you need to restore the global Autopricer limits, you must open the product details on the Autopricer page and click on "Reset to Global Limit".

Preparing the CSV File

1. File Preparation in Excel:

Start by creating an Excel spreadsheet or a Google Sheet.

2. Create a Column for SKU:

Create a column titled "SKU" and enter all the SKUs for which changes will be made.

3. Add Additional Columns for Values to be Changed:

- If you only need to change the price, create a second column titled "Price" and input the desired values for the corresponding SKUs.

- If you want to modify multiple values, such as changing prices and adding EAN codes simultaneously, create multiple columns with the appropriate titles.

4. Save as Plain Text:

Ensure that the text is saved as "Plain Text" through the "Format" option.

5. Download the file in CSV format.

6. If you are using Microsoft Excel, save the spreadsheet in the format: CSV UTF-8.


Procedure for Bulk Editing Limits

1. On the Autopricer page, click the Bulk Edit CSV button in the upper right corner.

2. Upload the prepared CSV file.

3. Map the values to the appropriate columns.


Procedure for Resetting Limits to Global Values

1. On the Autopricer page, select the marketplace for which you want to reset the limits.

2. Search for the specific product.

3. Open the product details and click on "Global %".


A CSV file for bulk editing might look like this: 👇

Did this answer your question?