Solved

Create searchable inventory database using wordpress

Posted on 2013-11-07
4
1,304 Views
Last Modified: 2013-11-08
I currently have a members only website built for a Cisco resellers group. They have a request for me and not sure how to approach it. They want:

Each member be able to upload their inventory to a searchable database. This would be done from a webpage and not the backend.

This inventory would be searchable for all members

Any ideas? Plugins? Manually creating a table in the database and coding the page myself? Any ideas and direction no matter how small would be greatly appreciated.
0
Comment
Question by:princeservice
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 110

Expert Comment

by:Ray Paseur
ID: 39631031
We would need a description of the inventory records, at least.  How many members in the group?  Have you thought about security?  How well do you know PHP and SQL?
0
 

Author Comment

by:princeservice
ID: 39631066
Because I don't have too many details yet lets say that each inventoried item would consist of five fields. We are looking at 330 members. There is already security on the site. These pages would be located in the secure area. I know SQL good enough and PHP a little. Have more of a background with classic ASP.

As far as displaying data on a page or building a search function I am not too worried (If I was bypassing wordpress and just doing straight PHP/MySQL).  I am more concerned about users being able to upload products with a csv file, dealing with duplicates, validating information, etc. This is why I would much rather find a plugin. Another problem is members need to be able to upload a csv file without accessing the Wordpress backend. Can't seem to find that capability in a plugin.

I am also looking into Toolset/Views/Types but still running into the upload issue.
0
 
LVL 70

Accepted Solution

by:
Jason C. Levine earned 500 total points
ID: 39632442
You're not going to find a plugin that does everything you describe above.  Parts of it, yes, but the whole request is sort of all over the place and no single plugin will work.

The two closest things I can think of would be FormidablePro to replicate a CRUD system or one of the better cart plugins that can do inventory management (WooCommerce probably).

Formidable can do a lot of what you ask, the one thing it can't do without effort is front-end CSV upload.  You would have to write some extra code to handle that part.

The cart idea would require backend access to manage the products and upload new ones and that probably is a deal breaker for you.  But otherwise, all other functions would be there.

Dupe checking would be an issue with either solution.

My gut feeling is to write your own system and just integrate it into WordPress.  That's probably the best the in the long run.
0
 
LVL 110

Expert Comment

by:Ray Paseur
ID: 39633363
What Jason1178 said.  With a background in ASP, this book will get you up-to-speed quickly on PHP.
http://www.amazon.com/PHP-MySQL-Web-Development-Edition/dp/0321833899

How your community members would do their uploads is one of the important design questions.  Depending on their level of sophistication, you may have some "deep thinking" to do on that subject :-)
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
MySQL limit and not so limited 13 42
BIG DATA Question: Path to migrate current "Document Management" system 13 42
Wordpress and Responsive Web Design 5 27
JSON decode 5 22
Since pre-biblical times, humans have sought ways to keep secrets, and share the secrets selectively.  This article explores the ways PHP can be used to hide and encrypt information.
This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
The purpose of this video is to demonstrate how to reset a WordPress password if you are locked out and cannot reset the password. A typical use would be if you cannot access the email to which WordPress would send the password recovery email to…
The purpose of this video is to demonstrate how to integrate Mailchimp with WordPress, by placing a Mailchimp signup form on a WordPress Page or Post. This will be demonstrated using a Windows 8 PC. Mailchimp will be used. Log into your Mailchi…

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question