Forum Replies Created
-
Posts
-
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.
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:
http://support.microsoft.com/kb/77295
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.
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.
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.
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.
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.
I just did another test. I changed 5 products using the “edit product” link and saved it. Then I opened the page that contains these pictures. The quantity box was still there. Then, I went into the cPanel admin area of my website, and went to the phpMyadmin application, opened my database, and scrolled down to the table “wp_estore_tbl” and looked for those product ID#s, and under the column “show qty” the ones I changed were 0, the others were 1. So this means the edit is definitely reflected in the table, so as far as I can tell there should be no reason for that quantity box to be on there!
Now, I went to the admin panel in wordpress for my NextGen photo gallery and picked one of the 5 images (products) that I had changed, and clicked on “recover from backup”. all this does is load a fresh copy of the image. Then when I refreshed the page, all 5 of the ones I edited were showing without the quantity box!
This is the page: [http://flightlineaviationmedia.com/photos/boeing/dreamliner/]
Really weird. And, for what its worth, this issue is not only with the “show quantity” box. If I change something else, like for example the text “Choose a Size” in the product variation – I changed it to “Pick a Size” and went thru the same procedure as above, the change did not show on the live webpage until I recovered the image in NextGen. This happens even if I make the edit directly on the table itself. Its almost like eStore is not playing nice with NextGen.
I’m talking about the gallery whose pictures are my products in eStore.
What I meant was I went to the gallery tab in my dashboard, under “manage galleries”, there is a link by each photo ID# to recover it from backup. When you upload a picture to a NextGen gallery it creates a backup of the image. I recovered it (that doesn’t change anything I had in the title or description fields) and then refreshed the published page and the change was visible.
The change I wanted to make was to uncheck the Show Quantity box. I did and saved it…then I can go back into that product and the box remains unchecked…but when I refresh the webpage where this gallery & product are, that quantity box is still there – even though the box is unchecked. I tried closing the browser tab, opening it in a new window, etc but the change is not visible online. It is reflected in the product details though.
I would like to know also, is there any way to change the product details settings for multiple products at once? I wonder if its possible to edit the actual table where all these details are stored maybe?
No. No cache plugin. I was able to get the change to take on two products but then I tried to make the same change on another one and it does not work. The box is ticked but the quantity field does not show. Previously on these products, the field was not ticked and it did not show which is correct. I was trying to add this field. But I tried a couple other changes for example on the variation and it also does not show the change.
I tried deactivating several plugins and it does not work. Also tried loading the page in a different browser in case it was a firefox cache problem – tried it in IE and its not there.
I just tried one more thing. After saving the change to the product in eStore, I went to the gallery and recovered the image from backup. Now the change is there. Is there any way to avoid having to do this extra step? Or 2 steps, because after i recover an image I’ll have to set the watermark again. I don’t understand why recovering the image from backup should effect the product details.
I did deactivate that addon, and now the cart shows on each page. I think for now I’ll leave the variation entry the basic way while I move on to configuring and setting up other areas.
