multi-source search, and initial product database setup

[k8inmd]

ok - multiple sources - one for each vendor.

but if I do that will we be able to search for items across sources? If someone wants a pound of broccoli can they search broccoli and see every vendor who sells it with each vendors price in one search?

Also - I'm looking to upload each vendors products. I assume excel spreadsheets are the easiest for family businesses. Does anyone have a setup I can see, possibly copy and play with? Or info on the settings needed to upload the excel sheet into my data source?

Thank you all for the help
Kathleen

[support]

[k8inmd]

thanks for the info -

trying to make up a test one to import - just code, descr, price. I'm getting an eror message on the create:
#1142 - CREATE command denied to user 'kathleen'@'localhost' for table 'tabletest2'

i have code as 'unique'.... what would keep me from creating this simple file?

[support]

The "CREATE command denied" error is usually caused by the issue in this topic:

http://foodclub.org/phpbb/viewtopic.php?f=1012&t=1872

[k8inmd]

The documentation you sent me to is good, and helpful. But at this point I am getting the create error on just trying to make the table in the first place. Even before trying to upload data into it.

What would cause the 'create command denied to user' when creating an sql table??

Please help,
kathleen

[support]

What exactly are you trying to do? There is no reason to create a table in phpMyAdmin. The act of enabling a private database, on your Product database settings in Foodclub, will create the private table for you.

[k8inmd]

I see. As I said I have not worked with this database. Didn't realize it would make it's own.

Thanks
Kathleen

[k8inmd]

I was able to upload into a file (source).

When a vendor wants to add products, post sales, or change prices - do I reload their excel spreadsheet into the same source? I tried this and was told the item already exists...

[support]

Yes, if it's the same vendor's products, only updated for current prices and availability, you will want to import into the same private database. If you are importing from an excel spreadsheet which contains all their products, you will want to clear out your private database first. See this FAQ entry:

http://foodclub.org/wiki/Foodclub:Docum ... ew_file.3F

If there are only a handful of items, you may just want to make changes manually using phpMyAdmin. You can update just a single field by double-clicking on it in the Browse tab, making changes, and hitting enter.

[support]