I run an ecommerce business on Shopify. I currently receive a csv file daily from one of our main suppliers with stock count and price changes. What I'm looking to achieve is a semi automated way of updating price and stock count based on their daily list.
I would need to be able to copy and paste my exported list from Shopify into this spreadsheet and also copy and paste the suppliers list and have that generate a new list with updated price and stock count for import back into shopify.
Other things I'd need it to do:
- highlight SKU's that are on my list but no longer on my supplier list (items no longer stocked at supply end)
- highlight items that are on my suppliers list but not on mine (new items added at supply end)
43 freelancers are bidding on average $358 for this job
Hi there - Thanks for the headsup. Can you please share your sheets, I like to have a look and also I can complete it in a day. Please reply, we can discuss further and hopefully get it started soon. Thank you!
Hello, I hope you are well. I would like to be part of this project as it sounds very interesting. I have experience of 8 years in advanced excel. Please contact me for checking the details. Regards...