Hello,
I hope someone can help me or steer me in the right direction.
I have an eBay store with about 750 items listed from a particular supplier. All these listed items have a Custom Label which is the SKU number.
Each day I download a CSV file with the SKU in one column and the Quantity on the other from my supplier. I also download the active stock from my eBay store as an Excel spread sheet each day which has the SKU and other info in the columns.
What I would like to do is have the current stock in a spread sheet and then import the supplier's CSV file and have it show what SKU is less than 5 for example, highlighted or listed in a new page.
For example;
Item in stock (SKU)..................................................Stock list
abc001......................................................................5
abc002.....................................................................10
abc003......................................................................0
abc004......................................................................0
abc005.....................................................................15
I would like the items that are 0 highlighted or opened up in a new page.
Thank you for any help in this area,
Mike
Bookmarks