Organic food and health retailer leverages APISpark for price list injection in ERP
Grön Gåva collects price lists from their suppliers from Excel spreadsheets. But manually entering and updating prices in the ERP system is very time-consuming, and not a very interesting job.
To improve the process, Grön Gåva imports Excel spreadsheets in Google Sheets, so that the data can be massaged, normalized and cleaned, thanks to App Script.
Then, thanks to APISpark, all that data is exposed through a RESTful Web API that can be consumed by other processes down the automation chain.
The ERP system is able to correlate the new data from the APISpark hosted Web API, with existing price lists, by joining and comparing with supplier’s article identifiers. From this step, another spreadsheet is generated to compare current prices, new prices from suppliers, and give useful metrics and statistics to help Grön Gåva decide the new price to apply in its e-Commerce shopping site. After a final review of those prices, they can be uploaded to the ERP and displayed on the site.
APISpark and its Google Sheets wrapper greatly simplify the tasks of ingesting supplier’s price lists into their ERP and shopping website, reducing long hours of tedious work into an automated process, where humans can focus on the pricing aspects rather than on the boring manual steps.
APISpark Google Sheets wrapper facilitates human work with the data with a powerful UI through Google Sheets, whereas the wrapper allows to expose a Web API to programmatic consumption.
- APISpark’s free plan is generous to get started with the APISpark platform.
Automate collection of suppliers’ price lists through APISpark’s Google Sheets wrapper
Build Web APIs in a snap for consumption by Grön Gåva’s ERP and shopping site
“We have the best of both worlds with APISpark and its Google Sheets Wrapper: ease of accessing data with a REST API, and powerful spreadsheet UI to facilitate working with the data.”