December 16, 2013 at 4:12 am #10242
I was trying to add about 60 images as products to my store using the CSV to DB plugin to do a batch. I followed all the instructions on that page. But when I click “import to db” it does 15 of them and gives an error on the rest. I looked at the data in the CSV file and the error ones look exactly like the non-error ones. So, what I did was delete from the CSV file the lines of the ones that were correctly added and then tried to upload & import the new batch. Again, it correctly added the first 15 of the ones that were previously errors and then stopped with an error. Basically I was only able to do 15 at a time. What could be causing this? Is there a number limit on how many lines you can import? I don’t see any settings I can change.December 16, 2013 at 8:14 am #59668mbrsolutionMember
Hello Bruce, could you post here the error log file so we can investigate further. You might have memory limitaions on your server.
Here is another URL you can check if the above procedure does not work for you. You can bulk import products data using this method too:
Kind regardsDecember 23, 2013 at 12:49 am #59669
Where can I find the error log?December 23, 2013 at 1:04 am #59670mbrsolutionMember
Hello Bruce, you need to enable, Enable Debug under Testing and Debugging Settings to view the log file.
Kind regardsDecember 23, 2013 at 7:22 pm #59671
I am trying it again, after updating to the new version of the plug in. And now it does not work. I have a file saved called estore_upload.csv and selected that file to upload..but after uploading when I click “insert into post” it says “invalid file extension – this is not a valid .csv file extension” and does not add my file. But the file is definitely a .csv file.December 24, 2013 at 7:36 am #59672
I just did some more experimenting. It seems that the Upload dialog box is making the plug in think that you are uploading a media file, not a csv file. The dialog box uploads to the wordpress media library by default. There is a folder called “uploads” within the plug in folder – so I placed my csv file into that folder via FTP, copied the URL, and then in the upload dialog box choose “from url” and “other file type”, put the url in there and uploaded it and it worked. However, it is basically taking the csv file from the plug in folder and copying it to the wordpress image library. I think there’s some kind of bug in the upload dialog.
Now I have run into yet another error. I got past the step of uploading the csv file, then I clicked Import and I get this error: “Starting row value exceeds the number of entries being updated to the database from the .csv file.” It did not import any data from the csv file.
For starting row I have entered 2.December 24, 2013 at 10:42 pm #59673
I just tested the plugin and I didn’t see an issue with it. Something is preventing the plugin from working correctly on this site. Have you tried importing the data via PHPMyAdmin using the following approach?December 25, 2013 at 7:58 am #59674
That is not working for me either. It uploads but the column data is off by 1 – i.e. under the column “downloadable” it has the data of the next column, “shipping cost”. According to your video, it did not say to fill in the field called “column names” on the import page. In your sample csv file called products.csv it does not have the exact number of columns as the database. I created my csv file based on yours that I downloaded. If you want I can send you my csv file.December 25, 2013 at 9:20 pm #59675
I’ve been working hard on figuring this out myself and I think I have a clue now. I made my csv file based off your products.csv that I downloaded. I was finally able to make the plugin add 2 products. The problem is, the original csv file did not have the exact same number of columns as the table. It has 34. the wp_estore_tbl has 47, if I tick “bypass auto increment” then 46. So I opened my csv file in text editor and added commas after the header row and each of the 2 products rows to make 46. Now it uploaded both of my products. Your file does not have all the column headings. Maybe I’ll try adding all the other column headings to it when opened in spreadsheet editor and then save it.December 25, 2013 at 11:17 pm #59676
We updated the sample “products.csv” file after we upgraded the plugin. I think you are still using the old products.csv sample file that you downloaded earlier. You can download a new one from here:December 26, 2013 at 12:41 am #59677
Ok…I see that now. I copied my data into a new csv with all 47 columns.
I tried importing, and it did 15 and stopped. Here’s the problem: many of the fields don’t apply to my product especially after the variation field, so when I’m filling in a csv file leaving it blank, saving the csv file does not put a comma and therefore doesn’t have all 47. I found an article from Microsoft explaining this – excel saves csv files in blocks of 15 rows. You need to have some kind of data in the 47th (very last) column otherwise excel will not put commas:
The last column in the table is “per_customer_qty_limit” which needs to have a number or leave blank. Do the columns in the table need to be in this exact order? If not, could I move the “custom_price_option” column to the end? That is a tickbox which will either have a 0 or 1 but it won’t be blank. Having this at the end of each row will guarantee commas for all blank fields in the row.December 26, 2013 at 1:22 am #59678
When you check that auto increment field, it will be 46 fields. That means you are not saving it as a proper CSV file. Are you using MS Excel to edit the CSV file? When you are saving it, are you choosing “Save it as CSV” file? When you save it as a CSV file, it will put the commas there for the empty fields automatically.December 26, 2013 at 1:50 am #59679
Yes. “save as” and .csv I am using excel to edit them.
When I open it in notepad, there are no commas after the variation field. This is probably just a Microsoft bug.
I re-saved it using google spreadsheets, and then bulk uploaded 61 products using the plugin…and it worked. Aside from using google, I can’t think of any other easy way to bypass the Microsoft bug. I use Excel for all my spreadsheet work.December 26, 2013 at 10:31 pm #59680
okay at least you got your products imported now.
- You must be logged in to reply to this topic.