NewWay to save Attributes Modelnumbers

01 Feb 2007, 08:45

#1

New Zenner

Join Date:: Dec 2006
Posts:: 6
Plugin Contributions:: 1

NewWay to save Attributes Modelnumbers

Hi...

I have read that it was a problem to get the modelnumbers for each attribute kombination stored in database.

So I´ve programmed a way around it...
Now u can save a modelnumber, proce and weight for each attributes combination... :smartass:

Watch this: http://www.baushop-manek.de/index.php?main_page=product_info&products_ id=271

Sorry its only in german...:lookaroun
but try to put the combination "gelb verzinkt", "M10 Gewinde" and "300 mm" in your basket... :yes:

nice ?

So how can i get this into the distribution?

I wanted to get this in, bcause there is a need for everyone to know what the modelnumber of the product is when someone bought it... even when there is a kombination of attributes...

I also build a module to get a an orderlist grouped by each manufactorer with listed and accumulated modelnumbers bought by your customers in your shop, which can send on order to the manufacturers homepage by only one click... :)

02 Feb 2007, 03:51

#2

ajeh

Oba-san

Join Date:: Sep 2003
Posts:: 62,757
Plugin Contributions:: 1

Re: NewWay to save Attributes Modelnumbers

You would test it on a clean install and ensure that it works ...

Then package it up into a Zip file and add it to the Downloads via the link at the top of your screen ...

Thanks! :smile:

02 Feb 2007, 12:27

#3

helixx23

New Zenner

Join Date:: Dec 2006
Posts:: 6
Plugin Contributions:: 1

Re: NewWay to save Attributes Modelnumbers

so...
i´ve uploaded it... :)

but it says:
http://www.zen-cart.com/forum/../includes/templates/template_default/images/icons/success.gif Success: file saved successfully.
http://www.zen-cart.com/forum/../includes/templates/template_default/images/icons/warning.gif Warning: no file uploaded.

greets HelixX²³

01 Jun 2007, 21:32

#4

hricco

New Zenner

Join Date:: Nov 2006
Posts:: 4
Plugin Contributions:: 0

Re: NewWay to save Attributes Modelnumbers

Hi,

First, thank you for this new module.
I installed it on our site (it's currently in developement, so available for internal viewing only). I've translated some of the German to English using Altavista babelfish (not perfect, I know). However, I'm having trouble figuring out how I add the model numbers to my attributes/products. I notice on the Attributes Controller Table I only get half the page. The page ends after the

[html]<form action="" method="post"><br>
<input type="hidden" name="setAttributes" value="go">
<input type="hidden" name="ID" value="1"><table width="200" border="1"><tr> <th align="center">Product Number <a href="#" onclick="helpwindow('Product Number', 'Product numbers directly of the manufacturer indicate as it a supplementory order also smoothly for the manufacturer to be ordered can.<br><br><strong>If the article in the combination is not available becomes a lozenge (#) registered!</strong>');">(?)</a></th>
<th align="center">Price (Net)<a href="#" onclick="helpwindow('Price (Net)', 'only indicate prices without value added tax!');">(?)</a></th>
<th align="center">Weight (in Kilo)<a href="#" onclick="helpwindow('Weight (Kilo)', 'Only in kilograms indicate weight!<br><br>e.g.: 50 gram indicate as 0.05<br>or 5 gram as 0.005');">(?)</a></th>
</tr>
off hereO_V C: 0<tr>
<td></td>
<td><input name="Attr_-" type="text" value="" /></td>
<td><input name="Price_-" type="text" value="" /></td>
<td><input name="Weight_-" type="text" value="" /></td>
</tr>
[/html]There's no </body> or </html>, or footer information. Did I just copy something wrong from the download? Where can I look to correct this?

Thanks,
HRicco

02 Jun 2007, 22:35

#5

helixx23

New Zenner

Join Date:: Dec 2006
Posts:: 6
Plugin Contributions:: 1

Re: NewWay to save Attributes Modelnumbers

Hi..
I have a new Version with some Bugfixes and new features ready to upload... :)

Maybe i can upload it next Week when i am at work so be patient.

Nice to hear that s.o. is using it... :)

greets HelixX²³

02 Jun 2007, 23:55

#6

gjh42

Black Belt

Join Date:: Jul 2005
Posts:: 21,876
Plugin Contributions:: 6

Re: NewWay to save Attributes Modelnumbers

Your dynamic total price display is something that a huge number of people would love to have. Is that part of the mod? I like the polite little note informing those who browse with javascript off that they can see the prices with it on.

03 Jun 2007, 03:13

#7

voltage

Totally Zenned

Join Date:: Apr 2005
Posts:: 1,356
Plugin Contributions:: 0

Re: NewWay to save Attributes Modelnumbers

Oh my gosh! Yes, I would LOVE to have this. PLEASE consider packaging that as a contribution. Thanks

gjh42:
Your dynamic total price display is something that a huge number of people would love to have. Is that part of the mod? I like the polite little note informing those who browse with javascript off that they can see the prices with it on.

03 Jun 2007, 03:18

#8

theoracle

Suspended

Join Date:: Aug 2004
Posts:: 3,180
Plugin Contributions:: 1

Re: NewWay to save Attributes Modelnumbers

Looks like an interesting MOD. However, there's one little comment I'd like to state:

[php]
<td><input name="Weight_-" type="text" value="" /></td>
</tr>
[/php]

to read:

[php]
<td><input name="Weight_-" type="text" value="" /></td>
</tr>
</table>
</form>
[/php]

:wink2:

22 Jul 2007, 18:06

#9

fredi

New Zenner

Join Date:: Mar 2004
Posts:: 1
Plugin Contributions:: 1

Re: NewWay to save Attributes Modelnumbers

Anyone have a correct version of this module?

25 Jul 2007, 23:44

#10

beilana

New Zenner

Join Date:: Apr 2006
Posts:: 84
Plugin Contributions:: 0

Re: NewWay to save Attributes Modelnumbers

I could use this as well.

I have not been able to get this one to work. When I view the module in the admin I get this:

1146 Table 'adminuser_zc5.products' doesn't exist
in:
[SELECT products_description.products_name, products_options.products_options_name, products_options_values.products_options_values_name FROM products LEFT JOIN products_description ON (products.products_id = products_description.products_id) LEFT JOIN products_attributes ON (products.products_id = products_attributes.products_id) LEFT JOIN products_options ON (products_attributes.options_id = products_options.products_options_id ) LEFT JOIN products_options_values ON (products_attributes.options_values_id = products_options_values.products_options_values_id ) WHERE products.products_id = 184 AND products_description.language_id = 43 AND products_options.language_id = 43 AND products_options_values.language_id = 43]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

I have tried this several ways and always end up with something similar...

27 Jul 2007, 08:32

#11

helixx23

New Zenner

Join Date:: Dec 2006
Posts:: 6
Plugin Contributions:: 1

Re: NewWay to save Attributes Modelnumbers

Hi...

I finally endeavored to persuade my chef to create a packet of the final release of this mod :cool:...
So be patient please...
I´m trying to get this ready quickly.

greets from Germany

HelixX²³

29 Jul 2007, 23:58

#12

lightcubed

New Zenner

Join Date:: Jul 2007
Posts:: 3
Plugin Contributions:: 0

Re: NewWay to save Attributes Modelnumbers

Any luck with this?

I noticed the mod has a bunch of references to AJAX in it which isn't in the default distribution.

HelixX23:
Hi...

I finally endeavored to persuade my chef to create a packet of the final release of this mod :cool:...
So be patient please...
I´m trying to get this ready quickly.

greets from Germany

HelixX²³

21 Aug 2007, 19:18

#13

dumpy_dooby

New Zenner

Join Date:: Jun 2007
Posts:: 7
Plugin Contributions:: 0

Re: NewWay to save Attributes Modelnumbers

Status? I'd really like to have this. :)

21 Aug 2007, 20:19

#14

dumpy_dooby

New Zenner

Join Date:: Jun 2007
Posts:: 7
Plugin Contributions:: 0

Re: NewWay to save Attributes Modelnumbers

Here are the files that have hard-coded modifications with this addon. Just a quick reference for those that want to try it out. You should back these up first.

admin\attributes_controller.php
includes\classes\shopping_cart.php
includes\functions\functions_prices.php
includes\functions\html_output.php
includes\modules\attributes.php
includes\modules\pages\product_info\jscript_main.php
includes\templates\template_default\templates\tpl_product_info_display.php

06 Sep 2007, 21:42

#15

petzlifedirect_com

New Zenner

Join Date:: Mar 2007
Posts:: 33
Plugin Contributions:: 0

Re: NewWay to save Attributes Modelnumbers

Any Body get this Thing to work yet?

09 Sep 2007, 02:58

#16

mauryg

Zen Follower

Join Date:: Jul 2006
Posts:: 213
Plugin Contributions:: 0

Re: NewWay to save Attributes Modelnumbers

Dumpy Dooby:
Here are the files that have hard-coded modifications with this addon. Just a quick reference for those that want to try it out. You should back these up first.

admin\attributes_controller.php
includes\classes\shopping_cart.php
includes\functions\functions_prices.php
includes\functions\html_output.php
includes\modules\attributes.php
includes\modules\pages\product_info\jscript_main.php
includes\templates\template_default\templates\tpl_product_info_display.php

As I remember, the files in admin can NOT be overridden with a custom template. Can all the others be copied into a custom template and overridden?

I am usinig a WAMP server on my localhost to test the site I'm building. It has Apache 2,0.18, PHP 5.14 with Zend, and MySQL 5.0.22. Does anyone know what else is needed to get the AJAX functions to work??

09 Sep 2007, 04:26

#17

mauryg

Zen Follower

Join Date:: Jul 2006
Posts:: 213
Plugin Contributions:: 0

Re: NewWay to save Attributes Modelnumbers

OK, I temporarily abandoned the idea of using the override system and installed everthing according to the readme instructions.
When I go to the Catalog > Attributes Controller and click on the "AttributCombinationsTable" link (need to make a nice button for this), I get a 404 error which says "Not Found: /admin/stats_attr_model.php". BUT that file is definitely there in that location.

Second, in the root folder "getPricefromcomboID.php" the first line reads:

require_once("ajax/xajax.inc.php");

So it looks like there has to be an added file which is not provided with this module in order to run the AJAX function.

YES, I checked and I did set the server address correctly in the jscript_main.php file.

Any explanations??? I would really like to get this mod to work...

Maury :frusty:

09 Sep 2007, 05:48

#18

mauryg

Zen Follower

Join Date:: Jul 2006
Posts:: 213
Plugin Contributions:: 0

Re: NewWay to save Attributes Modelnumbers

Well part of the mystery is solved, I think.

for the AJAX library, I went to http://www.xajaxproject.org/ and downloaded the latest stable version and installed it in the root folder. I changed the name of the folder from "xajax" to "ajax" to match what is coded in jscript_main.php for this module.

When I go to the Attributes Controller page in Admin and click on the link, I still get the 404 Error. I noted that the URL it is trying to access is "http://localhost/admin/stats_attr_model.php". My root is one level down in http://localhost/newzen/ and that is what is encoded in jscript_main.php for

var xajaxRequestUri="http://localhost/newzen/getPricefromcomboID.php"

So I don't understand why it cant find the file properly. If I manually change the URL in the browser window to include the "localhost/newzen/admin..." then it finds the file and shows me the ArticleCombination window.

Help needed!

Maury

24 Oct 2007, 21:08

#19

dumpy_dooby

New Zenner

Join Date:: Jun 2007
Posts:: 7
Plugin Contributions:: 0

Re: NewWay to save Attributes Modelnumbers

Status?

25 Oct 2007, 11:02

#20

petzlifedirect_com

New Zenner

Join Date:: Mar 2007
Posts:: 33
Plugin Contributions:: 0

Re: NewWay to save Attributes Modelnumbers

I have tried all the hints listed on this thread and it still does not work 100%