I am trying to build an automotive catalog for my small business with WIX, and as you can imagine, I have a lot of databases to search & filter before a correct product can be displayed to my customer.
The reason why I need to make multiple databases is because WIX's database is limited to 10,000 rows (which may sound like a lot, but unfortunately in the aftermarkets world, that's hardly enough to include all the existing car models, let alone positions, product category, etc.).
In short, I have a total of more than 200,000 rows of data.
My plan right now is this:
1. Split my database by vehicle manufacturer (~40 databases) - i.e. "Honda.DB", "Toyota.DB", etc.
2. Create 1 database containing all available manufacturers, create a dynamic page to let user select their vehicle Make with a drop down
3. Take the value of drop down (A vehicle make, i.e. Honda), and redirect user to search in "Honda.DB"
4. User will continue to select vehicle Model and Year from drop downs, and all part_numbers would appear matching the exact Make, Model, and Year
5. The results (Product types, part_numbers, part availability, price, and a "add to cart" button) will be displayed in a table. Data for part availability and price will be fetched from my listings.