Well crapolla I need help

[bkpie]

I just uploaded model/price/quantity using easypopulate to change prices which works great but it made all my products New Products for August!!!!! How do I fix that one?

It doesn't even have date on model/price/quantity database on easypopulate GO FIGURE!

Help would be appreciated Thanks

BKPIE

[michael_s]

That is a new one on me

You could export your table as sql file, then to a search and replace on the product date, making it an earlier month. Then re-import the sql.

I would be interested to know if it put today's date in there.

[bkpie]

Yep Today's date

[bkpie]

Alright I exported the products table in sql on test site and checked drop table if exists and used insert

I then did a replace of 2007-08-11 with 2007-06-11 It seemed to work as new products disappeared on the test site so I did it on the live site and the new products disappeared but then products got jumbled everywhere accross categories some rings in charms some bracelets in pendants etc. So I assume some other numbers got changed with the replace that shouldn't have. I restored my old database which I smartly backed up

How do I do it so it just replaces date product added? Not great with mysql

Thanks

Bkpie

[michael_s]

Do it again, and this time make sure you only change the date

That would be my suggestion.

[met00]

STOP.

There is this cool tab in phpmysql called... get this... SQL. In that tab you want to put a single sql command that looks like (please not this is an example, I have not tested this sql statement)

Update products set date_added = '2007-06-11" where date_added = '2007-08-11'

Basically, let SQL do what SQL does best.

[bkpie]

Ok Michael very cute! MET00
Sarcasm dosen't suit you. Did you miss the part that I have trouble with MY SQL I have worked hard to help other people on this forum and add things to oscmax and if all I get back is sarcasm then that SUCKS!!!!!

[met00]

1) I wasn't being sarcastic

2) I was telling you to use phpmysql directly to do an update on the products table date_added field

3) There is no export or import, this is just a straight mysql call. the example I used should take everything from the products table that had the date in the field that you wanted to change and changed it to the date you wanted to insert.

4) phpmysql actually does have a tab called SQL once you select the database and that's the tab you will select to enter the sql statement to do the field update

5) if I was being sarcastic I would have told you to wait until next month and then all the products wouldn't show up as new anymore.

[michael_s]

I think it is time to take a deep breath and if you drink, crack open an icy cold beer...



Ahhhh.. that is better.

Now, lets get back to business.

[bkpie]

Sorry, just had a wicked headache and when you get excited you got a response on your question after you have been pulling your hair out trying things and then find it didn't help hence the frustration.

For those who ever want to change the date added or modified or whatever here is the sql query just change which field you want to modify. I just changed all since I could not get it to replace Back up first

update products set products_date_added='2007-06-11 17:10:59'