osCommerce and osCMax shopping cart software forums

Shopping Cart Software

osCommerce with teeth!

 
 

So Many Queries so little time

This is a discussion on So Many Queries so little time within the osCMax v2 Customization/Mods forums, part of the osCMax v2.0 Forums category; Because I sell mostly one off items on my site, whenever I mark a product inactive it makes it unavailable ...


Go Back   osCommerce and osCMax shopping cart software forums > osCMax v2.0 Forums > osCMax v2 Customization/Mods

Register FAQ Members List Calendar Mark Forums Read


Free community membership! Fast easy FREE membership
Closed Thread

 

LinkBack Thread Tools
  #1  
Old 10-31-2005, 04:45 AM
New Member
 
Join Date: Sep 2005
Location: Auz
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
delphi1
Default So Many Queries so little time

Because I sell mostly one off items on my site, whenever I mark a product inactive it makes it unavailable for the review function.
It takes up product space and looks tacky to leave it there marked SOLD in order to be able to review it.
Does anyone know a way around it. So that I can remove the product from the catalog after it has been reviewed and get the review and image to stick?

2/Also when I go to my site as punter and click on the product I get a line at the end of the descpription that says
For more information, please visit this products webpage.
When I click on that it takes me to other peoples sites?
Does anyone understand what is happening?

3/Also In admin when I check the product counter it is merely adding one to every item each time someone checks anything out? Is this normal?

4/Also When I load up many products in one catagory the listing shows up with numbers 1-10 coming up after 12etc,1, 21etc,2, 32etc,3
How van I get it to stay in numerical order? Do I have to add a 0 before the number?

5/Also when doing a search as a punter on my site if I ask for say , M2 ,
I get anything with a m or a 2 in it even though I am being specific. Is this normal?

6/Also why is there not a Search in the admin for the same purpose Ie:
If I want to get to S6 it would be quicker than gong catagory , catagory , and then getting the drop down.

Any assistance will be gratefully accepted.
Cheers D
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Sponsored Links
Advertisement
  #2  
Old 10-31-2005, 07:16 AM
michael_s's Avatar
osCMax Developer

 
Join Date: Jul 2002
Location: Phoenix, AZ
Posts: 10,488
Thanks: 73
Thanked 334 Times in 313 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: So Many Queries so little time

1. I dont know of any way around this. You either enable products or disable them. If disabled, they are completely invisible to customers.

2. Yes, you have specified the products url when creating the product. If you don't want to link to these other sites, do not add a products url when creating the product in the admin.

3. What product counter? Be more specific, like what section of the admin and what link you click to get there.

4. Not understanding this one. Can I see a page as to what you are describing.

5. I do not see this result. Say I search for abs, it only returns products that have the letter combo 'abs' in it. When I do a search for ms2 it only returns products that have the word 'ms2', but not products that only have an m or and s or a 2. It must have the whole word 'ms2'

6. There is a search box, just above the drop down in the admin. Leave the category set to Top and then enter your search term. It will look through all categories to find your term. Does exactly what you want.
__________________
Michael Sasek
osCMax Developer


  • osCMax Templates - Hundreds of premium quality templates. New designs every month!

  • 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.

  • 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!
  #3  
Old 11-01-2005, 07:46 PM
New Member
 
Join Date: Sep 2005
Location: Auz
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
delphi1
Default RE: So Many Queries so little time

Hi Micheal thanks for the comprehensive response.
!/thanks
2/Thanks
3/In Reports - Best viewed products.
4/Copy of sample: Note that if i put a 0 before the single digit catalog number it stays on top but if I list the product without the 0 infront it drops down the list.

Deltablastus Blastoid-Temporarily out of stock.
F01-Ammonite
F10
F11
F12
F13
F14
F15
F16
F17
F18
F19
F20
F21
F22
F23
F24
F25
F26
F27
F28
F29
F30
F35-Crinoid Necklace
F36-Crinoid Necklace
F37-Crinoid Necklace
F38-Crinoid Necklace
F39-Crinoid Necklace
F40-Crinoid Necklace
F5-Dentoid Fossils
F8

5/ Selection of a search I did for M1

Displaying 1 to 10 (of 30 products) Result Pages: 1 2 3 [Next >>]
Product Name+ Price Buy Now Manufacturer
10cm/4" - M100 $5.00 TTS
10cm/4" - M101 $7.00 TTS
14.5cm/5.75"-M118 $20.00 TTS
14cm/5.5"-M121 $24.00 TTS
15cm/6"-M126 $30.00 TTS
18.5cm/7"-M122 $18.00 TTS
19.5cm/7.75"-M129 $30.00 TTS
19cm/7.5"-M132 $45.00 TTS
20cm/7.75"-M125 $32.00 TTS
22cm/8.75"-M149

6/ Thanks.
And thank you for a fantastic product and service.
regards D
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #4  
Old 11-02-2005, 06:15 AM
michael_s's Avatar
osCMax Developer

 
Join Date: Jul 2002
Location: Phoenix, AZ
Posts: 10,488
Thanks: 73
Thanked 334 Times in 313 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: So Many Queries so little time

Hi,

4.Ok, I get it now! Yes you need to add a zero as the leading digit or it will not be in order.

5.Regarding the search results, that is the correct results that I would expect, as you are searching for anything with M1 in it, and all of those results contain M1. If you want more refined searching, you would need to specify M10 (that should return only 2 results), M11 (only 1 result). In order for your results to be more focused, your original search needs to be more focused.
__________________
Michael Sasek
osCMax Developer


  • osCMax Templates - Hundreds of premium quality templates. New designs every month!

  • 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.

  • 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!
  #5  
Old 11-02-2005, 09:43 PM
New Member
 
Join Date: Sep 2005
Location: Auz
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
delphi1
Default RE: So Many Queries so little time

Hi,

Excellent Thank you.

One more question please.
Although I have only processed 10 orders thru my site ( yeah pathetic heh)
the latest order that came through was #48. When I ran through a check as a customer
little while later I got #50. Is there an order history I can check that details allll the orders?
Regards
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #6  
Old 11-03-2005, 01:57 PM
jpf's Avatar
jpf jpf is offline
Moderator

 
Join Date: Sep 2003
Location: Manitoba, Canada
Posts: 1,684
Thanks: 2
Thanked 94 Times in 80 Posts
Rep Power: 12
jpf is a glorious beacon of lightjpf is a glorious beacon of lightjpf is a glorious beacon of lightjpf is a glorious beacon of lightjpf is a glorious beacon of lightjpf is a glorious beacon of light
Default RE: So Many Queries so little time

Thes are orders that people have not gone thougth the checkout process (like window shoppers) - they put stuff in there carts and cancel out of or just to see how much shipping would be or just cause they can...then go elseware or don't follow thought to acually doing the checkout/payment....

As for maybe following up with these possable lost sales...osCMax has a module called:Recover Cart Sales

Which is supost to help you maybe to increase sale - by contacting the customers and see why they abandoned there purchase....it also shows all the "abandoned carts".

Look in ADMIN>REPORTS>Recover Cart Sales


Good Luck
__________________
JPF - osCMax Fourm Moderator
Try out our osCMax at: Live Catalog Demo
Limited access Admin: Live Admin Demo
Feel free to add products they way you want and then purchase them -=+=- Sorry nothing will be billed or shipped!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #7  
Old 11-04-2005, 06:14 PM
New Member
 
Join Date: Sep 2005
Location: Auz
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
delphi1
Default RE: So Many Queries so little time

Thank you very much for your informative reply.
regards D
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #8  
Old 11-04-2005, 06:21 PM
New Member
 
Join Date: Sep 2005
Location: Auz
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
delphi1
Default RE: So Many Queries so little time

On checking Reports in Admin I find that I have only got
Products Viewed
Products Purchased
Customer Orders-Total
Is there something that I am missing?

Also In Products Viewed one simply get added to EACH of the already viewed products
when a someone goes in to look at any product.
Again a I missing somethng in my coding maybe?


ie;Best Viewed Products

No. Products Viewed
01. Sandalwood and Gaharu Incense Cones (English) 789
02. Gaharu Incense Cones -16pack (English) 515
03. Seed Necklace and Statuette-C30 (English) 392
04. Money Pots (English) 264
05. Spoon-C90 (English) 257
06. WB1200-Betel Nut Bag (English) 255
07. F04-Deltablastus Blastoid-Temporarily out of stock. (English) 252
08. Spoon-C89 (English) 228
09. Bow and Arrows-C47 (English) 226
10. WB1195-Betel Nut Bag (English) 218

Displaying 1 to 10 (of 486 products) << Page 12345678910111213141516171819202122232425262728293 031323334353637383940414243444546474849 of 49 >>



regards D
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #9  
Old 11-04-2005, 07:40 PM
michael_s's Avatar
osCMax Developer

 
Join Date: Jul 2002
Location: Phoenix, AZ
Posts: 10,488
Thanks: 73
Thanked 334 Times in 313 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 recover carts

See the screenshot below. If your admin doesnt look like this, you are not running oscmax 2 (I added the purple highlight for emphasis, it is not part of oscmax2)...
__________________
Michael Sasek
osCMax Developer


  • osCMax Templates - Hundreds of premium quality templates. New designs every month!

  • 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.

  • 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!
  #10  
Old 11-07-2005, 03:31 AM
New Member
 
Join Date: Sep 2005
Location: Auz
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
delphi1
Default RE: recover carts

My Humble apologies, You are right. I am running MS2-MAX.
Can you direct me to info that clarifies please.
I will go browse The Guide now. Thanks D
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Sponsored Links
Advertisement
Closed Thread

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

Similar Threads

Thread Thread Starter Forum Replies Last Post
Another one from me... (css this time) [wicked] osCMax v2 Customization/Mods 2 02-07-2006 04:06 PM
securing and storing database queries fun2bnuts osCMax v2 Installation issues 2 06-26-2005 09:09 PM
sql queries overloading my hosts, what to do? Anonymous osCMax v1.7 Installation 1 08-03-2004 11:10 PM
Time Zone rd42 osCMax v1.7 Installation 1 01-08-2004 06:33 AM
Custom Queries know osCommerce 2.2 Modification Help 1 10-29-2002 10:14 AM


All times are GMT -8. The time now is 08:01 AM.


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