osCommerce and osCMax shopping cart software forums

Shopping Cart Software

osCommerce with teeth!

 
 

Well crapolla I need help

This is a discussion on Well crapolla I need help within the osCMax v2 Features Discussion forums, part of the osCMax v2.0 Forums category; I just uploaded model/price/quantity using easypopulate to change prices which works great but it made all my products New Products ...


Go Back   osCommerce and osCMax shopping cart software forums > osCMax v2.0 Forums > osCMax v2 Features Discussion

Register FAQ Members List Calendar Mark Forums Read


Free community membership! Fast easy FREE membership
Reply

 

LinkBack Thread Tools
  #1  
Old 08-11-2007, 12:49 PM
osCMax Testing Team
 
Join Date: Sep 2004
Posts: 298
Thanks: 23
Thanked 35 Times in 34 Posts
Rep Power: 6
bkpie has a spectacular aura aboutbkpie has a spectacular aura about
Default Well crapolla I need help

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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Sponsored Links
Advertisement
  #2  
Old 08-11-2007, 09:02 PM
michael_s's Avatar
osCMax Developer

 
Join Date: Jul 2002
Location: Phoenix, AZ
Posts: 11,091
Thanks: 81
Thanked 348 Times in 327 Posts
Rep Power: 10
michael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond repute
Default Re: Well crapolla I need help

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.
__________________
Michael Sasek
osCMax Developer


  • osCMax Templates - Hundreds of premium quality templates designed for osCMax 2. Loyalty discounts up to 30% off!
    Each purchase supports the osCMax project with much needed funds!

  • xShop for osCMax - Windows Based osCMax administration. Improved workflow, security, speed and convenience.

  • osCMax Hosting - From basic hosting to High Availability, Load Balanced arrays, the most experienced osCMax host. Default multi server configuration for exceptional performance!

  • osCMax Template Tutorial - Learn how to make your own custom templates and how to use the powerful features of the osCMax template system.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3  
Old 08-11-2007, 10:09 PM
osCMax Testing Team
 
Join Date: Sep 2004
Posts: 298
Thanks: 23
Thanked 35 Times in 34 Posts
Rep Power: 6
bkpie has a spectacular aura aboutbkpie has a spectacular aura about
Default Re: Well crapolla I need help

Yep Today's date
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4  
Old 08-12-2007, 09:21 AM
osCMax Testing Team
 
Join Date: Sep 2004
Posts: 298
Thanks: 23
Thanked 35 Times in 34 Posts
Rep Power: 6
bkpie has a spectacular aura aboutbkpie has a spectacular aura about
Default Re: Well crapolla I need help

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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #5  
Old 08-12-2007, 10:47 AM
michael_s's Avatar
osCMax Developer

 
Join Date: Jul 2002
Location: Phoenix, AZ
Posts: 11,091
Thanks: 81
Thanked 348 Times in 327 Posts
Rep Power: 10
michael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond repute
Default Re: Well crapolla I need help

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

That would be my suggestion.
__________________
Michael Sasek
osCMax Developer


  • osCMax Templates - Hundreds of premium quality templates designed for osCMax 2. Loyalty discounts up to 30% off!
    Each purchase supports the osCMax project with much needed funds!

  • xShop for osCMax - Windows Based osCMax administration. Improved workflow, security, speed and convenience.

  • osCMax Hosting - From basic hosting to High Availability, Load Balanced arrays, the most experienced osCMax host. Default multi server configuration for exceptional performance!

  • osCMax Template Tutorial - Learn how to make your own custom templates and how to use the powerful features of the osCMax template system.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #6  
Old 08-12-2007, 11:54 AM
Active Member
 
Join Date: Oct 2005
Location: wherever I happen to be at the moment
Posts: 470
Thanks: 4
Thanked 79 Times in 73 Posts
Rep Power: 8
met00 is just really nicemet00 is just really nicemet00 is just really nicemet00 is just really nicemet00 is just really nice
Default Re: Well crapolla I need help

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.
__________________
so endith the lesson
<think>sometimes I just sit's and thinks</think>
"Here you are with a hand full of holes, a thumb up your ass, and a big grin to pass the time of day with." - TWB
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #7  
Old 08-12-2007, 12:21 PM
osCMax Testing Team
 
Join Date: Sep 2004
Posts: 298
Thanks: 23
Thanked 35 Times in 34 Posts
Rep Power: 6
bkpie has a spectacular aura aboutbkpie has a spectacular aura about
Default Re: Well crapolla I need help

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!!!!!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #8  
Old 08-12-2007, 12:56 PM
Active Member
 
Join Date: Oct 2005
Location: wherever I happen to be at the moment
Posts: 470
Thanks: 4
Thanked 79 Times in 73 Posts
Rep Power: 8
met00 is just really nicemet00 is just really nicemet00 is just really nicemet00 is just really nicemet00 is just really nice
Default Re: Well crapolla I need help

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.
__________________
so endith the lesson
<think>sometimes I just sit's and thinks</think>
"Here you are with a hand full of holes, a thumb up your ass, and a big grin to pass the time of day with." - TWB
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #9  
Old 08-12-2007, 02:11 PM
michael_s's Avatar
osCMax Developer

 
Join Date: Jul 2002
Location: Phoenix, AZ
Posts: 11,091
Thanks: 81
Thanked 348 Times in 327 Posts
Rep Power: 10
michael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond repute
Default Re: Well crapolla I need help

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.
__________________
Michael Sasek
osCMax Developer


  • osCMax Templates - Hundreds of premium quality templates designed for osCMax 2. Loyalty discounts up to 30% off!
    Each purchase supports the osCMax project with much needed funds!

  • xShop for osCMax - Windows Based osCMax administration. Improved workflow, security, speed and convenience.

  • osCMax Hosting - From basic hosting to High Availability, Load Balanced arrays, the most experienced osCMax host. Default multi server configuration for exceptional performance!

  • osCMax Template Tutorial - Learn how to make your own custom templates and how to use the powerful features of the osCMax template system.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #10  
Old 08-12-2007, 04:04 PM
osCMax Testing Team
 
Join Date: Sep 2004
Posts: 298
Thanks: 23
Thanked 35 Times in 34 Posts
Rep Power: 6
bkpie has a spectacular aura aboutbkpie has a spectacular aura about
Default Re: Well crapolla I need help

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'
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Sponsored Links
Advertisement
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


All times are GMT -8. The time now is 03:17 PM.


Powered by vBulletin®
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO
http://www.oscmax.com/forums/
Copyright 2008 osCMax