have the product data, need a e-commerce solution

have product in a DB, need e-commerce solutions

[papabear1126]

I work with a POS, point of sale software that manages product inventory, customers, manages whole stores etc.
The software can export the inventory in various ASCII formats, csv, and txt, and some other DB formats.
I have created and run several static websites using shopping carts like Mals-ecommerce.
What I want to be able to do is insteqd of having to create a new product page from scratch everytime, I want to be able to create a ecommerce site that, after it is set up, I can upload products without having to create a page and add to cart button for each.
From what I can tell, this requires a database website.
I know nothing of DB websites and related subject matter.
I need to know what options I have without having to learn a ton of codes, like PHP and MySQL, etc.
I want to be able to create a site, home page, FAQ page, Contact Page, and one product page template.
I want to be able to just upload products from the format exported by the POS software.
I have no clue where to begin to learn this stuff.
Any tutorial links, program links, tips, anything is a help at this point.
tyia
Frank

[hiker_jjw]

There's not much out there on this topic. I call what you are trying to do an "Upload Web store". They are usually "very" custom Web stores.

I've developed a store for a client of mine in a very similar manner. The client runs everything from his "business PC". He basically dumps his current inventory to a flat-file (text, ¦ delimited) about twice a month, and FTP's it to the server. I created a custom PHP script which takes his products (flat-file) and imports (inputs) the data into a MySQL database. Products and Category tables are created, amongst many other things such as picture/photo requirements and such.

The content is then generated on the fly with PHP and a MySQL database. Since the products only change twice a month, I even created a "On-The-Fly Content Generation" scheme, which actually writes out HTML pages as they are requested. This reduced the load on the MySQL server and frees up CPU usage (no longer PHP). I recommend the on the fly content generation for sites with lots of traffic.

Orders are pulled from the Web as they come in and processed offline through a Credit Card processor. While it's not as efficient as using Authorize.net, it a LOT cheaper. Since you are managing all of the product/order data offline, you should be able to "create" a custom Web solution without too much effort. Hope that helps some. If you have further questions, send me a sticky message and maybe I can help.

Cheers,
Jeff

[Essex_boy]

Have you looked at webgenie?

All you do is list your products on a spreadsheet it then converts this in to a web site for you to upload.

CGI scripts are all so set up by the program.

[hoekda]

I'm using the open source store sofrware called "Interchange", it easily imports and exports product descriptions, inventory, pricing, etc. via csv files. I routinely add product in that fashion. I send raw info. to an out of the US typing service, then upload the products into the store. Drop me a line if you'd like a referral to my tech guys.

dave

[hiker_jjw]

Look around on one of the many Script Sites. You should be able to find a PHP/MySQL based Web store to import your products into. If not, find someone who can write a Web store to fit your needs.