We have a repricing tool to update the price of our Onbuy listings by communicating with the Onbuy API to find out if our listings are winning the buy box, then adjusting the price accordingly.
We are now looking to add inventory management to this project:
We would like to tie the Onbuy repricer in with Onbuy inventory management. Rather than just checking prices, now we need to update the stock quantity as well.
Task 1: Setup quantity and price updates with logging.
The main settings page: From Manage Products page we should allow Upload product csv to include Quantity column too. If min and max price are not included it should be ok, as long as price column is included. I would like the main Products page to include a “quantity” column.
New settings page: Feed import There should be a new settings page to setup mapping for feed imports: Input feed url: one of CSV/XML/TXT/XLS/XLSX/TSV/JSON. Import Frequency 15 mins, hourly, every 6 hours, every 12 hours, daily, once per week, onetime, drop down box Clear Stock: Set all currently live stock quantities to 0 before running update, tick box Create listings: Create listings not currently in catalog, tick box, Settings can be set, but requires “Create listings” subscription in order to be active. It is only to create “In stock” items i.e quantity 1 or more.
The basic import feed looks like this: SKU Product Name Description Default Image Brand Category Condition EAN / UPC Price Sale_price Sale_start_date Sale_end_date Quantity
Required columns for quantity updates would be SKU and Stock. Required columns for price updates would be SKU and Price.
Logging: Should be able to see history of updates to Onbuy and imports into system from feeds. To show summary (Number records updated, number failed, time updated) and then download full log in CSV with each line of import file then outcome (I.e failed and reason, or success)
You can see the documentation here: https://docs.api.onbuy.com/
If you have the skills and experience to create this cloud based project please place a bid.
