Search Multiple Databases / Building Automotive Catalog

Ask the community
,
1

Hello,

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.

In the past few days of learning, I have only managed to search 1 database. I have some experiences with HTML, CSS, and Python, but I’ve never worked with databases and Javascript before. Any help or suggestions would be appreciated. Also if you are a Freelancer with this kind of expertise, please let me know. Thank you all.

2

There is no limit to the size of a database collection.

The CSV import function is limited to 10,000 at a time, but multiple imports can be performed to allow the import of a very large database.

If you need further details or clarification, I would recommend contacting the Wix support team .

3

Thank you Yisrael, that’s helpful to know