I think I know what I want.

by zlgoan
1 replies
Hi everyone I have a task I need to accomplish which massively improve the user experiance on my website.

What I have are a few Excel Datasheets with ~5,000 parts prices and description.

What I want to do, is find a way to make these parts prices and describtions available in my sites search query.


MY site is a wordpress site, but the purpose of this is to automate the shopping process. So they can pay for the part online, our competitors can do it, and I feel i should be able to do it.

I don't know how they do it, if they do it 1 by one! I will but I don't want to ya know?

So the question is, is there a plugin? Would zencart work the best for what I need and how I want to do it?

If I'm not vague let me explain.


Ya know when you export your contact out of Google Contact and you can get a CSV file?

I have parts databases and I want that same functionability specifically search as that a contacts program would have.

Please advise

Thank you
-Zach Logan
#database #excel #web
  • Profile picture of the author shahriyar
    You basically want to get all the products from Excel sheets to your website where you can sell them, correct?

    If you want wordpress search to find it you need to add the products as wordpress posts or into a wordpress shopping cart plugin (e.g. WooCommerce) that utilizes the wordpress search feature.

    Wordpress itself and also most shopping cart plugins can import products from specifically formatted CSV or XML files.

    So, to import you need to write a PHP script that can convert the excel sheets into a format (CSV or XML etc.) that is importable by wordpress or a shopping cart plugin.

    Run the script to generate the properly formatted CSV or XML and import it into wordpress or a shopping cart plugin.
    {{ DiscussionBoard.errors[8837677].message }}

Trending Topics