The answer is Yes, although you might wanna make sure and wait for another member here to confirm my answer as I am on the fence. Better yet, why don't you contact the iPage guys because they can assist you better...
Oh yes... I forgot to add that I have :.
SQLyog and phpMyAdmin installed as well and I can access the mySQL as well to run commands. So if it's a mysql command that any guru comes up with?.
Like : if date_last_modified < now()-3days then set inactive... ???.
Not sure how to do this... PLEASE someone help... it's really bugging me.....
Gee! I felt sure someone would know how to do this!.
Ah well never mind. I'm sure someone will come up with it some time but for now I'll have to work on another theory..
My next theory is to use EasyPopulate to download a complete csv then sort it by date last modified then upload changes again with EasyPopulate. I'll only select those that need to be changed. Still it's not ideal. I'd like to be able to at least download only the the items I needed...
That would only work if ya would empty all yer products before updating.
That is if ya indeed want em deleted.
I to am lookin for a way to remmove products that arent updated in say 3 weeks.
Or where at least stock became 0, wich in my case is the same.
I do not allow chekin out, since some of my suppliers dont give stoc amounts, but only products they can deliver.
But some do deliver products that became absolete.
Setting em inactive would be a good deed aswell, as long as no one would see em no more in the shop..
I understand that actually removing the products to clear the database would mess up my facturation.
I dun mind since I dont use the commerce billing thing but make my own offline.
(for the irs and stuff).
Thanks in advance for anyone that figures out a way to do this and help me out..
If it aint out here yet I will atempt to make one myself, but hell, thatll take at least 2 months before I get the time to start on it, let alone have it finished.
Workin on other contribs first (need em myself, cant find em, so make em, and upload when ready and tested)..
I had a similar question myself about checking my suppliers stock against mine and vice versa and asked my darlin teckie brother but his answer was to use the iOPUS macro thingie which is like over $300 but woulda worked he thinks. I did see it in action it's pretty sweet but not at that price.
So I'll be watching this tread, lol...
My supplier sends us updates of over16,000 products every day. Takes about 3 hours to upload every day using easypopulate ..
So now for the problem....
Some products quickly become redundant. We need to have a contribution or a method of making a product inactive after a time frame such as 3 days....
Either a MySQL command or a contribution would be handy... Though I imagine that the MySQL command would be faster???.
Something along the logic of .... IF date_last_modified = 3days old then set inactive..
How to do that I'm not sure....
Some may have noticed that I've renamed this topic for the following reasons..
1: If you remove inactive products apparently this stuffs up your orders records..
2: I imagine thant images may also be affected by this if a product comes back into stock..
3: I've had a bit more time to think about what needed to be done...
Can't believe that nobody has done anything like this?! Please someone? Even if someone gives a hint on how to do it in PHP I might be able to put together a contribution for others....