close ad
WARNING: Do Not Install the DREAMWEAVER CC 2017 or 2018 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Adding Manufacturer to Products

Thread began 4/20/2010 12:14 pm by myron364647 | Last modified 4/22/2010 6:24 pm by Jimmy Wu | 850 views | 7 replies |

myron364647

Adding Manufacturer to Products

My customer is asking if it would be possible to add in the manufacturer (to have a Manufacturer drop-down menu) for the products in the database. I know it can be done obviously, but is there anything with Dreamweaver or extensions I have that might cause problems with the existing code/SQL in the pages and totally screw things up?

What extensions and specific versions need to be installed that works is PS3 to do something like this and not cause interference?

Sign in to reply to this post

Jimmy Wu

What you can do is use the categories to display the manufacturer. The categories will show up in the Products menu. Would that be a satisfactory solution to the issue?

Sign in to reply to this post

myron364647

I had thought about that, and it's a great idea, but they want the categories available too---and here's the catch, there's 515+ manufacturers, not an easy task to make available and manageable. That's why just adding in a Manufac. field in the Insert/Change/Result pages would be even possible using dreamweaver without breaking PS3.

Sign in to reply to this post

Jimmy Wu

What kind of category structure are they looking to have? Having 515 manufacturers in a navigation menu is probably not a good idea in any case.

Sign in to reply to this post

myron364647

Single list drop-down menu like what DataAssist would build from scratch - and to make it easier adding in a category column in the ps3_products table to store the label derived from a manufacture table-- placement of this would have to be just somewhere easy to reach and not buried somewhere within the site

Sign in to reply to this post

myron364647

I took a different direction on this and it's working on the customer front-end pages, however creating the admin page - I duplicated the categores_Results.php page, made some necessary changes, added in the column in the ps3_products table for ProductManufacturer data to store info, although the new Results page isn't showing any of the info in the populated ps3_manufacturers table. At this point, I'm kinda lost as to how to get the list to show now below the New x Name field and Add button

Attached Files
manufacturer_Results.zip
Sign in to reply to this post

myron364647

Adding in the Manufacturers populated list in the Products_Update.php page, the data in the table isn't showing up. And also noticed that the Categories section isn't storing changes now. The products table has a ProductManufacturer table now to store this information--not using relationship table..still don't know quite how that works to get it work, so I'm doing what I know.

Attached Files
Products_Update.zip
Sign in to reply to this post

Jimmy Wu

Unfortunately, you've ventured into an area that isn't supported. Adding in a new database table to store the different manufacturers and getting them integrated with the rest of the store is mainly custom code, so I can't help you much on this. If you posted in the Job board, there might be some other users on the forum that are willing to help you out on getting this set up.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...