Product Prices By Supplier

This report shows the latest price and fixed price (if applicable) for every supplier/product combination. Prices are shown in the supplier currency. It also shows supplier SKUs and whether dropshipping is enabled. This report allows for editing of data via CSV export/import. This report cannot be customised and there are no inputs to the report. 


The following information is shown:


ProductProduct SKU
CategoryProduct category
SupplierThe name of the supplier
Supplier SKUProduct SKU as specified by the supplier
Supplier Product NameProduct Name as specified by the supplier
URLURL of the web page describing the product on the supplier's web site
Latest PriceLatest Price of the product excluding discount from the most recent purchase invoice of the supplier
Fixed PriceFixed Price of the product defined by the supplier
Drop ShipDrop shipment provided by the supplier (Yes/No)


This report allows importing/exporting product prices by the supplier via CSV.


FAQs

[back to top]


I need to see sales for a certain period - by supplier - with fixed price visible. Is this possible?

Unfortunately, the data you required cannot be viewed in a single report. We advise to utilise two reports such as Sales By Product Details (shows quantities, profit and additional financial summary for sales by product) and Product Prices by Supplier Report (shows the most recent and fixed prices from every supplier/product combination) and combine in Excel with VLOOKUP. 


Can I insert purchase prices per supplier on a price list?

If you want to add Purchase Price per Supplier on the Price List report, combine Product Prices by Supplier report to the Price List report using Excel and VLOOKUP. 


Still no answer to your question? Please do not hesitate to get in touch with DEAR support.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.