704 replies to this topic

[kymation]

I didn't make the filters work with more than one language. I'll add that to the wish list, but it's unlikely to get fixed before the end of the year.

Regards
Jim

[mayo23]

Am very interested to see this contribution in action.

Has anyone got an example to look at?

Would be greatly appreciated.

[Zane86]

Hi there.
Is it possible to add a few of the specifications i've done in product_listing.php?
Would be nice if it were possible

Cheers

[kymation]

See sections 4.1.1 through 4.1.8 in the manual. Also section 4.5.1.

Regards
Jim

[Zane86]

I got the part to show the comparisons and all that, but i would like to keep the osCommerce-setup for showing the products..


For exampel, if you go in you admin-system and click Product Listing, you can choose what to show...

Display Product Image 1  
Display Product Manufaturer Name 0  
Display Product Model 0  
Display Product Name 2  
Display Product Price 3  
Display Product Quantity 0  
Display Product Weight 0  
Display Buy Now column 4  
Display Category/Manufacturer Filter (0=disable; 1=enable) 1  
Location of Prev/Next Navigation Bar (1-top, 2-bottom, 3-both) 2


...and so on. Is it possible to add for example;

Display Product Specification: Size
Display Product Specification: Color
Display Product Specification: XXXX


Hope you know what i mean =)

//Zane

[kymation]

If I do understand what you mean, this is all covered in the manual. If not, you need to be a lot more explicit.

Regards
Jim

[Zane86]

Hmm.. well, i give it a try.

This is how my product listing looks today:
[img]http://www.izd.se/001.jpg[/img]

I want to add Size from Product Specification inside this red markings:
[img]http://www.izd.se/002.jpg[/img]


If i turn on "Comparison in Index", i just get this:
[img]http://www.izd.se/003.jpg[/img]

Edited by Zane86, 01 January 2010 - 10:02 PM.

[kymation]

Now I think I understand. I can think of two ways to do this:

1. Turn on Comparison in Index. Set the Comparison fields to the ones you want to appear. That would be Image, Product Name, (the one you want to add), Final Price, and Buy Now. You will need to set up these Specifications if you have not already. This will mean that you cannot have a separate comparison page.

2. Modify the code in catalog/index.php to retrieve your new specification from the database, and catalog/includes/modules/product_listing.php to display the new field.

Regards
Jim

[Zane86]

Think i have to go with #2 then . But thats a lot of cracking code in a short time of period.
However, i aint using "model" at the time being - that might be a way out i guess.

Thanks for i great contrib anyway. It works really nice.

//Zane

---------------------------------
Edit:

I guess it's something like this:

in Index.php:
add
        case 'PRODUCT_LIST_SPECIFICATION':
          $select_column_list .= 'p.specification_id=50, ';  //Since id 50 is Size from the DB for me)
          break;

in product_listing.php:

      case 'PRODUCT_LIST_SPECIFICATION':
        $lc_text = TABLE_HEADING_SPECIFICATION;
        $lc_align = '';
        break;



And then alter the code on a lot of places and so on.... Short description... p
(and by the way.... php aint my biggest friend)

Cheers

Edited by Zane86, 01 January 2010 - 10:35 PM.

[kymation]

Not quite. Specifications are stored in the products_specifications table, not the products table. Take a look at the SQL in catalog/includes/modules/products_specifications.php.

Regards
Jim

[hoangk800]

Hi,
Your contribution is very well. But I want to change display at products_info.php as:
At the Specs  tab, I want display the same specs in each group name (ex:
- Group name 1
  -- Specs 1: specs 1 detail
  -- Specs 2: specs 2 detail
- Group name 2
  -- Specs 1: specs 1 detail
  -- Specs 2: specs 2 detail)

*default is: Specs 1, Specs 2,.... - not included in a Group

Can you help me to make this change?
Thanks & best regards,

[kymation]

Just off the top of my head:

1. Set up two different groups and link them to the product categories you want them to appear in. Add your specifications to these groups.

2. Modify the code in catalog/includes/modules/products_specifications to group the specifications by Specification Group. Also add the Group name before each set of specifications.

Regards
Jim

[hoangk800]

kymation, on 20 January 2010 - 04:40 AM, said:

Just off the top of my head:

1. Set up two different groups and link them to the product categories you want them to appear in. Add your specifications to these groups.

2. Modify the code in catalog/includes/modules/products_specifications to group the specifications by Specification Group. Also add the Group name before each set of specifications.

Regards
Jim

I selected specs group but specs result is a loop, ex:
Group specs 1:
Specs 1: detail 1
Specs 1: detail 1
Specs 1: detail 1
Specs 2: detail 2
Specs 2: detail 2
Specs 2: detail 2
My DB code:

$specifications_query_raw = "select ps.specification, 
									  s.filter_display,
									  s.enter_values,
									  sd.specification_name, 
									  sd.specification_prefix, 
									  sd.specification_suffix
							   from " . TABLE_PRODUCTS_SPECIFICATIONS . " ps, 
									" . TABLE_SPECIFICATION . " s, 
									" . TABLE_SPECIFICATION_DESCRIPTION . " sd, 
									" . TABLE_SPECIFICATION_GROUPS . " sg,
									" . TABLE_SPECIFICATIONS_TO_CATEGORIES . " sg2c
							   where sg.show_products = 'True'
								 and s.show_products = 'True'
				and ps.specifications_id = sd.specifications_id
				and sd.specifications_id = s.specifications_id
								 and s.specification_group_id = sg.specification_group_id
				and sg.specification_group_id = '". (int) $spec_group['specification_group_id'] ."'
								 and ps.products_id = '" . (int) $_GET['products_id'] . "' 
								 and sd.language_id = '" . (int) $languages_id . "' 
								 and ps.language_id = '" . (int) $languages_id . "' 
							   order by s.specification_sort_order, 
										sd.specification_name
							 ";

Please help me to fix this error.
Tks,

[kymation]

That should give you  the specifications by group, provided that your group ID is being set correctly. Try uncommenting the print line just after this code and check the SQL it prints out for errors.

Regards
Jim

[bhbilbao]

Installed and working.

But I have questions:
Is there a way to copy the specificatios from on product to other (or to varius products or a whole category) ??

I start working with this and I see that is a very slowly thing, inserting the specifications one by one. Also If yoy have a lot of Specifications in the product edit page the scroll down nevers end clicking them one by one.

A lot of products have the same specifications except for one specification value.

Example:
65 nm
E2220 1 MB L2 2.4 GHz 800 MHz FSB DualCore 2 65 nm Retail Boxed 3years Socket775  No  Yes  No  Yes Enhanced Intel SpeedStep® Technology◊
E2200 1 MB L2 2.2 GHz 800 MHz FSB DualCore 2 65 nm Retail Boxed 3years Socket775  No  Yes  No  Yes Enhanced Intel SpeedStep® Technology◊
E2180 1 MB L2 2 GHz 800 MHz FSB DualCore 2 65 nm Retail Boxed 3years Socket775  No  Yes  No  Yes Enhanced Intel SpeedStep® Technology◊


http://www.intel.com/products/processor/pentium_dual-core/specs.htm

[kymation]

You can copy an existing product and just make the changes to the copy. If you're adding specifications to existing products, then you have to do each one individually.

Regards
Jim

[bhbilbao]

Thanks Jim,
I will try the maner you said. But I think the work is similar because you must change the name, product_code, image, web link, weight, etc. Same or more work.

Introducing the Specs and Filters is not problem at all, if I have time and patience. The problem is on introducing the specs one by one. From the options I think the fast way is the Checkbox Option.
Also asking you if a maner to introduce only one checkbox for all languages. I have 3 languages instaled, and for example, for a "3MB Spec" I must click and check 3 times, It should be fine to be an option to check only one spec to all languages (I saw Multidropdown but I tested it and it dont make im saying).

Im not a profesional coder like you. Im designer.

Looking the spec database of the products (products_specifications) I see that is the only one than changes, the other ones are the "base" with the specs root.

Looking this:

products_specification_id products_id specifications_id language_id specification
121 16227 49 3 2200
122 16227 50 3 2mb
125 16227 49 1 2200
126 16227 50 1 2mb
129 16227 49 2 2200
130 16227 50 2 2mb
100 16210 49 3 2400
101 16210 50 3 4mb
102 16210 49 1 2400
103 16210 50 1 4mb
104 16210 49 2 2400
105 16210 50 2 4mb
112 16230 49 3 2600
113 16230 50 3 4mb
115 16230 49 1 2600
116 16230 50 1 4mb
118 16230 49 2 2600
119 16230 50 2 4mb
114 16230 58 3 Dual Core
117 16230 58 1 Dual Core
120 16230 58 2 Dual Core
123 16227 58 3 Single Core
124 16227 59 3 AM2
127 16227 58 1 Single Core
128 16227 59 1 AM2
131 16227 58 2 Single Core
132 16227 59 2 AM2

We can see that our product (product_id #16227) has 3 specs asigned x 3 languages = total 6 specs.
I say a BUTTON to copy those specs from the product #16227 to other product of the catalog (ot to entire category).
this maner:
create a new products_specification_id (autoincrement) for the other product maintaining specifications_id language_id specification

There is other contribs that makes this in similar maner (Product Sets, Ajax Atributes or Atribute Cloner & Copier), with them you can create a sets of Atributes and copy them to other product very fast.

Thats all.
Thanks in advance.

[kymation]

That sounds useful enough to add to a future update.

Regards
Jim

[bhbilbao]

Oh!  that sounds fantastic Jim.

For the moment I have the contribution installed but using the old categories.php and product_info.php.

You save me on using and pay for IceCat Spreadsheet.

One more thing,

I saw when integrating the code in admin/categories.php the page takes long to load (about 2-4 seconds). You scroll down the page and inmediatly goes to the begining. Its extrange to explain.
It should be interesting to take the specs menu out from the product editor and edit the specs in other page like the clasic page of the atributes. I have been trying making a categories2.php and adding other line on column_left "Products Specs" only with the code for the specs. But not tested completely.

[kymation]

The Categories page does do a lot of work, but I can't see it being that slow. The Specifications page should be just as bad; is it? If not, it may be the Javascript in categories.php.

Regards
Jim