Extract Product Data to Excel

API Queries
1

We use Excel to produce a custom quote (normally about 300 lines).

We create 5 to 10 bespoke quotes per day.

I need a way of automating the download of product information into a spreadsheet, then we can manipulate the data from there.

How can I export the products to a spreadsheet every time we open it at the push of a button.

I’m currently exporting the data via the csv route, but where prices change, I need data which is more live than this route as prices change hourly.

I only need sku, product name, retail price

TIA

2

Hello @ItsOnlyNeil

When it comes to extract data we currently support 2 different ways:

  1. The one you mention through csv which is more manual and as you mentioned, which is part of the limitation we currently have with csv.

  2. For the Veeqo API you can obtain this data as JSON format, for this you would need the ID of the product which can be found on the UI, on the url.

For this please find more information here:

Please let us know if there is any other question.

Regards.