asked on

OsCommerce Add Product Attributes to Multiple Products ?

Hi EE,

I have a web site that use osCommerce. (Actually I bought a template from TemplateMonster.com)

My problem is that yes I can add product attributes to a product but I think its one by one...
what if I want to add the attribute Size Small to 100 products? 1000? .. I cant juste do it one by one its mental suicide... there must be a way?

Any ideas? Im sure im not the first one aksing that

leakim971

Hello,

You may use queries. Run a script.
Export your product list with their id (one distinct id per product), associate under excel for example the id of attribute and import the data.

Regards

Pensare

I have used this product, and it worked verywell. Moreover it was easy to use too. Worth paying for if you are lkely to do a lot of this:

http://www.oscommerce-manager.com/

ASKER CERTIFIED SOLUTION

Pensare

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Member_2_5212910

A simple example of multiple options based upon the previous option (if you ever need it):

<html>
	<head>
		<title>Drop Down Product Selectors</title>

		<script language="javascript" type="text/javascript">
			// Do this when the document is ready
			window.onload = function()
			{
				// Selects
				var sizeSelect = document.getElementById("size");

				// When the 
				sizeSelect.onchange = function()
				{
					if(sizeSelect.options[sizeSelect.selectedIndex].value != "Select a size")
					{
						var colourSelect = document.getElementById("colour");

						// Remove all existing options
						colourSelect.options.length = 0;
				
						var colours = {
							"10": ["Red", "Blue"],
							"11": ["Red"],
							"12": ["Red", "Black", "Blue"]
						};
					
						// Loop through colours for that size
						for(i = 0; i < colours[sizeSelect.options[sizeSelect.selectedIndex].value].length; i++)
						{
							var availableColours = colours[sizeSelect.options[sizeSelect.selectedIndex].value];

							// Add the size
							colourSelect.options[i] = new Option(availableColours[i], availableColours[i], false, false);
						}
					}
				};
			}
		</script>
	</head>

	<body>
		<form action="order.php" method="post">
			Size: <select id="size" name="size"><option value="-1">Select a size</option><option value="10">10</option><option value="11">11</option><option value="12">12</option></select><br><br>
			Colour: <select id="colour" name="colour"><option value="-1">Please select a size</option></select><br><br>
			Qty: <input type="text" name="quantity"><br><Br>
			<input type="submit" value="Order">
		</form>
	</body>	
</html>

Open in new window