Master Products - MS2

[mijman2]

Hi,

I am new to all of this stuff, but when i log into my admin, then i click on catalog, then catalog/products this error is displayed at the top of the page... What happened? All i did was copy the newest 1.1.5 to my catalog file... I clicked overwrite all... did i install correctly? Here is the error... What to do about it?

1054 - Unknown column 'p.products_master' in 'field list'

select p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.products_master, p.products_master_status, p.products_listing_status from products p, products_description pd, products_to_categories p2c where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = '0' order by p.products_master

[TEP STOP]

Edited May 2, 2004 by mijman2

[Guest]

There is a master.sql file you must run on your database - use phpmyadmin for this.

 

Please backup first :D

 

Matti

[mijman2]

Thanks got that set up and all works well...

 

However, I have attributes set up and I want them to be the slave products... For instance there are two sizes, and then off of those two sizes there are 4 colors... How do I make it recognize those as products with seprate inventory/stock and same price?

 

-I want to still be able to use the attributes drop down menu... instead of having it all text based...

Edited May 2, 2004 by mijman2

[Guest]

Look a few posts back at what Chris has done.

 

Matti

[milehightech]

I'm just getting started building a store with OSC, and am so glad I found the master products module right off! I haven't had a chance to read all these pages, but am hoping someone can answer a couple of questions:

 

1. Is there a way to set the sort order of slave products? I don't want them sorted alphabetically--I want to control the order in which they appear. This would work better for me than the +- click to sort.

 

2. When I add slaves, they show up as new products. Is there any way to have only masters show up as new products? Or a way to configure the slave to indicate whether or not it should display as a new master? This one isn't a big deal, just wondering.

 

3. Is there any way to make the quantity select menu a box in which customers can enter a number instead of selecting it from a menu?

 

Thanks!

[thisheart]

There is a master.sql file you must run on your database - use phpmyadmin for this.

 

Please backup first :D

 

Matti

Can you please let me know how to do this? I have plesk 7 and myphpadmin installed. Im just not sure where to start. :blink:

 

On another note, I had my shop up and working, but when I uploaded the MS2 files I get this error message: FATAL ERROR: register_globals is disabled in php.ini, please enable it!

 

I think I changed a file to fix this problem before, do you know what file that would have been? I am on a shared server so I can't change the php.ini file myself. However, I did ask my host to change this, he said that he did but I still get this message.

 

Thanks!

 

ps. if you know how to fix the problem of not been able to add products into the shopping cart, can you please point me in the right direction. I have searched the forums and have not been able to find the solution.

[Guest]

Can you please let me know how to do this? I have plesk 7 and myphpadmin installed. Im just not sure where to start. :blink:

Start by opening PhpMyAdmin - you should see an "SQL" tab - click on this - then use the 'browse' button to locate the master.sql file on your local hardrive - click 'go'.

 

You should backup your database first.

 

Your host must restart the server for the php.ini file changes to take effect :blink:

 

This should fix your other problems :P

 

Matti

[Guest]

1. Is there a way to set the sort order of slave products? I don't want them sorted alphabetically--I want to control the order in which they appear. This would work better for me than the +- click to sort.

 

Yes - you can change this line in modules/master_products.php:

 

$master_sql .= " order by pd.products_name";

 

Change it to 'order by' whatever you wish, so long as its in the $master_sql query.

 

2. When I add slaves, they show up as new products. Is there any way to have only masters show up as new products? Or a way to configure the slave to indicate whether or not it should display as a new master? This one isn't a big deal, just wondering.

 

Yes - select 'hide product' on the product edit page.

 

3. Is there any way to make the quantity select menu a box in which customers can enter a number instead of selecting it from a menu?

 

You will find it in this thread - you will probably need to use the application_top.php from the first release - let me know here how it goes :)

 

Matti

[kat2nz]

Hi, I'm about to install Master Products and want to know if all of my formatting will be lost when I do this, ie. does it need to be set up on a new install of oscommerce? (just a bit nervous as I seriously don't want to lose all the changes to design etc I have made.) Thanks.

[Guest]

Hard to say - only you know the changes you have made :P

 

PM me and I'll talk it over with you.

 

Matti

[kat2nz]

hahaha too late im in the process of it :D so the sql file goes in my catalog folder right?

[kat2nz]

nevermind just found how i do the sql file thing.

[Guest]

hahaha too late im in the process of it  :D so the sql file goes in my catalog folder right?

 

The master.sql file must be run on your database - there is an updated one posted a few pages back in this thread - use it.

 

Please backup :)

 

Matti

Edited May 3, 2004 by Johnson

[kat2nz]

Looks to be working just fine, thanks! Is there a readme file somewhere that explains how it works & how to set up my products? Thanks.

[kat2nz]

OK I'm now totally confused as to how this works. Can someone show me a demo website or explain it very simply how it works & how I set it up so ppl can order a red tshirt in med but not in small & a green in small but not in med. Thanks!

[Guest]

This thread is the readme :)

 

Matti

[jzee123]

I have the master slave contribution working and its great.

What i'm interested in doing is seperating some of the slaves on a product page with text.

 

For example it would look like this:

 

Master Text Text Text

 

order widget 1

order widget 2

 

more text more text

 

order widget 3

order widget 4

 

Does anyone know how to do this? is there a way to do this?

[kat2nz]

Can someone tell me how to do this... I'm just trying to work this contribution out... I have a master as Dickies Workpants & a slave as Black Dickies Workpants. I want to add an attribute of the size which I have set up but it doesnt show up. I want the slaves box under the master product to show Model, Size, Select & Price. How do I do this?

[Barido]

Hi, i've successfully installed master products. Just having a few minor issues.

 

If I add a slave product to my cart. Go into my cart, click the slave product it takes me back to the slave product, i'd like it to take me back to the master product. Clicking the image in the cart does do this however -see screenshot. I think there is a solution posted earlier in the thread but it doesn't seem to work for me.

 

Another issue:

I made the suggested changes to the advanced_search_results.php so only masters were displayed. But if a slaves model number is searched for it really should appear as a result. If clicked it should go to the master products. A few people have posted this issue with no response...

 

Any help appreciated!!

 

Great mod though keep up the good work!

Edited May 6, 2004 by Barido

[safoo]

Wait until Monday - I will be uploading some new files, including a much simplified admin/categories.php.

 

Matti

 

Has the new files been uploaded yet? Or a rough estimate of when they will be ready? Thanks in advance.

[Donovan]

If I may be so rude, the new files will be ready when they're ready... An estimate will have no effect on that timeline aside from delaying the one person everyone has all their hopes on... ;)

 

Since this is a completely free offering that Matti has been more than generous in supporting even though he is under absolutely no requirement to do so, the best thing we can all do is to be patient, for he doesn't owe us anything, and to offer him our respect and admiration when appropriate. :wub:

 

The last thing we want to do is create a situation where the project is no longer fun for him... :wacko: even extraordinary patience has it's limits :)

 

Take as long as you want Matti, it's your project... if we don't like it, then the challenge is set to make something better and faster on our own time B)

[socrates]

@matty,

i have made some changes in my products_info.php

to have an other way to display the slave-products.

you can see it here : testsystem.

soc.

[kat2nz]

Can some one tell me how I change the slaves box that comes up below a product. At the moment it shows Model, Description, Name, Select & Price. I want it to show a Picture, Model, Select & Price. & if possible can I change "model" to "style & size".

[kat2nz]

I'm sooooooo confused!!!!! Can someone please help. I don't know how to sort out my products using master products. If someone could please have a look at http://www.wearit.co.nz/catalog/product_in...&products_id=39 and tell me how to arrange them, list them it owuld be HUGELY appreciated.

[kat2nz]

ok I think I have it sorted now, not sure if I'm using it correctly but it works!! Please take a look at http://www.wearit.co.nz/catalog/product_in...&page=1&sort=5a and tell me how to get rid of the "Oout of Stock" bit?!?!? I don't want people to buy the master, just the slaves underneath. Does this make sense?