If you use individual prices, whether purchase or sales prices, you may encounter a situation in everyday practice where these prices need to be updated in bulk.

Bulk changes can be handled via import. The easiest option for most users is importing from Excel, which allows you to update both purchase and sales prices.

But how do we obtain the source data that already exists in Flexi and that we want to update? Simply taking item codes, assigning a company along with a price in Excel, and re-uploading them to individual prices is not a valid approach for updates — it would only work for creating new prices.

When updating individual prices, we must use the ID of each record — that is, the purchase or sales prices assigned to price list items.

The easiest option for users is to connect to the web interface and perform the export directly from there.

You can navigate to individual sales prices;

or individual purchase prices;

easily using the search as shown above.

Once you are in the sales or purchase prices agenda, use the column settings to add the ID column to the view.

The result should look similar to the example below (other columns are optional depending on your needs — whether you are updating prices for a company or for a price list group).

Once all the required columns are displayed, all that remains is to export to Excel. You can do this using the services at the bottom of the page.

We can easily retrieve individual price data via the API by exporting to XLS.

This can be done using two endpoint URLs:

If you take your server address and construct a URL that matches your correct URL, you will get the required output.

Example URL for individual sales prices:

demo.flexibee.eu/c/demo/odberatel/(firma='code:ABRA').xls?limit=0

Example URL for individual purchase prices:

demo.flexibee.eu/c/demo/dodavatel/(firma='code:ABRA').xls?limit=0