Post by hreinn » Mon Sep 12, 2016 6:22 pm

Hi all,

I'm starting a new project, an e-commerce website that has about 2-3 million products.

A quick rundown on the specs are
  • 1) Products have 2 photographs.
    2) Products have around 3-8 categories, 2-3 Specification attributes
    3) The searchable description for each product has around 2000 chars.
You should be able to search within one or more categories.

Any suggestions ? My budget for running this is around 250-300$ per month. I have access to a Solr Server,

If you have any links to websites with a large volume of products and you know the system setup + backend specs, please share.



Mon Sep 12, 2016 6:19 pm

Post by IP_CAM » Tue Sep 13, 2016 11:15 am

you do NOT really expect other LARGE-VOLUME-Online Dealers to share their hard-earned Knowledge with you ?! ::)

And I cannot imagine, how you plan, to add 2 - 3 Million Products, with a budget if 250-300$ per month, because this will be a full-time Job for several Persons, and a few months of hard work, I assume. And you will need a powerfull Server for such, and this itself will add about 50 Bucks per month, just to have the Shop working on a solid Bases.

So, better publish such in the commercial Section of this Place here, because many DEV's around this place do not read the 'open' Sections on a regular scale.
Good Luck ! ;)

For Sale: Turnkey Top URLs with Opencart installed!
Latest Opencart LIGHT + V-Pro Test Site:
For more Information, please contact me at:
Free OC Extensions from the largest Github OC Archive on Earth,
635 + free Repositories - from OC v.1.5.x up
on my Github Opencart Site:

User avatar
Legendary Member


Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by Johnathan » Tue Sep 13, 2016 10:37 pm

Smart Search Pro has Fulltext searching, though I haven't tested it on a database that large. The largest demo database I have is 200,000 products, which you can test out here: ... uct/search

If you wanted to purchase it and test it on your installation, I'd be fine giving you a refund if the speed of finding results is not within reasonable limits (i.e. a few seconds within your normal page loading time), and I can't improve it all by looking at your server and database. Feel free to take a look at the screenshots and demo site, and if you're interested let me know at if you have any further questions.

Image Image Image Image

User avatar
Global Moderator


Fri Dec 18, 2009 3:08 am

New member


Fri Dec 02, 2016 10:28 pm
Who is online

Users browsing this forum: mircead and 29 guests