Mass uploading products on a local server using phpMyAdmin v 2.6 and below

  1. Set up a local testing server using WAMP5 and the instructions here
  2. Download a copy of the default products table in Excel (.xls) format from here
  3. Open products.xls in Excel and make the changes you need following the values of the default product entries
  4. When you are finished delete the first row of field names ie pID, PName, pName 2 etc
  5. In Excel go to File > Save As and select "CSV (Comma delimited)" from the file type drop down and save the file as products.csv
  6. Login into phpmyadmin
  7. Select the database for your store from the left hand drop down choices
  8. Below you should see the 27 fields, click on "products"
  9. Scroll down the right hand frame and click on "Insert data from a textfile into table" . . . you will see a bunch of settings. One of those will be . . .
    Fields terminated by
    . . . and make sure that it is a comma and not a semi colon.
  10. In the resulting page browse to your saved products.csv, check the Replace box below and click on "Submit" at the bottom of the page.
  11. Finally check your admin section to see if the new products have been successfully uploaded.

Mass uploading products on a local server using phpMyAdmin v 2.8

We do not currently recommend using phpMyAdmin v2.7.0. What we recommend is that you go directly to a minimum of v2.8.0 which you can pick up from www.phpmyadmin.net

  1. Set up a local testing server using WAMP5 and the instructions here
  2. Download a copy of the default products table in Excel (.xls) format from here
  3. Open products.xls in Excel and make the changes you need following the values of the default product entries
  4. When you are finished delete the first row of field names ie pID, PName, pName 2 etc.
  5. In Excel go to File > Save As and select "CSV (Comma delimited)" from the file type drop down and save the file as products.csv
  6. Login into phpmyadmin
  7. Select the database for your store from the left hand drop down choices
  8. Below you should see the 27 fields, click on the "products" table in the left panel.
  9. In the right hand panel at the top, click on "Import". Click on "Browse…" to browse to your CSV file then click "Open". The format of imported file should automatically be set to CSV now. You will see a bunch of settings. One of those will be . . . Fields terminated by . . . and make sure that it is a comma and not a semi colon. The settings "Replace table data with file" and "Ignore duplicate rows" are probably good to check if required.
  10. In the "Column names" box, copy and paste this line . . . pID,pName,pSection,pDescription,pLongdescription,pImage,pLargeimage,pPrice,pListPrice,pWholesalePrice,pShipping,pShipping2,pWeight,pDisplay,pSell,pExemptions,pInStock,pDropship
  11. Now click on the "Go" button
  12. Finally check your admin section to see if the new products have been successfully uploaded.
Print page Print Page