💡 Sometimes you may need to change the selling/purchasing prices or add barcodes to products that are missing in your .xml source. Below, you'll find a guide on how to do it.
Bulk Editing Using a CSV File
1. Preparing the File in Excel:
Start by creating an Excel spreadsheet or a Google Sheet.
Create one column titled "SKU" and enter all the SKUs for which changes will be made.
Next, create additional columns based on the values you wish to modify. If you only need to change the price, simply 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.
Ensure that the text is saved as "Plain Text" through the "Format" option.
Download the file in CSV format.
If you are using Microsoft Excel, save the spreadsheet in the format: CSV UTF-8.
2. Uploading the File in EXPANDO APP
Click on the Products section:
In the top menu, select the Marketplace that this applies to, such as Alza.
Click on "Bulk Edit (CSV)":
Drag and drop or upload the prepared file.
Map each column, such as SKU, Price, Stock, EAN, etc., so that the EXPANDO APP can recognize which column contains each specific value.
Confirm the upload. The EXPANDO APP will notify you of how many products were successfully updated according to the CSV file.
Manual Editing of Individual Products
Click on Products.
Select the marketplace where you want to edit the product, such as Alza.
Search for the product you want to modify.
Click on the product name.
Edit the value and save the change.
ℹ️ If you are using Shoptet, follow the guide for preparing a .csv file. ⬇️
The file may look something like this, for example: