Jump to content


Corporate Sponsors


Latest News: (loading..)

fourmat

Member Since 22 Jun 2003
Offline Last Active Apr 05 2012, 18:17
-----

Posts I've Made

In Topic: The Feedmachine Solution

07 February 2012, 16:04

Love the feedmachine, but I have a configuration issue.

I have another URL parameter that I have been using to track what particular item is being clicked to produce the click conversion.
I have been using another feed generator and had coded it to return the additional URL parameter of &utm_term="model number" where model number is pulled from the $products['products_model'] in the database. How can I structure or modify FM to return that parameter?

I have tried adding it to various locations in feedmachine.php where PRODUCTS_URL is generated, but it doesn't seem to be picking it up. I also tried creating a separate function in the configuration file, but it's not picking up the url parameters spec'd in the admin. Any help would be appreciated.

In Topic: [Development] Products Specifications

07 July 2011, 15:29

I should clarify the previous post by saying that I have the MySQL error issue on the Filter Module or Box the public side.

In Topic: [Development] Products Specifications

07 July 2011, 15:06

Thanks for the push in the right direction.

I'm having another problem and I wonder if I found a bug. I have built a filter with a multi select box. Whenever I select multiple items within the same box, and submit I get the following SQL error.

Quote

1066 - Not unique table/alias: 'ps9'

select count(p.products_id) as count from (products p) join (products_to_categories p2c) on (p.products_id = p2c.products_id) left join (specials s) on (p.products_id = s.products_id) INNER JOIN products_specifications ps9 ON p.products_id = ps9.products_id INNER JOIN products_specifications ps9 ON p.products_id = ps9.products_id where p.products_status = '1' and p.products_master_status != '1' and p2c.categories_id = '140' AND ps9.specification <=> 215 AND ps9.specifications_id = '9' AND ps9.language_id = '1' AND ps9.specification <=> 245 AND ps9.specifications_id = '9' AND ps9.language_id = '1'

Is anyone else seeing this?

In Topic: [Development] Products Specifications

01 July 2011, 13:42

View Postkymation, on 01 July 2011, 01:32, said:

That won't work. The weight is a stock field, and there is no code for the stock fields to show up on the Product Info page, since they should already be there. You could add a separate field for weight, which means you would have to enter that value twice. You could also modify the code to allow the stock field to show up, but that's a can of worms.

Regards
Jim



Thanks for the prompt reply Jim. I thought that was the answer but I miss things sometimes. I'm trying to consolidate the display of various bits if information about the products, and this system would be a great place to put it. For instance I have added UPC, ISBN, Manufacturer Part Number fields as well as the already existing fields. To bring the site up to the standards of a Grainger or Fastenal, I'll need to be able to display all of this information in a fast easy to digest manner. The dilemma I have is that my customers who admin the site see the "display on products info page" setting and are disappointed when I tell them that they can't do that.

Correct me if I'm wrong. In glancing at the code, I'm thinking that if I add an additional MySQL query to the /includes/modules/products_specifications.php code, which ignores the restrictions from the products_specification table, I'll be able to bring in the information from the products_column_name field, and reference that to the products_id to be able to display the info stored in the field. I'll just have to rejigger some of the if statements (and grow some talent).

Any thoughts?

In Topic: [Development] Products Specifications

30 June 2011, 19:30

Another questions guys,

I want to display the weight on the product info page, but not as a filter and not in the comparison page. I have set up the spec and have selected the Products Weight from the drop down. It is not displaying in the products information page along with the other specs.

I have a couple of questions:
Is this even possible with this feature?
If so, what would the criteria be that I need to meet to make it happen?

Thanks for the help.

Matt