Maximum number of store items?

[adkins2004]

Is there a maximum number of store items that the system can handle? I'm creating a store currently, with the potential for 500,000 unique items. I will be importing a mysql table containing the items from a separate MRP system.

Also, I will need to refresh this item database at least monthly as new product part numbers are added and others are removed (this can't be a manual process).

Can Squirrel Cart handle this?

Thanks in advance for any feedback

[Jamie]

Hi,

Thanks for checking us out. The main limiting factor is the maximum table size in MySQL. On most systems, it is 4GB. That should be more than enough to handle the records. Squirrelcart does not have an import feature. You will need to either import using phpMyAdmin, or secure shell. Due to the size of the file, I would recommend using shell access, as phpMyAdmin may time out.

Each product needs a record in the Products table, and at least 1 record in REL_Products__Categories to define what category the product is in.

Thanks,
Jamie

[emagin]

May I suggest you take a look at Navicat (http://navicat.com/)
I had PHPMyAdmin crap out many times on big DBs, and if you do this a lot it's a lot faster than commandline.

But it does cost a touch of cash.

[Jamie]

Thanks for the link...will check it out.