Software for eCommerce to show out of stock and in stock from daily orders

Software for Mac easily imports our daily orders needs to work out which order have out of stock items, when out of stock item is detected needs to change to another available colour in the same style and size. Exports new orders once above is complete to google sheets