Opening New Product Listings causes Actinic to Crash

[gabrielcrowe]

Gabriel, slightly off topic but given your recent splurge of tweaks scattered around the forum have a look at this one.

Is it possible to exclude `out of stock` items from being used in the Best Sellers/New Products lists?

There is something that I've done before that hides them from the list BUT leaves a space where they should be, resulting in a very odd list.

Maybe the formulae for calculating the lists needs altered so it can exclude oos items if desired?

it would be easy to edit my script to exclude out of stock items, but then you'd need actinic to fill the gaps back up, and this puts them back again.

actinic would have to edit the SQL that makes the list fill up again, to exlude out of stock items. or even better, give us the option.

perhaps its time to make a wish?

note: i have previously hex edited the exe after finding the sql for various things, but only simple hacks are possible. and this also makes the checksum wrong on the catalog.exe. ergo: its not worth it. lol.

[gabrielcrowe]

that bit's easy! even I can answer that lol

put a product in your best sellers list
then delete the product from your catalogue and try opening your best sellers list again from the marketting menu

It'll crash Actinic

Only way back into the marketting menus without crashing will be to delete the product from best sellers in the database.

does that help?

nope, doesnt crash for me at all.
8.5.1 hfua

[TraceyHand]

nope, doesnt crash for me at all.
8.5.1 hfua

*scowls*

what about if the item is "cut" rather than just deleted?
Or did you delete and purge anyway when you tried it?

Seems odd that you're not having the problem. I have to admit I thought it was a universal one

[gabrielcrowe]

*scowls*

what about if the item is "cut" rather than just deleted?
Or did you delete and purge anyway when you tried it?

Seems odd that you're not having the problem. I have to admit I thought it was a universal one

i pressed the delete key
i cut
i moved
i deleted then purged

after a delete then purge, the item is actually removed from the list. this seems like a natural feature of purging.

but the item is still in my list, an my list is open, though i find it ironic that this thread is about creating a problem, lols.

[gabrielcrowe]

SUCESS!!! i cut it with the right click menu.

BAM! crashed.

thenn... run the script and... CRASH! i'm back in.

thanks miss bumps for the help.

[TraceyHand]

SUCESS!!! i cut it with the right click menu.

BAM! crashed.

thenn... run the script and... CRASH! i'm back in.

thanks miss bumps for the help.

no problem
Glad I could help you crash your software successfully
LOL

[george]

Dear Santa Dicko,

Can we please not have out of stock stuff on our lists?

Thank you.

George.

[gabrielcrowe]

if anyone from SQL breeding can help me with the sql in that posted script, then that'd be great.

its only supposed to remove items from the lists, that arent in the product table. but in reality, its stripping the lists out.

althouh this works and it means that people can get back in to their catalog, its still not the solution i was looking for. can anyone here provide the correct SQL?

this is mine:
DELETE FROM [NewProducts]
WHERE NOT EXISTS
(SELECT * FROM [Product]
WHERE [NewProducts].[sProductRef]=[Product].[Product reference]
AND [Product].status LIKE 'Y')

[TraceyHand]

Dear Santa Dicko,

Can we please not have out of stock stuff on our lists?

Thank you.

George.

I think there's already a wishlist thread about it somewhere (started, I think, by Lee?) wayyyyyy back.

[fergusw]

Gabe,
Try

'my shop database is located at:
mydb = "C:\Program Files\Actinic V8\Sites\Site1\ActinicCatalog.mdb"

	
	'best Sellers
	Set OBJdbConnection = CreateObject("ADODB.Connection")
	OBJdbConnection.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & mydb
	SQLQuery = "DELETE FROM [BestSellers] WHERE NOT EXISTS (SELECT * FROM [Product] WHERE [Product].[Product reference]=[BestSellers].[sProductRef])"
	Set Result = OBJdbConnection.Execute(SQLQuery)
	OBJdbConnection.Close
	
	
	
msgbox("done")

[gabrielcrowe]

DOH! i just realised what i did wrong.

revised:

'my shop database is located at:
mydb = "C:\Documents and Settings\All Users\Documents\Actinic v8\Sites\actinet\ActinicCatalog.mdb"

Function DoDatabaseThings(SQLQuery)
	'New Products
	Set OBJdbConnection = CreateObject("ADODB.Connection")
	OBJdbConnection.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & mydb
	Set Result = OBJdbConnection.Execute(SQLQuery)
	OBJdbConnection.Close
End Function

DoDatabaseThings("DELETE FROM [NewProducts] WHERE NOT EXISTS (SELECT * FROM [Product] WHERE [NewProducts].[sProductRef]=[Product].[Product reference])")
DoDatabaseThings("DELETE FROM [BestSellers] WHERE NOT EXISTS (SELECT * FROM [Product] WHERE [BestSellers].[sProductRef]=[Product].[Product reference])")
DoDatabaseThings("DELETE FROM [AlsoBought] WHERE NOT EXISTS (SELECT * FROM [Product] WHERE [AlsoBought].[sProductRef]=[Product].[Product reference])")
DoDatabaseThings("DELETE FROM [RelatedProducts] WHERE NOT EXISTS (SELECT * FROM [Product] WHERE [RelatedProducts].[sProductRef]=[Product].[Product reference])")
	
msgbox("Done! Gabriel cleaned those pesky marketing with some help from Miss Bumps and The Fergus Unit!")

[leehack]

no problem
Glad I could help you crash your software successfully
LOL

Kinell Tracey, hardly a difficult feat lol......