One Attribute for all Products

[doorwish]

Hi Everyone!

 

Is there a possibility to just have 1 set of attributes including prices which I can give to ALL my Products AT ONCE????????

 

I have 600 Products which will all have the same attributes and the same attribute price settings.

 

Well just setting one attribute would be a HUUUUUUUUUUGE time save instead of copying the set of attributes to each Product and pump up my database for nothing! :)

 

I have tried a couple of contributes which say they copy attributes but they all don't copy prices.....

 

WELL THE BEST AND MOST HELPFUL SOLUTION WOULD BE

 

1 ATTRIBUTE FOR ALL!!!!!

 

Can anybody help???????

 

Thanks so much allready and I appreciate any help or hint to get this Productupload as smooth as possible! ;)

 

I need to have this finished till 2morrow! :'(

[Airsoft-warrior]

Try having a look at the easy populate mod in contributions, http://www.oscommerce.com/community/contri...h,easy+populate

 

There's a lot of support out there for it, we used it sparingly for the same kind of process, can be a bit of a quick fix, especially when used with excel.

 

Hope this helps

[doorwish]

Try having a look at the easy populate mod in contributions, http://www.oscommerce.com/community/contri...h,easy+populate

 

There's a lot of support out there for it, we used it sparingly for the same kind of process, can be a bit of a quick fix, especially when used with excel.

 

Hope this helps

 

Hey Simon,

 

thanks for the quick response. Well I downloaded that and the contrib. "excel import 1_51a_1" and started using the seconf one since I don't have any "model no." in my products and easy populate needs that......but I could install that! Are you sure that they support all attributes as well??? Cause I ahve been reading this and that about attributes...

[Airsoft-warrior]

Hey Simon,

 

thanks for the quick response. Well I downloaded that and the contrib. "excel import 1_51a_1" and started using the seconf one since I don't have any "model no." in my products and easy populate needs that......but I could install that! Are you sure that they support all attributes as well??? Cause I ahve been reading this and that about attributes...

 

I have easy populate 2.76 and there is the attributes button for a compile to download, have you thought about using phpmyadmin and at the end of the day just writing an sql query, if your products are all listed on site all you need is the products_id, to populate one product with attributes, export product_attributes table from phpmyadmin, copy and paste changing the product_id each time, primarily creating your own sql query. Import back to table....

[doorwish]

I have easy populate 2.76 and there is the attributes button for a compile to download, have you thought about using phpmyadmin and at the end of the day just writing an sql query, if your products are all listed on site all you need is the products_id, to populate one product with attributes, export product_attributes table from phpmyadmin, copy and paste changing the product_id each time, primarily creating your own sql query. Import back to table....

 

Well I was thinking exactly about something like that!!!! I am using phpmyadmin but the only thing is I am not good in programming and I just learn by doing. I have never written a sql query before! I probably could figure out the first step to just copy paste and change the products_id but the query to automate the whole thing is definatly the better solution.

 

I would be very thankful if you had any hint where I could get a tutorial about sql queries or if it's not too time taking to just tell me what the query has to have as content!???

 

THANKS FOR THE HELP SO FAR SIMON! :)