Improved Attributes Controller (now built-in to v1.3.9)

kajunto:

YEP... THAT DID THE TRICK!!! thanks for the help.
Apparently, that's still not my issue :dontgetit
When attempting to copy attributes from one product to another, I get this error:

1136 Column count doesn't match value count at row 1
in:
[insert into zen_products_attributes values (0, '1030',           '13',           '439',           '0.0000',           '+',           '0',           '0',           '0',           '+',           '0',           '0',           '1',           '',           '1',           '0.0000',           '0.0000',           '0.0000',           '0.0000',           '0.0000',           '',           '',           '0.0000',           '0',           '0.0000',           '0',           '0')]

I have your attributes controller file (above) installed, as well as dual pricing (and a host of other mods that shouldn't actually be affecting this.)

Any insight is appreciated.

Vicki,

Look in your database at your products_attributes table and compare your the columns (columns names and data types) with the data that is being copied in that error message and see if you can figure out where the difference is.

You can post the columns here if you want me to take a look at it or PM me and I'll see what I can do to help. I had the same problem at one time, but can't remember exactly how I solved. I'll help if I can.

hrm:

Vicki,

Look in your database at your products_attributes table and compare your the columns (columns names and data types) with the data that is being copied in that error message and see if you can figure out where the difference is.

You can post the columns here if you want me to take a look at it or PM me and I'll see what I can do to help. I had the same problem at one time, but can't remember exactly how I solved. I'll help if I can.

You're right on the money on that one. Looking at it like that, it's clear that the "options_values_price_w" (wholesale price) isn't supported by the attributes controller (it doesn't display on the attributes controller page now that I look again... should have spotted that before). Field listing is:

products_attributes_id
products_id
options_id
options_values_id
options_values_price
options_values_price_w
price_prefix
products_options_sort_order
product_attribute_is_free
products_attributes_weight
products_attributes_weight_prefix
attributes_display_only
attributes_default
attributes_discounted
attributes_image
attributes_price_base_included
attributes_price_onetime
attributes_price_factor
attributes_price_factor_offset
attributes_price_factor_onetime
attributes_price_factor_onetime_offset
attributes_qty_prices
attributes_qty_prices_onetime
attributes_price_words
attributes_price_words_free
attributes_price_letters
attributes_price_letters_free
attributes_requiredIs it possible to add that functionality to the improved attributes controller without a major re-write?

Moebiusenterprises:

Looking at it like that, it's clear that the "options_values_price_w" (wholesale price) isn't supported by the attributes controller (it doesn't display on the attributes controller page now that I look again... should have spotted that before).

Just to clarify, you don't have a box labeled "Trade" in your attributes controller?

If not, are you using the attributes_controller.php that I posted in this thread?

Perhaps you could try re-loading that file and see if the Trade box shows up. If not, then you probably need to re-install the whole Dual Pricing mod.

hrm:

Just to clarify, you don't have a box labeled "Trade" in your attributes controller?

If not, are you using the attributes_controller.php that I posted in this thread?

Perhaps you could try re-loading that file and see if the Trade box shows up. If not, then you probably need to re-install the whole Dual Pricing mod.

Yes, I do have the "trade" item showing up (feeling stupid, didn't equate that with wholesale in my mind at the time).

Will try the re-install on the dual pricing mod anyway...

Moebiusenterprises:

Yes, I do have the "trade" item showing up (feeling stupid, didn't equate that with wholesale in my mind at the time).

Will try the re-install on the dual pricing mod anyway...

Ok, re-installed the dual pricing mod (and the attributes controller you posted earlier on this thread).... still same error, so I'm stumped.

OK. I found the thread that I used months ago to help solve my problem with copying attributes. The solution involves making changes to admin/includes/functions/general.php

http://www.zen-cart.com/forum/showthread.php?t=35219

Try the changes suggested by boylan and see if that works.

hrm:

OK. I found the thread that I used months ago to help solve my problem with copying attributes. The solution involves making changes to admin/includes/functions/general.php

http://www.zen-cart.com/forum/showthread.php?t=35219

Try the changes suggested by boylan and see if that works.

Brilliant!
Works like a charm:clap:.
BTW, I must add that I adore the improved attributes controller... much cleaner interface, IMHO.
Now if the other attribute modules were that slick, life would be SQUEE! :jump:

Moebiusenterprises:

Brilliant!
Works like a charm:clap:.
BTW, I must add that I adore the improved attributes controller... much cleaner interface, IMHO.
Now if the other attribute modules were that slick, life would be SQUEE! :jump:

I've noticed that this mod doesnt work so well when installed with easy populate, having huge problems downloading the easy populate files for adding/changin products quickly.
Anyone else encountered this?
Anyone that have or would like to look into what the problem is with theese two mods?

thanks

When adding new attributes to a product,
is there any way to get the "Option Value" sorted?

Would be alot easier with this, let me know if anyone has an answer.

dedj:

When adding new attributes to a product,
is there any way to get the "Option Value" sorted?

Would be alot easier with this, let me know if anyone has an answer.
Your question has already been addressed in this same thread.
You have to enter sort order manually, please go back for related postings.

oh ok, sorry must have missed it.

hrm, manual set sortorder is not helping me, I'm contantly adding new option values to that option name all the time and will have to change sort order to them all the time to get them somewhat sorted.

hope for an automatic sortorder of some kind soon :smile:

a small info to my post, I went back and added manually sort order,
and will add sort order when adding new order values.
It's maybe not perfect, but atleast i will have them somewhat sorted.

i had at the moment ordervalues in this order.
6,5" et45 black
8" et40 grey
7,5" et40 black
6,5" et40 silver
7,5 et32 gold
8" et 40 black

now with added sortorder 65 on all 6,5", 75 on all 7,5" and 80 on all 8" will atleast get all 6,5" wide rims collected together, 7,5" collected and 8".
they will maybe not be in perfect sortorder, but atleast they will be more organized and easier to find :smile:

thanks ckosloff for info that made me try it :hug:

NOTE: be sure to try the Catalog ... Option Name Sorter ... and Catalog ... Option Value Sorter ... to manage the Default Sort Orders that can be applied any time you add attributes to your products or applied globally from the Tools ... Store Manager ...

yup nice ajeh.
with that you can quickly sort out in what sortorder option names and values should go by.

in my case, i could just enter option value sorter and choose my option name, and change all the values sortorder and in one click update them all. quick to do if you haven't straightened their sortorder earlier.

After implementing the modded file I now only have the phrases "option name" & "option value" displayed in their respective fields when I pull up a product. It's not actually populating the boxes, any thoughts?

oppss wrong thread :(

This mod totally rocks. Great job.

I am so stoked to have this attributes controller, but unfortunately I can't get it to work. I copied over the file to the proper directory, and the interface seems to be working fine (I can select size and color attributes and the option values box does the right thing), but when I click to add the attribute I get this error:

1136 Column count doesn't match value count at row 1
in:
[insert into products_attributes values (0, '2', '2', '24', '0', '+', '1', '1', '0', '+', '0', '0', '1', '', '1', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0')]
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 swear to God I didn't leave anything blank that needed to be filled in, or so I thought. It sounds like I forgot to enter some values? But there's so many of those values that if I had to enter all of those every time I add an attribute it would seriously suck worse than the old attributes controller (and besides I don't even know where they'd go in anyway).

What did I do wrong?

Thanks,
Sarah

Ah, never mind. I got through like 13 or 14 pages of "love this mod" posts before I got bored and posted, and if I'd gone one or two pages further I would have seen that the solution had already been posted. I had the wholesale pricing and some kind soul had posted a fix for us noobs. Thanks everyone!