I understand why the Cartesian product $A \times B$ is the product of $A$ and $B$ in the category of sets. But is it the only product from the point of view of the category theory? Following the categorical definition, product is defined up to an isomorphism and there can be more than one product.
I think $B \times A$ is another product (and there is a bijection between $B\times A$ and $A \times B$). Am I right? Are there any other products?
In category theory, a product of $A$ and $B$ is not merely an object, but rather it is an object $P$ together with two morphism $\pi_A\colon P\to A$ and $\pi_B\colon P\to B$, called the "projections", that satisfy the universal property associated to the product.
The universal property ensures that if $(P,\pi_A,\pi_B)$ is a product, and $(R,\rho_A,\rho_B)$ is also a product, then there exists a unique isomorphism $\phi\colon P\to R$ such that $\pi_A = \rho_A\circ \phi$ and $\pi_B=\rho_B\circ\phi$. So we say the product is "unique up to unique isomorphism", but that uniqueness requires you to have the full information about the product: the object and the projection morphisms.
Conversely, if $Q$ is any object and $\psi\colon P\to Q$ is an isomorphism, then we can make $Q$ into a product of $A$ and $B$ by defining $q_A\colon Q\to A$ to be $q_A=\pi_A\circ\psi^{-1}$ and $q_B=\pi_B\circ\psi^{-1}$.
So, in your case, yes: $A\times B$ with $\pi_A(a,b)=a$ and $\pi_B(a,b)=b$ is a product of $A$ and $B$. Also, $B\times A$ with $\pi_A(b,a)=a$ and $\pi_B(b,a)=b$, is another product. And any set that can be bijected with $A\times B$ can be given the structure of a product by defining suitable "projection functions".
(The above holds for any family of objects, not just pairs)