Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

phpmyadmin uploading 65,000 product database


elijahweb

Recommended Posts

Posted

I'm attempting to upload the database for my bookstore that has 65,000 line items and roughly 10 fields. I'm using phpmyadmin to upload to the tables. My first attempt is to the products table. I'm simply locating the text file by clicking the browse button. After it's located(from my desktop) I clicked the submit button and then watch it seemingly stall. On the bottom of my explorer window I see it saying sending request for /3rd party/phpmyadmin/ldi_check.php. It justs kind of sits there. Any suggestiosn to what might be wrong? It showed and error window once but I didn't catch what it said before I closed it out by mistake. is it because I'm loading it from the local host and it needs some sort of permission. I opted to go this way instead of EZ populate by number of osCommerce users, because of teh size of the database. Thanks in advance!

 

Keith Ronan

Thanks in advance,

Keith Ronan

Posted

With such a huge database it may take some time to upoad to your server.

 

Try been more patient, maybe start it and have some coffee or something.

Posted

I also am unsure of thsi area in my upload process... I am using the ISBN # for my products as the product ID ,I think! Is it a good idea to then remove the default setting of Auto Increment from product ID or is that a bad idea?? I thought using ISBN as the product ID would help different tables ie. product description, product categories, and etc, by all having that ID (ISBN) # to see . Is this going to cause confusion. I'm about to take a MYsql course, but I'm up against the wall with a client so I'm relying on thsi forum and my Books... Thanks

 

Keith

Thanks in advance,

Keith Ronan

Posted

I also would like to hear comments regarding the isbn number being used as prod id in the database. At present I have added another table to the database for the isbn number with prod id... seems like there must be a better way.

Also when an order comes and send me the extra email I want and need to know the isbn number on that email to save time when ordering from my distributors. Has any one got a suggestion on how to do this effectively?

 

If the isbn becomes the product Id can that be added to the extra email? or both customer and admin email?

 

Cheers

Paul

  • 4 months later...
Posted

Hi there appears to be an add SKU, ISBN issn, module in contriutions, but i'm not clear how to install it yet as i'm not up on sql programming

 

isis

Posted

sql programming is not needed to install this module. Wordpad and a MYSQL admin is all you really need. (Of course there are a hundred ways to do it). Just load the file you want to edit into wordpad. Use the Find / replace function in wordpad to locate and replace all the instances of code. That will take care of 80% of the installation. It should take you about 30 minutes to install this contrib. (maybe longer for newbies). :D

 

 

 

Mark

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...