Import your Cafepress Shop Data into your own SQL Database

Step 3 Create Your SQL Database and Table

I am not going to cover the steps that involve creating a SQL database because there are numerous docs on the web about that task. Here is the link to MySQL Documentation for your reference: http://dev.mysql.com/doc/. I am going to cover the steps needed to ensure a successful import of your feed generated from podToolbox.

• Create your SQL database
• Create your table
• Refer to your cpFeeder .txt file
• The very first line of the file consists of your column headers (i.e.-  id, link,title,description, price..etc)
• Create the TABLE fields in your SQL database using the same names of the headers in the .txt file.

Import your .csv File

I used phpMyAdmin for administering MySQL but you can perform the same tasks via command line.

• In phpMyAdmin, click on your Database
• Click on the table for your shop data
• Click on Import tab
• Browse for your .csv file
• Under Format of imported file, select CSV using LOAD DATA
• In the CSV using LOAD DATA options
  • Select Replace table data with file
  • Fields terminated by Enter a comma ( , )
  • Fields enclosed by Enter a quota ( ” )
  • Fields escaped by Enter backslash ( \ )
  • Lines terminated by Enter auto
  • Column names Enter the column names from your cpFeeder .txt file. Separate each with a comma. (i.e.- id,product,description)
  • Select check box Use LOCAL keyword
• Click GO button to perform the import.
• If you receive any SQL errors you need to refer to the error code and message then read the SQL documentation. You can first try and verify that you do not have any characters in your file that could be interpreted as code functions. Then import it again. This worked for me.