bow-viper1 Posted March 9, 2004 Share Posted March 9, 2004 I'm adding sizes 6-13 including half sizes as attributes for a client, and I have about 185 products I need them added to.. is it possible to do some sort of mass add? Link to comment Share on other sites More sharing options...
bow-viper1 Posted May 25, 2004 Author Share Posted May 25, 2004 Anyone know how I can do this? Link to comment Share on other sites More sharing options...
ptrau Posted May 25, 2004 Share Posted May 25, 2004 easy populate contribution...we have one site that has 175 individual sizes with over 500 price combinations "Aliiiiive, it's alive, it's ALIIIIIIIIIIIIIVE!!!" Link to comment Share on other sites More sharing options...
joeyjgarcia Posted May 25, 2004 Share Posted May 25, 2004 I haven't tried Easy Populate, but if that is easy then I would go that route. I just finished creating my enhancement for this same problem, but mine is more integrated into adding a new product. Here is my description from another post (in the Development forum, as a recommendation for the next version. amen!) Product Attributes - this functionality needs a revamp! I sell clothing, so I have to add "Size" attributes to each product so for every product I add, I have to add up to 6 more attributes in another page. The attributes were taking more time than adding the products. I would like to see the Product Options/Attribtues page modified to only allow you to add Product Options and then you can create "Attribute Sets". For example, I would create an Option called "Sizes" that would have a bunch of Option values everuthing from 2T, 3T, 4T, ... XXXXL. Then I would be able to group these Attributes into Sets and give them my own name, for example for Adult T-Shirts from sizes Small to 2XL I could call it "AT S-2X". Then when I add a new product I can select from a Drop Down List just under the Manufacturer Drop Down List, I would have another Drop Down List called Attribute Sets and if my product is an Adult T-Shirt then I would select the "AT 2-2X" and the code would add the necessary rows in the products_attributes table for sizes S, M, L, XL and XXL. I actually just completed this for myself and I plan on submitting this as a contribution this weekend, but I haven't written the interface that would create the Attribute Sets on the Product Attributes page. I figure someone could add to my contribution. Let me know if if you have interest in this feature. My approach would work nicely if you are going to continue to add products in the future one at a time, where Easy Populate may really useful for a batch insert, but like I said, I've never used it. Joey Link to comment Share on other sites More sharing options...
pewe Posted May 26, 2004 Share Posted May 26, 2004 joeyjgarcia, I would really be interested in you contribution. I have 200 products to add each with 3 Attributes, each attribute having 19 options. I dread the thought of having to do this using the standard attributes allocation. Please PM me the details. Thanks Pewe Link to comment Share on other sites More sharing options...
Guest Posted May 26, 2004 Share Posted May 26, 2004 i have been working on this, in the round about way of utilizing a spread sheet, as easy populate does, then using a VB Script which pulls the required information from the database tables, places them in the spread sheet, then creates the SQL code for adding the options, the option values, then the attributes and finally putting them all together with the product. i was able to do 2000 products in about 5 minutes (of course had to have all the info in the spread sheet like easy populate) and it worked fairly slick. so, if someone has something which they have used, then would be good to talk. one thing tho, when you have tons of attributes, as i do, the database really slows down the back end of the store, to where it is next to impossible to manage/add products. thus what prompted my next step, in creating an access application for doing everything what you can do in the back room, locally on your system, and it is multi-user. still perfecting and adding reports, etc, but is starting to come together. Link to comment Share on other sites More sharing options...
krookeddave Posted May 26, 2004 Share Posted May 26, 2004 Joey, I am very interested in your feature. Will it also control inventory such that your stock looks more like: 1 black XL 2 blue L 2 red M instead of: 5 total items XL L M Thanks! Link to comment Share on other sites More sharing options...
Guest Posted May 26, 2004 Share Posted May 26, 2004 Joey, I was just about to open a thread regarding "attribute sets" as you call them. I would agree that the current method of adding product options is rather time consuming. Please let me know of any developments to your contribution. I'm dealing with a site that requires ~25 product attributes (scents) per product (candles) -Jeff Link to comment Share on other sites More sharing options...
Guest Posted May 29, 2004 Share Posted May 29, 2004 any updates? :) Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.