Sorry to hear of all those problems but some, like the colour coding problem, while it doesn't make it excusable, are common on Chinese products, and others like the non-Shrader valve type, which will be a Presta, much favoured by serious cyclists and certainly not old fashioned, cannot really...