Attributes HOW-TO

**Ajeh** · 27 Mar 2006, 11:55 PM

Not at this time ...

Stock Attributes will be available in a future release ...

**kimartist** · 29 Mar 2006, 08:34 PM

I've been reading this for hours and can't find out how to do this....
Is there a way to set it up so that if someone purchases 2 of one product they get 1 free?

Also, is there a way that would also work if they choose a product with an option file.

I have a client who sells specialty soaps, they don't have an option file, just all in the same category. She want to run a sale, that if they buy 3 soaps they get one free. They don't have to be the same fragrance (item #) just from the same category.

I appreciate the help.

**madmonkey** · 31 Mar 2006, 10:02 AM

Having set attributes up i find the product display page very slow and its making 4000+ qureys. page load times of 15 secounds plus.

please have a look at Triangle Carpets.

I have done all speed tips, Gzip does nothing really on my host.

any suggestions would be welcome.

many thanks
Monkey

**kelvyn** · 31 Mar 2006, 10:09 AM

Originally posted by madmonkey@Mar 31 2006, 09:02 AM
Having set attributes up i find the product display page very slow and its making 4000+ qureys. page load times of 15 secounds plus.

please have a look at Triangle Carpets.

I have done all speed tips, Gzip does nothing really on my host.

any suggestions would be welcome.

many thanks
Monkey

OMFG! 1997 queries to display ONE single carpet! WTF??
What version of ZC are you using? I know some of these problems were resolved in 1.2.6/7 - you only have 153 products too!

This is a big worry for me - we've been "attributalising" lots of products over the past week. Hmmm.

**madmonkey** · 31 Mar 2006, 10:58 AM

Zen Cart 1.2.6

**Ajeh** · 1 Apr 2006, 12:25 AM

Unless you have some 50-80+ attributes on a given Product, you should not see a time issue despite the number of querries ... unless you are on a server that cannot handle your database or is not optimized for MySQL and php ...

I have taken sites that take 30-60 seconds a page to load that on hosting sites server take 0.5 - 1.5 seconds ... and the server configurations were the same in many cases ...

Optimization is key here ...

**kimhuff** · 1 Apr 2006, 06:44 AM

Well, I have been reading through the attributes and I am just not getting it.

Here is what I am trying to do.

We have a science fiction convention we will be holding in November. We want to sell weekend admission tickets online along with preferred seating, photo op sessions and various merchandise. I think I get the whole color and size thing but I am not getting how to do text fields.

Basically, if we are selling a weekend ticket, we need to know the badge name for that ticket and the mundane (or real) name for that ticket. BUT, here is my question. First, if the person orders 3 weekend tickets, I need three sets of names. Second, and most importantly, how do I capture these names.

Also, lets say someone orders 3 weekend tickets and 2 preferred seating. I need to know how to tie the preferred seating with a specific ticket.

Is it possible anyone has used ZC for a site similar to what we are attempting? Any advice would be greatly appreciated.

Thanks,

Kim

**madmonkey** · 1 Apr 2006, 09:36 AM

In reply to Ajeh, page load time down to couple of secounds now.

Our products do have about 35-50 attributes on a given Product

i made the reapeated sql enquires in to array much faster for me now.

**kelvyn** · 1 Apr 2006, 10:00 AM

Originally posted by madmonkey@Apr 1 2006, 08:36 AM
In reply to Ajeh, page load time down to couple of secounds now.

Our products do have about 35-50 attributes on a given Product

i made the reapeated sql enquires in to array much faster for me now.

Great! ::tup
Can you let us know how you did this? I'm sure it would benefit a lot of people, especially in shared environments where excess queries result in warnings!