MySQL Import

RickC · Posted: Tue Jan 31, 2012 1:14 am Post subject: MySQL Import

I have been entering items by uploading with a SQL file I make in Excel.

In order to get the category counts to show correctly all I would have to do is edit any item in the category I uploaded to and push the update button and everything would work fine.

After the newest update 9.5

Now each item shows up with the button “view details” if I push that button it sends me an Email,

Subject: Notification: R.F. Engine - Link Visit for Delete Test
User Name/ID: Guest

Product www.dieselcranks.com/i...mp;id=6357
Link "

Now I have to go into each new item and push the update to have it show correctly.
Question is any idea why the change or how to get around it.

Also maybe for the next update we could do some sort of import/export from Excel.

RickC

Initiated by Bugger (Original Entry) - Comments Here Please.

Phoenix · Posted: Wed Mar 14, 2012 7:04 pm Post subject: Re: MySQL Import

"View Details" should only appear for an item designated as a link, off-site as opposed to an on-site item.

This only comes into play when you enter a value in Product Link - redirects Off Site: i.e. the prodLink field which I thought was introduced before v9.5

Can you provide a sample of your Excel file?