lindsayanng Posted August 16, 2010 Posted August 16, 2010 Ok I am contemplating how to set up this website with a really complex grouping of products.. The person sells apparel, but its really complex. She has the same "design" on every type of clothing article. i would like to name the product the same as the design.. So say she has a tshirt, long sleeve, and hoodie with a butterfly. I would LIKE to have the product be named "Butterfly" and the model be "T-shirt" That means that there will be products with the same names and same model numbers, but not the same name AND model.. Has anyone done this and has it caused any issues? A great place for newbies to start Road Map to oscommerce File Structure DO NOT PM ME FOR HELP. My time is valuable, unless i ask you to PM me, please dont. You will get better help if you post publicly. I am not as good at this as you think anyways! HOWEVER, you can visit my blog (go to my profile to see it) and post a question there, i will find time to get back and answer you Proud Memeber of the CODE BREAKERS CLUB!!
lindsayanng Posted August 16, 2010 Author Posted August 16, 2010 Hmm I also got an error when trying to upload my csv using Easy Populate that says "13onsie - white... ERROR! - Too many characters in the model number." I went into the DB and adjusted the limit on the table from 12 to 25 just to see if that would fix it and I am STILL getting that error.. Is there almost limit within the function files/ A great place for newbies to start Road Map to oscommerce File Structure DO NOT PM ME FOR HELP. My time is valuable, unless i ask you to PM me, please dont. You will get better help if you post publicly. I am not as good at this as you think anyways! HOWEVER, you can visit my blog (go to my profile to see it) and post a question there, i will find time to get back and answer you Proud Memeber of the CODE BREAKERS CLUB!!
pick1e Posted August 16, 2010 Posted August 16, 2010 That means that there will be products with the same names and same model numbers, but not the same name AND model.. Has anyone done this and has it caused any issues? You won't have any problem there as far as the database. Only the products_id needs to be unique, and that's automatically created by the system, not you. Think of it like a table with three fields: products_id, products_model_no, products_name ------------------ 1, Butterfly, Hoodie 2, Butterfly, Hoodie 3, Smiley, T-Shirt Also, look into using some of the additional features like attributes and additional fields. You could have butterfly hoodie as the product, with attributes for size and color. As for your csv check to make sure you don't have something in the csv that is messing it up, like a comma in a description field or some mysql keyword. -------------------------------- Justin osC is awesome. Thanks everyone.
Jack_mcs Posted August 16, 2010 Posted August 16, 2010 Ok I am contemplating how to set up this website with a really complex grouping of products.. The person sells apparel, but its really complex. She has the same "design" on every type of clothing article. i would like to name the product the same as the design.. So say she has a tshirt, long sleeve, and hoodie with a butterfly. I would LIKE to have the product be named "Butterfly" and the model be "T-shirt" That means that there will be products with the same names and same model numbers, but not the same name AND model.. Has anyone done this and has it caused any issues? The model number has to be unique for Easy Populate to work correctly so that won't work. Also, when you change the model size, you also have to change it in the easy populate file. Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons
♥bruyndoncx Posted August 16, 2010 Posted August 16, 2010 there are a few other places where a longer model number will be invisible or chopped of during the ordering process. there is a limit set in easypopulate, but shouldn't be too hard to change, I believe i've done so in the past. KEEP CALM AND CARRY ON I do not use the responsive bootstrap version since i coded my responsive version earlier, but i have bought every 28d of code package to support burts effort and keep this forum alive (albeit more like on life support). So if you are still here ? What are you waiting for ?! Find the most frequent unique errors to fix: grep "PHP" php_error_log.txt | sed "s/^.* PHP/PHP/g" |grep "line" |sort | uniq -c | sort -r > counterrors.txt
lindsayanng Posted August 16, 2010 Author Posted August 16, 2010 ok yea, i managed to adjust the size without an issue everywhere, but having duplicate names just does NOT work with easy populate.. I might have to adjust because we NEED to work with easy populate.. there are too many darn products here! A great place for newbies to start Road Map to oscommerce File Structure DO NOT PM ME FOR HELP. My time is valuable, unless i ask you to PM me, please dont. You will get better help if you post publicly. I am not as good at this as you think anyways! HOWEVER, you can visit my blog (go to my profile to see it) and post a question there, i will find time to get back and answer you Proud Memeber of the CODE BREAKERS CLUB!!
jhande Posted August 16, 2010 Posted August 16, 2010 Uhm Lindsay... Maybe both you and your client should consider what it will be like come order fullfillment time. Product Name: Butterfly Model Number: T-Shirt What about Size and Color? Are there options for that also within the above product? It might be hard to setup but best in the long run if you can establish a unique Model Number for different products. Maybe something like this; Product Name: Butterfly T-Shirt Color Option: Blue Size Option: Extra Large Model Number: BflyTBXL Just something to think about before editing a bunch of files. - :: Jim :: - - My Toolbox ~ Adobe Web Bundle, XAMPP & WinMerge | Install ~ osC v2.3.3.4 -
lindsayanng Posted August 16, 2010 Author Posted August 16, 2010 Ummmm Jim.. I have more than just names and models to tell me what the product is that the client ordered.. I am trying to actually make the site look good and NOT have to display all of the ugliness of the "administration" on the front end.. meaning, why does the front end need to show the ugly model model number?? Why can't it show a sub-name or descriptive model?? Well there's no real reason other than the fact that it wasn't designed with the end user in mind, it was designed with the administrative user in mind. Also, i used "tshirt" as an example.. A great place for newbies to start Road Map to oscommerce File Structure DO NOT PM ME FOR HELP. My time is valuable, unless i ask you to PM me, please dont. You will get better help if you post publicly. I am not as good at this as you think anyways! HOWEVER, you can visit my blog (go to my profile to see it) and post a question there, i will find time to get back and answer you Proud Memeber of the CODE BREAKERS CLUB!!
♥bruyndoncx Posted August 16, 2010 Posted August 16, 2010 actually in our business the model number contains the vendor provided reference, by displaying that to the customer they know it is exactly the item they are looking for. We prepend the model with an abbreviation for the brand where we can to make it unique. This gives our customers more confidence that it is the right item they are buying, and allows them to get reviews and compare prices with other sites. We are not all in a (custom) T-shirt business :D KEEP CALM AND CARRY ON I do not use the responsive bootstrap version since i coded my responsive version earlier, but i have bought every 28d of code package to support burts effort and keep this forum alive (albeit more like on life support). So if you are still here ? What are you waiting for ?! Find the most frequent unique errors to fix: grep "PHP" php_error_log.txt | sed "s/^.* PHP/PHP/g" |grep "line" |sort | uniq -c | sort -r > counterrors.txt
jhande Posted August 16, 2010 Posted August 16, 2010 actually in our business the model number contains the vendor provided reference, by displaying that to the customer they know it is exactly the item they are looking for. We prepend the model with an abbreviation for the brand where we can to make it unique. This gives our customers more confidence that it is the right item they are buying, and allows them to get reviews and compare prices with other sites. We are not all in a (custom) T-shirt business That is how my shop is setup; Manufacturer reference then manufacturer product number. Example: Manufacturer = Revell Product Name = 1924 Ford "T" Big Tub Manufacturers Product Number = 85-2622 My Model Number = RMX/85-2622 When an item is ordered we just go to the proper shelf (in this case Revell) and pull 85-2622. - :: Jim :: - - My Toolbox ~ Adobe Web Bundle, XAMPP & WinMerge | Install ~ osC v2.3.3.4 -
lindsayanng Posted August 16, 2010 Author Posted August 16, 2010 bruyndoncx - that would be why I am asking this for myself.. I'm not trying to lobby for a change to the core.. You guys are entirely missing my point that when you are selling products that actually have model numbers why layout is NOT going to work for you and yours is NOT going to work for me.. Enough said. I am trying to figure a way to use the model and name to actually be useful to my USERS and not to the administrators. A great place for newbies to start Road Map to oscommerce File Structure DO NOT PM ME FOR HELP. My time is valuable, unless i ask you to PM me, please dont. You will get better help if you post publicly. I am not as good at this as you think anyways! HOWEVER, you can visit my blog (go to my profile to see it) and post a question there, i will find time to get back and answer you Proud Memeber of the CODE BREAKERS CLUB!!
jhande Posted August 16, 2010 Posted August 16, 2010 Ummmm Jim.. I have more than just names and models to tell me what the product is that the client ordered.. I am trying to actually make the site look good and NOT have to display all of the ugliness of the "administration" on the front end.. meaning, why does the front end need to show the ugly model model number?? Why can't it show a sub-name or descriptive model?? Well there's no real reason other than the fact that it wasn't designed with the end user in mind, it was designed with the administrative user in mind. Also, i used "tshirt" as an example.. I was unaware Lindsay that you had other references to identify the products, that's good! I just thought it would be easier for the order picker. Yes I agree that if one (customer or shop owner) does not need the model/product number to identify items, then it would result in an ugly frontend. - :: Jim :: - - My Toolbox ~ Adobe Web Bundle, XAMPP & WinMerge | Install ~ osC v2.3.3.4 -
♥bruyndoncx Posted August 16, 2010 Posted August 16, 2010 ok, I'm out. :-" KEEP CALM AND CARRY ON I do not use the responsive bootstrap version since i coded my responsive version earlier, but i have bought every 28d of code package to support burts effort and keep this forum alive (albeit more like on life support). So if you are still here ? What are you waiting for ?! Find the most frequent unique errors to fix: grep "PHP" php_error_log.txt | sed "s/^.* PHP/PHP/g" |grep "line" |sort | uniq -c | sort -r > counterrors.txt
Recommended Posts
Archived
This topic is now archived and is closed to further replies.