So iv'e recently taken control of a website which sells catering equipment. Running on CubeCart 3. It hasn't been updated for about 6 years. for the first few days i was manually uploading every product through the 'add product' tab of Cubecart 3. which was extremely time consuming and let alone tedious. iv'e got about 2000 more product to add. Which i believe i can do though phpMYADMIN via the SQL section? Ive set up a CSV file including the product names, Codes and prices. Heres a small extract:-

CAP005,Skull Cap Lge Black, £4.99 ,
CAP006,Paper Chef Hat Tall, £1.06 ,
CAP008,Pk 50 Hair nets , £15.59 ,
CAP009,Pk 100 Disp Blue Aprons , £20.82 ,
CAP010,Forage Hot Pk 100, £16.28 ,
CAP015,White Bib Apron, £4.65 ,
CAP016,Money Belt Black, £5.75 ,
CAP017,Tabard Blue, £10.35 ,
CAP018,Black Waist Apron, £5.18 ,
CAP019,Skull cap white, £3.22 ,

I have set the column names to- productCode, description, price, when i click Go i recieve this error code 'Invalid column () specified! Ensure that columns names are spelled correctly, separated by commas, and not enclosed in quotes'.

Which to my knowledge i have done? Any help you can provide i would greatly appreciate as I have come to a bit of a dead end in my quest to not sit here and manually enter 2000 products. Sorry also if this is a stupid question im completely new to this.

    21 days later

    Do any of your line items have apostrophe's (') in them? Perhaps you're throwing the import off...

      Hexegon wrote:

      Ensure that columns names are spelled correctly, separated by commas, and not enclosed in quotes'.

      Which to my knowledge i have done?

      The column names don't appear in your extract; do you list them at the top of the CSV file?

        There are many versions of phpmyadmin and it sounds a bit like you may be using a relatively new/recent one. In the older ones, phpMyAdmin would not read the column titles and would rely on you to put the columns in your CSV in the same sequence as the columns in your table.

        You did have an option to specify in some versions of phpMyAdmin which columns you were importing in your spreadsheet. I.e., your CSV wouldn't have any column titles in the first row, but there would be an input in the phpMyAdmin form where you could list the columns that you had in your spreadsheet. the sequence of this comma-separated list would have to match the column sequence in your CSV.

        If phpMyAdmin is in fact paying attention to your column names, you'll probably need to list the exact column names for the table in the first row of your CSV.

          Write a Reply...